1721985 - Error Message: Product Category ID Missing, While Uploading Material Through MS Excel

SAP Knowledge Base Article - Public

1721985 - Error Message: Product Category ID Missing, While Uploading Material Through MS Excel

Symptom

When upload some Materials in the system using MS Excel, excel throws below error message:

Product Category ID missing

Reproducing the Issue

  1. Go to Product Data work center.
  2. Select Materials view.
  3. Select New button and choose New Material from Microsoft Excel.
  4. Logon to the Excel (Business ByDesign Excel add-in)
  5. Update the Material details in the excel.
  6. Select Save data to.

Cause

The cause for the issue is that the Production Group is not entered for the Logistics.

If you are activating the Logistics for the Material then the Status, Site and Production Group are mandatory fields.

Resolution

The system works as designed.

You have to maintain the Production Group for the Site in Logistics section.

If you have not yet created the Production Group, follow the below steps:

1. Go to Supply Chain Design master Data work center.
2. Go to Production Groups view.
3. You can create the Production Group Hierarchy here.

After creation, you can enter the Production Group ID into the excel in the Logistics section.

Keywords

KBA , SRD-FIN-ACR , Receivables , How To

Product

SAP Business ByDesign all versions