SAP Knowledge Base Article - Public

3145517 - External ID Not Found In OData Service For Sales Orders

Symptom

The Sales Order 'External ID' is not available in the OData Service "Customer_order_collection".

Environment

SAP Cloud for Customer

Cause

External ID is not directly available in the Sales order Odata.

Resolution

However there is a way to get it: 

External ID is stored as a BTD reference in the sales order. Query the CustomerOrderBusinessTransactionDocumentReferenceCollection and then write a filtering logic to get the ID field where the RoleCode = 6.

Keywords

Customer_Order, customer order, sales order, odata, collection , KBA , LOD-LE-CQP-CO , Lean Sales Orders , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer core applications 2111