Valuation and Account Assignment In SAP MM

Banner-Img

  • Share this blog:

SAP MM valuation and Account Assignment

This is completely integrated with FI(Financial Accounting). material Valuation: stock value= stock Qty x Price. The material valuation will update the G/L accounts in Financial Accounting.

SAP MM valuation:

The procurement process begins with generating a purchase order plus ends with invoice verification. Within the entire process, one of the relevant parts is material Valuation. While developing purchase orders, material price is a necessary field plus it is automatically determined. It arises because material valuation is attested within the SAP system in the material master. Material valuation describes integration among MM & FI (Financial Accounting) modules as it updates the general ledger accounts within financial accounting. The important points to note regarding material Valuation are −

Material valuation assists in managing the price of the material.

Stock obtained from one vendor is valuated at a different price than the stock, which is obtained from the other vendor.

We can evaluate the material based on various types of Procurement which are called Split Valuation.  

Split Valuation:

Split valuation assists in evaluating the stocks of materials within the same valuation area differently. Some of the examples where we use split valuations are:

A stock that is procured externally from a vendor has a distinct valuation price than the stock of in-house production.

Stock acquired from one vendor is valuated at a distinct price than the stock obtained from another vendor.

The same material possessing a different batch may maintain distinct valuation prices.

Split Valuation requires to be activated before setting any other configuration.

This course will help you to master SAP MM

Valuation and Account Assignment :

  • This is fully integrated with FI. Material Valuation: Stock value = Stock Qty X Price
  • The material valuation will update the G/L accounts in Financial Accounting.

Material Valuation features:

  • It allows you to evaluate the materials
  • You can evaluate the materials differently based on sub stocks.
  • It allows you to evaluate the balance sheet.

Material Valuation control:

This valuation is controllable by

  • System settings (where valuation has to be done)
  • Material master records (As a rule for each material has to be evaluated under a material type). If this material type is evaluated or not

For every material, you are assigning a valuation class.

  • You are grouping a material type under the valuation class.
  • All materials of a material type can have one material valuation class.
  • Under a material type, you can have different valuation class for different materials

Materials under different material types can have the same valuation class.

Valuation structure:

Data over material is evaluated using the following structure

  • Valuation area
  • Valuation class
  • Valuation category 
  • Valuation type
  • Material type
  • Movement type

Valuation area:

The valuation area is an Organizational level at which material valuation is done; the valuation area is defined as 

Valuation area= company code

Complete stocks of that particular material in the company code are evaluated together

Valuation area= one plant

Valuation class:

We can group the different materials with the same properties into the valuation calls so that there is no need to control a separate stock account for each material.

All the materials with the same type are assigned to one valuation class.

Various materials with the same material type are assigned to different valuation classes.

Valuation category:

The criterion, according to which split Valuation is carried out:

Procurement: You can evaluate a material uniquely depending on whether it is made in-house or procured externally.

Origin: You can evaluate a material uniquely depending on where it comes from (such as home or else from abroad). 

Status: You can evaluate a material uniquely depending on its status (such as new, used, or repaired). 

Valuation Type:

The valuation type defines the unique character of the valuation category, like internal or external, within the case of Procurement. In the valuation category Origin, you can determine the different countries as the valuation types. You determine valuation types within Customizing. You first define all the correct valuation types for a valuation category.

You specify within this material master record that valuation types are permitted for a different material. For every material subject to split valuation, you must enter all the valuation types permitted within the material master record.

Material Type:

We can assign every material to a material type when we create it. Examples of material types in the standard system incorporate operating supplies, raw materials, and finished products.

Movement Type:

For every material movement, there is a movement type within the SAP System. The movement type manages the properties of the movement, for instance, which entries you have to make when entering a material movement, and which updates are taken out when the movement is posted.

Customization

SPRO -> Material Management -> Valuation and Account Assignment -> Define Price Control for Material Types

SPRO -> Material Management -> Valuation and Account Assignment -> Account Determination -> Account Determination Without Wizard

  • Define Valuation Control (OMWM)
  • Group Together Valuation Areas
  • Define Valuation Classes
  • Define Account Grouping for Movement Types (OMWN)
  • Configure Automatic Postings

Define Valuation Control (OMWM):

Choosing the valuation level is one of the first steps we will perform while customizing the system.

If using the PP Production module, the valuation area must be set at the plant level. For account determination, you can group valuation areas by activating the valuation grouping code. This makes the configuration of automatic postings much easier.

Group Together Valuation Areas:

Valuation areas are grouped with the objective of simplifying the management of the standard accounts table by minimizing the number of entries.

Along with other factors, the valuation grouping code determines the G/L Accounts, to which a goods movement is posted (Automatic Account Determination).

The valuation grouping code makes it easier to set the automatic account determination.

Within the chart of accounts, we assigned the same valuation grouping code to the valuation areas.

Since we want to assign to the same G/L account, we assigned the same valuation grouping code to the valuation areas.

Define Valuation Classes:

The Valuation class is a group of material with the same G/L account.

