User Experience Insights
Uploading PIR through CSV file in Maintain PIR app
The purpose of this blog post is to explain how to upload PIR in Maintain PIR Fiori app using the upload through Excel/CSV feature.
Step 1- Access the Fiori app- Maintain PIR.
Step 2- Assign yourself with an area of responsibility (AOR). The AOR is a combination of plant and MRP controllers. You can maintain this through app settings of Maintain PIR or My area of responsibility -Fiori app.
Step 3 – Access maintain PIR Fiori app and filter your materials as per various selection criteria .
Step 4 – Click Edit(1) button. The (X) depends on how many materials you want to edit/create PIRs. In the above example, I have chosen 1 material; hence it is showing Edit(1)
Step 5– Click the Excel download button, as highlighted below.
You can see that , CSV file with name Material_Details gets downloaded. This is is your input format. Even though you have downloaded just for a material, you can add more materials in the input file.
Step 6– Data before load in Fiori
Step 7 – Click upload and edit button to upload edited CSV file
Step 8– After CSV file is uploaded, you will see CSV data (editable) in Fiori app. You can change and save
Step 9: You will get a success message if the data uploaded has no errors.
Step 10: Few important things to troubleshoot
1- If data is numeric , convert it to text in CSV.
2- Ensure to map MRP controller in your settings and material master is having MRP controllers for which you have AOR mapped.
Do give feedback if you faced any issues in CSV upload.
Good explanation, however a blog exits
Oh , I saw this late. Too late for now. But I guess, blog has few new points
Useful feature by SAP
Thanks Avkash
Can you explain how accuracy is calculated?
I guess , if the PIR is not consumed, it would show accuracy accordingly
Not yet explored
Hello sir Narasimha Prasad Bhat
Really it's a very useful info, thank you. I also observed the accuracy% there.
Actually one of my client is asking for forecast efficiency report, so can I able to consider this accuracy % as a forecast efficiency%??
Your feedback will help a lot. Thanks once again.
Yes, my client is also looking for this. But accuracy calculation is not simple (Especially because they can spill over to next month due to MRP tab settings and you will get 100% accurate forecast where as for that month it may not have been)
Could you please advise, is there any other ways to get the forecast efficiency?
Check app Analyze PIR quality.
This is deprecated Poorvi, but its documentation is good to calculate the accuracy
Suresh Eswaran :Even I was exploring. But looks like, accuracy is working as expected. Check this link
According to F1 help, the 'Accuracy - Current Period' field is calculated according to the following information:
Definition
Provides information on the accuracy of your planned independent requirements (PIRs) as a percentage.
Use
You can use this information to determine how accurate your forecasts (PIRs) are. If the PIRs match actual demand, the accuracy is 100%. If the PIRs are less than actual demand, the accuracy is below 100%. On the other hand, if the PIRs are greater than actual demand, the accuracy is above 100%.
Note
The planned independent requirement quantity of the current period is only considered in proportion to the number of workdays that have passed in the current period. See example 3 below.
Depending on a material’s forecast period indicator, you can display the accuracy of the forecast for the current period, for the last week or the last month, for example.
A filter option is also available on the Accuracy - Current Period. For example, you can filter for materials for which the forecast was fairly accurate (between 90% and 110%), or you can filter for materials for which the accuracy of the forecast was poor (Less Than 50% or Greater Than 125%). This means you can quickly determine the materials for which you need to update the forecast.
Example
The formula used to calculate the accuracy for all periods other than the current period is: Accuracy = PIRs/Actual Demand * 100
Example 1
PIRs = 100 and Actual demand = 150
Accuracy = 100/150 * 100
Accuracy = 66%
Example 2
PIRs = 100 and Actual demand = 80
Accuracy = 100/80 * 100
Accuracy = 125%
The formula used to calculate the accuracy for the current period is: Accuracy = (PIRs * (Number of Workdays Passed in Period / Total Number of Workdays in Period)) / Actual Demand * 100
Example 3
PIRs = 100
Actual demand = 50
Half of the period has passed. For example, it is the 15th of the month.
Accuracy = (100 * (15/30)) / 50 * 100
Accuracy = 100%
Great. So this can be used as an accuracy report too
Very helpful
Thanks for this
Does it support excel ? Or .txt file ?
Only csv
I also have issues on period. I want to edit proposed period in PIR and I want to update forecast for some materials on Days. I am yet to explore the app, hope it will allow?
short and sweet, looking forward to blog on accuracy of PIR
Sure
Will this work if my input is in Weeks?
Deepa, from app documentation, it looks like , whatever period you maintain in material master, that would be enabled in this app
It doesn't work for Days
This App is not showing all materials. I have 10 Finished goods with exactly the same MRP data, but only 6 are showing in this app. Could you please help me?
Check material master period settings. I just learned
Narasimha, I am not getting weekly periods, any troubleshooting tips ?
Check material master -period.
In Material master-MRP3 view, change the period Indicator as weekly.
Yes, Suresh, but Day wise, the app is not supporting it.
Yes!!
Good content. Can you explain the logic behind proposed PIR in the maintain PIR app?