| Description | Query Account Open Amounts |
| Name | QueryAccountOpenAmountsIn |
| 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 open amounts, such as the current spending limit amount per company, and account combination for each account where the financial data for the company is maintained.
The web service interface Query Account Open Amounts In enables you to connect external applications to your solution, and to query and read open amounts, such as the current spending limit per company and account. The account and company combination is returned when in the account the company is maintained in the financial data.
The web service interface Query Account Open Amounts In is relevant if your company wants to evaluate the credit worthiness of an account. The credit worthiness comprises of the credit limit, open items (receivables only), open sales and service orders, and doubtful debtor indicator and credit limit maintained indicator as the risk status of the customer.
The web service interface Query Account Open Amounts In offers the operation Find Account Open Amounts.
Here is an example of a simple web service request, which seeks for company "123" all accounts with an ID matching "A*", returning at maximum 100 instances:
Show full documentation
Show full documentation
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
<soapenv:Header/>
<soapenv:Body>
<glob:AccountsOpenAmountsQueryRequest_sync>
<AccountOpenAmountsSelection>
<CompanyID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryIdentifier>123</LowerBoundaryIdentifier>
</CompanyID>
<AccountID>
<InclusionExclusionCode>I</InclusionExclusionCode>
<IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
<LowerBoundaryIdentifier>A*</LowerBoundaryIdentifier>
</AccountID>
</AccountOpenAmountsSelection>
<ProcessingConditions>
<QueryHitsMaximumNumberValue>100/QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID></LastReturnedObjectID>
</ProcessingConditions>
</glob:AccountsOpenAmountsQueryRequest_sync>
</soapenv:Body>
</soapenv:Envelope>
As this is a synchronous service, it is recommended to use paging for requesting the data.
You can find general information about Web services, their structure and consumption in the Web Services documentation.
| Description | Find accounts open amounts |
| Name | FindAccountOpenAmounts |
| Synchronous | yes |
| Release Status | Released |
To query the open amounts, like the current spending limit amount, per company and account combination for each account where the financial data for the company is maintained.
The request message of the operation FindAccountOpenAmounts contains the AccountOpenAmountsQuerySelection node that groups all possible selection parameters.
For account and company combination, the financial data must be maintained.
As the returned amounts are converted into the company currency, no entries are returned for a company without default currency.
The indicator IncludeOpenOrders defines if service and sales orders in status open are returned
The indicator IncludeOpenAndInPreparationOrders defines if service and sales orders in status open and in status In Preparation are returned
This node groups all selection parameters. The selection parameters are:
| Selection Parameter | Remark |
|---|---|
| SelectionByCompanyID | Selection by company ID |
| SelectionByAccountID | Selection by account ID |
| SelectionByCreditLimitMaintainedIndicator | Selection by credit limit maintained indicator: true The credit limit is maintained. It can be zero, false In case no credit limit is maintained (currency missing) |
| SelectionByOrderBlockIndicator | Selection by accounts that are blocked for orders |
| SelectionByInvoiceBlockIndicator | Selection by accounts that are Blocked for invoices |
| SelectionByDeliveryBlockIndicator | Selection by accounts that are blocked for deliveries |
| SelectionByDoubtfulDebtorIndicator | Selection by accounts that are doubtful |
The response contains the list of found open amounts per account and company, log items, and processing conditions.
The structure of the list of found open amounts per account is the following. Be aware that all amounts are returned in the company currency.
| Response Elements | Remark |
|---|---|
| CompanyID | Company ID |
| AccountID | Account ID |
| CreditLimitMaintainedIndicator | The credit limit maintained indicator is true when a credit limit is maintained for the account. It can be zero. It is false In case no credit limit is maintained, which means the currency is missing. |
| OrderBlockIndicator | Is true when the account is blocked for orders |
| InvoiceBlockIndicator | Is true when the account is blocked for invoices |
| DeliveryBlockIndicator | Is true when the account is blocked for deliveries |
| DoubtfulDebtorIndicator | Is true when the account is doubtful |
| CreditLimitAmount | Credit limit amount that is maintained for the account and company in company currency |
| CurrentSpendingLimitAmount | Calculated spending limit in company currency. Calulation formular: Credit limit amount - open items receivables – open sales orders – open service orders; Can be negative |
| ReceivablesBalanceAmount | Open item receivables in company currency; Can be negative |
| SalesOrderAmount | Not yet invoiced gross amount of all open sales orders (status in process or open) of the account and company in company currency |
| ServiceOrderAmount | Not yet invoiced gross amount of all open service orders (status in process or open) of the account and company in company currency |