Procurement's role in keeping your SAP material master data honest



download.jpgWill the company that has reasonable material master data please stand up!? SAP’s material master data, without a doubt, is the bane of any Procurement Manager’s existence. This will also not be news to any manager in purchasing, with most companies despairingly accepting that master data always has and always will be an insurmountable problem. This, after several failed attempts to fix the challenges that material master data presents, says Steven Freemantle of SweetThorn Thought Leadership in this month’s SmartProcurement.


You may be wondering why keeping material master data honest is procurements’ job. Master data can only make a buyer’s job that much easier. Having good data means less intervention is required in SAP generated requisitions, and in fact, the better the quality of your data, the more likely you can move to using SAP’s automated procurement functionality.

If automation is not motivation enough, you may want to consider this: It is procurement that contact suppliers and promise remuneration in exchange for goods, perhaps it is procurement then that may have a vested interest in making sure that that master data of the goods they buy, accurately represents what they are buying.

There is also no doubt that addressing the issue of master data is complex and daunting, but you will have to begin somewhere. In the interests of getting back to basics, one should come to terms with the following fundamental questions departure point for fixing your material master data

1. Do you have a stocking strategy philosphy – that supports alignment of organisational strategy with tactical execution?

2. Do you know how to translate this philosphy into effective MRP rule sets?

3. Do you have a methodology that will help determine these rule sets?

4. Do you know where to populate these rules in SAP’s four MRP views?

5. Do you know how to use standard SAP tools to measure that the rules are delivering to, or detracting from your strategic objectives?

6. Do you know how to change the rules if they are not helping with the tactical execution of your strategy?

7. Do you know how to use SAP’s supply chain exception monitors to check that the rules are adhered to – every day?


Thumbnail image for StevenFreemantle2.JPGSAP has built a variety of different stocking strategies into the 4 MRP views you find in a material master and when combined through a structured and thought-out approach, will significantly improve not only the quality of your master data, but the outputs of your MRP. In most cases companies typically stick to one set of rules across all materials, implying that all materials, articles or spares behave in exactly the same way, however, it is not believable that this is the case. One way to test if your implementation went this route is to figure out the diversity of MRP Types that you use. SAP has built around 30 standard MRP Types into the system. Most companies use only one or two. If this is the case in your company then you have inadvertently adopted a “One Solution Fits All” inventory management philosophy. If this is the case in your SAP system, then not much attention has been paid to the questions above, and you most likely have some work to do in getting your material master data to reflect your reality.

There are some standard, quick and easy reports you can use to figure out the ratios of MRP Types your company uses across your inventory. Your SAP support partner or IT department should be able to guide you to these. Understanding how well you are using this one MRP rule is starting point to begin addressing the multitude of other possible master data settings.

As the procurement function considers material master data setting sit is worth noting that procurement cannot function as the sole owner of material master data, but more the custodian. Collaboration and integration across all departments - sales, planning, procurement, maintenance, accounts payable and accounts receivable is paramount to ensuring exceptional customer service, streamlined efficiency and optimised inventory levels. It becomes crucial then that procurement (or any function for that matter) does not dictate the master data setting, but rather collaborates with their customers to at very least ensure a sound understanding of how master data impacts the entire supply chain.

Leave a comment

SmartProcurement Newsletter

Please enter your details below to receive the SmartProcurement Newsletter for FREE on a regular basis.

As part of the SmartProcurement Newsletter you will be receiving World Class Procurement News, Tools, Tips, Tactics, Procurement Training updates, Upcoming Events, and the latest Procurement Career Openings.

* Email Address:
* Title:
* First Name:
* Surname:
* Company:
* Country:
* Public / Private:



Career opportunites

Supply Chain Analyst

  • <500 000 Analyst Permanent Supply Chain Western Cape
R400 000 - R500 000 per annum.Location: Cape ...More

Commodity Manager

  • <500 000 Commodities Gauteng Permanent Procurement Consultant
R650 000 - R750 000 per annumLocation: Cape ...More

Logistics Manager

  • <500 000 Gauteng Logistics & Warehousing Operations, Planning & Inventory Permanent
Salary: R 800 000 - R 900 000 ...More

Demand Planner

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management
Salary: R 600 000 - R 650 000 ...More

Supply Chain Analyst

  • <500 000 Analyst Gauteng Permanent Supply Chain
R600 000 - R700 000 per annum Location: ...More

Commodity Manager

  • <500 000 Commodities Gauteng Permanent Procurement Management
R850 000 - R1 000 000 per annumLocation: ...More

Commodity Manager

  • <500 000 Commodities Permanent Procurement Management Western Cape
R700 000 - R850 000 per annum,Location: Western ...More

National Supply Chain Manager

  • <500 000 Across borders Permanent Procurement Management Supply Chain
R750 000 - R1 000 000 per annum,Location: ...More

Industrial Engineer

  • <500 000 >500 000 Industrial Engineer Operations, Planning & Inventory Permanent Western Cape
R450 000- R500 000 CTC per annum,Location: Western ...More

Commodity Manager

  • <500 000 Commodities Gauteng Permanent Procurement Management
Category: Procurement,Salary: R700 000 - R800 000 per ...More

Supply Chain Manager

  • <500 000 Gauteng Permanent Procurement Management Supply Chain
Category: Consulting,Salary: R750 000 - R800 000 CTC ...More

Logistics Manager

  • <500 000 Across borders Logistics & Warehousing Permanent Procurement Management
Category: Logistics,Salary: R900 000 - R1 000 000 ...More

Demand Planner

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management
Area of Specialisation: Planning,Salary: R500 000 - R650 ...More

Industrial Engineer

  • <500 000 Analyst Gauteng Industrial Engineer Permanent
R800 000 - R850 000 CTC per annum.Location: ...More

Security Manager

  • <500 000 Analyst Gauteng Permanent Procurement Officer / Specialist
(Total Cost to Company R350K - R550K).This is ...More

Operations Manager

  • <500 000 Gauteng Operations, Planning & Inventory Permanent Projects / Category Management
(Total Cost to Company R650k - R750k) excluding

Commodity Manager Raw Materials

  • <500 000 Commodities Gauteng Permanent Strategic Sourcing
(Total Cost to Company R980k - R800k) excluding ...More

Commodity Manager Logistics

  • <500 000 Commodities Gauteng Logistics & Warehousing Permanent
(Total Cost to Company R1mil - R900k).Industry: Engineering

Procurement Consultant

  • <500 000 Gauteng Permanent Procurement Consultant Procurement Management
(Total Cost To Company 550K - 450K) includes ...More

Commodity Manager MRO &CAPEX

  • <500 000 Commodities Gauteng Permanent Projects / Category Management
(Total Cost To Company 900k - 750k) includes ...More