SAP Knowledge Base Article - Public

2991040 - OData Data Source Extraction Shows UUIDs Instead of Text

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

  1. Run your OData query based on a data source.
  2. 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

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions