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

Cross-Functional Customizing in SAP S/4HANA MM: Account Determination Configuration

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:

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

f.hubspotusercontent00.nethubfs57072001995-1

Get MM on SAP S/4HANA! Set up the master data your system needs to run its material management processes. Learn how to define material types, MRP procedures, business partners, and more. Configure your essential processes, from purchasing and MRP runs to inventory management and goods issue and receipt. Discover how to get more out of SAP S/4HANA by using batch management, special procurement types, the Early Warning System, 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

Sales Contract Management with SAP S/4HANA Logistics

Sales Contract Management with SAP S/4HANA Logistics

Transfer Pricing Analysis in SAP S/4HANA

Transfer Pricing Analysis in SAP S/4HANA

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

Blog curated by

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

Automatic Account determination due to Sales Activity

Sap sd–fi integration.

What is SAP SD–FI integration?

Determination of right G/L posting scheme in SAP at the time of sales activity. There are two types of billing process based on customer sales.

  • O2C Cycle (Order to Cash)
  • POS transaction.

It starts with Sales order -- > Delivery -- > Post good issue --- > Billing document.

At the time of Post goods issue, the inventory account will get credited, and cost of goods sold will get debited. This will get determine by SAP MM – FI Integration. Link for SAP MM-FI integration is given below.

Once the Goods issue is completed, the next step is to capture the customer billing and ensure the values are getting into right finance books. The sales may be to outside customer or intercompany.

  • POS transaction:

In retail system, the sales are happening in POS system and integrate to SAP system. When the sales are integrating to SAP, it will generate two documents in SAP. One is for the goods movement document (251 movement type), the account determination is happened through SAP MM-FI integration. Link shared above. The billing document get posted to capture the retail sales in SAP. Here also we need to ensure right G/L is determined to capture the sales.

To determine the auto account posting in the above two process, it is mandatory to have Automatic Account determination procedure in billing.

In this article will go through the important steps and configuration methods.

Automatic Account determination is done through T code – VKOA . Before proceeding to assign G/L accounts, we must complete some prerequisites in below SPRO path.

SPRO à SD à Basic Function à Account Assignment/ Costing à Revenue Account Determination

SPRO PATH Screenshot:

SPRO PATH

Check Master for Account Assignment:

In this step we need to define the Account assignment groups for both customer and material/article master.

Account Assignment groups

Material Master Accounting group:

Materials are grouped based on their nature (Eg: Trading goods, Finished goods etc). SAP will have predefined Account assignment group; consultant can create new entry based on business requirement. It’s a two-digit key. The account assignment group is maintained in sales tab in Material master. During sales transaction, the same will be captured in billing document items.

Material Master Accounting group

Customer Master Accounting group:

Customer grouping is done in this step grouping of customers, tax agent etc. Consultants can create new entries based on the business requirement. The customer accounting group is maintained in customer master sales area screen under billing tab. The same will reflect in billing document when the sales transaction is posted.

Customer Master Accounting group

Dependencies of Revenue Account determination:

In this configuration path, we have to define the key combinations to determine the G/L during sales postings. We call it as Account determination table. SAP has provided the predefined tables to map the combinations. We can create new tables (Starting with 9 series) based on business requirement. New fields can be added in the catalogue to include in account determination table. Also we can define our selection criteria and display fields for the account determination. The data are stored in table C001, C002, C9XX etc).

Revenue Account determination

Define Access Sequence and Account determination:

In this step, we need to define the access sequence to be followed during account determination. SAP has provided few access sequence by default eg: KOFI - Account determination w/o COPA & KOFR - Acc. Det./POS - Rack Jobbing, KOFK – Account Determination with CO. We can define our own access sequence also. In the access sequence we have to provide the hierarchy list on what sequential order the system should follow during account determination. We can modify the existing access sequence based on business need.

Then the access sequence needs to Account determination condition type.

Access Sequence and Account determination

Define and Assign Account determination procedure:

In this step, we have to define account determination procedure. It is different from Pricing procedure. Pricing procedure helps to determine the calculation schema in Order or in billing. Account determination used to determine the G/L accounts at the time of billing document posting.

Create new account procedure or use the existing one for pricing procedure given by SAP. In that we must define the counter and assign the condition type created in previous step.

Then assign the billing document to the account determination procedure.

Assign Account determination procedure

Define and Assign Account Keys:

In this step, we have to define the account key and map the account key against the pricing procedure. For eg, Account key ERL is used to capture the sales revenue, ERS is used to capture discount & MWS used to capture the Tax. You can define your own key based on business requirement. The same will be assigned to Pricing procedure and Pricing condition type configuration.

When the transaction is posted, system will do pricing calculation based on order type or billing type and the pricing procedure assigned to it. The account determination will happen based on the account key mapped to the Pricing condition type in pricing procedure.

This step seems little confusing in theory, when you are doing in real time you can figure out the difference between pricing condition type and account determination condition type.

Account key

Assign G/L Accounts:

This is the last step in G/L account determination. Now we have the following set of parameters in our hand,

  • Account assignment group for material and customer master.
  • Account determination access sequence and assignment to condition type.
  • Account determination procedure and its corresponding billing type.
  • Account Key mapped to Pricing procedure.

For illustration we will take the SAP provided one. The T code to assign G/L account screen is VKOA. Let’s assume the access sequence are defined in the following order from 001 to 005.

Whenever the transaction posted, system will read the G/L determination in below sequence based on the account determination procedure. If the G/L is determined in 001 it will not proceed further to 002 etc, if the G/L is not determined in 001 it will check on 002. Similar to pricing determination in pricing procedure.

Assign GL accounts

In condition table 001 we have to define 9 key fields to define the G/L determination.

  • Application,
  • Account determination Condition type
  • Chart of account
  • Customer account assignment group
  • Material Master assignment group
  • Account Key
  • G/L account
  • Provisional account.

Application :

It is always V for sales and distribution. In German language sales is represent as Vertrib. That’s the reason all sales related transaction with VXXX.

Account Determination condition type:

KOFI for account determination without COPA and KOFK for account determination with CO. Exact difference between with CO and without CO I am not aware. Financial consultant may help on this.

Chart of account:

Chart of account is assigned to your company code.

Sales organisation represents your organisation structure where the sales is happening.

Customer account assignment group:

Customer assignment group is maintained in customer master under the corresponding sales organisation. The same will be copied to your billing document in header tab.

Material account assignment group:

Material account assignment group is maintained in material master under sales area tab. The same will be copied in to billing document in Item tab.

Account Key:

Account keys are maintained in Pricing procedure. When the billing document created, system will capture the sales or discount or tax amount to the corresponding account key.

G/L Account:

The G/L accounts will be given by finance business users or finance consultant will help to get the right G/L account from business users.

Provision Account:

This is only applicable when the conditions are subject to accrual posting (eg. Rebate). For example, in Automobile or Pharma industry, rebate will be given to dealer based on the volume of sales performed. The rebate will be on monthly or quarterly or half yearly or yearly basis. The provision account is used to calculate the rebate amount.

Below is the table view of Account mapping in C001 table.

C001-Display of entries found

Leave a Reply Cancel reply

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

  • TutorialKart
  • SAP Tutorials
  • Salesforce Admin
  • Salesforce Developer
  • Visualforce
  • Informatica
  • Kafka Tutorial
  • Spark Tutorial
  • Tomcat Tutorial
  • Python Tkinter

Programming

  • Bash Script
  • Julia Tutorial
  • CouchDB Tutorial
  • MongoDB Tutorial
  • PostgreSQL Tutorial
  • Android Compose
  • Flutter Tutorial
  • Kotlin Android

