sap material master account assignment group

• Terms of Use
• Privacy Policy
• SAP ERP Solutions
• What does SAP stands for

ETCircle.com SAP FI and CO consultant information

Materials: account assignment groups | ovk5.

In this configuration activity we are able to define account assignment groups for materials used in Sales and Distribution Module ( SD ).

Transaction: OVK5

IMG Path: Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination ->  Check Master Data Relevant For Account Assignment

Tables:  TVKM, TVKMT

If you use the IMG Menu, you will have to choose the first option on the pre-selection screen.

On the main screen there is a list of Account Assignment Groups for Materials. You can create new here if you need.

Tags Account Assignment OVK5 TVKM TVKMT

About Emiliyan Tanev

Related articles, assign g/l accounts | vkoa, customers: account assignment groups | ovk8, define automatic credit control | ova8, configure automatic postings | omwb.

In this FICO configuration activity we are able to define account determination for automatic postings …

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.

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

Account Determination in SAP S/4HANA Materials Management

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 .

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:

• 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

• 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:

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.

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.

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.

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.

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 .

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.

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

Ready to streamline your SAP S/4HANA Finance system? Learn how to determine accounts for your core business areas via the SAP GUI, including materials management, sales and distribution, accounts receivable and payable, cash and banking, and fixed assets. Follow step-by-step instructions to configure automatic account determination for each process in your system. Your journey to simplified accounting starts here!

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!

Latest Blog Posts

3 Steps to Pre-Planning Repetitive Manufacturing and MRP with SAP S/4HANA

How to Delete Business Partners in SAP S/4HANA Sales

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

3431836 - How to create new material group and link it to G/L Account

How to create new material group and link it to G/L Account

Environment

SAP S/4HANA Cloud

You can create new material group using SSCUI 102665   'Define Material Groups ' , but you cannot directly assign a Material Group to a G/L Account.

Instead a Material Group is assigned to a Valuation Class using  SSCUI 102424.

New material groups, Define Material Groups, G/L account, S/4hana cloud, LO-MD-MM , KBA , LO-MD-MM , Material Master , How To

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

• What is SAP SD?
• SAP SD Training Tutorials for Beginners
• SAP SD T-codes
• SAP SD User Exit for Billing Document
• SAP SD User Exits for Sales Order
• SAP Customer Down Payment Configuration
• SAP PGI (Post Goods Issue)
• SAP IS-Retail Module
• SAP Incoterms
• SAP SD Variant Configuration Steps
• SAP SD Configuration Step by Step Guide
• SAP SD Credit Management Interview Questions
• Account Assignment Group In SAP
• Subcontracting Process In SAP SD
• Rebate Processing In SAP SD
• Difference Between Rebate And Discount
• Movement Type In SAP
• SAP SD Availability Check Configuration
• Debit And Credit Note in SAP
• Sales Documents List
• Intercompany vs Intracompany
• SAP SD Pricing Routines & User Exit
• Shipping Condition In Sales Order
• SAP SD Invoice Table
• SAP SD Certification & Course Fees
• SAP SD Interview Questions

Define Account Assignment Group

Updated May 18, 2018

Field found in Material Master Sales Organization 2. To define the General Ledger Posting:- IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing. User will not be able to Release the billing document to Accounting if this is not setup. If you happened to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment. * Transaction code VKOA REPORT ZMATNR_AC_ASSIGN LINE-SIZE 132 NO STANDARD PAGE HEADING LINE-COUNT 044(001).

• 05 Apr 2010 6:12 am Manzoor Ahmad Its very good and helpful for SD Trainee.
• 08 Oct 2010 8:24 am Guest very nice.....

Changing material account assignment group in sales order

I have a requirement where I have a sales order with 2 different line items and I need to post the net values for wach of those line items to different GL accounts. I was thinking to do this based on the material account assignment group. However in the sales order this field in greyed out and not possible to change. The value is taken from the material master and cannot be changed in the sales order. I find this hard to understand why SAP will not give the user the option to change the material account assignment if required during sales order processing, when the customer account assignment can be changed. Any clarification and advise is appreciated Thanks and Regards AXM

I found the solution; the account assignment can be changed during billing.

NO. My issue is not VKOA settings…I will obviously assign the GL’s against these keys…

My issue is say that I default 01 acc assignment in the material master which is linked to GL#100100…But I will also configure another acc assgn 02 which is linked to GL 200200. Now in order processing the user wants to have the option to either post to 100100 or 200200 depending on certain situations…However in the sales order only acc assgn 01 which is the default setting in the material master will show up and this field is non-modifiable. So how can the user if we want post to the other GL acc#200200 since the default acc assgn 01 will point to 100100.

Related Topics

Querying Employee Master Data and Organizational Assignments from SAP SuccessFactors Employee Central

After completing this lesson, you will be able to query employee master data and organizational assignments from Employee Central .

Parameters for the Employee Master Data and Organizational Assignment Query

Employee organizational assignments are replicated together with employee master data based on the employee's job information and job relationships in Employee Central.

Recommendation: Configurable Organizational assignment

The following is the recommended approach! New configurable approach; configurable organizational assignment : In the new ECS4HCM add-on, customers can configure what data is replicated from Employee Central to reflect the organizational assignments of the employees in the SAP S/4HANA system.

Previous Approach

Previous (nonconfigurable) approach; classical org. assignment : In the PA_SE_IN add-on, the replication of organizational assignments wasn’t configurable. The way how position relationships were created in the SAP S/4HANA system was hard-coded. All additional or deviating logic could be influenced only by implementing a Business Add-In (BAdI).

Options with Configurable Organizational assignment

With the configurable organizational assignment, you can:

• Configure the standard (hard coded) relations between employee position and assigned objects and also other SAP S/4HANA relations and SAP S/4HANA custom relations.
• Map the Employee Central object IDs from standard fields and also from customer fields.
• Fill extra fields (such as PROZT) of relations from customer fields.
• Configure a flexible org. hierarchy.
• Configure any kind of job relationships.
• Copy sample content for the standard organizational assignment relations.
• With the new configurable organizational assignment, organizational assignment BAdIs are no longer called.
• "Reduced organizational assignment" constants to exclude relations are no longer considered. Instead, only those HRP1001 relations that are not written by the generic organizational object replication must be configured.

Customizing: Define Parameters for Employee Master Data and Org Assignment Query

The settings for the query report are configured per transformation template group through the customizing activity Define Parameters for Employee Master Data and Org. Assignment Query :

• Restrict data replication to: Company, country/region, employee class, type of workforce.
• Decide whether the query only transfers employments whose company and country/region assignment matches the defined company and country/region filters.
• Include organizational assignments into the replication.
• Prevent replication of organizational assignments for employees with specific employment statuses.
• Specify the target system of the data replication that DRM is to monitor.
• Specify to use the external cost center ID instead of the internal cost center ID for the mapping.
• Enable the replication of multiple job events per day.
• Enable the replication of multiple compensation events per day (only available for Brazil.)
• Enable notifications being created for the Employee Central Data Replication Monitor.
• Disable confirmations being sent to the Employee Central Data Replication Monitor.

Configure the Parameters for the Employee Master Data and Organizational Assignment Query

Employee master data and organizational assignments query from employee central, query program.

The query program Create and Execute Employee Master Data and Org. Assignment Query (ECPAO_EE_ORG_REPL_QUERY) creates and sends a query to replicate employee master data from SAP SuccessFactors Employee Central to the SAP S/4HANA system.

Transformation template group (mandatory):

• The query runs for all employees specified by the selection criteria, based on the transformation template group that is entered on the selection screen and based on the configuration stored for this transformation template group.
• Which data is queried from Employee Central depends on which transformation templates are contained in the template group.
• The earliest transfer date of the transformation template group defines the full transmission start date (FTSD) to be used for data replication.

External employee ID (optional):

• Entering specific IDs triggers a full load for the employees in question.
• To improve the performance, only a maximum number of 500 employees can be selected at a time.

Change date (optional):

• Employees whose master data (or organizational assignments if applicable) was changed after this date are queried.
• The change date must not be more than three months in the past and must be before the last modified date. If a change date is entered, the last modified date is reset to this change date.

Enable payload logging (optional):

• With this option, extended information is transferred to the process log in the middleware.
• This completes the options of the query program Create and Execute Employee Master Data and Org. Assignment Query .

Processing Program: Process Employee Replication Requests

The SAP S/4HANA system creates a replication request for each employee in the staging area when a replication run contains new or updated data for this employee. Writing replication requests to the staging area triggers the event SAP_SFIOM_EE_ORGAS_RPPQ_CREATED in the SAP S/4HANA system.

The processing program Process Employee Replication Requests (ECPAO_RPRQ_EE_PROCESSING) is used to process replication requests from the staging area for employee master data and employee organizational assignments replicated from SAP SuccessFactors Employee Central. The processing program can be scheduled as a regular background job that is registered on the triggered event.

The processing program can also run in dialog mode to process a specific set of replication requests:

• External employee ID : Enter external employee IDs to process the requests of one or more specific employees.
• Include failed requests : Select this checkbox to process the latest request of employees although it has the status Failed.
• Parallel processing : Keep the default setting to process multiple packages with replication requests in parallel.
• Server group name : Select a server group if server groups are used for specific purposes in the system. If a specific server group is not selected, the program uses all available work processes on all server groups.
• Sequential processing : To process packages one after the other instead of in parallel, select this option.

Query Employee Master Data and Organizational Assignments Manually from Employee Central

Employee master data and organizational assignment query management.

Reset the status of an employee master data and organizational assignment query if it cannot be completed in a longer period of time due to errors. The reset is necessary so that the next scheduled query can start .

You can set the query status manually to Failed if a query sent by the Create and Execute Employee Master Data and Org. Assignment Query (ECPAO_EE_ORG_REPL_QUERY) program remains in the Sent or In Process status for a longer period of time. Resetting the status is necessary since the next query cannot be created before the current query has one of the statuses Successful or Failed . A query remains in the Sent status if it doesn’t reach the middleware, for example, due to configuration issues. It remains in the In Process status if data can't be transferred from Employee Central. If the query remains in the Sent status, it can be resent after a five-minute timeout has passed. Since the queries are triggered and administered by the SAP S∕4HANA system, you can't use the middleware to reset the query status.

Created On shows when the query was initiated. Status Set On shows when the status of the query was set. For successful queries, the difference between these two time stamps tells you how long the replication took. Here's an example:

Example: Query Runtime

This query ran for 2 minutes and 35 seconds.

You can also delete single queries completely.

To bulk-delete queries with the type Employee-Specific Query and one of the statuses Successful or Failed , use the Delete Queries from Admin Tables for EE Master Data and Org Assignment (ECPAO_DEL_EE_ORG_QRY_ADM) program.

• Go to the Reset Query Administration Table (ECPAO_RESET_QRY_ADM) transaction in your SAP S∕4HANA system.

You can't reset the status of queries that already have the status Successful or Failed .

In productive system environments, delete only queries of the Employee-Specific Query type and only if they have one of the statuses Successful or Failed . If you delete other types of queries, the last modified date is removed. This means that the next query will trigger a full load, unless you enter a change date in the Select Employees with Data Changes After section.

Log in to track your progress & complete quizzes