SAP Knowledge Base Article - Public

3395677 - Purchase Order's Item Status is not Returned in WebService

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

The user is using the webservice QueryPurchaseOrderQueryIn because they want to check the Purchase Order's item status. However this information is not available in the webservice response. 

Environment

SAP Business ByDesign 

Reproducing the Issue

  1. Go to Application and User Management work center.
  2. Go to Service Explorer view.
  3. Select 'Query Purchase Orders'.
  4. Click in 'Download WSDL' button. 
  5. Open SOAP UI.
  6. Open the project and search for the Purchase Order query (QueryPurchaseOrderQueryIn). 
  7. Fulfill the XML payload with the request needed.
  8. Enter the user credentials.
  9. Execute the request.

The user gets the response of the Webservice. The response does not mention the item's status for any of the items. Hence the user does not know if the item is cancelled or not. 

Cause

The item's status is not shown in the webservice QueryPurchaseOrderQueryIn. This information is not available. 

Resolution

This is a limitation for the webservice QueryPurchaseOrderQueryIn, but there is a workaround. 

In service ManagePurchaseOrderIn, Read purchase orders, the user can only get the item status by searching PO ID/UUID.

In the response, the user can find very detailed item status, as showed below (e.g.):

<ItemStatus>
<PurchaseOrderItemLifeCycleStatusCode>10</PurchaseOrderItemLifeCycleStatusCode>
<PurchaseOrderItemApprovalStatusCode>1</PurchaseOrderItemApprovalStatusCode>
<CancellationStatusCode>1</CancellationStatusCode>
<DeliveryProcessingStatusCode>3</DeliveryProcessingStatusCode>
<InvoiceProcessingStatusCode>3</InvoiceProcessingStatusCode>
<InvoicingStatusCode>3</InvoicingStatusCode>
<OrderingStatusCode>3</OrderingStatusCode>
<PurchaseOrderConfirmationStatusCode>9</PurchaseOrderConfirmationStatusCode>
<PurchaseOrderDeliveryStatusCode>3</PurchaseOrderDeliveryStatusCode>
</ItemStatus>

Refraining that for ManagePurchaseOrderIn this can only be executed with PO ID/UUID, so the information returned is only for this specific ID (the user can’t query by time/product like in service QueryPurchaseOrderQueryIn). 

Keywords

Purchase Order; Query; WebService; Web Service; Item; Status; QueryPurchaseOrderQueryIn; ManagePurchaseOrderIn , KBA , SRD-SRM-PRO , Purchase Requests and Orders , How To

Product

SAP Business ByDesign all versions