2499610 - How to get description for UUID fields in BW system from C4C/ByD

SAP Knowledge Base Article - Public

2499610 - How to get description for UUID fields in BW system from C4C/ByD

Symptom

The text fields like 'Opportunity, Activity' shows only UUID's in BW system when exposed from Cloud system but the description cannot be found in BW system.

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 Header and Item)

4. The Opportuntiy field shows description of Opportunity ID in Cloud for Customer

However,  when these fields are passed to BW we can only see field UUID's but not there corresponding description or text.

Cause

We get the description of these UUID fields from the corresponding Master Data source with which it is referenced and show it in the UI.

If you enable text and ID from Settings> characteristics in report for these fields you can see UUID's along with its description. However, when you expose it to BW system since the reference Master Data will not be exposed it will show only the UUID's which is expected behavior.

Resolution

In such cases for example, Opportuntiy Header and Item stores 'Opportunity UUIDs' in Opportuntiy field, which act as foreign keys. Using these keys, you need to find out the corresponding IDs & Descriptions from the Master Data data source(Opportunity Header in this case) and show them in their reports in BW.

Since the master data source is responsible for fetching the descriptions for these UUID's you need to expose the referenced Master Data in this case'Opportuntiy Header' and for this you can see the text for UUID field with field name Doc_name for Opportunity. Later, you need to map internally these texts and UUID's in your transactional data source in your BW system.

Note: You can find the reference Master data source from the data source documentation under Design Datasources.

Ref_DS.PNG

Keywords

KBA , LOD-CRM , Cloud for Customer , How To

Product

SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711