When you create a material master record, you must assign the material to a valuation class. The valuation class is assigned to a material at the plant level. However, if using the split valuation, the valuation class will be assigned at the valuation type level.

The choices for valuation class are dependent on the material type. In general, several valuation classes can be allowed for one material type. Also, the same valuation class could be allowed for different material types.

The link between the valuation class and the material type is the account category reference. The account category reference is assigned to a material type.

The G/L account determined for the material is carried out according to the settings for its valuation class.

Step1: Account Category Reference: Account Category Reference (4 Char): Group of valuation classes that’s the system uses to check whether the valuation class you have entered is allowed when you maintain accounting data in a material master record.

Step2: Valuation Class: Here The Valuation Class is defined and an Account Category Reference is attached to a Valuation Class. Example: 3000 (Raw Materials) -> 0001 (Reference for Raw Materials)

Step3: Material Type / Account Category Reference: Here the Material Type can be assigned to an Account Category Reference. Example: ROH (Raw Materials) -> 0001 (Reference For Raw Materials)

Define Account Grouping for Movement Types: Movement type - Special stock indicator - Value updating - Quantity updating - Movement Indicator - Consumption posting - Posting string for values - Counter - Transaction/event key - Account modification - Check

The following diagram shows the relation between Chart of account, Transaction, account modifiers, accounts posting keys. 

TRANSACTION / EVENT KEYS IN SAP

AUM: Stock transfers are there between plants and from one movement type to another with split valuation. The difference between the price at the delivery plant and the receiving point is booked at the latter.

Account to be opened: Loss – Stock Transfer Gain – Stock Transfer A/c

BO1: Check up Subsequent settlement of Provisions (e.g.: volume-based rebate)

BO2: Check up Subsequent settlement of revenues -conditions in inv. Verification

BO3: Check up Provision Differences

BSV: The Company sends materials for subcontract work, this transaction is considered, Accounts to be opened, Materials Consumed/Trading Goods w/o cost element, for ROH Inventory Change, Cost of Goods sold w/o Cost element, for FERT s

BSX: All stock postings to Stock Accounts due to Goods receipts & goods issues in Inventory Management. B/s Inventory A/c s 11101 to 11111

DIF: Small Differences that may arise during invoice verification in the invoice amount not exceeding tolerance.

Accounts to be opened: Loss—Inventory Differences A/c, Gain---Inventory Differences A/c

FRX: These are used for posting delivery costs when goods and invoices are received for purchase orders

FR1: Freight Clearing 69002 Separate A/c s is required

FR2: Provisions for freight Charges 69002

FR3: Customs Clearing 69002

FR4: Provisions for Customs Clearing

FRL: Services are performed for the company externally. Account to be opened: Purchased Services A/c

FRN: Services are performed for the company externally and hence delivery costs

Account to be opened: External Procurement Costs A/c

GBB: Offsetting Entries for Inventory Postings AUA For Order settlement 68005 (Factory output for Production)

AUF: For GRs for orders (w/o account assignment) 68005

BSA: For initial entry of stock balances 11199  

INV: Expenditure/Income from Inventory differences 68004 – Raw Material Consumption A/c  

VAX: For goods issues for sales orders with no assignment object The account will not be a cost element 68002 –Raw Material Indigenous 72001 – Stores & Spares

VAY: For goods issues for sales orders with assignment object The account is a cost element

VBO: Consumption from stock provided to vendor 68002 –Raw Material Indigenous

VBR: For internal goods issues (e.g.: to a cost center) 68005—Factory output for Production 72001 – Stores & Spares

VKA: For consumption in Sales Order without SD (Mvt. Type 231) 68005—Factory output for Production

VNG: For Scrapping & destruction 68004 – Raw Material Consumption – Others

VQY: For sampling with account assignment

ZOB: For goods issues with no Purchase order reference (Mvt 501)

ZOF: For goods issues with no production order reference (Mvt 521)

KBS: Account - assigned Purchase Order ie. account assignment taken from PO Account need not be assigned in OBYC

KDR: Exchange rate rounding differences in case of foreign currency invoices 80029 -- Exchange Rate Difference - Valuation 1

KDM: Exchange rate rounding differences for open items (invoice posting with a Different exch. rate than the GR/due to Std price difference/insufficient stock coverage) 80028 --Exchange Rate Difference - foreign currency to local

KDV: Material ledger from low levels E/R diff.

KON: Consignment payables

KTR: Offsetting entry for price differences in cost object hierarchies 68005—Factory output for Production

LKW: Accruals and deference. acct (material ledger)

PRD: Price Differences, Loss/Gain Inventory Differences (Two A/cs to be opened & assigned) 68004 – Raw Material Consumption – Others A/c is assigned

PRK: Price Differences in cost object hierarchies Loss/Gain Inventory Differences (Two A/cs to be opened & assigned)

RKA:  Inv. reductions from logistic invoice verification

UMB: Gain/loss from revaluation Checkup- 68004 is found attached (Raw Material Consumption – Others A/c )

UPF: Unplanned delivery costs

VST: Input Tax

