Main menu
Member section cover

BLOG

ERPCorp SAP FICO Blog

Font size: +

Fundamentals of SAP MM-FI Account Determination

 

Fundamentals of SAP MM-FI Account Determination

by Ashish Sampat

Ashish

 

Colleagues often ask me about the integration of Materials Management (MM) & Financial Accounting (FI):

  • How do postings from MM flow into FI

  • How do we find out what occurs behind-the-scenes

  • Is there a way to change the posting to a different GL Account

  • How do we identify which movement types point to a specific GL Account

  • How do you create a new movement type and assign it to a specific GL Account

Many SAP practitioners, IT and business alike, do not know where to start on MM-FI data flow and reconciliation. This blog clarifies the fundamentals of MM-FI account determination.

Configuration Transaction OBYC forms the core of the integration between the MM, FI, and Controlling (CO) modules in an SAP ERP system.

 

Transaction keys (1)  are used to determine general ledger accounts used by the system. Account modifier is used to differentiate account determinations, depending on the procedure. Transaction and account modifiers are a logical grouping similar types of transactions. The transaction-account modifier, along with the valuation class, drives the accounting entries. Transaction keys are predefined in SAP and cannot be changed.

 

AshishBlog1

 Figure 1: OBYC setup for BSX – Inventory posting

Many of you may have seen an accounting entry at the time of the purchase of raw material as a debit to inventory and credit GR/IR. The configuration setup of transaction BSX (inventory posting) is responsible for the inventory posting (see Figure 1), and WRX (GR/IR clearing account) is responsible for GR/IR posting.

 

When movement type 101 is used to record the goods receipt of raw material (valuation class 3000) for a purchase order, the system looks up the GL Account for transaction BSX and WRX for valuation class 3000 and records it in the accounting document.

AshishBlog2
 Figure 2: OBYC setup for GBB-VBR – Consumption to Order

Similarly, when raw material is consumed using movement type 261, the system looks up transaction GBB (offsetting entry for inventory posting) for account modifier VBR,consumption for internal goods issues, and that reflects the GL Account in the accounting document as shown in Figure 2.

Figure 3 provides a summary of a few important movement types and accounting entries. Business process is listed in the column furthest to the left, with movement type in the next column and the debit and credit posting in the subsequent columns.

 

Conf CTA

 

There is a column for transaction and account modifiers; as we noted earlier, these are the SAP terms for logically grouping similar types of transactions. The transaction account modifier, along with the valuation class, drives the accounting entries.

The OBYC MMFI account determination configuration is set up at the time of original implementation, and once set up, these accounts are derived automatically. You’ll want to test the setup before going live to ensure that the correct accounts are being hit for the respective transactions. You can change this configuration after go-live, but the revised setup needs to be thoroughly tested. Otherwise, we may run the risk of impacting regular operations.

 

AshishBlog3
Figure 3:  Summary of Movement Types and Accounting Entries

 

Key takeaways:

  • Transaction-account modifier and valuation class drive the accounting entries

  • Transaction key: determines general ledger accounts for posting

  • Account modifier: differentiates account determination based on procedure

  • OBYC MM-FI Account determination setup is stored in underlying table T030

  • OMJJ Movement Type setup is stored in underlying table T156X

  • Combine these two tables via SQ00 query, or simply on Excel

  • The account modifier links the Movement Type to the Accounting entries

(1) - The transaction key in MM-FI account determination is not the same as transaction code. A transaction code is an alphanumeric code that represents a particular task in SAP. It allows users to access tasks directly without having to use menu paths.

New book ad

 

About the Author:

Ashish Sampat is an SAP FI/CO Consultant who has provided solutions in SAP Controlling, including product costing, Material Ledger, and cost center accounting to global clients in consumer-packed goods, life sciences, and industrial sectors.  Ashish is based in Chicago, working as an independent SAP FI/CO consultant.

 

Ashish is the author of:

  • First Steps in SAP Controlling

  • Expert tips to Unleash the Full Potential of SAP Controlling

 

Glossary

 

Movement Type

This key indicates the type of material movement such as goods receipt, goods issue, and physical stock transfer. The movement type enables the system to find predefined posting rules, which determine how the stock and consumption general ledger accounts post and how the stock fields in the material master record are updated.

Valuation Class

The valuation class in the material master Costing 2 view determines which general ledger accounts are updated as a result of inventory movement or settlement.

 

SAP S/4HANA Finance Frequently Asked Questions
2017 SAP Controlling Community Award Winners
 

Comments 3

Guest
Guest - K.Lakshmanaswamy on Friday, 15 December 2017 17:17

Iam very thankful to you, every time you post all informative post thanks for the great share keep posting.
SAP FICO Online Training In Hyderabad

Iam very thankful to you, every time you post all informative post thanks for the great share keep posting. SAP FICO Online Training In Hyderabad
Guest
Guest - Ramesh Munigadapa on Monday, 18 December 2017 11:12

Nice explanation

Nice explanation
Guest
Guest - Bhaveshkumar Patel on Wednesday, 25 July 2018 04:45

Its noting new people require innovative, Most of the Certified people know how MM and FI work , but still appreciate your hard work.

Its noting new people require innovative, Most of the Certified people know how MM and FI work , but still appreciate your hard work.
Already Registered? Login Here
Guest
Sunday, 05 February 2023

Captcha Image