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:
Brought to you by the SAP S/4HANA RIG and Customer Care team.