Web & Server

  • Selenium Java
  • SAP FICO Training
  • SAP FICO Tutorials
  • SAP FICO - Introduction
  • SAP Financial Accounting
  • What is SAP FICO
  • What is client in SAP
  • SAP FICO - Enterprise Structure
  • Define Company in SAP
  • Define Company Code in SAP
  • Assign company code to company in SAP
  • Define business area and consolidation business area in SAP
  • Assign business area to consolidated business area in SAP
  • Define credit control area in SAP
  • Assign company code to credit control area in SAP
  • Define functional area in SAP
  • Maintain Financial Management Area in SAP
  • Assign financial management area to company code in SAP
  • How to create segments in SAP
  • SAP FICO - Global Parameters
  • What is Chart of accounts and how to create COA in SAP?
  • Assign company code to chart of accounts
  • What is Fiscal year in SAP?
  • How to maintain fiscal year variant
  • Assign company code to fiscal year variant
  • Define account group in SAP
  • Define retained earnings account
  • Define posting period variant (PPV)
  • Assign variants to company code in SAP
  • Open and closing posting period variants
  • Define field status variant and field status groups in FICO
  • Assign company code to field status variant
  • Define Tolerance group for G/L accounts
  • Define Tolerance group for employees
  • Check company code global parameters
  • SAP FICO - Foreign Currency Transactions
  • Check exchange rate types
  • Define translation ratios for currency translation
  • How to maintain exchange rates in SAP
  • Define accounts for exchange rate differences
  • Define foreign currency valuation methods
  • Define accounting principles and assign to ledger group
  • Define valuation areas and assign to accounting principles
  • SAP FICO - New G/L Accounting
  • How to activate new G/L accounting?
  • Define ledgers for general ledger accounting
  • Define currencies for leading currency
  • Define & Activate Non-Leading Ledgers
  • Define Zero-balance clearing account
  • Define interest calculation types
  • Define interest indicator
  • SAP FICO - Accounts Receivable
  • Define account group for customers
  • Maintain number ranges for customer account groups
  • Assign number ranges to customer account groups
  • Define risk categories
  • Define tolerance group for Customers
  • Create sundry debtors accounts
  • ADVERTISEMENT
  • Define Customer Master Record
  • SAP FICO - Accounts Payable
  • What is Accounts Payable in SAP?
  • Define vendor account groups
  • Maintain number range intervals for vendor accounts
  • Assign number ranges to vendor account groups
  • Create payment terms
  • Define accounts for cash discount taken
  • Define Vendor reconciliation account
  • Create vendor code
  • SAP FICO - Tax on Sales and Purchases
  • What is Sales tax and Purchase tax in SAP?
  • Define tax calculation procedures
  • Assign country to calculation procedure
  • Assign tax codes for non taxable transactions
  • Maintain tax codes for sales and purchases
  • Define tax accounts in SAP
  • SAP FICO - Bank Accounting
  • What is Bank Accounting in SAP?
  • Define bank key
  • Define house bank in SAP
  • Create check lots
  • Automatic payment program
  • SAP FICO - Asset Accounting
  • What is Asset Accounting in SAP?
  • Define Chart of Depreciation
  • Assign chart of depreciation to company code
  • Specify Account Determination
  • Number range intervals for Assets
  • Maintain Asset Classes
  • SAP Controlling Training
  • SAP CO Tutorials
  • SAP FI TCodes
  • ❯ SAP FICO Tutorials
  • ❯ Assign number ranges to customer account groups

Assign Number Ranges to Customer Account Groups in SAP

How to assign number ranges to customer account groups.

In this SAP tutorials, you will learn how to assign number ranges to customer account groups step by step by using transaction code OBAR. In our previous training tutorial, we have learned how to create customer account groups in SAP .

Configuration steps

You can assign number range intervals to customer account groups by using one of the following navigation method.

  • Transaction code: – OBAR
  • Menu Path: – SPRO > Financial Accounting (New) -> Accounts Receivable and Accounts Payable –> Customer Accounts —> Master Data —-> Preparations for creating customer master data —–> Assign number ranges to customer account groups.

Assignment Procedure

Step 1) Enter T-Code “OBAR” in the SAP command field and press enter.

SAP Transaction code OBAR

Step 2) On change view “Assign Customer Acct Groups –> Number Range overview screen, click on position button and enter customer account group key in the given field. So the customer account group key displays on top of the screen.

spro path for account assignment group

Step 3) Now update the customer account group number range interval “TK” in the field number range as shown below.

Assign Number Ranges to Customer Account Groups in SAP

Click on save button to save the details.

Save sap configuration details

Step 4) Now you are prompted for customizing request number, choose the request and save the assigned details.

Assign customer account group request

Successfully we have assigned number ranges to customer account groups in SAP .

Popular Courses by TutorialKart

App developement, web development, online tools.

Guru99

SAP CRM Business Partner: Grouping, Roles, Relationships

Ryan Bennett

SAP CRM Business Partner: Overview

  • Almost all business transactions in an organization involve certain stakeholders like employee, contact person, organizational unit, etc.
  • Within SAP CRM these participants involved in a business transaction are maintained as CRM Business Partner. Following can be involved in a business transaction as Business Partner:

SAP CRM Business Partner

  • In SAP CRM , business partners are created centrally. Also the roles that a business partner play, such as sold-to party and ship-to party are also maintained centrally
  • Thus a business partner created in SAP CRM can be involved in any of the business transaction in different modules like sales, marketing and service. This involvement of the business partner in a business transaction depends upon the role assigned to the business partner and the partner functions involved in the business transaction
  • Creating and maintenance of the business partner in the SAP CRM is included in the Account Management application within CRM Web UI. In order to work on the business partner, the user need to have access to the Account management in the Web UI:

Account Management

For a particular business transaction, involved business partners can be found within the Parties Involved assignment block:

  • Within SAP GUI , business partner maintenance is available with transaction code BP. SAP has now stopped supporting GUI for CRM transactions and thus Web UI is used for the business partner creation and maintenance
  • Account management in CRM Web UI provides 360 0 view of the business partner data which means it represents complete data of the business partner including:
  • the header details of the business partner
  • relationships to other business partners in the business processes
  • account life cycle of the business partner
  • business transactions in which the business partner is involved
  • change history of the business partner data
  • Using CRM Middleware it’s possible to populate business partners in SAP CRM using data maintained in SAP ERP . Also updates in the business partner data in any of these systems (ERP or CRM) can be synchronized through the CRM Middleware
  • Below is the SPRO path for Business partner customizing. The Partner Processing implemented for a particular business transaction also depends upon the customizing settings implemented for the business partners. Thus the customizing settings for the business partners in CRM are implemented in the SPRO and once done, CRM Web UI is used to create and maintain the business partners

SPRO to maintain Business Partner

Business Partner Category

  • Person or Individual
  • Organization
  • A business partner can belong to any one of these categories. An account can be further sub-divided as follows-
  • Account: An account is a company, group, or individual, with which your organization have a business relationship.
  • Accounts are further divided into:
  • Corporate Account (organizations or companies)
  • Individual Account (individuals)
  • Groups (Groups like households)
  • person with whom you have a business relationship
  • mostly assigned to a corporate account
  • member of your organization
  • involved in interaction between your organization and vendor, prospect, customer, and other parties

Business Partner Category

  • It is not possible to modify these categories or to create new categories.
  • When a business partner is created in SAP CRM, category is assigned to it. The business partner category can only assign once while the creation of the business partner and cannot be modified at later stages of the business partner life cycle. Thus while creating a business partner you need to select the category as the first step. Also, the account search can be filter based upon the account category for faster results:

Search: Accounts

  • This business partner category is also used in the header of the account display, create and modify page:

Individual Account

Business Partner Grouping

  • When a business partner is created, a number termed as “business partner number” is assigned to it. This number can be configured in the SPRO customizing such that it is generated automatically when a business partner is created
  • For this, Business Partner Grouping and Number Ranges are used
  • We define range of numbers using start and end value (within SAP CRM this is termed as “Number Range” and has an identifier):

Business Partner Grouping

  • For example, from the above screen shot, business partner with number range 01 will be assigned a number ‘4907620’ , while business partner with number range 02 will be assigned number ‘A’
  • Number range can be Internal or External
  • Internal Number Range
  • Based up on the customizing settings this is generated within the CRM system
  • This is a sequential number from the relevant number range
  • External Number Range
  • In this case, number can be assigned by the user while creating the record
  • Or the number can be derived from an external system
  • In both cases the number used must lie within the corresponding number range interval
  • This number range is then assigned to a grouping
  • SPRO path to assign Number Range to Group:
  • IMG -> Cross-Application Components -> SAP Business Partner -> Business Partner -> Number Ranges and Grouping -> Define Groupings and Assign Number Ranges
  • Business Partner Grouping is basically different number ranges that could be assigned to a business partner.Thus Grouping can be considered as a container which holds the Number Range settings
  • While creating a BP, user selects the Grouping
  • Selected grouping identifies the number to be generated
  • If the grouping is using an Internal number range, the business partner number will be auto assigned while saving the Business Partner
  • For the Grouping corresponding to external number ranges
  • ID field can be enabled for user to give a Business Partner number or
  • BP number can be fetched from external system (e.g. connected ERP)

Individual Account: New

