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 .
You have the option to filter by Materials/Active version/Last modified date etc. Compare it with MD63 if you plan to change PIR for a material. Observe "Reach" is based on the number of periods for which data exists. If no data is maintained, the reach attribute will show zero.
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.