![](https://community.sap.com/html/assets/img_tile-default.png)
My blog SAP S/4HANA Procurement – Service Procurement – “Item Hierarchies” provided an overview of the service procurement capabilities SAP made available with SAP S/4HANA 2022.
Since then, SAP released a new version of SAP S/4HANA Cloud Public Edition 2402 and SAP S/4HANA Cloud Private Edition 2023. In this blog we will take a closer look at the option to import Model Product Specifications into an SAP S/4HANA system.
Note:
We will take a look at the new capability of importing Model Product Specifications via an “MS Excel” template into the SAP S/4HANA system The process is based on the SAP Fiori app ‘Manage Model Product Specification’ (ID F5079).
The Manage Model Product Specification (ID F5079) allows you to import new Model Product Specifications into your system. The process of creating larger structures in the system might be easier done in an offline “MS Excel” document than to create and update these Model Product Specifications in the system itself.
You have the option to download the template from the system and import the file into the system. Navigate from your Launchpad to the app Manage Model Product Specification (ID F5079). The app should open.
SAP Fiori app Manage Model Product Specification (ID F5079) - Overview.
You should find the option “Import” on the right-hand side underneath the Search View. The word should be active, which is shown on the screen shot and the word “Import” being in a darker color. Other activities like “Copy” are shown in faded color and are currently inactive.
Note:
Depending on your authorization and the setup of the system the button may be inactive or not visible at all.
SAP Fiori app Manage Model Product Specification (ID F5079) - Import.
Selecting the button shows a drop-down menu. The options are Download, Upload and Application Jobs. We will select the “Download” option and check the menu options.
SAP Fiori app Manage Model Product Specification (ID F5079) – Import | Download.
We can now see further menu options for Download. We could download “Selected Objects”, “All Objects” or can download a “Template”.
SAP Fiori app Manage Model Product Specification (ID F5079) – Import | Menu options.
We are interested in the “Template” and will select this option. The system will start with the download of the Template to your computer.
SAP Fiori app Manage Model Product Specification (ID F5079) – Import | Template.
You should be able to find the downloaded MS Excel file called “MPS_DOWNLOAD” in your download folder.
Downloads Icon on your Browser – Google Chrome - Example.
With this we have finished the first step.
In the second step we will take a closer look at the MS Excel file and enter the required information into the file to create our Model Product Specification. This example will be kept simple ensuring you understand the key steps you will need to follow to successfully import the data.
You will need to open the MS Excel file from the location it was stored. This might be your “Download” folder or any other place you specified.
After the file opened you should see a banner at the top informing you that you will need to enable editing.
Note:
You should only enable editing in case you are aware of the origin of the file!
Screen Shot of the MS Excel file and the request to Enable Editing.
Select the “Enable Editing” button to ensure you can enter information and save it.
Screen Shot the Enable Editing button in the MS Excel file.
You might click on the first tab of the MS Excel file, after you enabled the editing. In this case you will notice the message that this sheet is protected.
Screen Shot of Message when clicking on the MS Excel file.
You can unprotect this sheet. First you will need to accept the message, shown above, and click on the “OK” button. Then navigate to the ribbon “Review” at the top of the Excel menu.
Screen Shot of Menu “Review” in MS Excel.
You will see a message with some information about the functionality in MS Excel when you move your mouse on the icon “Unprotect Sheet”. Click on the icon and the protection of the sheet will be removed.
Screen Shot from “Unprotect Sheet” button in MS Excel.
The name of the icon will change to “Protect Sheet”.
Screen Shot from “Protect Sheet” button in MS Excel.
The sheet is now unprotected and you can access the details on the sheet.
We are now going to start preparing the Excel file with the required information for the import of this example Model Product Specification. We will keep things simple, in this first example, and only create 1 new Model Product Specification. We need to enter the following information into the mandatory fields:
Header fields:
Screen Shot MS Excel Header with example data.
The following screen shot shows the example data that I have entered. There are two key field which will need specific data entries to ensure the import works.
Screen Shot MS Excel Header with mandatory example data.
The first field is “Action Code”.
In this example we downloaded the Excel file from the system and directly opened it. In this case the file will only allow you to select the action code “1”. Your selection will then be shown as “Create” in the Excel file.
Screen Shot MS Excel Header Action Code drop down list.
The second field is the “Grouping Code”.
On the tab “LEGEND” you will find the following information for entering details into the field for “Grouping Code”: “… Grouping Code * | Internal or External. This assigns an ID within the number range of the selected grouping code to your MPS. …”.
You will need to enter either “INT” or “EXT” for the import to work. It is recommended to use the internal numbering and I’ll therefore enter the value “INT”. There is no drop-down selection or other information that this is the value to be used.
Screen Shot MS Excel Header Grouping Code field with value.
We have entered all the required information for our example on the header level.
We prepared the heard information for our example Model product Specification. In this next step we are going to prepare the item hierarchy, we want to import into the system.
You will find a description on the sheet “Legend” giving you some idea about the details you need to enter.
Item fields:
The following screen shot gives an impression of the example used for this blog.
Screen Shot MS Excel Line Items – Overview of example.
The previous screen shot is hard to read. We are looking at the first section of the Excel sheet. You can see that the Model Product Specification ID is maintained in front of all line items. Each line item has a unique ID starting with one and ending with 10. The parent ID defines how the individual line items should be linked within the hierarchy. The item 2 will be linked to item 1. The items 3 and 4 will be linked to item 2.
The action code for all items is “Create” which was selected from the drop-down list.
The items all belong to the same plant. In this example it is plant 1710.
NOTE:
The system will show you an error in case you try to use plants, which belong to different company codes. All items need to belong to the same company code.
NOTE:
You must have at least one item assigned to an item set. An item set can’t stay on its own. The system would show you an error in case you have prepared it incorrectly. This would need to be corrected and the import repeated.
Screen Shot MS Excel Line Items – Overview first part.
The second screen shot shows the items sets for this model product specification and the materials and services which have been assigned. I choose to add an item description in front of all items. I then entered the material and service master number.
NOTE:
There is no F4-Help in this file for maintain these material and service numbers. In this example they are short and easy to check. This might be more challenging with master data having 40 digits.
Its key to enter the correct unit of measure and the quantity of the items.
Screen Shot MS Excel Line Items – Overview second part.
We have prepared the file with all the header information and the item information for this example. I’m saving the file to my PC.
NOTE:
The file in this example uses the name given to it from the system “MPS_DOWNLOAD.xlsx”. You can change the name of the, which is recommended in case you create multiple files.
In the previous steps we downloaded the Excel template and entered the information for the model product specification.
In this step we will walk through the import process.
You will need to access the system and navigate to the from your Launchpad to the app Manage Model Product Specification (ID F5079). Navigate to the menu item “Import” and open the drop-down list. Click on the entry “Upload”.
SAP Fiori app Manage Model Product Specification (ID F5079) - Upload.
Once you click on the menu entry the system will show you a pop-up window. Choose the button “Browse…” to search for the file on your computer.
SAP Fiori app Manage Model Product Specification (ID F5079) – Choose Spreadsheet.
In this example the file is stored in the folder “Downloads”. Select the file, in this example it is named “MPS_DOWNLOAD.xlsx”.
Select the MS Excel file you want to upload.
The file should be shown at the bottom of this window. Then select the button “Open”. The window will close, and you will be back in the SAP S/4HANA system.
Open the MS Excel file you want to upload.
You should see the file name in the pop-up window in the SAP S/4HANA system. Click on the “Upload” button in the bottom right-hand corner for the window.
SAP Fiori app Manage Model Product Specification (ID F5079) – Upload Spreadsheet.
The system will now ask you to enter a job description. You can choose to go with the default suggestion. The naming of the files might help in case you are planning to import several files after another. Click on the “Upload” button to start the job and the import process.
SAP Fiori app Manage Model Product Specification (ID F5079) – Enter Job Description for upload.
The system will show you the message that the import job has been scheduled. In this example, we will click on the “View Job” button to check if the file is imported successfully or if there are any errors, which we would need to correct.
SAP Fiori app Manage Model Product Specification (ID F5079) – Job scheduled.
You will see the following screen, after you choose the button “View Job”. The app displayed is called “Monitor Jobs for Model Product Specifications” with the ID F7440. The following screen shot shows that the “date From To” field shows a specific date. I changed this entry form the standard selection of +1/-1 days for this demo.
SAP Fiori app Model Monitor Jobs for Model Product Spec. (ID F7440) – Check Job.
You will need to click on the button “Go” for the system to show you the results.
SAP Fiori app Model Monitor Jobs for Model Product Spec. (ID F7440) – Successful import.
The system will show one entry for the import we started a few steps ago. You can now click on the green log icon on the left hand-side or click on the arrow icon on the right-hand side.
SAP Fiori app Model Monitor Jobs for Model Product Spec. (ID F7440) – Details of import.
It seems we entered the information correctly and the model product specification was imported and created in the system.
NOTE:
The system will not create the model specification if there is an error. In this case you will need to check the details and update the information in the Excel file.
We are now returning the app Manage Model Product Specification. Use the “back” button on the left hand-side of the SAP logo in the left top corner.
I’m using the term “Demo” in the search field and click on the “Go” button. The system returns one entry. It is the model product specification we just imported. You will need to click on the arrow on the right-hand side of the item to access the details.
SAP Fiori app Model Product Specification (ID F5079) – Imported Model Product Specification.
We can now see the header information which we entered and the data which was added automatically by the system.
SAP Fiori app Model Product Specification (ID F5079) – Overview Model Product Specification.
Scrolling down on the page we can see the line items. You can see that the system created the item sets we defined in the Excel.
SAP Fiori app Model Product Specification (ID F5079) – Imported item structure.
The following screen shot shows you the complete hierarchy we defined with all the line items, service and material master items.
SAP Fiori app Model Product Specification (ID F5079) – Imported items and structure.
The follow up steps like adjusting the model or activating it and moving data into follow up documents has been described in another blog.
In this blog we walked through the steps importing a model product specification, using an MS Excel file, into the system. We started with an empty file and entered the required header data and the item structure. The file was then imported into the system. We then checked that the data was imported in the way we prepared it in the file.
The purpose of the blog is giving a first impression and helping you with the initial steps. I only included one model product specification in the Excel file. You can enter multiple model specifications into the file at the same time. The steps are the same. Managing the data and structure in the file might get a little bit more complex, in case of issues. I suggest you first test the process and then start modelling more complex hierarchies.
I hope the blog will be of help.
SAP Learning
Creating MPS with Item Hierarchies by Mass Upload
SAP Roadmap
Service Purchasing and Recording (S/4 CLD)
SAP Help
Manage Model Product Specifications (SAP S/4HANA Cloud Public Edition)
Manage Model Product Specifications (SAP S/4HANA Cloud Private Edition)
Please note that you may need dedicated SAP users accessing the above-mentioned material.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |