SAP Knowledge Base Article - Public

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


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.


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.


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.


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


SAP Business ByDesign all versions