You created an extension field of type Multivalued List and added it to a basic data source, which is used in a combined or joined data source. Now you created a report on top of it but when you run it and want to show the field description it is not displayed in the report view. Instead you will see the code list or ID.
SAP Cloud for Customer
SAP Business ByDesign
Reproducing the Issue
Go to work center Business Analytics, view Design Reports.
- Show all and open report ABC (ABC stand for your custom report) based on data source CDE (CDE stands for a custom combined or joined data source).
- Run the report and add your multivalued list extension field to the report view.
- You will notice that it is displaying the ID but you are expecting to see the description.
This is the expected system behaviour. Extension fields of type multivalued list do not work on combined and joined data sources. It only works on the data sources in which the extension field was directly added.
If you create the report on top of the basic data source it will successfully display the description or ID.
multi code, multi code values, extension field, code values, combined data sources, joined data sources, code list, report shows ID , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To