| Description | Query Trade Receivables Payables Account |
| Name | QueryTradeReceivablesPayablesAccountIn |
| Namespace | http://sap.com/xi/A1S/Global |
| Process Component Description | Due Item Processing |
| Process Component Name | DueItemProcessing |
| Process Component Namespace | http://sap.com/xi/AP/DueItemManagement/Global |
| Deployment Unit Description | Financials |
| Endpoint Activation | By Scoping of Process Component | Operations |
| Release Status | Released |
An Interface to query Trade Recievables Payables Accounts
The webservice interface Query Trade Recievables Payables Accounts enables you to query and read trade recievables payables accounts in your system.
The web service interface Query Trade Recievables Payables Accounts offers the operation Find By Elements.
Here is an example of a simple web service request, which seeks for a trade recievables payables account with company A and a last dunning date of the account that is in the year 2018
<n0:TradeReceivablesPayablesAccountByElementsQuery_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global"> <TradeReceivablesPayablesAccountByElements> <SelectionByCompanyID> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <LowerBoundaryIdentifier>COMP_A</LowerBoundaryIdentifier> </SelectionByCompanyID> <SelectionByLastDunningDate> <InclusionExclusionCode>I</InclusionExclusionCode> <IntervalBoundaryTypeCode>3</IntervalBoundaryTypeCode> <LowerBoundaryDate>2018-01-01</LowerBoundaryDate> <UpperBoundaryDate>2019-01-01</UpperBoundaryDate> </SelectionByLastDunningDate> </TradeReceivablesPayablesAccountByElements> <ProcessingConditions> <QueryHitsMaximumNumberValue>200</QueryHitsMaximumNumberValue> <QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator> </ProcessingConditions> </n0:TradeReceivablesPayablesAccountByElementsQuery_sync>
Here is an exerpt of the response of the request
<n0:TradeReceivablesPayablesAccountByElementsResponse_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:ACL:/1SAI/TAS086EF7E0527CC14D1F43:804"> <TradeReceivablesPayablesAccount> <ChangeStateID> 20080627135814.8304720</ChangeStateID> <UUID>00145ef5-88e6-02db-bff1-bfdd0e1e807e</UUID> <CompanyUUID>00145ef5-88e6-02db-b8b3-ac44715e0cc1</CompanyUUID> <CompanyID>COMP_A</CompanyID> <BusinessPartnerUUID>00300571-ce9b-1ded-89de-4402ab375ec4</BusinessPartnerUUID> <BusinessPartnerInternalID>BP_1</BusinessPartnerInternalID> <PartyRoleCategoryCode>4</PartyRoleCategoryCode> <LastDunningDate>2018-05-22</LastDunningDate> <DunningProcedureCode>03</DunningProcedureCode> <ClearingStrategyCode>Z0</ClearingStrategyCode> <PaymentStrategyCode>01</PaymentStrategyCode> <SystemAdministrativeData> <CreationDateTime>2008-06-27T13:58:14.830472Z</CreationDateTime> <CreationIdentityUUID>00145ef5-88e6-02db-b8ad-62bc2e628346</CreationIdentityUUID> <LastChangeDateTime>2018-08-22T08:29:31.689753Z</LastChangeDateTime> <LastChangeIdentityUUID>00163e07-3d6a-1ed8-93be-12fcc9a71e19</LastChangeIdentityUUID> </SystemAdministrativeData> </TradeReceivablesPayablesAccount> <TradeReceivablesPayablesAccount> <ChangeStateID> 20180601013352.7050240</ChangeStateID> <UUID>00163e5f-4d76-1ed8-99a7-7aec3204819a</UUID> <CompanyUUID>00145ef5-88e6-02db-b8b3-ac44715e0cc1</CompanyUUID> <CompanyID>COMP_A</CompanyID> <BusinessPartnerUUID>00163e5f-4d76-1ed8-99a7-79d296ed219a</BusinessPartnerUUID> <BusinessPartnerInternalID>BP_2</BusinessPartnerInternalID> <PartyRoleCategoryCode>4</PartyRoleCategoryCode> <LastDunningDate>2018-08-22</LastDunningDate> <DunningProcedureCode>03</DunningProcedureCode> <ClearingStrategyCode>Z0</ClearingStrategyCode> <PaymentStrategyCode>01</PaymentStrategyCode> <SystemAdministrativeData> <CreationDateTime>2018-06-01T01:33:52.705024Z</CreationDateTime> <CreationIdentityUUID>00163e07-3d68-1ed7-abc8-ede75e065d94</CreationIdentityUUID> <LastChangeDateTime>2018-08-22T08:30:11.257135Z</LastChangeDateTime> <LastChangeIdentityUUID>00163e07-3d6a-1ed8-93be-12fcc9a71e19</LastChangeIdentityUUID> </SystemAdministrativeData> </TradeReceivablesPayablesAccount> <ProcessingConditions> <ReturnedQueryHitsNumberValue>2</ReturnedQueryHitsNumberValue> <MoreHitsAvailableIndicator>false</MoreHitsAvailableIndicator> <LastReturnedObjectID>00163E5F4DA71EE89E8977504F0EEB42</LastReturnedObjectID> </ProcessingConditions> </n0:TradeReceivablesPayablesAccountByElementsResponse_sync>
This shows that for company A there are two business partners ( BP_1 and BP_2 ) that have a last dunning date in 2018
You can find general information about Web services, their structure and consumption in the Web Services documentation.
| Description | Find trade receivable payable accounts |
| Name | FindByElements |
| Synchronous | yes |
| Release Status | Released |
To find a trade recievables payables account by elements.
The request message of the operation Find By Elements contains the TradeReceivablesPayablesAccountByElements node that groups all possible selection parameters.
This node groups all selection parameters. The selection parameters are as follows:
| Selection Parameter | Remark |
|---|---|
| SelectionByUUID | Selection by UUID |
| SelectionByCompanyUUID | Selection by company UUID |
| SelectionByCompanyID | Selection by company ID |
| SelectionByBusinessPartnerUUID | Selection by business partner UUID |
| SelectionByBusinessPartnerInternalID | Selection by business partner's internal ID |
| SelectionByPartyRoleCategoryCode | Selection by party role category of the account (3 = Payable, 4 = Recievable, blank = mixed account) |
| SelectionByLastDunningDate | Selection by the last dunning date |
| SelectionByDunningBlockedIndicator | Selection by dunning blocked indicator |
| SelectionByDunningBlockingReasonCode | Selection by dunning blocking reason code |
| SelectionByDunningBlockingExpirationDate | Selection by dunning blocking expiration date |
| SelectionByDunningProcedureCode | Selection by dunning strategy code |
| SelectionByDuePaymentStrategyCode | Selection by the payment strategy code |
| SelectionByDueClearingStrategyCode | Selection by clearing strategy code |
| SelectionByDebtorDoubtfulIndicator | Selection by debtor doubtful indicator |
| SelectionByCreationDateTime | Selection by creation date time |
| SelectionByLastChangeDateTime | Selection by last change date time |
| SelectionByCreationIdentityID | Selection by creation identity ID |
| SelectionByLastChangeIdentityID | Selection by last change identity ID |
| SelectionBySearchText | Selection by search text |
The response contains the list of found accounts, log items, and processing conditions.
In this node, all found accounts are contained, including their account data. This includes the ChangeStateID that may be needed for subsequent change requests via web services as well.
Show full documentation
Show full documentation