SAP Knowledge Base Article - Public

3563161 - Customer Consignment Report is giving incorrect data

Symptom

Customer Consignment Report is giving incorrect data when adding fields from the Add fields

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Goto Business Analytics Workcenter
  2. Design Reports
  3. Customer Consignment Report
  4. Filter on Outbound Delivery ID
  5. Add fields >try to add from reference Master data field, Eg: Outbound Delivery ID dimension >Serial ID

In case of multiple line item it results in repetitive data in the serial ID field

Cause

The display feature which will work fine in scenarios where there is single line item but in case of multiple line item it results in repetitive data as the report design is such that on the mapping.

Resolution

Currently, this is standard system behavior specially incase where the report design is complex and involves combining multiple data sources each containing multiple line of data.

However, you can try creating a custom data source joining the data source which has the serial ID so that it will be directly part of the report metadata and we need to add field via Add Fields and report created on top of this data source will list the serial ID correctly against Product and Outbound Delivery ID. 

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign 2411