SAP Knowledge Base Article - Public

2437389 - Description missing for code list fields in BW


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

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 there corresponding description.


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.


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.


KBA , SRD-CC , Cross Components , How To


SAP Hybris Cloud for Customer 1608 ; SAP Hybris Cloud for Customer 1611 ; SAP Hybris Cloud for Customer 1702 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1711