WGI: Goods issue inflation revaluation

WGR: Goods receipt inflation revaluation

WRX: GR/IR clearing account 40051 – GR/IR Clearing A/c

WRY: GR/IR clearing acct (mat. ledger) (old) 

[Check Out: SAP MM Tutorial ]

Account assignment in SAP MM:

Account Assignment category is a very relevant field available and utilized in the purchasing documents. It has various control functions and assists in managing the objects (e.g. sales order, cost center, project) that are charged within the case of a purchase order for material that is meant for direct usage or consumption.

Use of account assignment:

You define which account assignment object is to be charged through the account assignment category such as (sales order, cost center, etc.,) Which accounts are to be charged. At the same time, the incoming invoice or else goods receipt is posted, and which account assignment data you have to give. The account assignment category is utilized at the time of the creation of a purchase order. For regular PO, no account assignment category is used.

Account assignment category:

The account assignment category defines:

The quality of the account assignment (sales order, cost center, and so on)

Which accounts are to be charged while the incoming invoice or goods receipt is posted.

Which account assignment data you have to provide.

Account assignment categories:

Asset (A)

Main asset number and sub-number

Order ( F)

Order and G/L account number

Production order

Production order number

Cost center(K)

Cost center and G/L account number

Sales order (C)

Sales order and G/L account number

Individual customer requirement(E)

Sales order and G/L account number

Project

Project and G/L account number

Unknown

None

Conclusion :

A valuation modifier is used to let the system find the predefined posting rules discover how the accounts of the financial accounting system are to be posted and update the stock fields within the material master data. Whereas by using the account assignment, we can specify which object is to be charged through the account assignment. 

You liked the article?

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Articles

Embedded Systems Interview Questions Views 1547 Types of Pointers in C Views 14352 Oracle Procure To Pay Interview Questions Views 4352 Characteristics of C Language Views 10834 Salesforce Sample Triggers with different Scenarios Views 11712 Oracle Financials Interview Questions Views 9437

Recommended Courses

About author.

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.

Stay Updated

Get stories of change makers and innovators from the startup ecosystem in your inbox

Related Blogs

SAP MM Tutorial

SAP MM Interview Questions

Enterprise Structure in SAP MM

Material Master Data in SAP MM

Vendor Master In SAP MM

Procurement Cycle In SAP MM

  • Programming
  • Admin & EIM
  • BI & BW
  • FICO & BPC
  • CRM & Sales
  • Introductions
  • SAP PRESS Subscription

Account Determination in SAP S/4HANA Materials Management

SAP PRESS

Various transactions in materials management (MM) are relevant for accounting, such as goods receipts, goods issues, and invoice receipts.

In such cases, the system always creates an accounting document and posts the amount in the appropriate general ledger accounts.

General ledger accounts are automatically determined with the help of automatic account determination settings. Consider, for example, a manufacturing enterprise that stores stock materials purchased from vendors. Whenever a material is received in a storage location with reference to a PO, the company wants its system to automatically determine and update the stock general ledger account. Similarly, whenever an invoice is posted, the system should automatically determine the vendor general ledger account and post the liability.

The SAP S/4HANA system provides automatic general ledger account posting via the automatic account determination process. When posting a goods receipt against a PO, the system creates an accounting document (along with the material document), and general ledger account postings are made. The system determines which general ledger accounts should be debited and credited based on configuration settings you’ve maintained for automatic account determination.

Essential Terms

Before discussing these configuration settings, let’s define a few essential terms:

Chart of Accounts

A chart of accounts provides a framework for recording values to ensure an orderly rendering of accounting data. The general ledger accounts it contains are used by one or more company codes. For each general ledger account, the chart of accounts contains the account number, the account name, and technical information.

Valuation Class

A valuation class is used to determine the general ledger account for the materials stock account. In automatic account determination, valuation classes must be created and then assigned to material types. While creating material master records, selecting the appropriate valuation class under the Accounting 1 tab is required. The valuation class list in the material master record will depend on the material type. For example, in a standard SAP system, material type ROH (raw material) has three valuation classes: 3000, 3001, and 3002.

Transaction Key

Transaction keys are used to determine accounts or posting keys for line items that are automatically created by the system. They’re defined in the system and can’t be changed.

Now that you have an understanding of the key terms in automatic account determination and understand how it can work in your business, we’ll move on to describe the configuration steps and business processes involved.

Configuration with the Automatic Account Determination Wizard

Automatic account determination can be configured either with or without the automatic account determination wizard, a tool provided by SAP to help you manage the automatic account determination functionality. To configure automatic account determination using the wizard, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination Wizard .

The wizard will ask you a number of questions and, based on your answers, finds the correct settings and saves them in the corresponding SAP tables. Except for a few restrictions (as documented in the wizard), the wizard will perform the following steps:

  • Defines valuation control
  • Groups valuation areas
  • Defines valuation classes
  • Defines account grouping for movement types
  • Manages purchase accounts
  • Configures automatic postings

