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