cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Material Master Data Mass Maintenance - Delete value from EAN code/EAN category field

Emi1
Explorer
0 Likes
909

Hi experts,

Please kindly advise if it is possible to mass delete value from "EAN/UPC" field and "EAN category" field in material master data in S4HANA Public Cloud system. 

Attached 01_Display Products Screen.png

Currently, we need to change the EAN code for around 10k records from having value to blank. We have tried with "Start Mass Maitenance - Products" but it is not going well.

Our firts attempt was clearing the value in "EAN/UPC" and "EAN category" and remove check from "Main EAN"  as in attached screenshot, the process ended with no error but the data did not change.

Attached 02_Mass Maintenance - Products.png

Our second attempt was to add Action Code D to delete the record from table MEAN but it got error as in below screenshots. Attached 03_Delete Row.pngAttached 04_Delete Row_Err.png

Thank you in advance!

Regards,

Emi

 

 

 

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Chris1973
Active Contributor
0 Likes

Hello @Emi1 

Thank you for sharing the details and screenshots regarding your attempt to mass delete EAN/UPC and EAN Category values from the product master in S/4HANA Public Cloud. Apologies for the very late response. Hope these details will still provide some good insights.

After reviewing the scenario, here is the clarification and recommended approach:

Here is why the Error in your scenario occurs

  • The EAN/UPC information is stored in table MEAN as a child entity of the product master.
  • The Mass Maintenance Products app does not support the deletion of GTIN records.
  • As a result, simply clearing the field values during mass maintenance has no effect because the system ignores blank overwrites for these dependent entities. Using an action code D results in the error: Deletion not allowed for GTIN (MEAN) or one of its children.
  • This is standard system behaviour in the Public Cloud environment to protect data integrity.

Supported Options in Public Cloud

  1. Individual Deletion via Product Master Apps
    • It is possible to manually delete EANs in the Change Product Master Data app under Basic Data.
    • However, this is not practical for your volume
  2. Data Migration Cockpit
    • Use the Migration Object: Product to reload products with blank GTIN data.
    • When executed in update/overwrite mode, this can clear existing EAN values.
    • This is suitable if you prefer a migration-style one-time cleanup.
  3. Product Master OData API
    • The API allows direct DELETE calls on the GTIN entity for a given product and unit of measure.
    • This is SAP’s recommended method for handling bulk deletions programmatically in Public Cloud.
    • You could script the calls or use CPI/iFlow to automate deletion for all 10k records.

However, these are not possible

  • Mass Maintenance Products cannot be used for GTIN deletions rather only for updates.
  • Direct table deletes are not permitted in Public Cloud due to clean-core restrictions.

The following are the recommended steps

Given the number of records (10k), the most efficient approaches would be either:

  • Use Data Migration Cockpit in overwrite mode, or
  • Leverage the Product Master API to programmatically delete GTINs.

See the references below for further details

Product Master API (A2X)

Mass Changes Products App Documentation

I hope this provides the desired result. Happy to answer any further questions.

Best regards

Chris