Creating Independent Requirements from a spreadsheet
SAP S/4HANA introduced a new Fiori App called Maintain PIRs (App ID F3445) that can be used for the mass maintenance of Planned Independent Requirements in the Fiori Launchpad. This app allows the user to mass create or change planned independent requirements for one or more products within his Area of Responsibility. This app also introduces a new feature that is much welcome that is the upload of planned independent requirements from a spreadsheet and this blog will explain how this feature works.
Figure 1: Maintain PIRs Fiori App in the Fiori Launchpad
Figure 2: Maintain PIRs Fiori App showing a list of materials
Figure 3: Template file download
Figure 4: Template file
Now that we have the file to be used as a model, we can make the desired changes in the PIR quantities. After that, we can use the button Upload and Edit, that is shown in Figure 2, in order to upload the file with the new PIR changes. A popup screen will be shown, where we can choose the file to be uploaded.
Once the upload is completed we will see the uploaded Planned Independent Requirements and make any changes in the quantities before saving, as shown in the Figure below.
Figure 6: Edit PIRs after the upload
If we need to import PIRs generated from any other system, we can generate a file with the same format and easily upload it using this app, without any kind of custom development or enhancement implementation.
For companies using SAP Intelligent Robotic Process Automation, this whole process can be automated with a BOT, so the planner will only need to provide the Excel file and the BOT will automatically upload it into SAP S/4HANA.
Details about this iRPA BOT can be found in the links below:
SAP Best Practices for iRPA – Maintain Planned Independent Requirements (4FL)
SAP Intelligent RPA – Maintain Planned Independent Requirements (4FL)
SAP Help – Maintain Planned Independent Requirements (4FL)
Brought to you by the SAP S/4HANA RIG and Customer Care team.
Thank you for this blog.
Can we add new material in downloaded CSV file and upload the file?
Yes, you can add materials to the spreadsheet.
Nice thing you have shared. Thanks. Actually "Maintain PIRs" is not available in Fiori.
I think this is available in newly updated version. Could you please share more on this information?
Which version and release this app will work?
In the blog there is a link to the Fiori Library, where you can find all the information about this app, including the roles you should add to get access and the releases.
When you enter the app, does the list of products already have to appear or do we have to create the independent needs first?
On my Fiori, the product list does not appear. Only, if I put an independent need. And it only appears for this product.
The list of products only appears if you have PIRs.
Thanks for your information! Just would like to check with you if there is features to enable the planning on day instead of month.
Hello Caetano Almeida
Thanks for sharing this useful information. Could you please explain about the Accuracy % showing there.
Because my client is asking for forecast efficiency report and I'm thinking will this accuracy% can serve my purpose or not?
Hi Caetano Almeida
Thank you very much for this interesting blog.
Could you please confirm what the limitations are for mass maintenance? Previous documentation mentions a maximum file size of 1 MB and/or maximum number of rows. But this seems to have changed in 2022 to a mere recommendation of 'no more than 10.000 materials'. Is this correct?
Corrections were recently implemented in this app to improve the app performance and to allow a larger number of materials to be processed (see SAP notes 3281392 and 3281294).
The official recommendation in the Fiori Library is to do not edit PIRs for more than 10.000 materials at the same time.