Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Andy456
Advisor
Advisor
Most SAP Customers run Procure to Pay processes, be it for indirect or direct materials.

I observe that most customers face supply chain issues due to incorrectly material master settings. These settings heavily impact manual efforts on the Purchase Requisition (PR) to Purchase Order (PO) flow, but also on Safety Stock Levels ( and therefore Liquidity).

I want to show that focusing on 'Planned Delivery Times' on the Material master (MARC-PLIFZ) will have extremely positive effects, and all that is needed is SAP Process Insights.

 

In Detail

For MRP driven materials several settings on the material master determine when a PR gets created, and for which suggested quantity based on a current 'Supply / Demand' situation present during the MRP run.

I want to put focus on direct materials, in particular Purchase Orders that were created as a result of an MRP run for materials with Procurement Type 'F' ( the German 1st character for 'Fremd' / 'External).

Below you see the logical flow of events.


The MRP run calculates Quantity and Date, iow, it suggests something like :

Order quantity X of material A on date D

I would like to elaborate a bit on how date D is calculated (simplified).

😧 PR Creation Date =

(Demand Date) - (Goods Receipt Processing Time) - (Planned Delivery Time) - (PR Processing)

If everything is well maintained, and the supplier delivers as expected, we should expect a goods receipt on time.

But this is not what I observe in customer systems.

Below illustration shows the gap between 'theory' and 'reality'


In fact, we typically find the following

  • The planned delivery time on the Material master is never equal the actual delivery time

  • The Purchase Orders are typically not created on the suggested date

  • If people adjust the delivery date on the PR to a value different from the material master, it also does not hold true


This means, that MRP induced POs do not deliver reliably and robustly.

How to improve the precision of PO deliveries?

There are many explanations why reality does hardly represent theory.

But significant improvement can be achieved by optimising at the planned delivery times maintained on plant level for externally procured materials.

 

SAP Process Insights delivers fantastic, actionable Insights with just a few clicks.

Choose your Purchase Requisition to Purchase Order Flow

Here, we want to focus on MRP created PRs, so select the filter 'Creation Ind. ESTKZ' = 'B'

Select your filter so that you focus on Raw Materials ( e.g. by Document Type or similar).

Now choose the filter 'Pl. Deliv. Time(Mat) PLIFZ_MARC' as well as 'Pl. Deliv. Time(PR) PLIFZ'

Sort both by 'ID', you should see something like this:

 


 

To the left you see 'Number of Days', and on the right you see how many PR Items were created in the time period for with this Number.

By putting both filters next to each other, you see on the left column what the system was using during MRP, and on the right column you see the value on the PR after manual intervention.

Do you see the difference?

But more interestingly is below is when you focus on '5' and '10'... - or on '7' and '14' ....

You see that in this example, there are two interpretations of 'what is a week?'.

 


One group believes you should take 5 days, another believe to take 7 days.


The team that chooses '7' btw is correct.

Let's take an example : The Supplier tells has he can typically deliver in 6 weeks.

  • Group 1 calculates 6*5 days = 30 Days

  • Group 2 calculates 6*7 days = 42 Days


This means, that the MRP job is creating the Purchase Requisitions 12 days too late. If the rest of the process happens as expected, production must be delayed by such 12 days. (In theory)

 

You can btw also measure the actual delivery time with process insights.

 

Without going further, here is what you should take away

  • SAP SIGNAVIO Process Insights helps you understand the real size of the opportunity

  • Planned Delivery Times on material masters are typically insufficiently accurately maintained

  • Generating a common understanding of '7 days = 1 week', with a subsequent update of Material Masters hardens the recommendations from MRP and improves the Supply of raw materials

  • Well maintained Planned Delivery times positively impact the reduction of Safety Stocks

  • Improving material master data allows to increase efficiency, automation, and provides more time for MRP controllers to focus on the unplanned


While certainly not all answers to improve Supply are in you area of influence - focusing on planned delivery times will bring great value to the organisation.

You can start with the 'What's a week' Analysis as indicated above, your one time usage right of SAP SIGNAVIO Process Insights from your RISE Contract is sufficient.

What is your experience with 'planned delivery times?'

Feel free to reach out to me to explore your data, to discuss and feedback, and, make sure to follow SAP SIGNAVIO.

 

 

 

 

 

 

 
8 Comments
TeawithThi
Product and Topic Expert
Product and Topic Expert
Such a great write up and I totally agree: the three most common issues are related to 1) master data, 2) master data and 3) master data...
In my near 20 years at an MNC across several countries - it didn't matter the regional culture, unity of process problems were in master data!
It saddens me a bit knowing that this blog post probably won't hash the awareness it deserves - but nonetheless a gem worth saving and revisiting. Because the above mentioned challenge is very common!
oscaramos
Associate
Associate
Very valid use case - it also shows the relevance of bringing people & processes together: we might have a clear process however different people interpretations on how to execute it, that need to be standardized to achieve clear value realization.
Andy456
Advisor
Advisor
0 Kudos
Thanks Oscar, spot on. I sometimes fear in many organizations workarounds are being established because some fundamentals are not equally well understood.
Andy456
Advisor
Advisor
0 Kudos
What a statement Thi. I will keep writing about this topic - to increase awareness.

There is also a common mistake when highlighting Master Data Problems : The answer is often 'Year, we know, that's why we implement Master Data Governance'. Such intiatives mainly address unique customer, vendor ( ok, Business Partner) numbers as well as material numbers. So - the 'common' part of master data, but hardly the 'plant specifics'.
What a lovely blog. It describes a very typical problem that we see in customer engagements since  at least 15 years, and customers are always wondering why the automatic supply chain planning is not yielding better (more realistic results). It's the master data that makes the difference. Of course the master data challenge is even a little bit more complex as purchasing info records for specific suppliers might provide more realistic planned delivery times, but as the material master is always the fallback scenario, it should contain more meaningful data than zero days or 999 days.
Andy456
Advisor
Advisor
0 Kudos
Many thanks Volker 🙏 I know we have been looking at this paradox for too long now. I will also write about Info Records and Order books to improve completeness of MRP proposed Purchase Requistions !
vtsykolanov
Associate
Associate
Great blog, Andreas! I remember writing SQL queries with you back in 2018. It was the first time we found out that 1 week is a subjective concept. Based on my recent projects, I still see all these issues in customer data. This blog is a must-read for any team, which decided to build something on top of master data. Simply because the quality of your output is determined by the quality of your input!
Andy456
Advisor
Advisor
0 Kudos
Look it was great fun with you in 2018 ! And I like your ‚must read‘ - well it is all about spreading the news … 💪 more on this to come !!!