account assignment group in billing document

G/L Account Determination in SAP SD

Most of the transactions in SAP are recorded against the GL account. During creation of billing document form a sales order , an accounting document is created where material value is posted against a G/L account. The post describes how the system determines the G/L account for a material sold to a particular customer by the GL account determination technique.

Lets try to create a sales order for a customer with some material and then creating a billing document from the sales order which also generated the accounting document.

To create sales order go to Tx- Va01

Lets create a debit memo request for the sales area 1000/10/10.

Provide the customer number and few materials and its quantity and double click on the first material to see the item details.

From the pricing procedure – for the pricing condition type- PR00 material value is calculated as 175.50 EUR.

For the second material  for the pricing condition type- PR00 material value is calculated as 1598.00 EUR. Go back.

Select the header button.

In the header section, in the Conditions tab, the total price is the sum of two materials.

Save  and DMR is created.

Go to Tx- VA02 and  from the menu choose Billing.

Select Save button to create a billing document. mark billing document type is determined as – L2.

Go to Tx- VF03 and display the billing document. Choose Accounting button.

Choose Accounting document.

Here is the accounting doc with few lines.

First entry is for the customer as we used the customer – 491000, the account becomes 491000 for the customer.

For the second line, the GL account calculated as 502000. Let’s figure it out how this g/L account is determined.

Go to Tx- VF02 and edit the billing document.

From menu, navigate along the highlighted path.

Well, it says the Account Determination procedure is KOFI00 and for the first item , for the pricing condition type PR00, the G/L account as 502000.

Same for the second item.

The G/L account determination requires few customizing steps.

First check what is the chart of account assigned to the company code. In SPRO IMG structure navigate along the highlighted path to see the chart of account assigned to the company code. 

For the demo we use company code- 1000

The chart of account is – YIKR

Next step , the customizing in the Sales&Distribution section for the Account Assignment/Costing.

First execute – Check master data relevant for account assignment.

Select first option- Materials : Account Assignment Groups.

Here Material account assignment group is created which is assigned to the material master when created in Tx- MM01

Select second  option- Customer : Account Assignment Groups.

Here Cusomter account assignment group is created which is assigned to the customer master when created in Tx- XD01

For our used material in sales order- H11, open this material in Tx- MM03 and in the Sales: sales org.2 tab, the material account assignment group is assigned to the material.

Similarly for another material used in sales order, it is assigned to the material account assignment group.

For our customer – 491000, open this customer in Tx- XD03 and go to the sales area data & in the billing document tab, customer account assignment group is assigned to the customer.

This customer and material account assignment group will help to determine the GL account.

GL account determination uses the condition technique. Now the next step is to define the condition tables. So choose option- Define Dependencies of Revenue Account Determination.  If you want to create new tables you can choose Create Table option. For this demo we are leaving this as already we have few condition tables.

Next is defining the access sequence and the condition type. So choose the highlighted opton.

Access Sequence is defined as – KOFI( a new access sequence can be created bu New Entries button ).  Select the access sequence and choose Accesses from left hand section to see all the access lines with condition table.

Well this access sequence KOFI has five access line each refers to one condition table.

Select one access line and choose Fields button to see all the fields included in the condition table to form the access line 10.

Access line-10 with condition table 001 has 4 fields.

Similarly for other access lines with condition tables other fields are there.

For access line 30.

For access line 40.

Choose Define Account Determination type.

Here Condition type- KOFI is created which is assigned to the access sequence KOFI which has 5 access lines with different condition tables.

Choose the option as pointed to create account determination procedure.

Procedure KOFI00 is created and assigned to the account condition types. Choose the procedure and select Control data from left side.

Here the account determination procedure is assigned to the condition type.

Choose the option – Assign account determination procedure.

Here the account determination procedure is assigned to the billing type.

Next step is to define account key. Choose the marked option.

For different types like revenue, tax and other different account keys are defined. For revenue its ERL.

Next step is to assign the account key to the pricing procedure – condition type PR00.

Here for the pricing procedure ZVAA01 and condition type PR00, the account key is assigned as ERL.

In the above created sales order, item we can check the pricing procedure as below bu selecting the Analysis button in the conditions tab of the item detailed screen.

Next time is to assign the G/L account. Choose the marked option.

Here we have five options. as account condition type KOFI of the account determination procedure KOFI00 is assigned to the access sequence – KOFI with five access lines.

This is like maintaining the condition records. During the GL account determination process, it checks to find the GL account by taking all the values from the billing document and checking against the condition records for table 001. If found it calculated the G/L account and if not found then checks for the condition records for the second table and so on upto 005 until it finds a G/L account.

Choose/double click on the first line.

Here we have maintained for V-Sales, KOFI- account condition type, YIKR as the chart of account and other four fields like sales org, customer account group, material account group and account key comes from the condition table, for our demo purpose we have assigned the G/L account as- 502000.

( Before assigning to the G/L account here it should be created first).

For our demo

• From Billing Type L2 it derives the account determination procedure as- KOFI00
• From account determination procedure- KOFI00 it find the account condition type as – KOFI
• During creation of billing its finds for the item, pricing procedure and the condition type as PR00
• Then it finds the account key for the pricing procedure with condition type PR00 as ERL
• The customer account assignment group is – 03
• The material account assignment group is – 01
• The chart of account as- YIKR fot the company code- 1000
• By taking all these values, the G/l account number calculated as – 502000

• Click to share on Twitter (Opens in new window)
• Click to share on Facebook (Opens in new window)
• Click to share on LinkedIn (Opens in new window)
• Click to share on WhatsApp (Opens in new window)

