SAP MM FI Integration

Advertisement

SAP MM FI IntegrationSAP MM FI integration is a good example of how different modules of SAP ERP systems are integrated with each other. SAP ensures that data from one module automatically flows to another module. In case of SAP MM FI integration, functionality and data from SAP MM (Materials Management) module triggers automatic postings in SAP FI (Financial Accounting) module. After reading this tutorial, you will learn about the integration points between MM and FI (there are several of them) and see an example of the integration in action. This tutorial is part of both our SAP MM course and SAP FI course.

The tutorial will be divided into several parts.

Advertisement

Inventory Management

Let’s start with discussion of SAP MM FI integration in the area of inventory management. As you can tell from from its name, MM module is responsible for managing materials and inventory in SAP. However, value of the inventory must be reflected on financial accounts of a company. Stock of materials that a company has is its asset and it is a legal requirement to mention it on various financial reports. SAP ERP is able to automatically calculate value the company’s stock and keep financial accounts up-to-date thanks to the integration between MM and FI modules.

How does SAP know which accounts to use for different materials? This is controlled by a number of parameters. Let’s see what happens when a goods movement is done in MM. SAP will automatically determine the following parameters:

  1. Chart of Accounts
  2. Valuation Grouping Code
  3. Transaction/Event Key
  4. Account Grouping
  5. Valuation Class

Let’s discuss them in more details.

Chart of Accounts

The first parameter influencing automatic determination of accounts is the chart of accounts. SAP determines the chart of accounts based on the plant mentioned in an MM transaction. Each plant is assigned to a particular company code (transaction OX18) and each company code uses a particular chart of accounts (transaction OB62). This is how SAP knows which chart of accounts should be used for account determination.

Valuation Grouping Code

Valuation grouping code enables us to customize account determination according to different valuation areas. As you know, valuation level must be defined in SAP customizing (transaction OX14). It is possible to have valuation level at company code or plant level. Depending on valuation level, either company codes or plants will be used as valuation areas. Valuation grouping codes enable us to combine several valuation areas for the purpose of account determination (transaction OMWD). So, valuation areas assigned to the same valuation grouping code will be treated in the same way during account determination and will correspond to the same G/L account.

Assign Valuation Grouping Code to Valuation Areas - Transaction OMWD
Assign Valuation Grouping Code to Valuation Areas – Transaction OMWD

Valuation grouping code simplifies maintenance of customizing because you don’t need to enter the same account determination settings for individual valuation areas. If you would like to use valuation grouping code, it first must activated in transaction OMWM.

SAP Valuation Grouping Code Activation - Transaction OMWM
SAP Valuation Grouping Code Activation – Transaction OMWM

Transaction/Event Key

Next parameter is related to MM transaction and details of the goods movement. It is called transaction/event key and its determination depends on another parameter called posting value string (sometime it is also called value string or posting string). Posting value string indicates a posting rule that always contains the same account assignment characteristics for a certain transaction or event. SAP uses the following criteria to determine posting string for values:

  • Movement type
  • Special stock indicator
  • Value update
  • Quantity update
  • Movement indicator
  • Consumption posting indicator

You cannot modify or add new posting value strings because they are standard and maintained by SAP. You can check which posting strings correspond to which movement types and other criteria in transaction OMWN.

Posting Value Strings in OMWN Transaction
Posting Value Strings in OMWN Transaction

Several transaction/event keys are assigned to each posting value string. You can check table T156W to see full details of the assignments or you can also get a glimpse of the assignments in transaction OMWN by double clicking on a relevant line in the table shown above.

Transaction/Event Keys and Value Strings in Table T156W
Transaction/Event Keys and Value Strings in Table T156W (Use SE16N Transaction to Browse Tables)

Transaction/event keys are also predefined and you cannot modify them. They are used for internal processing by SAP.

Advertisement

Account Grouping

There are cases when postings corresponding to the same transaction/event key must be further divided. For example, offsetting inventory posting (transaction/even key GBB), can be done for goods issue or for scrapping. Account grouping codes enables SAP to differentiate between these cases and determine different accounts.

Account Grouping (Account Modifier)
Account Grouping (Account Modifier) in Transaction OMWN

Valuation Class

Valuation class allows us to customize account determination according to a particular material. This is achieved by assigning different valuation classes in material master records on Accounting 1 tab.

Valuation Class in Material Master - Transaction MM02
Valuation Class in Material Master – Transaction MM02

Configuration of Automatic Postings

Now that we have understanding about different parameters that can be used for customization of automatic account determination in SAP MM FI integration, let’s see how different financial accounts are assigned to different combinations of these parameters.

