Skip to Content
0
Apr 22, 2020 at 03:35 PM

I want to download purchase order by last changed date from ByD via Webservice

50 Views Last edit Apr 23, 2020 at 12:21 AM 4 rev

Hello,

I am able to download PO using OrderedDateTime field in filter, It's perfect working with below payload.

<SelectionByOrderedDateTime>
                <InclusionExclusionCode>I</InclusionExclusionCode>
                <IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode>
                <LowerBoundaryOrderedDate timeZoneCode="EST">2020-04-03T13:18:12Z</LowerBoundaryOrderedDate>
                <UpperBoundaryOrderedDate timeZoneCode="EST">2020-04-03T13:20:32Z</UpperBoundaryOrderedDate></SelectionByOrderedDateTime>

But, When i am downloading PO using SystemAdministrativeDataLastChangedDateTime field in filters. It's returning all records without applying filter.
Experts, Please help me on this.

Here, I have attached my payload,

<ns1:Envelope xmlns:ns1="http://www.w3.org/2003/05/soap-envelope">
	<Body>
		<?xml version="1.0" encoding="UTF-8"?>
		<n0:PurchaseOrderSimpleByElementsQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global">
			<PurchaseOrderSimpleSelectionByElements>				
				<SelectionBySystemAdministrativeDataLastChangedDateTime>
					<InclusionExclusionCode>I</InclusionExclusionCode>
					<IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode>
					<LowerBoundarySystemAdministrativeDataLastChangedDateTime timeZoneCode="EST">2020-04-20T00:00:12Z</LowerBoundarySystemAdministrativeDataLastChangedDateTime>
					<UpperBoundarySystemAdministrativeDataLastChangedDateTime timeZoneCode="EST">2020-04-20T13:20:32Z</UpperBoundarySystemAdministrativeDataLastChangedDateTime>
				</SelectionBySystemAdministrativeDataLastChangedDateTime>
			</PurchaseOrderSimpleSelectionByElements>
			<ProcessingConditions>
				<QueryHitsUnlimitedIndicator>true</QueryHitsUnlimitedIndicator>
			</ProcessingConditions>
		</n0:PurchaseOrderSimpleByElementsQuery_sync>
	</Body>
</ns1:Envelope>

Regards,

Yagnik Desai