We’ll explain how to set up automatic account determination without the wizard because this manual and step-by-step approach to account determination will help you understand how to work with the wizard. Further, using account determination without the wizard enables the creation of more complex configurations. Once you’ve gained the concepts and the fundamentals behind account determination, you can use the automatic account determination’s wizard tool to quickly setup account determination processes in SAP systems.

Configuration without the Automatic Account Determination Wizard

We’ll now follow a step-by-step approach to setting up account determination in an SAP system. We’ll cover the necessary configuration steps involved, followed by steps for assigning the configured objects in the master data. Business processes involving account determination and that use the master data are covered next. We’ll also cover the accounting entries that occur as the result of a stock posting.

Let’s walk through the required steps next:

Define a Valuation Control

In account determination, you can group together valuation areas by activating the valuation grouping code (also known as the valuation modifier ), which makes configuring automatic postings much easier. A valuation grouping code can be made active or inactive by choosing the respective radio button.

To define a valuation control, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Valuation Control .

By default, the valuation grouping code is active in the standard SAP system.

Assign Valuation Grouping Codes to Valuation Areas

The valuation grouping code makes setting up automatic account determination easier. Within the chart of accounts, assign the same valuation grouping codes to the valuation areas you want assigned to that account. As shown in the figure below, valuation grouping code 0001 has been assigned to valuation area 1100 and company code 1100. If another valuation area also uses the same set of general ledger accounts as valuation area 0001, then assign valuation grouping code 0001 to that valuation area.

To assign valuation grouping codes to valuation areas, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Group Together Valuation Areas .

Valuation Grouping

Define Valuation Classes

In this step, you’ll define the valuation classes allowed for each material type. Then, you’ll assign the account category reference to the material type. As shown in the second figure below, account category references 0001 and 0002 have been defined, and for each account category reference, one or more valuation classes can be assigned. Account category reference 0001 has been assigned to material type ROH, and valuation classes 3000, 3001, and 3002 have been assigned to account category reference 0001. Consequently, valuation classes 3000, 3001, and 3002 have been assigned to material type ROH. While creating the material master record for material type ROH, select any of these valuation classes. Similarly, for material type HALB, select valuation classes 7900 or 7901.

In this section, through an example, we’ll create the new valuation class 3004 and cover all the associated configuration settings required to ensure a working end-to-end business process.

To define which valuation classes are allowed for a material type, use Transaction OMSK or follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Valuation Classes . On the screen that appears, you’ll see three options: Account Category Reference , Valuation Class , and Material Type/Account Category Reference . Follow these steps:

  • Click on Account Category Reference and, if needed, create an account category reference, as shown here:

Account Category Reference

  • Click on Valuation Class , shown below, and then click on the New Entries Create a new valuation class ( ValCl ) 3004 (with Description Raw Materials- Steel ) and assign the valuation class to account category reference ( ARef ) 0001 . 2

Valuation Classes

  • Click on Account Category Reference and maintain a mapping between the material types and account references. For material type ( MType ) ROH , assign the account reference ( ARef ) 0001 , as shown here:

Account Category Reference with Material Type

Define an Account Grouping for Movement Types

Now, assign an account grouping to movement types. The account grouping is a finer subdivision of the transaction/event keys for account determination. For example, during a goods movement, the offsetting entry for the inventory posting (Transaction GBB) can be made to different accounts, depending on the movement type. The account grouping is provided for the following transactions:

  • Transaction GBB (Offsetting Entry for Inventory Posting)
  • Transaction PRD (Price Differences)
  • Transaction KON (Consignment Liabilities)

The account grouping in the standard system is only active for Transaction GBB. To define account groupings for movement types, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Account Grouping for Movement Types . Define the account grouping code, the movement type, and the transaction/event key combination, as shown in the next figure.

Movement Types and Account Modifiers Combinations

Note: Value strings group together the various transactions used in account determination. For example, the value string WE01 can be seen by following the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination Without Wizard > Define Account Grouping for Movement Types . On this screen, if you double-click on any entries that contain WE01, a list of transactions along with their descriptions will appear. The transactions that appear in the value string are hard coded in the system, so you should never try to change them.

Configure Automatic Postings

In this step, enter the system settings for inventory management and invoice verification transactions that result in automatic posting to general ledger accounts. A transaction/event key is a key to differentiate account determination by business transaction. For example, we must differentiate general ledger account posted by goods receipt transaction and posted by invoice receipt transaction.

You don’t need to define these transaction keys; they are determined automatically from the transaction of the movement type (inventory management) or from the transaction of invoice verification. All you need to do is assign the relevant general ledger account to each posting transaction.

To assign general ledger accounts to transaction/event keys, use Transaction OMWB or follow the menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Configure Automatic Posting . Click on Cancel , as shown below.

Configuring Automatic Postings

To assign a general ledger account, on the screen shown above, click on Account Assignment (not shown). A list of transaction keys will appear; double click on the key for which setting the general ledger accounts is required. Next, define the valuation grouping code (also known as the valuation modifier ), valuation class, and general ledger account, as shown below. Then, check the settings function by using the simulation function.

Automatic Account Posting Transactions

