SAP MM FI Integration

Material Management Concept:

Material Management is one of the important module in SAP. These module supports the Procurement and Inventory Function occurring in day to day business operations.This module contains many aspects such as Purchasing, Good Receiving, Material Storage,  Consumption based Planning and Inventory MM Module is tightly integrated with other modules of SAP R/3 like Financial Accounting, Controlling, Sales and Distribution, Quality Management, Plant Maintenance, Production Planning and Warehouse Management It supports all phases of Material Mgmt like Material Planning and Control, Purchasing, Good Receiving, Inventory Mgmt and Invoice verification.

 

MM-FI Integration  :

Purchasing Organization:

It is an MM Org unit, used to categories inventory transactions according to its nature.

Multiple Plants can be assigned to one Purchasing Org.

Plant:  

It is a physical location where the Production Activity and Procurement transactions are performed. In SAP Plant can be Production Unit, Sales Office or a Corporate Office.

Note: All Inventory transactions must be Posted at Plant Level

Automatic Posting of Inventory Valuation Transactions in Fin. Accounting depends on Assignment of Company Code to Plant This Assignment can be 1 : 1 or 1 :  N ratio (Company Code Vs Plant)

Note:  One Plant Cannot be Assigned to Multiple Company Codes

Storage Location:

The Place where the Stock are kept. These Locations are maintained under Plant

Importance Parameters of MM – FI Integration are

Company Code and Plant Assignment

Valuation Level

Moment Type

Material Master

Transaction Keys or Event Keys

Valuation Sting

Valuation Grouping Code or Valuation Modifier

Account Modifier or General Modifier

Valuation Class

Posting Keys

Sub Module of MM

Material Planning

Purchasing

Inventory Mgmt

Vendor Valuation

Invoice Verification

Statutory Requirement

Procurement To Payment  ( P To P Cycle ) 

All Inventory Managed transaction are posted from MM Module and due to Integration settings, the valuation will hit Financial Accounting in the form of Journal Entries

Purchase Requisition

Purchase Order

Goods Received       → Inventory A/c Dr                 To GR/IR Clearing A/c

Invoice Receipt         → GR/IR Clearing A/c Dr        To Vendor A/c

Outgoing Payment    → Vendor A/c Dr                      To Cash / Bank A/c

List of Movement Type 

101 -  Good Received with Reference to Purchase Order

102 - Reversal of Movement Type 101 (Cancellation of Good Received)

122 - Return Delivery of the Supplier

201 - Goods Issued to Cost Center for Consumption

241 - Goods Issued to the Assets

261 - Goods Issued Against Production Order

309 - Transfer of Posting from Material to Material

311 - Transfer Posting from Storage Location to another Location

545 - Receipt of Product from Sub-Contractor

554 - Scrapping of Goods

561 - Initial Entry of Stock Balances (Opening Stock)

601 - Goods Issued for Delivery

651 - Good Return from Customer

701 - Inventory Differences Unrestricted Stock

Note:  Based on Movement Type system will control the transaction keys. Inventory GL Accounts are maintained

against transaction keys

Material Types:

It is used to classify the materials based on material nature and attributes

The Material Master must be created with ref. to material type

Each Material Type Control

No. Range of Material Master (Internal/External)

Field Status of Material Master, Views, and Screens Settings

It Controls Controlling and Accounting information

List of Material Types:

ROH  - Raw Material

FERT  - Finished Goods

VERP  - Packing Material

ERSA  - Spare Parts

DIEN  - Services

HALB  - Semi Finished Goods

PIPE - Pipe Line Products

HAWA - Traded Goods

Note:  Against Material Type, we must maintain quantity update and value update (Material Type Attribute) for each Plant and Valuation Area. On setting of this indicator system will updates all quantity movements and value of material in a Material Master

Material Master:

It is Important Logistic Master Data and consists of all the imp or Key Properties relevant to other modules. It is maintained with multiple views relevant to MM, SD, PP, PM, WH, FI and CO .It indicates Material Master is central component used for Integration between all others module 

Plant Or Valuation Area:

Plant is Logistic Org unit which is used to track or maintain all inventory transactions.

All the stocks or Material Master must be maintained at Plant Level Each Plant must be assigned to a Company Code

Valuation Area:

Material can be valuated at Plant Level or at Company Code Level.The Level at which the Materials are valuated into Financial Accounting is called as Valuation Area or Valuation Level

Valuation Level at Company Code:

The Material Price must be equal across all the Plants of a Company Code 

Valuation At Plant Level

Material Prices are maintained at Plant Level and Price can be differentiated

It is advisable to maintain material valuation at Plant Level 

Price Indicators:

The Price indicators of Material Master Place a vital/imp Role in Material Valuation

Below are Price Indicator available for Valuate inventory

S- Standard Price

V- Moving Average Price

Standard Price:

The nature of material prices which are Fixed or not Fluctuated  frequently are managed with Price indicator ‘S’  and also the in-house manufacturing materials for which the Price is under control also managed with Standard Price

The standard price is maintained in material master. All the material/goods movements must be evaluated with the standard price maintained in material master. Any price difference will be posted to Price Difference Account 

The Production Department produced 10 more quantity at 12/- Actual Cost. The material is valuated at Rs.10/- and difference of Rs.2/- will be posted to Price difference account or Production

Variance Account

List of Transaction Keys:-

Moving Average Price:

This indicator is maintained for materials for the Prices which are much fluctuated and not under the control of Organization. 

Ex: - External Procured Materials, Services, Traded goods.

System will always calculate a New Price at each Goods Movement

Transaction Keys: 

The inventory GL A/c are mapped to Transactions Keys with the Combination of Chart of Acc (COA), Valuation Grouping Code, Valuation Modifier or Account Modifier and Valuation Class 

Based on the Valuation Sting of the movement type system will automatically hit the respective transaction keys.This code is used to maintain same GL Accounts across all the Plants or to differentiate inventory GL Accounts at Plant Level .

The Valuation grouping code maintained with above combination COA, Plant, CoCd Valuation Grouping Code.

   

 The Valuation Grouping Code maintained with above combination COA,  Plant, CoCd, Val Grouping code 

Valuation Modifier or Account Modifier:

This Valuation modifier or Account Modifier are used to differentiate Offsetting inventory GL Account. 

These modifiers are used along with Transaction Keys like GBB –  (Offsetting Inventory Account) and PRD –  (Price Differences)

List of Account Modifier or General Modifier: 

Valuation Class:

It is used to differentiate Inventory GL Accounts based on Material nature

Valuation class is assigned to the material master under Accounting view.

Note:  The Valuation Class is maintained with reference to Material Type Material Master also created with Reference Material Type. While assignment of Valuation Class to the material master, system validates material types of Material Master and valuation class. If any mismatch will cause error 

 

Note: 

All Inventory and goods movements will be posted by logistic users with Movement Type

The respective transactions keys area associated with movement type Against transaction keys inventory GL Accounts are maintained with the Combination of  COA, Val Grouping Code, Account Modifier or General Modifier and Valuation Class.

Configuration Steps for MM – FI Integration

Step 01 - Define Plants T-Code 0X10

Path: SPRO →  Enterprise structure → Definition → Logistic general → Define copy, delete check plant → Double click on Define Plant → New Entries button 

Step 02 - Define Location T-Code 0X10

Path: SPRO →  Enterprise structure → Definition → Logistic general → Define Location → New Entries button 

Step 03 - Define Division:  T Code OVXB    TSPA

Path :SPRO → Enterprise structure → Definition → Logistic general →Define copy, Delete, check division → Define Division → New Entries button 

 

Note : Division is organizational unit of SD, which is used to track sales or profits from Salable Materials or services. Division are used to identity or track business area against logistic transactions

Step 04 - Maintain Storage Location T Code : OX09 – T001L