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

Steps to reproduce:

1. Goto Business Analytics Work Center

2. Design Data sources

3. Any data source which is exposed (Eg: Opportunity Item)

4. The code list fields like 'Life Cycle Status, Document type' etc.

When these fields are passed to BW we can only see field ID's but not their corresponding description.

Cause

This is designed behavior. Code list descriptions are not exported via 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