Business Partner Roles

  • The BP (Business Partner) roles assigned to a business partner reflect the partner’s functions and the business transactions in which the partner may be involved.
  • It is possible to assign more than one business partner role to a business partner
  • This means a business partner can be involved in different business transactions with different roles
  • But the general information of the business partner like name, address, etc. are entered only once
  • It is possible to create custom BP roles as per the business requirement

Business Partner Roles

  • A business partner role is assigned to a business partner role category

Business Partner Roles

  • BP Role Category controls properties of the BP role:

Business Partner Roles

  • There is a separate assignment block in the Accounts Overview for the BP Roles. The drop down list shows the available roles that can be assigned to the account. Using the Insert button it is possible to assign new role to a business partner:

Business Partner Roles

BP Relationships

  • A business partner can have relation with another business partner.
  • A connection between two business partners is formed using the “business partner relationships”.
  • Within SAP CRM, relationship between business partners is described with business partner relationship category:

BP Relationships

  • These BP Relationship Category defines the properties of the business partner relationship:

BP Relationships

  • A BP Relationship can be unidirectional or bidirectional
  • BP Relationships can be assigned to a business partner in Web UI in the Relationship assignment block:
  • This updates all the Business Partners involved in the relations
  • Existing relationship can be modified using the ‘Actions’ buttons

BP Relationships

  • It is possible to have a relationship time dependent. Thus the relationship will be valid for the time frame specified while the creation of this relationship
  • Using the New button in above screenshot it is possible to create new relation:

Account Classification

  • SAP CRM provides functionality of account classification using which you can classify your accounts according to any criteria. This is particularly useful when a large enterprise needs to classify different business areas according to different criteria
  • It is possible to perform search for accounts based upon these classification criterion
  • Account classification is also available as an individual assignment block on the Account page:

Account Classification

  • The role in this assignment block is different from the Business Partner Role. You can define any number of Criteria and Attributes
  • As per the requirement account criteria can be combined to create Classification Category. Each classification category can consist of up to 5 criteria and any number of attributes as per the requirement
  • Constituents of account classification are defined in the SPRO customizing
  • There is a helper class associated with each criteria and attribute for the value help as drop down list in the Web UI
  • Criteria definition:

Account Classification

  • Attribute definition:

Account Classification

  • Assignment of attributes:

Account Classification

  • Assigning Criteria:

Account Classification

360 0 View of Business Partner

View of Business Partner

SAP CRM provides 360 0 view of the business partner. This means that all the data related to the business partner can be checked in one place. In the header data it is possible to maintain and display the data which is applicable in all scenarios like the first name, last name, BP number, etc. There are separate assignment blocks for data like BP Role, BP Relationship, etc. Also we can find all the business transactions within which the business partner is involved. For example, there is an assignment block “Opportunities” which displays all the opportunity business transactions in which the business partner is involved

  • It is possible to navigate to the corresponding business transaction document from these assignment block data. Also, we can create new business transactions through these assignment block. That is, using the new button on Opportunity block it is possible to navigate to the Opportunity page and create an opportunity with respect to the business partner
  • Thus, the SAP CRM supports the maintenance of the complete business partner life cycle in single place which makes it convenient for the end user to use and helps in the reporting purpose
  • SAP CRM Modules: Full Form, Overview, Architecture
  • SAP CRM Sales Process, Management, Quotation & Product Determination
  • SAP CRM ServicePRO & Process Flow
  • SAP CRM Marketing: Plan, Campaign Management & Automation Segmentation
  • SAP Partner Channel Management (PCM)
  • SAP CRM Interaction Center
  • SAP CRM Organizational Management
  • SAP CRM Product Master: Hierarchy, Categories, Set Types & Attributes
  • Terms of Use
  • Privacy Policy
  • SAP ERP Solutions
  • What does SAP stands for

ETCircle.com SAP FI and CO consultant information

Customers: account assignment groups | ovk8.

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

Transaction: OVK8

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

Tables: TVKT, TVKTT

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

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

Tags Account Assignment OVK8 TVKT TVKTT

About Emiliyan Tanev

Related articles, assign g/l accounts | vkoa, materials: account assignment groups | ovk5, 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.

How to Create Customer Account Groups in SAP

This Tutorial guides you on how to create customer account groups in SAP FI.

Let configure the below customer account groups

Steps to create a customer account group:-

