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