What is master data in SAP MM | Consulting Tips

Master data in SAP MM is the building block of all the logistics processes. It not only affects MM processes but also PM, QM, SD, FICO, PS and EHS module business processes. There are ten key master data in SAP MM. Please go through the list of master data in SAP MM and enhance your knowledge.

List of master data in SAP MM

Master data in SAP MM

Master data in SAP MM are necessary for all the MM and other module’s business processes. There are ten important master data in SAP MM. All the Logistics modules uses Material master therefore its quality must be good.

  1. Material Master (“Product master” in S4 HANA)
  2. Vendor Master (Business Partner)
  3. Service Master
  4. Purchase Info Record
  5. Condition Master
  6. Source List
  7. Quota Arrangement
  8. Class
  9. Characteristics
  10. Characteric values

Consulting Tips and recommendations

In a full life cycle implementation project master data plays a critical role. Poor designing of master data and its nomenclature can totally ruin the show. If you load garbage in system, system will throw garbage. You must take care of following tips while designing master data with business:

  1. Material Master designing is a joint activity between MM, SD, QM, FICO, PP, PM and EHS.
  2. Business Partner is introduced in SAP S4 HANA. It represents vendor master data. Vendor master design is a joint activity between MM and FI.
  3. Nomenclature of Material Master, Service Master and Vendor master id and their description should be finalized as per a predefined formulae. This is known as Cataloguing.
    • For ex: First 2 characters of material master should indicate material type such as Raw material, spare part or semi finished material. The next character can indicate its Function. Such as it is Air Circuit Breaker, Pump, Shocker, etc. Similarly you can decide the nomenclature of vendor master and service master. But you must do thorough study of master data before giving any recommendation. As per scope of project this activity can be done by client. You can only give consultation by showing examples.
  4. Recommend client to develop a Material Cataloguing tools for generating material number. This Cataloguing helps business to identify and locate the material, vendor etc easily in SAP.
  5. Finalize the Material type at the beginning of the blue print phase. So that purpose of each material type is clear to client. This will help them to prepare material master data in a correct form. Many times its has been observed that client gets confused between different material types.
  6. Procedure to create the master data post go live must be defined during implementation itself. Responsible person at client side must be identified and all templates must be in place.
  7. Do not forget to ask for material or vendor description in client local language.
    • For ex: If you are working for a German client then client may ask to enable master data uploading program to handle multiple languages such as German, Dutch etc.
  8. Unit of measurement in material master is very critical. Generally people ignore it and later on it creates isue while doing business. Lot of SAP MM support tickets are created due to incorrect unit of measurement. You can use the additional data in material master.

Master Data Dependency

Here is the list of master data in sap mm with the dependency of other data which must be created before we upload SAP MM related master data. Please refer below table to understand the dependency:

S. No.Master data in SAP MMDependency on other master data
1CharacterisitcsUnit of Measurement (UoM)
3Business Partner (Vendor or Supplier)GL Account
4Material MasterProfit Center, UoM,
5Service Master
6Purchase Info RecordMaterial master, Vendor (Supplier)
7Condition MasterMaterial master, Vendor,
8Source ListPurchase Info Record, Material, Vendor
9Quota ArrangementPurchase Info Record, Material, Vendor
10Characterisitc valuesClass, Characterisitcs, Material Master. It depends upon where we are assigning the characterisitc values.
Table to show the master data dependency

SAP MM Master data uploading

SAP MM Master data upload needs a proper strategy. You cannot plan it in a hustle. There are few ways we can do so. Please refer below table to understand various ways to upload MM master data. I have included only those ways which can be used by a functional consultant.

S. No.List of master data in SAP MMMaster data upload approach/ tool
1Material Master (or Product Master)Migration cockpit
SAP Data Service
2Business Partner (Vendor Master)Migration cockpit
SAP Data Service
3Purchase Info RecordMigration cockpit
SAP Data Service
4Source ListMigration cockpit
SAP Data Service
5Quota ArrangementMigration cockpit
SAP Data Service
6Service masterLSMW
SAP Data Service
7Condition MasterLSMW
Migration cockpit
SAP Data Service
Migration cockpit
SAP Data Service
Migration cockpit
SAP Data Service
10Characteristc valuesMigration cockpit
SAP Data Service
Master data uploading tools
error: Content is protected !!