SAP Knowledge Base Article - Public

2741624 - Technical Field ID Duplicated for OData Service Extraction

Symptom

When extracting a standard Data Source from SAP to another system using OData service, some fields have the "Name in Odata Service" id duplicated, causing incompatibility to extract the information properly to external system.

Environment

SAP Cloud for Customer

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Data Sources view.
  3. Find Data Source ABC (ABC represents the data source name).
  4. Click on the Data Source documentation icon.
  5. In Data Source documentation icon, click in Integration Information.
  6. See the values in column "Name in Odata Service" for fields.
  7. Some IDs look duplicated, as in below example.

a) 'FieldABC' ('FieldABC' represents the field name)

  • Field ID: ABC_ID
  • Name in BW Extraction: ABC_ID
  • Name in OData Service: Abc_odataid


b) 'FieldABCDE' ('FieldABCDE' represents the field name)

  • Field ID: ABC_DE_ID
  • Name in BW Extraction: ABC_DE_ID
  • Name in OData Service: Abc_odatAid

Note that "Name in OData Service" info are the same for both fields above, except a single letter which is lower case in field A, and UPPER case in field B.

Cause

The Name in Odata Service id of the fields are set according to the OData standards. Therefore, any specific changes in the format would be an incompatible change to the OData standards, and would also affect all other customers that already consume the data as per the standards.

Resolution

In case of incompatibility with any external system, this needs to be adapted by the consumer system.

Keywords

OData; Name in OData Service; OData field id; wrong id in OData; incorrect field id; BW extraction; Technical Field; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902