{"id":4685,"date":"2024-06-05T21:56:15","date_gmt":"2024-06-06T02:56:15","guid":{"rendered":"https:\/\/innovapps.net\/materials-in-sap-how-to-be-a-master-of-master-data\/"},"modified":"2025-02-20T03:48:15","modified_gmt":"2025-02-20T08:48:15","slug":"materials-in-sap-how-to-be-a-master-of-master-data","status":"publish","type":"post","link":"https:\/\/innovapps.net\/en\/blog\/materials-in-sap-how-to-be-a-master-of-master-data\/","title":{"rendered":"Materials in SAP | How to be a Master of Master Data."},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Challenges in the SAP Materials Master and how to address them.<\/strong><\/p>

SAP’s Material Master is where the entire supply chain is born. And where it starts to die when things go wrong. <\/span><\/p>

This is the first reason why we decided to set aside the traditional SAP consulting services and to spin off a <\/span>spin off<\/i> on our business to focus on addressing these challenges common to all SAP companies, through a solution that is easy to implement and works for everyone.<\/span><\/p>

Now, if you don’t want to wait, you can go directly to the site of <\/span>SiDM Materials<\/a>but before you fall in love with our application, let’s go formal and let me show you the structured list we have found of common mistakes or challenges in the Material Master in different companies, and the general approach to address them, and I will complement it with the good approach that Anjali More adds in her article on SiDM Materials. <\/span> <\/span>companies, and the general approach to address them, and I will complement it with the good approach that Anjali More adds in her article <\/span>A Complete Guide to Master Data in SAP MM.<\/a>:<\/span><\/p>

Main challenges of material master data in SAP:<\/span><\/p>

1 <\/span><\/span>Wrong data:<\/span><\/h1>

1.1 <\/span><\/span>The naive error, <\/span> <\/h2>

Just the item group that has been removed, or the unit of measure that does not exist, is not a big deal, but it is minutes of rework, especially when dealing with outdated Excel templates.<\/p>

1.2 <\/span><\/span>The complex error, <\/span> <\/h2>

When SAP allows you to create, a material called “Lubricating Oil” but by mistake you set the unit of measure in “inches” instead of liters or barrels. This is more risky because it can go unnoticed until it becomes a big problem if you already have stock or define a price of $10 per ml instead of $10 per gallon. <\/p>

Another common major problem that exists with erroneous data is erroneous reporting, such as when a user sets up the wrong valuation category and the inventory asset account on a financial report is erroneous because the value of the raw material account includes the value of a high-cost spare part.<\/p>

Solution approach<\/b>: Business rules, sometimes meaning formulas in an Excel template, non-standard validation programs in SAP, or simply a PDF manual for the user to follow step by step.<\/p>

2 <\/span>Incomplete data:<\/h1>

It is often a waste of support time, causing delays in invoicing or in the creation of purchase orders because a material has not been extended to a plant or the purchase view is missing.<\/p>

Forgetting alternative units of measure, or tax classifications, are cases where SAP allows you to create incomplete material, but then charges you dearly with error messages just at the time of most urgency.<\/p>

<\/b><\/p>

Solution approach<\/b>: Again, business rules are needed, in this case to define all the views that are needed for each scenario and organizational units, but there are different approaches, often shocking red cells in Excel templates to warn users about the required views, or checklists in documents. In this case it is more difficult to use custom programs in SAP or it means solutions that are too customized, not scalable and not flexible enough. <\/p>

3 <\/span>Data Governance – Centralized \/ Decentralized Processes<\/h1>

Who should make the requests? Who should validate them? Who should create the material? And how to do it in time? <\/b><\/p>

In most cases, different departments are responsible for part of the data, such as purchasing departments create the purchasing view, logistics creates the MRP data, finance creates the accounting views, and so on. Sometimes in parallel, sometimes depending on dependencies. <\/p>

But how to involve all these people without it becoming a bureaucratic and inefficient process that sometimes ends up excluding users or creating delays in the supply chain.<\/p>

Solution focus<\/b>: Workflows are clearly the solution, but what tools do they require? Most common: a live template that goes back and forth between different inboxes, sometimes in meticulous order, sometimes in a chaotic sequence that takes days to create a “mouse” for the accounting department’s laptops. It’s sad. <\/p>

Other solutions are external applications, such as forms in SharePoint, or custom software that ends up in a template that the user must load into an LSMW or a non-standard program with iterations of manual file corrections.<\/p>

4 <\/span><\/span>Duplicate data: the silent danger<\/span><\/h1>

The problem is clear: a single SKU created in SAP 2 or more times by mistake, at best only time is lost to identify and block the duplicate, at worst duplicate purchases, inventory and ultimately costs.<\/p>

But here I want to go deeper into the solution approaches, because they are not as obvious as the previous ones.<\/p>

Solution approach<\/b>: Here are some ways to address the challenge:<\/p>

4.1 <\/span>Based on the description of the material (short text)<\/h2>

One of the most common customer requests and one of the most difficult to solve. You can use the most advanced technology such as AI, but I am of the opinion that human validation is necessary, and here our common example of the difficulty of this challenge: <\/p>

Case 1: No duplicate data.<\/span><\/b><\/p>

Material number<\/span><\/p><\/td>

Description<\/span><\/p><\/td><\/tr>

A0001<\/span><\/p><\/td>

Stainless steel screws 3 inches x 100 pieces<\/p><\/td><\/tr>

A0002<\/span><\/p><\/td>

Stainless steel screws 4 inch x 100 pieces<\/p><\/td><\/tr><\/tbody><\/table>

Case 2: <\/span>Duplicate data.<\/span><\/b><\/p>

Material number<\/span><\/p><\/td>

Description<\/span><\/p><\/td><\/tr>

A0003<\/span><\/p><\/td>

Stainless steel 2″ Screw<\/span><\/p><\/td><\/tr>

A0004<\/span><\/p><\/td>

2″ Stainless Steel Screws<\/p><\/td><\/tr><\/tbody><\/table>

In case 1, the SKUs are 3-inch and 4-inch screws, so that’s fine. There is no duplicate data<\/b>.<\/p>

In case 2, the text lengths are different, there are few matches, but the references are the same. They are duplicate data<\/b>.<\/p>

4.2 <\/span><\/span>Based on key fields<\/span><\/h2>

This approach is really accurate and easy to identify early on, in the creation process, or later for existing materials. Fields such as “EAN” or “Manufacturer’s part number” are recommended here. <\/p>

A common mistake is to apply this approach, but using fields that are not from the basic data view. This is not right, because they may be fields that depend on different organizational units, therefore, they may have different values for the same material, so it would be a wrong approach. <\/p>

4.3 <\/span>Based on classification characteristics<\/h2>

This could be even more accurate, and is appropriate for spare or replacement parts, because duplicates can be identified with a list of specific attributes, regardless of whether the materials have the same description, EAN or manufacturer part number. For example, if a user creates an “electric motor”, he or she should set characteristics such as <\/p>

Manufacturer<\/p>

Reference<\/p>

Input voltage<\/p>

Synchronous\/Asynchronous<\/p>

Power<\/p>

RPM’s<\/p>

On the other hand, as you can imagine, this requires military discipline and is difficult to implement in a material master that already has thousands of records.<\/p>

5 <\/span><\/span>Maintenance<\/span><\/h1>

Even if your company has a solid and controlled creation process, it is practically impossible to have an error-free material master. Even if we assume so, companies are living animals, they grow, change, have new scenarios, and it is usual that new projects bring new requirements to modify thousands of materials in a specific field, or change values, or extend to new organizational units. <\/p>

Perhaps the company has a strong filter in the creation process, but may have an open door in mass changes to all previous errors (incomplete or erroneous data), so it is important to have tools to control maintenance as well as creation.<\/p>

Solution approach<\/b>: Typically the solution is the same, non-standard templates and programs in SAP, but often with less validation or governance.<\/p>

The proper approach, regardless of the technical solution, is to ensure the application of business rules to reduce incorrect and incomplete data.<\/p>

6 <\/span><\/span>Integration<\/span><\/h1>

There are situations where companies need to share material master data in SAP with other systems, and sometimes the material creation process is initiated in external systems.<\/p>

In my opinion, it is important to assume that if SAP is YOUR ERP, where you run your processes (finance, operations, sales), it should be the center of your landscape<\/i>, at least as far as master data is concerned.<\/p>

Therefore, it is convenient to start in SAP, create the right data and only then trigger events to consume API’s or web services to replicate the data you need in other systems.<\/p>

If you need to initiate the process in an external system, try to identify the minimum data you need to share with that system, define an appropriate field mapping and, ideally, obtain only the minimum data needed from the external system, to complete the rest of the material data in SAP, taking into account the business rules and workflows we discussed earlier.<\/p>

As for the solution approach, in this case, sorry, but there is no escpe, custom integrations need to be developed, don’t expect a magic answer.<\/p>

It’s time for SiDM Materials<\/a><\/h2>

Now, I think we deserve your attention for a few more lines, and possibly, your love for our SiDM Materials solution.<\/p>

Let me explain in a few words, in a graphic, easy as we want your SAP processes to be, how to address all the challenges of Material Master Data:<\/p>

Challenge<\/span><\/p><\/td>

Function \/ Solution<\/span><\/p><\/td><\/tr>

Erroneous data<\/span><\/p><\/td>

SiDM Materials has field rules that require no technical knowledge or programming. 100% end-user functionality to automatically populate the values your company needs and additionally, it maintains standard validations such as required fields, existing values and even user permissions. <\/p><\/td><\/tr>

Incomplete data<\/span><\/p><\/td>

Business rules for views and organizational units, not only to ensure that materials are created correctly, but also to check and correct existing incomplete data.<\/p><\/td><\/tr>

Data Governance<\/span><\/p><\/td>

Workflows, with flexibility to define:<\/p>

– <\/span>Different workflows for different scenarios<\/p>

– <\/span><\/span>Multiple levels\/responsible parties<\/span><\/p>

– <\/span><\/span>In line or in parallel<\/span><\/p>

– <\/span>Specify the fields to be filled in by each responsible person or if only approval is required.<\/p>

– <\/span>Who is responsible for the creation<\/p>

– <\/span>And furthermore, define additional data managers such as bill of materials or routings.<\/p><\/td><\/tr>

Duplicate data<\/span><\/p><\/td>

SiDM Materials encompasses all three approaches:<\/p>

– Text-based (multilingual, short text, long text, purchase order text)<\/p>

– Based on key fields (such as EAN or Manufacturer Part No.)<\/p>

– Based on classification characteristics<\/p>

Identify and validate in the creation process and identify and correct existing duplicate materials.<\/p><\/td><\/tr>

Maintenance<\/span><\/p><\/td>

Multiple tools for massive changes, based on business rules, in model material or manually.<\/p>

Identify specific materials that do not comply with business rules.<\/p>

Identify and extend incomplete materials with all validations.<\/p>

Proofread, standardize or complete texts in several languages.<\/p><\/td><\/tr><\/tbody><\/table>

Now, I know we’ve gone straight to your heart, so…if you want to see how the magic happens, or if you want to bring the magic to your users:<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLet's talk about SiDM Materials<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Challenges in the SAP Materials Master and how to address them. SAP’s Material Master is where the entire supply chain is born. And where it starts to die when things go wrong. This is the first reason why we decided to set aside the traditional SAP consulting services and to spin off a spin off […]<\/p>\n","protected":false},"author":1,"featured_media":4433,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96],"tags":[99,98,100,97,101,85],"class_list":["post-4685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-master-data-sap","tag-data-governance-en","tag-data-quality-en","tag-material-master","tag-mdm-en","tag-mm01-en","tag-sap-en"],"_links":{"self":[{"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/posts\/4685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/comments?post=4685"}],"version-history":[{"count":3,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/posts\/4685\/revisions"}],"predecessor-version":[{"id":4954,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/posts\/4685\/revisions\/4954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/media\/4433"}],"wp:attachment":[{"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/media?parent=4685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/categories?post=4685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/innovapps.net\/en\/wp-json\/wp\/v2\/tags?post=4685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}