SAP S/4HANA Cloud

How to mass update Material Classification in SAP S/4HANA Cloud

Introduction

In SAP S/4HANA Cloud Master Data, there are 2 useful apps ‘Export Master Data’ and ‘Mass Maintenance for Master Data’ that can be used for the Product Master and Business Partner areas to allow a customer to export master data to Excel for filtering/reporting purposes and also for mass update of data to reduce manual effort

A little-known gem of these apps is that it also allows the Export / Mass update of Classification as well!

For Classification, the initial creation is uploaded using the Migration Object ‘Object classification’ in the app “Migrate your data” but afterward if you wish to mass update the classification assigned to an object such as Material (class type 001) there is no Classification app like transaction CLMM for SAP S/4HANA Cloud.

The API and Interface API_PRODUCT_SRV and PRODUCTMDMBULKREPLICATEREQUEST respectively support the update of ( POST / PATCH / PUT ) for Product Master Data fields but does not include Classification

There is an API for Classification which is API_CLFN_PRODUCT_SRV but it only allows READ operation and not update (POST / PATCH / PUT ) as of SAP S/4HANA Cloud Essentials Edition 2102

The use of these 2 apps ‘Export Master Data’ and ‘Mass Maintenance for Master Data’ allow update of classification as a workaround till dedicated classification apps / APIs are available in future releases

What Apps and Roles are needed to follow this blog post to mass update material classification?

The following example was tested in an SAP S/4HANA Cloud 2102 Essentials System.

The User involved has 2 roles SAP_BR_PRODMASTER_SPECIALIST and
SAP _BR_PRODUCT_CONFIG_MODELER assigned.

With the role SAP _BR_PRODUCT_CONFIG_MODELER you are able to access the ‘Manage Characteristic’ and ‘Manage Class’ apps to create the characteristics involved and to add them to a new class of type 001 ( Material Class )

With the role SAP_BR_PRODMASTER_SPECIALIST you are able to follow the process of creating the products involved and then use the apps ‘Export Master Data’ and ‘Mass Maintenance for Master Data’ to download, change and reupload to mass change the classification

Creating the Test Data

The example consists of 2 products, 4 characteristics of different formats, and 1 class of type 001 – Material Class

Step 1: Creating the characteristics

  1. Open the app ‘Manage Characteristics’
  2. Input characteristic name, for example, COLOUR and Create button
  3. Input description and in the dropdown for Data Type, select ‘Character format’
  4. Under Value assignment – select “Single-value”
  5. Press Enter
  6. For the field ‘Number of chars’, input a value for a number of chars, for example, 8
  7. Navigate to the values tab
  8. Input a char value’s and description

Repeats steps 1 to 8 and create different characteristics of type ‘Numeric Format’,’ Time Format’ and ‘Date Format’

All characteristics have the Value assignment – select “Single-value”

Characteristic values maintained for Colour
Characteristic values maintained for Length
Characteristic values maintained for Date
Characteristic values maintained for Time

Step 2: Creating the Class

  1. Open the app ‘Manage Classes’
  2. Input class name
  3. Input class-type 001
  4. Press create button
  5. Input class description
  6. Navigate to char. Tab
  7. Input chars created from Step 1
  8. Press save
Class with Characteristics assigned

Step 3 Creating the product (s )

  1. Open the app ‘Manage Product Master Data’
  2. Click on the create button
  3. In the Create Master Data Record popup, input a product number (for example PRODUCT_1), Material Type (FERT Finished Product ), Base Unit ( EA ), and a product description
  4. Press ok
  5. Navigate to the Classification tab
  6. Click on the button “Click here to assign a class”
  7. In the popup that appears, input the class created previously in Step 2 (of type 001)
Assign the class to the Product

8. In the dropdown for each characteristic, select a value

Classify the Material

9. SAVE when finished evaluating all characteristics

Repeat steps 1 – 9 for how many materials you wish to test with

Process for mass updating the material classification

Exporting the material and its classification to excel using the app ‘Export Master Data’

  1. Open the app ‘Export Master Data – Products’
  2. For the field “Select specific Fields” – press the F4 / popup window
  3. Press the button ‘show filters’
  4. Search for field MARA-MATNR_EXTERNAL
  5. Press the select button
  6. In the ‘Table Name’ field, input AUSP
  7. Clear the field ‘Field Name’ (was MATNR )
  8. Press the ‘Go’ button
  9. Select all entries returned
Select all fields for AUSP

10. Press the ‘Ok’ button

11. Under “Select Products”, input the materials you created previously in Step 3

Selection criteria filled for products

12. Under ‘File Format’ – select ‘Office Open XML (*xlsx )
13. Press the Export button
14. Press ‘Export’ on the popup

Popup before exporting to Excel

Changing / Understanding the Exported File

Open the Excel file created in the previous step. The Excel file has 2 tabs‘MARA – Basic Data’ and ‘MARA_AUSP – Characteristics’

The Tab ‘MARA – Basic Data’ contains the materials and ‘MARA_AUSP – Characteristics’ contains the characteristic values

The characteristic values for an object are maintained in the columns ATFLV, ATWRT, DEC_VALUE_FROM, DEC_VALUE_TO, DATE_FROM, DATE_TO, TIME_FROM, and TIME_TO

Update the excel sheet with new values ( in accordance with what is already defined for each characteristic in the Manage Characteristic app )

Uploading the changed Excel sheet and mass updating the Product Classification

  1. Open App ‘Start Mass Maintenance – Products’
  2. Press the Browse button
  3. Navigate and select the Excel sheet that was updated with the new classification values
  4. Press Open
  5. Maintain a Description and press save
  6. a message ‘ A new process is being created is shown
  7. A screen will appear with the number of records (Products) to be changed and the field MARA_AUSP-ATWRT shown under “Fields in Scope”
Mass Maintenance App initial stage

8. Press the ‘Start’ button
9. A message ‘ Process started’ is shown

It is now in the stage ‘Stopped for Review (Edit)’.

Here you can see under the bar graph what is planned to be changed ( in orange ) and what is left unchanged ( in blue )

Stopped for Review

If you wish to review in more detail the values that are planned to be updated, please use the button ‘Edit Records’ and navigate to tab Characteristics. Here you can manually update a value if it was not set in the excel sheet that was uploaded. Press the back button takes to the ‘Stopped for Review (Edit)’ page.

Manual update fo characteristic value

10. if you are happy with the intended changes, please continue the message ‘Process continues’

11. The progress will finish in status ‘Completed’ and the Bar chart will appear in Green

Completion of classification update

If you check now in the Manage Product Master Data app, the products should now be updated with the new classification!

Leave a Reply

Your email address will not be published.