Material Master Data

SAP-MM (Material Management)

A) Purchasing Module

B) Inventory Management.

C) Logistic Invoice Verification.

Master Data: The data in the consolidation system remains unchanged over a long period of time called master data.

Transaction Data: The Data uses Mater data while creating transactions.

Material

  • Goods or objects that are used, consumed, or created during the manufacturing may be called materials.
  • It is the smallest unit that cannot split into any smaller unit.
  • The material can be traded, used in manufacture, consumed are produced.
  • A Service may also be treated as material.

Inclined to build a profession as SAP MM Developer? Then here is the blog post on, explore "SAP MM Training"

Material Master:

  • It contains the description of all materials that an enterprise procures, produces, or keeps in stock.
  • It represents the central source for the material-specific data.
  • Integration of all material data in a single material database eliminates the problem of data redundancy and permits the data to be used not only purchasing but other applications like inventory management, Material Planning & Control, Invoice Verification, etc.
  • The data mentioned in the Material Master is for more than one organizational level
  • How the information in the Material Master is organized in the Material Master DataBase?

Check Out SAP MM Tutorial

Data at the Client level (data is valid for the whole company)

Ex: Material No, Short Text, Material Group, Base, and Alternate Unit Of Measure.

Data at Plant level: All the data that is valid within the plant and for all storage locations in its store at the plant level.

Ex: Purchasing data, MRP data, Forecasting data, and work scheduling data

Data at Storage Location Level: All the data that is valid for a particular storage location is stored at this level.

Ex: Storage bin Description, picking area, etc.

Material Type: Certain attributes of Material called Material Type or Grouping of materials with the same basic attributes/characteristics. Ex: Raw Materials, Semi-finished or finished products.

Material Group: Similar properties of material grouped together called Material Group (Or) grouping of materials according to their characteristics.

Material Class: Material Classification is for easy and fast retrieval of (material) data.

SAP MM Material master

Notes on Material Type:

Material Types are used for the following areas

  • Profit Center Accounting
  • Valuation & A/c Assignment (Valuation Class)
  • Product Cost Planning
  • Production, BOM, and Routings
  • SD (Availability Check)

Material Type determines which accounts are to be posted when a material is posted or leaves from the warehouse.

Together with the plant, the material type determines the materials Inventory Management Requirements like

  • Whether changes in Quantity are updated in the Material Master record
  • Whether Changes in Values are updated in the Stock A/c in Financial Accounting.

Material Type Controls

  • Type of Number assignment
  • Permitted Number range interval
  • Which screens are to be displayed in which order?
  • Which user department-specific data (view) is suggested for entry?
  • Which procurement type is permitted for material i.e. whether the material is procured externally, in-house or both allowed.Etc.

Which G/L accounts are to be updated?

Material Types in standard SAP

  1. ABF - Waste 
  2. COMP- Prod. Alloc. Purchases                
  3. CONT - Kanban Container                         
  4. COUP - Coupons                                        
  5. DIEN - Services                                            
  6. ERSA - Spare parts                                       
  7. FERT - Finished Product                           
  8. FGTR - Drinks                                               
  9. FHMI - Prod. Resource/ tools                    
  10. FOOD - Food (excl: perishable)                 
  11. FRIP - Perishable         
  12. HALB - Semi-finished prod.           
  13. HAWA - Trading goods.
  14. HERS - Manufacturing Parts.     
  15. HIBE - Operating supplies       
  16. IBAU - Maintenance Assy. 
  17. INTR - Intra material. 
  18. KMAT - Configurable Mat.
  19. KWFO - Own material.
  20. LEER - Empties. 
  21. LEIH - Returnable-Packaging
  22. LGUT - empties (retail)   
  23. MODE - Apparel (seasonal)
  24. NLAG - Non Stock material
  25. NOFI - Non-Foods
  26. PIPE - Pipeline material
  27. PLAN - Trading goods (planned)
  28. PROC - Process material
  29. PROD - Product Group
  30. ROH - Raw material   
  31. UNBW - Non-Valuated material                               
  32. VERP - Packing material                       
  33. VKHM - Additionals                       
  34. VOLL - Full product                                       
  35. WERB - Product Catalog                             
  36. WERT - Value Only material               
  37. WETT - Competitive product.   

master-material-data

Material Views:

Basic Data1                 

Quality Management                               

Forecasting                     

Basic Data2                 

Warehouse Management1                       

Accounting 1      

Classification               

Warehouse Management2                       

Accounting 2

Purchasing Data           

Plant / Storage 1                                     

Costing 1

PO Text                         

Plant / Storage 2                                     

Costing 2

Sales1                           

MRP 1                                                       

Plant Data

Sales2                           

MRP 2                                                       

Storage Loc. Data

Sales3                           

MRP 3                                                       

Production Resources

Sales Order Text         

MRP 4                                                       

Work Schedule                                                                               

Foreign Trade Import                                                                                                                                                                                                             

Foreign Trade Export

 

 table

Material Master IMG Settings:

Define the valuation level: SPRO->Enterprise Structure ->Definition -> Logistics – General

Define the valuation level (OX14)

Define Output Format of Material Numbers: SPRO->Logistics – General -> Material Master ->Basic Settings

Define Output Format of Material Numbers (OMSL)

Maintain Company code at Material Management: SPRO->Logistics – General -> Material Master -> Basic Settings Maintain Company Codes for Materials Management (OMSY)

Define Attributes of Material Types: SPRO->Logistics – General -> Material Master -> Basic Settings Material Types-> Define Attributes of Material Types (OMS2) - Qty and Value updating

Define Number Ranges for Each Material Type: SPRO->Logistics – General -> Material Master -> Basic Settings Material Types-> Define No Ranges for Each Material Type (MMNR)

Define Material Groups: SPRO->Logistics – General ->Material Master -> Settings for Key Fields Define Material Groups (OMSF)

Create Purchasing Groups: SPRO->Material Management -> Purchasing -> Material Master Data in SAP MMCreate Purchasing Groups