Use Transaction BSX for inventory posting and for assigning general ledgers. In the popup window that appears, enter the Chart of Accounts 1100 , and the screen shown below will appear.

Transaction BSX with Valuation Class 3004 and General Ledger Account

This figure shows the Transaction BSX screen for posting inventory. Click New Entries and enter the newly created Valuation Class 3004 and assign the Account 11020101 .

Go back to the screen shown when utilizing Transaction OMWB, and this time, use Transaction WRX (for the goods receipt/invoice receipt [GR/IR] clearing account) and maintain the general ledger account of the newly created Valuation class 3004 . Similarly, repeat the same steps for Transaction PRD (for price difference account).

Let’s now look at the business processes and the associated master data setup and transactions, not only to check that the newly created valuation class 3004 works correctly, but also that the associated general ledger accounts are correct.

Master Data Setup

Access the screen shown below via Transaction MM01. Under the Accounting 1 tab of the material master 157 , assign the newly created Valuation Class 3004 .

Assigning the Newly Created Valuation Class to a Material

Now, let’s discuss the account determination for the general ledger as it relates to goods receipt and goods issue postings. Post a good receipt of the material 157 with reference to a PO via Transaction MIGO. Then, display the goods receipt document and go to the Doc. info tab. Click on the FI Documents button, which will display a list of financial documents created for the goods receipt document. Select Accounting document to see the details of that accounting document.

As shown below, you’ll see the general ledger account postings, which are determined based on the automatic account determination configuration. General ledger account 11020201 (inventory raw material stock account) is debited, and GR/IR account 22010202 is credited.

Accounting Entries of Goods Receipt

In this blog post, we covered the account determination process that is useful to those running materials management with SAP .

Editor’s note : This post has been adapted from a section of the book Materials Management with SAP S/4HANA: Business Processes and Configuration by Jawad Akhtar and Martin Murray.

Recommendation

Materials Management with SAP S/4HANA

Manage your materials with SAP S/4HANA! Whether your focus is on materials planning, procurement, or inventory, this guide will teach you to configure and manage MM in SAP S/4HANA. Start by creating your organizational structure and defining business partners and material master data. Then follow step-by-step instructions for your essential processes, from purchasing and MRP runs to goods issue and receipt. Discover how to get more out of SAP S/4HANA by using batch management, demand-driven MRP, SAP Fiori reports, and other built-in tools.

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!

Share on facebook

Latest Blog Posts

A Look at Materials Management and Logistics in SAP S/4HANA

A Look at Materials Management and Logistics in SAP S/4HANA

Sales Contract Management with SAP S/4HANA Logistics

Sales Contract Management with SAP S/4HANA Logistics

The official sap press blog.

As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more!

SAP Blog Topics

  • Administration
  • Business Intelligence
  • Human Resources

Blog curated by

  • Legal Notes
  • Privacy Policy
  • Terms of Use
  • Guest Posting

SAP Material Management Tutorial

  • SAP MM Tutorial
  • SAP MM- Home
  • SAP MM - Overview
  • SAP MM - Screen Navigation
  • SAP MM - Procurement Process
  • SAP MM - Organization Structure
  • SAP MM - Enterprise Structure
  • SAP MM - Defining Structure
  • SAP MM - Organizational Units
  • SAP MM - Master Data
  • SAP MM - Purchase Info Record
  • SAP MM - Source Determination/List
  • SAP MM - Procurement Cycle
  • SAP MM - Purchase Requisition
  • SAP MM - Request for Quotation
  • SAP MM - Outline Agreement
  • SAP MM - Quota Arrangement
  • SAP MM - Posting Period
  • SAP MM - Purchase Order Types
  • SAP MM - Inventory Management
  • SAP MM - Invoice Verification
  • SAP MM - Service Management

SAP MM - Valuation

  • SAP MM - Account Determination
  • SAP MM - Configuration
  • SAP MM - Transaction codes
  • SAP MM Useful Resources
  • SAP MM - Questions & Answers
  • SAP MM - Quick Guide
  • SAP MM - Useful Resources
  • SAP MM - Discussion
  • Selected Reading
  • UPSC IAS Exams Notes
  • Developer's Best Practices
  • Questions and Answers
  • Effective Resume Writing
  • HR Interview Questions
  • Computer Glossary

Procurement process starts with creating a purchase order and ends with invoice verification. In the whole process, one of the important parts is material valuation. While creating purchase orders, material price is a mandatory field and it is automatically determined. It happens because material valuation is maintained in the SAP system in the material master. Material valuation represents integration between MM & FI (Financial Accounting) modules, since it updates the general ledger accounts in financial accounting. The key points to note about material valuation are as follows −

Material valuation helps in determining the price of the material, and in which general ledger account it needs to be posted.

Material valuation can happen at company code level or plant level.

Material can be valuated based on different types of procurement; it is known as split valuation .

Split Valuation

Split valuation helps in valuating the stocks of a material in the same valuation area (company or plant) differently. Some of the examples where split valuation is required are as follows−

