Hello Friends if you are looking for SAP MM Automatic Account Determination | Automatic Account Determination in SAP MM | Automatic Account Determination Integration | Automatic Account Determination Configuration in SAP MM and SAP FI | Automatic Account Determination SAP FI then you will details here.
In SAP MM, procurement process involves the cost of goods and services that needs to be paid to the vendor by an organization. The cost being paid must be posted in an organization necessarily in a correct general ledger (G/L) account. It is quite impossible to recollect and feed the correct G/L account every time during procurement. To avoid this inconvenience, the SAP system can be configured so that the system will automatically determine the correct G/L account that needs to be posted. G/L account is posted when goods receipt is done as well as during clearing the invoice verification.
Note: –
Account determination is only happening when we do Goods Movement.
List of Elements Decides Account Determination: –
- Chart of Account (COA)
- Valuation Grouping Code
- Valuation Class
- Transaction / Event Key
- Account (Modifier) Grouping Code.
- Event Key & G/L Code Mapping (OBYC)
Chart of Account (COA) in SAP MM (MM-FI Integration)
The chart of accounts in SAP is a group of GL Accounts that controls the name of the General GL Master, the number of GL Master and some control information. In other words, the grouping of G/L accounts forms the framework for recording accounting transactions in a structured way.
- Chart of Account is assigned to Company Code & Company code is Assigned to Plant/ Valuation area as above shown.
- For Checking linkage of COA & Company Code we use T-Code:-OB62
- Enter T-Code in command bar & press enter below screen opens.
Click on position & Enter your Company Code & Check as below.
We can assign one COA to multiple company code.
Valuation Grouping Code in SAP MM (MM-FI Integration)
Valuation grouping code is a collection of valuation areas that will have the same account determination. Since a valuation area can be a company code or plant, we can say that a valuation grouping code represents a group of plants or company codes that have the same account determination.
- For checking Valuation Grouping Code, we use T-Code:-OMWD
- Enter T-Code in command bar & enter your valuation area. Check as below.
Here also we can assign Valuation grouping code to multiple valuation area & Company code.
Valuation Class & Account Category Reference in SAP MM (MM-FI Integration)
The account category reference (ACR) is an artificial code of four characters which allows flexibility in linking material type with valuation class. In reality, the valuation class is linked to an account category reference and account category reference linked to material type.
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
For checking Valuation class, we use T-Code:-OMSK
By entering T-Code in command bar below screen opens.
By entering T-Code in command bar below screen opens. Click on Account Category Reference.
- We have multiple Account category reference for material here.
- As per requirement we can create also.
- Click on Valuation Class.
- Here we can link Valuation class to Account category reference as per requirement.
- Click on Material Type/ Acc. Cat. Reference
- Here we can assign Acc. Cate. Reference to Material Type.
- We can assign Multiple Acc. Cate. Reference to Specific Material type also.
- So the Material type have multiple Valuation Class.
Transaction or Event Key in SAP MM (MM-FI Integration)
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.
The system uses the transaction/event key to determine the account in which a posting line is generated. This means that at least two transaction/event keys (one per posting line) are involved in each posting.
- Movement type is linked to Value String & Each Value string contain Transaction key as shown.
- Transaction key is nothing but the it fixes the account in which posting is done.
- For Goods Receipt WE01 Value string & Transaction Event Key BSX & WRX triggered as below
For checking Value String, we are using T-Code:-OMJJ/OMWN
As above shown for movement type 101 Value string WE06 & KBS TEKey is assign.
Account (Modifier) Grouping Code in SAP MM FI
Account Modifier or Account Grouping Code is a three-character code especially used to differentiate the offsetting accounts for consumption postings which could be different in cases for Trans/event Keys GBB & PRD.
To check we can us T-Code:-OMJJ/OMWN
As shown above GBB/PRD has different account modifier i.e. different GL code assigned.
Event Key & G/L Mapping (OBYC) in SAP MM-FI
By using T-Code: – OBYC we can check all this GL & Event Key Mapping.
Actual Account Determination Process in SAP FI-MM
Its look like complicated but it’s very easy to understand while configuring.
Step by Step Configuration for Automatic Account Determination in SAP MM
Step: -1 Check/Define the Valuation Level
Path to check Valuation Level: –
SPRO-> IMG-> Enterprise Structure-> Definition-> Logistics – General->
Define valuation level
Double click on it below screen opens.
This is only one-time activity this done at when you Activate SAP in system.
99 % Valuation level is set at Plant Level as shown above.
Step: -2
Define Material Type
Path to Define Material Type: –
SPRO-> IMG-> Logistics – General-> Material Master-> Basic Settings->
Material Types-> Define Attributes of Material Types
- Crete a new material type by copying Standard One.
- I am creating YMEI: – Std. Raw Material ME by copying from ROH
Update the Quantity & Value updating for Plant which you need to use as below.
Step: -3 Group Together Valuation Area
Path to Group Valuation Area: –
SPRO-> IMG -> Materials Management-> Materials Management-> Valuation
and Account Assignment-> Account Determination-> Account Determination
Without Wizard
Click on Define Valuation Control
As we tick on activate then we can use Same G/L Code for multiple Valuation Area & Different Material type.
Click on Group Together Valuation Area
Just enter your Valuation area & put valuation Group Code as above shown.
Save the data.
Click on Valuation Classes
As we click on it below screen opens.
First Click on Account Category Reference. Below screen opens.
We can use existing Account Category Reference also or Create new one as per requirement.
For creating new one click on new entries & Create it as below
ME11 : – ACR for Mechanical Item.
Then Click on Valuation Class Below scree opens.
Click on New Entries & Create New Valuation Class.
I am creating Two Valuation Classes for same Account Category Reference as above.
Save the data.
Now Click on Material Type/ Account Category Reference. Below screen opens.
Assign Account Category Reference to Your Material Type.
Material Type: YMEI
Account Category Reference: – MEI1
Now All the Configuration has been done.
Step: -4 Now assign the Valuation Class to G/L Code
We have to use T-Code : OBYC
By entering T-Code blow screen opens.
- As we are setting Account Determination for Movement 101 i.e Normal GR.The BSX & WRX transaction are trigger automatically.
- Then we need to set the GL code for BSX & WRX
- By click on BSX below screen opens.
As previously seen enter the COA as INT & press enter.
- Enter our Valuation Class & GL Code here & Save
- GL Code has given by Finance Team Only.
- Now do the same procedure for WRX also.
Save the data.
Step: -5 Now check the All configuration is done well for that we need
test the data for this create Material.
There you have to Use TCode – MM01
Enter the T-Code & press enter
Select the Industry & Material type as per configuration.
- Select the basic views for create material.
- Enter the Plant & S.Location
- Enter the Basis & Purchasing Data
- In Accounting View, we need to enter valuation class.
- As per configuration system will show valuation class. Select any one from list.
- Enter required detail & Data.
- Material 60725 created.
Step: -6 :
Now Create Standard PO for this material by using T-Code :-
ME21N
Step: -7
Do the Goods Receipt by using T-Code: – MIGO
- Material document 80008 posted
- Now Display the Material Document.
- Under that check the FI Document
Click on Accounting Document
- As per the set GL Account Documents get generated & BSX & WRX triggered.
- For Cross verification of this G/L Account how this account come into this picture.
- T030 – Standard Account Table
- Enter the TCode : SE16N
- Enter all the details & Verify.