IMG Menu Path:-  IMG > Finance Accounting –> Accounts Receivable and Accounts Payable –> Customer Accounts –> Master Data –> Preparation for creating customer master data –> Define Account Groups with screen layout (Customer)

Transaction Code:- OBD2

Step 1: – Enter Transaction code SPRO in the SAP command field and press enter.

Step 2:- Select SAP Reference IMG

Step 3:- Follow IMG Menu Path and select

Step 4:- Select New entries to create a new customer account group.

Step 5:- Update the following data.

Account Group:- Enter four digits  customer Account group code

Description: – Enter the name of the customer account group.

Select Company code data under field status and select Account management under a group,

Select Reconciliation account as required entry

Step 6:- Select Save Icon to save the configured settings

Similarly, create customer account groups for A002, A003.

Thus customer account groups are successfully configured in SAP.

ERProof - Blog about All Things SAP

Blog about all things SAP

ERProof » SAP FI » SAP FI Training » SAP Account Group of G/L Accounts

SAP Account Group of G/L Accounts

SAP Account Group of GL Accounts

SAP account groups are used to maintain intervals, segregate G/L accounts groups, and define field statuses. SAP account group  has a four-digit alphanumeric code and serves for organization of G/L account master data based on specifications on how G/L account master data to be defined.

SAP account group controls G/L account intervals and screen layouts while defining or extending G/L account master data at the company code level. SAP account group helps users to define required fields while creating the G/L account master data. For example, the fields for entering a reconciliation account and open item management indicator are not required for Profit and Loss accounts .

As per the requirement of the company, SAP account groups can be created and are defined at the chart of accounts level as explained below.

How to Create SAP Account Group?

In order to create a new SAP account group or modify the existing one, it is necessary to navigate to the following path in SPRO transaction:

Financial Accounting (New) – General Ledger Accounting (New) – Master Data – G/L Accounts- Preparations – Define Account Group.

Or directly start the transaction OBD4 (define SAP account group) using the transaction bar.

Relevant table: T077S (G/L account groups).

Edit SAP Account Groups Transaction

In the above screenshot 1234 is the chart of accounts and Asst , BS , PL , MAT and GL are SAP account groups. Here are detailed explanations of meaning of each column in this transaction:

Chart of accounts : G/L accounts are defined at the chart of accounts level.

Account group : A four-digit identification to group certain G/L accounts.

Name : Name to the account group.

From account : Starting number in the range of accounts belonging to a particular account group.

To account : Ending number in the range of accounts belonging to a particular account group.

spro path for account assignment group

By double clicking on each group we can define whether the fields will be suppress, required, optional or display.

Suppress : Field is not visible while creating the G/L master record.

Required : Field is mandatory while creating the G/L master record.

Optional : Field is available for entry but not mandatory to update.

Display : Field available only in display mode.

Let’s discuss each group of fields one by one.

1. Account control

Available fields in account control group. This group contains fields of company code level G/L account creation.

Account Control Group of Fields

Currency : G/L account currency, by default it is company code currency, it can be change also.

Tax category : To maintain tax category for the G/L account, so that tax-related postings are possible while booking transactions.

Reconciliation account : G/L account which be maintained in the master data of Vendor, Customer and Asset accounts.

Exchange rate difference : Key for account determination to perform foreign currency valuation.

Account managed in ext. system : If the same account is used in another application, then this field status will be defined.

Only balance in local currency : To update only in local currency.

Alternative account number : To update country chart of accounts G/L master record.

Inflation key : Only useful when inflation accounting is used in financial accounting .

Tolerance group : Useful to maintain if any difference raised while clearing of open items.

2. Account Management

Available fields in account management. This group contains fields of company code level G/L account creation.

Account Management Group of Fields

Line item management : To activate line item display.

Open item management : To activate line items as open items to perform clearing.

Sort key : Sorting the data while execution of reports.

Authorization group : To control through authorization object.

Administrator : It is called accounting clerk.

3. Document entry

Available fields in document entry. This group contains fields of company code level G/L account creation.

Document Entry Group of Fields

Reconciliation account ready for input : To enable the alternative reconciliation change functionality.

Field status group : To maintain which fields are required while booking transactions.

Post automatically only : To restrict manual postings.

Supplement automatic postings : To activate bank charges while posting incoming payments.

4. Bank/financial details

