SAP Knowledge Base Article - Public

3430193 - Extension Field in Purchase Order not Shown in Response via API: QueryPurchaseOrderQueryIn

Symptom

There are extension fields on item level in a purchase order, but when querying the purchase order by API: QueryPurchaseOrderQueryIn, the content in extension fields are not returned in the response.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Purchase Requests and Orders work center.
  2. Create a new purchase order XYZ (XYZ stands for the document ID).
  3. Fill in extension fields on item level.
  4. Go to Application and User Management work center.
  5. Go to Service Explorer view and download WSDL for API: QueryPurchaseOrderQueryIn.
  6. Create a new project in SOAP UI for the WSDL.
  7. Input required information in the payload to find XYZ. 
  8. In the response result, there is no structure of "<n1:TechnicalName(field name) xmlns:n1="namespace of the extension field”>Value of extension field</n1:TechnicalName>".

Cause

This is an expected performance.

QueryPurchaseOrderQueryIn cannot return extension field values on item level, but will return ones on header level.

Resolution

To get extension field values on item level, user need to call ManagePurchaseOrderIn.

See Also

KBA 2636184 - How To Integrate KUT Extension Fields Into Web Services

Keywords

Extension field; Web Service; QueryPurchaseOrderIn; SOAP UI , KBA , SRD-SRM-PRO , Purchase Requests and Orders , How To

Product

SAP Business ByDesign all versions