Stock that is procured externally from a vendor has a different valuation price than the stock of an in-house production.

Stock obtained from one vendor is valuated at a different price than the stock obtained from another vendor.

Same material having different batch may have different valuation prices.

Split Valuation needs to be activated before setting any other configuration. Follow the steps given below to activate split valuation.

Path to Activate Split Valuation

IMG ⇒ Materials Management ⇒ Valuation and Account Assignment ⇒ Split Valuation ⇒ Activate Split Valuation

TCode: OMW0

Step 1 − On the Display IMG screen, select Activate Split Valuation by following the above path.

SAP Split Valuation

Step 2 − Click the option Split Material Valuation Active. Click on Save. Split valuation is now activated.

SAP Split Valuation Set

Some important terms under split valuation are as follows.

Valuation Area − Material may be valuated at plant level or at company code level. The level at which materials are valuated is known as valuation area.

Valuation Category − Valuation category is the criteria on which material is split valuated.

Valuation Type − Valuation type specifies the features of a valuation category.

Split valuation configurations like defining valuation category, valuation type are described in below context.

Split Valuation Configuration

Follow the steps given below to do split valuation configuration such as defining valuation category and valuation type.

Path to Configure Split Valuation

IMG ⇒ Materials Management ⇒ Valuation and Account Assignment ⇒ Split Valuation ⇒ Configure Split Valuation

TCode: OMWC

Step 1 − On the Display IMG screen, select Configure Split Valuation by following the above path.

SAP Split Valuation Configuration

Step 2 − Click Global Types to create valuation type.

SAP Split Valuation type path

Step 3 − Click the Create button.

SAP Split Valuation type create

Step 4 − Provide the name of the valuation type. Click on Save. A new Valuation Type will be created.

SAP Split Valuation entry

Step 5 − Now go to the same screen and click Global Categories to create valuation category.

SAP Split Valuation category

Step 6 − Click the Create button.

SAP Split Valuation Category create

Step 7 − Provide the name of the valuation category. Click on Save. A new Valuation Category will be created.

SAP Split Valuation Category entry

Step 8 − Now go to the same screen and click Local Definitions to map valuation type and valuation category.

SAP Split Valuation Map

Step 9 − Click the Cats. → OU button..

SAP Split Valuation map select

Step 10 − Provide valuation type, valuation category, and set the status as active, and then click the Activate button. Valuation category and valuation type are now mapped and both are activated.

SAP Split Valuation map entry

After maintaining the valuation type and valuation category, you can mention them in the material master as shown below.

Go to mm02 (Change screen for material master). Here you can maintain the valuation category and valuation class in accounting view. On this basis, valuation of the material will be done in a purchase order.

SAP Split Valuation material master

To Continue Learning Please Login

SAP® MM Questions and Answers by Kogent Learning Solutions Inc.

Get full access to SAP® MM Questions and Answers and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

CHAPTER 8VALUATION AND ACCOUNT ASSIGNMENT

1. how can we create the vendor account group in sap.

sap mm valuation and account assignment

2. What is the purpose of material valuation?

Get SAP® MM Questions and Answers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Cover of Software Architecture Patterns

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

sap mm valuation and account assignment

Setting Up Account Determination

After completing this lesson, you will be able to:

  • Use the control options for account determination

Account Determination Influencing Factors

The system automatically determines the financial accounts that are automatically posted with the goods movement.

When a goods movement is recorded, the system posts to the stock account of the material and to one or more offsetting accounts depending on the goods movement. This automatic account determination depends on various factors, such as the chart of accounts, the plant (or valuation area), but also on the material.

The following table roughly represents the account determination logic for goods movements with the determining factors.

It shows an example for a simple goods issue to a cost center.

Chart of account

Transaction key (derived from )

General modification (more detailed identification of the transaction key, if available.)

Valuation modification (grouping code for )

(assigned to a product at plant level)

Account debit

Account credit

YCOABSX 000130001310000013100000
YCOAGBBVBR000130005110000051100000
YCOA...     

Let's look at the influencing factors one by one.

The type of goods movement

Depending on whether you are posting a goods issue to a cost center or a goods receipt with reference to a purchase order, for example, different posting schemas result:

  • A goods receipt with reference to a purchase order results in at least a debit posting to an inventory account, possibly another debit posting to a price difference account if the material is valuated at standard price, and a credit posting to a GR/IR clearing account that is cleared when the invoice is posted.
  • A goods issue to a cost center results in at least one credit posting to an inventory account and one debit posting to a cost account.

The posting schema, that is the possible posting line types to be generated, is assigned to the movement type. You can view it in the movement type configuration.

Start the following interactive demo to learn more about the posting schema depending on the type of goods movement.

In the previous demo, we learned that when a goods issue is posted to a cost center, in addition to the stock account (transaction key BSX), an offsetting account is also updated, which is further specified by transaction key GBB plus account modification VBR. This explains columns 2 and 3 in the table above.

  • The valuation area

The valuation area is a logical organizational unit that structures a company for the purpose of uniform and complete valuation of material stocks. In SAP S/4HANA Cloud Public Edition, each plant represents a valuation area. 

