SAP Knowledge Base Article - Public

2437389 - Description missing for code list fields in BW

Symptom

The description for code list fields is missing when the data source is exposed to BW via ODP Scenario.

Environment

  • SAP Cloud for Customer
  • SAP Business byDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Select the view Design Data sources.
  3. Choose any data source which is exposed (E.g.: Opportunity Item).
  4. Check the code list fields like 'Life Cycle Status, Document type' etc.
  5. When these fields are passed to BW we can only see field IDs but not their corresponding description.

Cause

Code list descriptions are not exported via the ODP scenario. This is a generic activity and not related to the ODP scenarios.

When data is extracted from C4C systems via ODP, only codes will be passed to BW since the corresponding descriptions are not stored in the actual transactional/master data.

Resolution

You need to create these codelists in BW manually and fill descriptions for the codes which are extracted via ODP. You can use A2X service to get the codelist values of the fields available in code list mapping for the mentioned Business Object QueryCodeListIn.

Keywords

BYD, C4C, codelist description, ID , KBA , codelist , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions