Skip to Content
Technical Articles
Author's profile photo Caetano Almeida

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.

First of all, we need to access the app Maintain PIRs in the Fiori Launchpad. We will have access to this app if we have business roles SAP_BR_MATL_PLNR_EXT_PROC or SAP_BR_PRODN_PLNR assigned to our user.

Figure 1: Maintain PIRs Fiori App in the Fiori Launchpad


When opening this app, system will immediately show the list of products assigned to the user Area of Responsibility. If there is no Area of Responsibility defined for the user, system will prompt the user to choose a combination of Plant and MRP Controller.

Here, we will already be able to see the button to Upload and Edit the PIRs, but before we can upload the PIRs, we need to generate the file that will be used as a template. In order to generate the file, we should select the materials for which we want to create or change the PIRs and then click the button Edit.

Figure 2: Maintain PIRs Fiori App showing a list of materials


We will then jump into a different screen, where we will see all the materials selected, and the period buckets showing the existing PIR quantities for those products and open for input if we want to make any change. Note that we only jump into this screen when we click the Edit and we will see a different screen if we just click one of the lines to see the details.

Figure 3: Template file download


On the top right corner, we can see a button with a spreadsheet icon called Download to Spreadsheet, which we can use to download this list of materials, including the PIR quantities, into a Comma Separated Value (CSV) file. This CSV file can be opened in Microsoft Excel, or even in notepad, and it should like shown in the screenshot below.

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.


FIgure 5: File Upload


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.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Aniket Nigade
      Aniket Nigade

      Hello Caetano,

      Thank you for this blog.

      Can we add new material in downloaded CSV file and upload the file?


      Best regards,

      Aniket Nigade

      Author's profile photo Caetano Almeida
      Caetano Almeida
      Blog Post Author

      Hello Aniket

      Yes, you can add materials to the spreadsheet.


      Author's profile photo MAHENDRAN PARAMASIVAN


      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?


      Mahendran P


      Author's profile photo Caetano Almeida
      Caetano Almeida
      Blog Post Author

      Hello Mahendran

      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.


      Author's profile photo Dimas Luis de Faria
      Dimas Luis de Faria

      Hello Caetano,


      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.


      Dimas Faria


      Author's profile photo Caetano Almeida
      Caetano Almeida
      Blog Post Author

      Hello Dimas

      The list of products only appears if you have PIRs.


      Author's profile photo liu bin
      liu bin

      Thanks for your information! Just would like to check with you if there is features to enable the planning on day instead of month.

      Best Regards,


      Author's profile photo Suresh Eswaran
      Suresh Eswaran

      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?

      thank you..

      Author's profile photo Jan Buchmann
      Jan Buchmann

      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?


      Author's profile photo Caetano Almeida
      Caetano Almeida
      Blog Post Author

      Hello Jan

      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.'F3445')/S25OP