C4C / BW Integration: External vs. Internal Values / Codes

[dykstrac]

Dear SAP Community,

based on following awesome blog we set up a C4C / SAP BW Integration:

https://blogs.sap.com/2018/12/17/sap-cloud-for-customer-integration-to-central-analytics-sap-bwbi-vi...

When extracting data from C4C data sources, the C4C internal values / codes are extracted. For instance:

1. Opportunity Sales Phase: Z1
2. Opportunity Category: Z_CAT_1

These are values nobody can work with in SAP BW / Reporting. Is it possible to extract the real values behind these codes at best for one or for different languages?

If that is not possible what could be a practical approach to map the values in BW reports?

Kind Regards

Christian

[manideepsatya · Accepted solution]

Hello dykstrac,

You need to maintain the values/descriptions for codelist fields manually in BW. Few codelist fields which are exposed to Code list mapping in C4C - you can use QueryCodeListIn A2X service to fetch the descriptions of codelist fields and then maintain them in BW

Regards,
Satya

[howsy]

Hello manideepsatya,

is there somewhere a kind of documentation od the "QueryCodeListIn", or an "how to", how to get the information out of the codelist? I am facing exactly that issue currently.

Thanks in advance,
Chris