12 comments

Very well explained

Can you please explain me how to assign different GL account while creating accounting document? What changes do I have to make?

is there any way to do a mass analysis on how account assignment has been done over a period of time? ie which tables were used with with criteria? We want tot clean up the SD account assigment tables which currently have over 100.000 entries and are not manageble anymore.

It’s truly a nice and useful piece of info. I’m happy that you shared this useful info with us. Please keep us up to date like this. Thank you for sharing.

Hi. I have an inquiry regarding the classification of ERL account group. In my current company, there are two GL accounts which are currently tagged to ERL (Revenue) – one is cash and another is VAT adjustment (based on their description). My question is, are those two accounts valid to be determined under ERL? If so, what is the impact if this matter is unresolved? Hope someone can take up and provide me a good input. Many thanks in advance.

this is how the fucking a document must be. excellent!

Thank you so much, detail explanation. Appreciate the hard work

Could you add little detail on ” how does the pricing procedure ZVAA01 and condition type PR00 linked/determined for an item”

Pricing procedure is not determined on the item level. Pricing Procedure is determined on the header level. In tx- OVKK , the determination of pricing procedure customizing are maintained. The sales area, document pricing procedure and the customer pricing procedure determines the pricing procedure. When an order is created we know the sales area(sales org, dist channel and division), the document pricing procedure derived from the document type and from the sold-to-party (customer) the customer pricing procedure is derived. With all these information, Pricing procedure is derived.

The pricing procedure contains condition types like PR00 and others. In Tx- VK11/VK12/Vk13 we can maintain pricing condition records against each condition types. When we enter a material in an item, from the already determined pricing procedure it gets the condition types and tries to find the pricing condition record for the material. This is how the price is found for that item condition type.

Hope this helps!

Like Liked by 1 person

Thanks to you Siva and Manish, I am not in to SD but was trying to have extended understanding between FI-SD integration and found your tutorial, its really help full. I was going through with the tutorial and played your videos as well in you tube. It helps me to understand the process and bridge the gaps from SD side. Really appreciate your effort on preparing and sharing the knowledge

Thanks for the details .suggest reading the note on account-determination helpful things are described there

execellent..well done..thank you

Leave a Reply Cancel reply

• Already have a WordPress.com account? Log in now.
• Subscribe Subscribed
• Copy shortlink
• Report this content
• View post in Reader
• Manage subscriptions
• Collapse this bar

SAPHANATUTOR.COM

SAP ECC | SAP S/4 Hana Tutorials

Revenue Account Determination in SAP SD: A Comprehensive Guide

Revenue Account Determination in SAP SD , is a crucial integration point between the SD and Financial modules. It ensures that when a billing document is created, the system accurately identifies and posts revenues, taxes, and sales deductions to the appropriate accounts. This process, deeply rooted in the condition technique of SAP, requires a collaborative effort between the SD and Finance teams. Here’s a step-by-step guide to understanding and implementing revenue account determination in SAP SD .

Table of Contents

Revenue Account Determination in SAP SD

Revenue Account Determination in SAP SD involves 6 configuration steps they are

• Check Master Data Relevant for Account Assignment
• Define Dependencies for Revenue Account Determination
• Access Sequence and Account Determination Types
• Define and Assign Account Determination Procedure
• Define and Assign Account Keys
• Assign G/L Accounts

Step 1: Master Data Relevance in Account Assignment

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Check Master Data Relevant for Account Assignment.

The first step involves checking the master data relevant for account assignment. This includes:

• Material Account Assignment Group : This groups materials to post related revenues into specific accounts. For instance, revenues from laptop sales might be posted to one account, while desktop sales go to another. This grouping is maintained in the Material Master ( MM03 ) under the Sales org data 2 view.

• Customer Account Assignment Group : Similar to materials, customers are grouped to direct revenues into designated accounts. This could differentiate between domestic and international customer revenues. This grouping is found in the Customer master ( VD03) under the Sales area view/Billing tab.

Step 2: Defining Dependencies

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define dependencies of Revenue account determination.

The second step is about defining dependencies for revenue account determination. This involves creating field catalogs and condition tables , which are essential for setting up the account determination tables.

Step 3: Access Sequence and Account Determination Types

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define Access Sequences And Account Determination Types.

This step focuses on setting up the access sequence for account determination and defining the account determination types. The access sequence dictates the order in which tables are accessed, while the account determination type functions like a condition type in the pricing procedure.

Detailed Configuration Steps

Step 4: account determination procedure.

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define and Assign account determination procedure.

Step 5: Account Keys Definition and Assignment

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define and Assign Account keys

Account keys play a pivotal role in account determination. They are linked to pricing condition types and are critical in linking the pricing procedure with the account key. Different pricing conditions have distinct account keys, like “ERS” for discounts, “ERL” for price, and “MWS” for taxes.

Step 6: Assigning G/L Accounts

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Assign G/L accounts.

The final step involves assigning General Ledger (G/L) accounts. This is akin to maintaining condition records for pricing condition types. The G/L account determination is a combination of the application, account determination condition type, chart of accounts, and account keys

Role of Account Keys in Pricing Procedure

Learn about role of account keys in pricing procedure here.

Related posts:

• Role of Account Keys in SAP Pricing Procedure
• How to configure material determination in SAP?
• SAP SD Partner Determination: Configuration Guide
• Exploring SD Pricing in SAP -Detailed Explaination
• How Customer Account Groups in SAP SD are created | Saphanatutor.com

• 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

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