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

When running the Sales Order Volume report, the Product ID XXX is displayed as XXX.1/XXX.2/XXX.3 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).

SAP Business Bydesign

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. For some of the sales orders, the product ID is XXX.1 and for few orders, it is XXX.2 (XXX is the ID of Product).

The reason why the Product ID is XXX.1/XXX.2/XXX.3 is because there is a Material, a Service or a Individual Material with the same ID XXX. In the report, ID for Material will be displayed as XXX.1 while ID for Service will be displayed as XXX.2 and ID for Individual Material will be displayed as XXX.3. 

Because there is a Material, a Service or a Individual Material sharing the same ID, in order to identify whether the product used in the sales order is a Material, a Service or a Individual Material, the product ID is displayed in this manner. This behavior is same for all the reports and data sources related to sales/purchase documents.

Sales Order Volume report; Customer invoice volume report; Sales order item; customer invoice item; data source; Product ID wrong; Incorrect Product ID; Product ID; Wrong; Sales Order Item; Incorrect Product ID; Monitoring Purchase Order , KBA , AP-SLO-SO , Sales Order , Problem