This means that you can basically control automatic account determination per plant.  You assign a valuation grouping code to each plant to group plants that should be treated the same for account determination. The valuation grouping code is an account determination key (see column 4 of the table above).

The following image shows the Group Together Valuation Areas configuration activity where you assign a valuation grouping code to plants. Here, you can see that valuation grouping code 0001 is assigned to all plants.

sap mm valuation and account assignment

The product

The following video explains how account determination is affected by the valuation class in the material master record.

To learn how to create and assign valuation classes start the following interactive demo.

To learn how to create an account category reference and assign it to a material type, start the following interactive demo.

We have reviewed each of the following  factors that influence account determination:

  • The movement type
  • The material

Account Determination Configuration

Automatic account determination configuration activity.

Now that we have examined the factors that influence account determination, start the following demo to learn how you can define accounts for certain combinations of factors that the system can automatically determine for goods movements.

In practice, account determination for goods movements is a joint task of the logistics/supply chain and finance teams. An important contribution of the supply chain consultants is to understand the interrelationships and influencing factors so that the finance people can assign the correct accounts.

Log in to track your progress & complete quizzes

SAP Logo

3331798 - Multiple account assignment valuation

Users have observed that the valuation of goods receipts for Purchase Orders (POs) with multiple account assignments exhibits discrepancies when compared to POs with a single account assignment. This variance becomes evident upon reviewing the accounting document following the goods receipt posting. Such differences may lead to confusion and inaccuracies in financial reporting and inventory valuation.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • Materials Management (MM)
  • SAP ERP Central Component
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

valuation, clearing account, multiple account assignment, KBS, WRX, Goods Receipt Valuation, Multiple Account Assignment, Purchase Order Discrepancies, Proportional Distribution, Financial Reporting Accuracy , KBA , MM-IM-GF-POVL , Purchase Order Valuation , Bug Filed

About this page

Search for additional results.

Visit SAP Support Portal's SAP Notes and KBA Search .

Privacy | Terms of use | Legal Disclosure | Copyright | Trademark

IMAGES

  1. SAP MM

    sap mm valuation and account assignment

  2. # SAP MM #Create valuation Class and Account Category Reference # Assign with material type

    sap mm valuation and account assignment

  3. SAP Material Valuation Tutorial

    sap mm valuation and account assignment

  4. SAP MM

    sap mm valuation and account assignment

  5. SAP MM

    sap mm valuation and account assignment

  6. SAP MM

    sap mm valuation and account assignment

VIDEO

  1. Sap Mm Logical Questions

  2. 97- Miscellenous In SAP MM

  3. SAP MM Valuation Class #13 part 2

  4. SAP MM Valuation Class #13 part 1

  5. 9) Material Valuation for Moving Average Price Materials in SAP

  6. Pricing Procedure Configuration in SAP MM S4 HANA

