Symptom
You are extracting data from a data source via OData. Fields such as "Product", "Account" etc show the UUID, rather than the description of that field (e.g. product description, account name, etc).
Environment
- SAP Cloud for Customer
- SAP Business ByDesign
Reproducing the Issue
- Run your OData query based on a data source.
- Check the result.
Fields such as "Product", "Account" etc show the UUID, rather than the description.
Cause
The respective field is of type UUID. All the data for that field in this data source are stored in this specific format.
Since data sources show raw data, the OData extraction will reflect this format. The display was enhanced on the system UI (i.e. data source preview) for better usability, but this enhancement is specific to the data source UI and not available in the OData extraction in data sources.
Resolution
This is the correct behavior, however there is an alternative way to get the product description:
The OData extraction on report level allows you to select the ID and / or the text of a field. Please create an OData URL based on a report, not data source. In the query builder, you will be able to select if you would like to see the ID of that field, or the text (or both).
Keywords
odata, data source, business analytics, reporting, UUID, wrong format, descriptions missing , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem