SAP MM – Master Data

Master data in MM module contains all the basic information need to manage a material. These data records are stored centrally and are used and processed on a cross-application basis. Material Management of SAP maintains the records of various activities and processes material procurement, material modification and production, such as purchasing materials, storing and maintaining them. Creating masters is the basis to start any implementation, which reduces repetitive work and minimizes the chances of errors.

The following are the list of master records in SAP

  1. Material Master
  2. Service Master
  3. Vendor Master
  4. Purchasing info record
  5. Source List
  6. Quota Arrangements.

Material Master

The Material master contains all data required to define and manage material.

It integrate with various departments of the company (eg: Sales and Distribution, Purchasing, Accounting, Production etc)

The material master is used as a source of data for processing procurement cycle.

Material master contains the information of material type, price control, industry sector, size, and dimension etc. Information is stored based on the views selected by the user departments.

Below are the list of views available in Material Master Record

1. Basic data 1 & 2
2. Purchasing
3. General plant data storage 1 & 2
4. Warehouse Management 1 & 2
5. MRP (Material required planning) 1,2,3,4
6. Accounting 1 & 2
7. Costing 1 & 2
8. Quality Management
9. Plant Stock
10. Storage Location Stock
11. Classification
12. Forecasting
13. Purchase Order Text
14. Foreign Trade: Import Data

 

Material Master

 

List of T-codes for SAP MM Material Master

S.NoT CodeDescription
1MM01Create a Material & extending Material
2MM02Changes a material
3MM03Displays a material
4MM04Displays the changes made in the material
5MM06Material Flags for deletion
6MM11Schedule creation of material
7MM60Material List
8MM17Mass Maintenance
9MM50List extendable materials
10MMAMChange Material Type
11MMNRDefine Material Master Number ranges
12MM70Archieve Material
13MR21Material Price Change

Following are the list of mandatory things to create Material Master

  1. Material Types
  2. Industry Sector

Material types:

It is a key that assigns the material to a material type such as Raw materials, trading goods. This allows you to manage different materials in a uniform manner in accordance with your company's requirements.
The Material type represents the group of materials that have same basic attributes.

Use: When creating a material master record, the material type determines

  1. Purpose of the material should be the same material type
  2. Whether the material number is assigned internally or externally
  3. From which number range interval the material number comes
  4. Which screens are displayed
  5. The order in which screens are displayed
  6. Which department-specific data is displayed for the user to enter
  7. The material procurement process should be same for all the materials in the material type.
  8. Price control is done in material type configuration. It can be either
  9. Standard price (S)
  10. Moving average price (V)

 Customizing Path: SPRO (T code) ---> IMG ----> Logistics General---> Material Master ---> Basic Settings--->  Material Type ---> Define Attributes

 T – Code – OMS2

 List of Material Types in Standard SAP

S.NoMaterial TypeDescription
1CONTKANBAN containers can be created as a material. It is easy to search the KANBAN containers in Material
2DIENServices can be performed internally or procured externally (outsourced). They cannot be stored or transported.
3ERSASpare parts are used to replace defective parts. Stock can be maintained. Purchasing data only exists for this material, no sales data
4FERTFinished products are produced in-house. Since they cannot be ordered by Purchasing, no purchasing data exists for the Materials in this material type
5FGTRBeverages.
6FHMIProduction resources/tools. This material maintained on quantity basis. Purchasing data will exists for this material. Since the tools used for Plant maintenance activities, no sales data will available for these material type (eg: Jigs & fixtures)
7FOODFoods excluding perishables
8FRIPGoods that are perishable in an mixture (eg : Fruits ,vegetables, dairy Products, Meat)
9HALBSemi-finished Goods.This material can be either purchased externally or produced internally. Material data can contain both work scheduling data and purchasing data
10HAWATrading Goods. This type of material can have both purchase data and sales data. This material can be purchased and sold externally
11HERSManufacturer parts .A material can be identified by different manufacturer part numbers by different vendors or manufacturers
12HIBEOperating Supplies. It is used to manufacture other parts. It is procured externally. Only Purchasing data exists, no sales data
13IBAUMaintenance Assemblies. These are not individual parts, but reasonable elements to separate technical objects (Eg: Tool Kits used to dismantle engine , Mobile phones etc. It contains only classification data and basic data
14INTRIntra Materials. It is used as intermediate material between two processing steps. No sales data no purchasing data
15KMATConfigurable Materials. Different types of variants are maintained for same material. (eg: Paint work in automobile industry)
16LEER & LGUTIndustry Empties & Retail Empties. Empties are returnable materials which all together formed the BOM of the material. (eg: Empty crate and Empty bottle all together formed the Product of Beer)
17MODEApparel, seasonal
18NLAGNon Stock material. Consumed immediately, no stocks can be maintained for this material (eg : Office supplies) No quantity and no value updating
19NOF1Non Foods. Items sold in grocery shop other than food items (Eg: Paper products, magazines)
20PIPEMaterials Oil, Power and water flowing into production process regularly through pipeline. These materials are always available. No planning is done.
21ROHRaw Materials. They are usually procured externally and Processed. No sales data maintained for this materials. Purchasing data can exists.
22UNBWNon valuated Materials. These materials are maintained in stock on quantity basis not on value basis. Eg: Pamphlets
23VERPPackaging Materials. Used in goods transportation and comes with goods free of charge. It is maintained on both quantity and value basis
24WETTCompetitive Products. For doing market analysis with the competitors by observing and evaluating. Used by the sales department to monitor the products of the competitor.

Industry Sector

Material needs to be classified based on Industry type. This is called industry sector.

Industry sector needs to be specified during material master record creation.

Industry sector cannot be changed once it is created.

Important Tables in Material Master

T codes to access table: SE16, SE16N, SE11

S.NoTableDescription
1MARAMaterials General data
2MARCPlant data of the material
3MARDStorage location data of the material
4MAKTMaterial Description
5MBEWMaterial Valuation
6MBEWHMaterial Valuation History table
7T134Material type
8T134TMaterial Type description
9MASTMaterial to BOM link
10TSKMMaterial Taxes

 

Organization Structure    Service Procurement

 

 

 

Leave a Reply

Your email address will not be published.