COMMENTS

  1. SAP Library

    SAP Library: Getting Started: Release notes: IMG: Glossary: Help on Help Advanced Search : Open All : Close All: Back : Forwards : Synchronize: Valuation and Account Assignment Define Price Control for Material Types Split Valuation Valuation at Retail and Value-Based Inventory Management Account Determination Configure Price Change in Previous ...

  2. Solved: Valuation and Account Assignment

    When stock is valuated at company code level, the valuation price of a material is the same in all of a company's plants. SAP recommends that we set material valuation at Plant level. The influencing factors that determine how SAP choose the G/L account numbers that are involved in the accounting journal for MM transactions are: 1.

  3. What is Account Assignment Category in SAP MM, How to configure?

    Account Assignment Category: It indicates what type of purchase the company is doing in Purchasing Documents, whether it is for consumption or anything relation to orders, projects etc. The nature of this also indicates which accounts it needs to be charged for when the incoming invoice and Goods Receipt are posted. Path.

  4. Valuation Class in SAP MM

    SAP MM valuation and Account Assignment. This is completely integrated with FI(Financial Accounting). material Valuation: stock value= stock Qty x Price. The material valuation will update the G/L accounts in Financial Accounting. SAP MM valuation: The procurement process begins with generating a purchase order plus ends with invoice verification.

  5. SAP MM

    SAP MM - Account Determination - In SAP MM, procurement process involves the cost of goods and services that needs to be paid to the vendor by an organization. ... IMG ⇒ Materials Management ⇒ Valuation and Account Assignment ⇒ Account Determination ⇒ Account Determination without Wizard ⇒ Define Valuation Control. TCode: OMWM. Step 1 ...

  6. SAP Library

    The account category reference is, in turn, assigned to precisely one valuation class. This means that each material type has its own valuation class. Recommendation. We recommend that you create the account groups of your chart of accounts as an account category reference. Example GKR: 3000 for raw materials; 3030 for accessory materials

  7. Account Determination in SAP S/4HANA Materials Management

    For example, the value string WE01 can be seen by following the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination Without Wizard > Define Account Grouping for Movement Types. On this screen, if you double-click on any entries that contain WE01, a list of ...

  8. SAP MM

    SAP MM - Valuation - Procurement process starts with creating a purchase order and ends with invoice verification. In the whole process, one of the important parts is material valuation. ... IMG ⇒ Materials Management ⇒ Valuation and Account Assignment ⇒ Split Valuation ⇒ Activate Split Valuation. TCode: OMW0. Step 1 − On the Display ...

  9. SAP Library

    In this step, you assign valuation areas to a valuation grouping code. The valuation grouping code makes it easier to set automatic account determination. Within the chart of accounts, you assign the same valuation grouping code to the valuation areas you want to assign to the same account. Valuation grouping codes either reflect a fine ...

  10. Automatic Account Determination Overview

    Automatic Account Determination Overview. 08-13-2014 11:34 AM. When a goods movement is entered, the G/L accounts need not be entered manually since SAP automatically determines the correct accounts. The settings for this automatic account determination & material valuation are done by using the account information set up in advance in an area ...

  11. CHAPTER 8 VALUATION AND ACCOUNT ASSIGNMENT

    Material valuation in the SAP materials management (MM) module is necessary to determine the stock ... Get SAP® MM Questions and Answers now with the O'Reilly learning platform. O'Reilly members experience books, live events, courses curated by job role, and more from O'Reilly and nearly 200 top publishers.

  12. Account Assignment

    Use. You can assign one or more account assignments to an item. Multiple account assignment allows you to apportion the costs covered by a purchase order partly to your own cost center and partly to others, for example. You specify which account assignment object is to be charged via the account assignment category. Account Assignment Category.

  13. SAP Library

    Purchase Account Management. In this step, you make the settings for the purchase account. Note. Due to special legal requirements, this function was developed specially for certain countries (Belgium, Spain, Portugal, France, Italy, and Finland). Before you use this function, check whether you need to use it in your country.

  14. Defining Account Determinations for Material Ledge...

    The G/L account is derived automatically from a default combination of configuration settings of material type, valuation class of material, and (in the case of split valuation) the valuation type and movement types. The mechanism to automatically determine the G/L account for each business transaction is called automatic account determination.

  15. Solved: Valuation Class and GL account assignment

    Maintain the GL account for the transaction key BSX and WRX for the valuation class YYYY. 3. Create a Purchase order without material and. a. specify the material group as XX. b. Account assingment = K. c. Go to Account assingment tab at the item level. d. specify the cost center number in it.

  16. Setting Up Account Determination

    The valuation grouping code is an account determination key (see column 4 of the table above). The following image shows the Group Together Valuation Areas configuration activity where you assign a valuation grouping code to plants. Here, you can see that valuation grouping code 0001 is assigned to all plants.

  17. SAP Library

    Valuation and Account Assignment . In this section, you make the system settings required for the following areas: Material valuation; Link between Materials Management and Financial Accounting; Requirements. You must have processed the defaults for the material types before you can make your configurations for "Valuation and Account ...

  18. Valuation and Account assignment

    In that my role/responsibility is to prepare business documents related to valuation and account assignment. So, any body having business documents related to Valuation and Account assignment kindly forward to below mail id. Thanks & Regards. Ravi. hi, check these notes. SAP notes : 301477, 165692, 189662, 523495, 216417, 158220, 441991. Notes ...

  19. Valuation and account assignment

    I configured the split valuation in order to have different valuation types for the valuation category M (ED split value u2013 IS-OIL) but the material master doesnu2019t display the valuation category field in the Accounting 1 view. I configured the valuation areas, the valuation classes in the accounting determination.

  20. Solved: Valuvation Modifer and General Modifier

    They are dependent on the account grouping to which each movement type is assigned. To see more details click on the documention icon next to Customizing for MM, choose Valuation and Account Assignment -> Account Determination -> Automatic Determination Without Wizard -> Configure Automatic Postings

  21. MM Account Assignment

    Go to OMJJ and choose your movement type example 301. Then to your left side you can see account grouping. click there. Where ever you see AUM for movement type 301 enter account modifier as z92. So whenver 309 happens system picks GL assigned to z91 and whenever 301 is used system picks GL account assigned to z91.

  22. 3331798

    Users have observed that the valuation of goods receipts for Purchase Orders (POs) with multiple account assignments exhibits discrepancies when compared to POs with a single account assignment. This variance becomes evident upon reviewing the accounting document following the goods receipt posting. Such differences may lead to confusion and ...

  23. Valuation and account assignment

    The SAP Partner Groups will be INACCESSIBLE January 16-23 for a technical migration. For more information, please click the button at right to view the partner page ... Nov 02, 2007 at 01:17 PM Valuation and account assignment - SD / MM related issue. 61 Views. Follow RSS Feed When we issue the material against sales order (delivery), system ...

  24. The problem of posting invoices for projects

    The problem of posting invoices for projects. I have a problem with posting an invoice, when I try to send it to accounting, I get the message: Enter only one true account assignment - Message no. KI249. It is about posting the delivery via project, tcode VL01N. After that, tcode VF01 creates the invoice but does not allow it to be released to ...