SAP Knowledge Base Article - Public

2696590 - FewPurchase Orders not Appearing Using the WebSevice -QueryPurchaseOrderQueryIn

Symptom

You did not get the desired list of Purchase order using Webservice though you got  the same using Respective report.

Environment

SAP Business ByDesign

Cause

Because of specific 'timeZoneCode' value( ike UTC) passed via the query parameter related to 'Ordered Date Time'. so only those Purchase orders created with that time zone are appearing.

Resolution

Do not use the Time zone in the query.

 For example:

 If your requirement is to fetch the POs of current year, you can use the 'IntervalBoundaryTypeCode' as '9'( Greater Than or Equal to) and 'LowerBoundaryOrderedDate' as 1st January with no specific time zone mentioned.

As suggested below,

<IntervalBoundaryTypeCode>9</IntervalBoundaryTypeCode>
<LowerBoundaryOrderedDate timeZoneCode="?">2018-01-01T00:00:00Z </LowerBoundaryOrderedDate>

Keywords

QueryPurchaseOrderQueryIn, Purchase ordes missing, Webservice query  not working , KBA , AP-POP-PO , Purchase Order , Problem

Product

SAP Business ByDesign all versions