This blog post explains about the mass create/update for the warehouse product master. There are many tools/options such as using the transaction code ‘/SCWM/MIG_PRODUCT’ (Migrate Warehouse Spec. Product) or implementing a BTE in ERP.

This blog post is based on SAP S/4 2023 which lets the user to create/update the warehouse product master using Fiori UI.

This app is part of the master data governance. If there are any issues faced during the upload, we need to check with the MDG team to ger them addressed.

Component:

• SCM-EWM-MD-PM (SAP Extended Warehouse Management Master Data Product Master)
• SCM-EWM-MD (SAP Extended Warehouse Management Master Data)
• LO-MD-MM

Business Role –

• SAP_BR_PRODMASTER_SPECIALIST (Master Data Specialist – Product Data)/
• SAP_MD_MDC_ADMIN_APP_06 – MDG, Consolidation and Mass Processing: Administrator

Note: The Fiori app role assignment and the Fiori app set up are not explained here.

The mass process has the following steps:

• Start Mass Processing

• Scope

• Selection

• Edit

• Validation

• Activation

Additionally, you can add the following steps:

• Update

• Filter and Remove

Steps:

• Build the upload file by referring the below link or use the ‘Export Master Data‘ app.

File Format for File Upload

Sample File:

• Note:
  • The fields used file can be based on the requirement.
  • Maintain a column with the fieldname ‘_ACTION_CODE’ to identify ‘Insert’ or ‘Delete’ action with the indicator ‘I’ or ‘D’ respectively.
• Select the Fiori Apps Group ‘Mass Maintenance for Product Master’

• Click on ‘Manage Mass Maintenance’.

• •  When clicked on the above tile, the below screen will be displayed.

Note: The values can be changed/updated in mass during the step ‘Edit’. The below information is based on the existing data update.

• Follow the same steps mentioned above and click on ‘Edit Records’.
  
• The below page/screen will be displayed.

• Click on ‘Warehouse’ tab to display the below information. The system shows the field/s to be changed with the existing values with the new values.

Create:

Update:

Useful Links:

1. Mass Processing of Master Data
2. Manage Product Master
3. Fiori App Library – Mass Maintenance for Master Data
4. Working with MDG, Consolidation and Mass Processing
5. File Format for File Upload

Conclusion:

With this new functionality provided by SAP can be used to create/update/delete the warehouse products using the Fiori app.

It has many interesting functionalities which makes this more user friendly and simple for the data migration activities.

Do you have any further comments related to this topic? Do share them in the comments sections below without any hesitation. You can also ask questions in the SAP EWM Master Data Community Q & A Section.

Finally, thanks to my vendor who provides the latest system whenever SAP releases.

Note – All the images are created by me and free to use/share.