Available fields in Bank/financial details. This group contains fields of company code level G/L account creation.

Bank/Financial Details Group of Fields

Planning level : To control display in cash management.

Commitment item : To be used for budgeting.

Relevant to cash flow : To define as a cash flow account.

House bank : Default house bank.

Bank account : Default bank account.

5. Interest calculation

Available fields in Interest calculation. This group contains fields of company code level G/L account creation.

Interest Calculation Group of Fields

Interest calculation : To activate or specify account for interest calculation.

6. Joint venture

Available fields in Joint venture. This group contains fields of company code level G/L account creation.

Joint Venture Group of Fields

Recovery indicator : To allow booking of incurred costs.

7. Multi currency accounting

Available fields in Multi currency accounting. This group contains fields of company code level G/L account creation.

Multi Currency Accounting Group of Fields

Multi currency accounting : To activate multi-currency accounting.

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP FI tutorials.

Navigation Links

Go to next lesson:  SAP Field Status Variant

Go to previous lesson: SAP Balance Sheet and P&L Statement Accounts

Go to overview of the course: Free SAP FI Training

2 thoughts on “SAP Account Group of G/L Accounts”

THIS IS AN OUTSTANDING ARTICLE. THANKING THE AUTHOR AND THE ENTIRE SUPPORT TEAM.

Why are the number ranges for account group allowed to overlap?

Leave a Reply Cancel reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM !

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

Save my name, email, and website in this browser for the next time I comment.

IMAGES

  1. How to Find IMG or SPRO Configuration path from SAP Table?

    spro path for account assignment group

  2. How Find Path In SPRO With Tracking Code Transaction

    spro path for account assignment group

  3. How to Create Account Group in SAP

    spro path for account assignment group

  4. Automatic Account determination due to Sales Activity SAP SD–FI

    spro path for account assignment group

  5. How to Find SPRO path from any Infotype in another Simple way

    spro path for account assignment group

  6. How to find SPRO Path from any Particular Screen

    spro path for account assignment group

VIDEO

  1. WILL BTCMTX RALLY AFTER LAUNCH?🔥 (Bitcoin Minetrix Presale Review)

  2. PSA Assignment Group 6

  3. ASSIGNMENT GROUP

  4. Analytics_assignment_group_6c

  5. APT2043 APPLICATION OF INFORMATION TECHNOLOGY FOR BUSINESS GROUP ASSIGNMENT (GROUP 3)

  6. ASSIGNMENT GROUP PRINCIPLE OF ECONOMICS (HFT10403)

COMMENTS

  1. Vendor Account Group Configuration in SAP MM: Part -1

    OBD3. Select on any one of the line items and press the magnifying icon. If you want to create a new account group hit on "New Entries". Here you can see 3 options General Data/ Company Code/ Purchasing named under "Field Status" . for now we can see General Data and the same can be followed for different options.

  2. Materials: Account Assignment Groups

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

  3. SAP Help Portal

    Account Group Assignment SAP Help PortalThis webpage explains how to assign account groups to business partners, customers, and vendors in SAP S/4HANA. Account groups are used to classify and control master data records for different business scenarios. You can learn how to define and customize account groups, number ranges, and field properties for your business needs.

  4. Account Assignment Group Maintenance in Billing

    hi. Account assignment groups two types , customer account assignment and material account assignment group , this defined at path level. img-sales and distribution- basic function-account assignment and costing-revenue account determination - here check assign , based on this this determination and assign to customer account assign group to customer master , material account assignment group ...

  5. Cross-Functional Customizing in SAP S/4HANA MM: Account Determination

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

  6. Automatic Account determination due to Sales Activity

    SPRO à SD à Basic Function à Account Assignment/ Costing à Revenue Account Determination. SPRO PATH Screenshot: Check Master for Account Assignment: In this step we need to define the Account assignment groups for both customer and material/article master. Material Master Accounting group: Materials are grouped based on their nature (Eg ...

  7. Setup Partner Determination Procedure in SAP SD

    SAP Menu Path: SPRO => Sales and Distribution(SD) => Basic functions => Partner determination => Setup partner determination. ... Account Grp : - Enter the account group key for assignment of partner functions to the required customer account group. Click on save button and save the details. Step 5 : - Define partner determination procedure.

  8. Assign Number Ranges to Customer Account Groups in SAP

    Assignment Procedure. Step 1) Enter T-Code "OBAR" in the SAP command field and press enter. Step 2) On change view "Assign Customer Acct Groups -> Number Range overview screen, click on position button and enter customer account group key in the given field. So the customer account group key displays on top of the screen. Step 3) Now ...

  9. Defining an Account Group

    The account group controls: The type of number assignment used for the account number. A number interval from which the account number is chosen. The system uses the account number to identify the customer. Which fields are displayed when you enter or change customer master data and whether or not an entry must be made in these fields (field ...

  10. How to Create Customer Account Group in SAP

    In this tutorial, we will learn How Create the Customer Account Group. Step 1) Enter Transaction Code SPRO in the SAP Command Field. Step 2) In the next screen, Select 'SAP Reference IMG' button. Step 3) In the next screen, 'Display IMG' Select the menu path. Financial Accounting ->Accounts Receivable and Accounts Payable ->Customer ...

  11. SAP CRM Business Partner: Grouping, Roles, Relationships

    SPRO path to assign Number Range to Group: ... There is a separate assignment block in the Accounts Overview for the BP Roles. The drop down list shows the available roles that can be assigned to the account. Using the Insert button it is possible to assign new role to a business partner:

  12. SAP CO Account Assignment Tutorial

    Welcome to the tutorial about SAP CO Account Assignment. This tutorial is part of our free SAP CO training. You will learn how account assignment works in SAP ERP and what are different sources of information about account assignment that the SAP system uses. Normally, when a financial document is entered in SAP FI module, user has the option ...

  13. Assign Vendor Account Group to BP Group in SAP Hana

    Step 1: Execute transaction code "SPRO" -> Choose SAP Reference IMG > Follow the IMG menu path and execute IMG activity "Define Number Assignment for Direction Vendor to BP". Step 2: On change view "Number Assignment Direction Vendor to BP" overview, screen, click on new entries button. Step 3: On new entries screen: Number ...

  14. Defining Account Groups and Field Selection for Customers

    2. Choose New Entries. 3. Enter the following data: Enter a code for your account group. Enter a description. Enter the number of the number range interval defined in the menu item Creating Number Ranges for Customer Accounts. Leave this checkbox blank because, in general, drivers are not one-time accounts.

  15. Customers: Account Assignment Groups

    In this configuration activity we are able to define account assignment groups for customers used in Sales and Distribution Module (SD).Transaction: OVK8 IMG Path: Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination -> Check Master Data Relevant For Account Assignment Tables: TVKT, TVKTT If you use the IMG Menu, you will have to choose the ...

  16. How to Create Customer Account Groups in SAP

    Transaction Code:- OBD2. Step 1:- Enter Transaction code SPRO in the SAP command field and press enter. Step 2:- Select SAP Reference IMG. Step 3:- Follow IMG Menu Path and select. Step 4:- Select New entries to create a new customer account group. Step 5:- Update the following data. Account Group:- Enter four digits customer Account group ...

  17. Maintaining Business System Group

    Procedure. Start transaction SPRO and in the IMG, choose SCM Extended Warehouse Management SCM Basis Integration Basic Settings for Creating the System Landscape Maintain Business System Group.: On the Change View "Business System Group": Overview screen, choose New Entries and make the following entries: BusSystGrp. BSG.

  18. SAP Account Group of G/L Accounts

    In order to create a new SAP account group or modify the existing one, it is necessary to navigate to the following path in SPRO transaction: Financial Accounting (New) - General Ledger Accounting (New) - Master Data - G/L Accounts- Preparations - Define Account Group.

  19. Business Partner Configuration in S/4HANA

    This blog attempts to give you the configuration, customer/supplier integration steps for BP. BUSINESS PARTNER CONFIGURATION STEPS: Step:1 BP Roles & Groupings. Path: IMG->Cross-Application Components -> SAP Business Partner->Business Partner ->Basic Settings-> Business Partner Roles. Define BP Roles. Use.

  20. Complete configurations steps done in SPRO(SAP ERP...

    To define template groups, In your SAP ERP HCM System go to Customizing for Personnel Management and choose Integration with SuccessFactors Employee Central> Business Integration Builder >Employee Data Integration > Define Field Mapping for Employee Data. 2. Go to Define Transformation template group option. 3.