This configuration is performed in transaction OBYC. On the initial screen of this transaction you will see a list of all the available transaction/event keys.

Configuration Automatic Posting - Transaction OBYC
Configuration Automatic Posting – Transaction OBYC

Double click on the line with a transaction key that you’d like to customize and the system will ask you for chart of accounts. Enter the relevant chart of accounts and proceed to the next screen. For example, we showed a screen for maintenance of G/L accounts corresponding to BSX transaction key below.

Account Determination for BSX Transaction Key - Transaction OBYC
Account Determination for BSX Transaction Key – Transaction OBYC

As you can see, this transaction key doesn’t use all the parameters for account determination we previously mentioned. SAP enables us to choose which factors should be taken into account during account determination. So, for simple cases, we don’t need to use all the parameters but only some of them. The choice of parameters can be configured using Rules button shown on the screenshot above.

Advertisement

Additionally, you can configure which posting keys (don’t confuse them with posting strings that we mentioned earlier!) will be used for automatic postings in financial accounting module. This can be done using Posting Key button for different rows in the account assignment table.

Posting Keys Configuration - Transaction OBYC
Posting Keys Configuration – Transaction OBYC

Let’s have a look at a different example – transaction key GBB. As you can see from the screenshot below, all the available parameters for account determination are used in this case. “Valuation modification” column contains valuation grouping code that we discussed earlier. “General modification” column contains account grouping code that we also mentioned earlier.

Account Determination for GBB Transaction Key - Transaction OBYC
Account Determination for GBB Transaction Key – Transaction OBYC

Let’s also check Rules screen for this transaction key.

Account Determination Rules - Transaction OBYC
Account Determination Rules – Transaction OBYC

We see that in the case of GBB transaction key, accounts are determined based on all available parameters.

SAP system uses the information about account assignments that we maintained in transaction OBYC for automatic determination of G/L accounts based on the information in MM transactions.

Advertisement

Invoice Verification

Another important point in SAP MM FI integration is related to the process of invoice verification. During invoice verification SAP system makes automatic postings to one or more of the following accounts:

  • Vendor account
  • Stock account (transaction key BSX)
  • GR/IR Clearing Accounts (transaction key WRX)
  • Tax Accounts
  • Price Differences Accounts (transaction key PRD)
  • Cash Discount Clearing Account (transaction key SKV)
  • Freight Clearing Account (transaction key FR1)

The logic of automatic account determination is the same as we discussed above. The only difference is in transaction keys that might be used by SAP during invoice verification. However, the there are more differences for vendor account determination and tax account determination. So, we will talk about them in the next sections.

Vendor Account

Vendor account is taken from the vendor master record. It is specified on Accounting Information screen in Reconciliation Account field. SAP makes a financial posting to the reconciliation account using SAP MM FI integration.

Vendor Reconciliation Account - Transaction XK02
Vendor Reconciliation Account – Transaction XK02

Tax Account

Tax account determination is performed based on the tax code specified during invoice verification. Tax codes for each country are created and maintained in SAP FI.

Tax Code Configuration - Transaction FTXP
Tax Code Configuration – Transaction FTXP

Each country usually has a different tax calculation procedure.  We can specify an account key for the input tax condition type in the calculation procedure. This account key is the same thing as transaction/event key that we discussed earlier.

Tax Calculation Procedure (Germany)
Tax Calculation Procedure (Germany)

SAP will use the account key and customizing that we perform in transaction OB40 to perform automatic determination of accounts where taxes should be posted.

Automatic Tax Account Determination - Transaction OB40
Automatic Tax Account Determination – Transaction OB40

As you can see from the screenshot above, OB40 looks very similar to OBYC that we discussed earlier. If you double click on one of the lines in the table, SAP will show you next screen where you can define account numbers for automatic postings.

Automatic Tax Account Determination - VST Transaction Key
Automatic Tax Account Determination – VST Transaction Key

SAP MM FI Integration – Conclusion

SAP MM FI integration is one of the advanced topics in SAP configuration. It is important to configure automatic postings in Financial Accounting and even more important to thoroughly test this configuration to make sure that postings are made to the correct G/L accounts. We hope that our explanation of SAP MM FI integration is easy and understandable. If you have any question or found a mistake, please let us know in the comments.

3 thoughts on “SAP MM FI Integration”

  1. Yes, it’s looks good and informative but what I recommend you is if it possible please explain clearly like what are the GL Accounts we need to create and where we need to create weather it is asset or liability and how to configure OBYC related to BSX,WRX and GBB.with examples.

    Thank you,
    Munikumar.

Leave a 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 *