SAP Knowledge Base Article - Public

2861116 - The Product ID is displayed in the reports and data sources of sales documents is not the expected one.

Symptom

You run the Sales Order Volume report, the Product ID  XXX  is displayed as XXX.2 for some sales orders. However, in the respective Sales Order the Product ID is correctly displayed as XXX((XXX is the ID of the Product)

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Go to Sales Orders work center.
  2. Go to Reports View.
  3. Open report Sales Order Volume and click Apply to run the report.
  4. From the View list, add the Row Field - Product and Sales Order.
  5. You can see for some of the sales orders, the product ID is XXX.1 and for few orders you can see it is XXX.2(XXX is the ID of Product).

Cause

The reason why the Product ID is XXX.1 or XXX.2 is because you have a Material and a Service with same ID XXX, whenever you use the material in the sales order, the product ID in the report will be displayed as XXX.1 and when you use service, it will displayed as XXX.2.

Resolution

There is material and service with the same ID , in order to identify whether the product used in the sales order is a material or a service, the product ID is displayed in this manner. This behavior is same for all the reports and datasources related to sales documents.

Keywords

Sales Order Volume report; Customer invoice volume report; Sales order item; customer invoice item; data source; Product ID wrong; Incorrect Product ID; , KBA , product id wrong , sales order volume report , sales order item , incorrect product id , AP-SLO-SO , Sales Order , Problem

Product

SAP Business ByDesign all versions