This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Working with Accounts in SAP Business ByDesign

Owned by Former user (Deleted)
Last updated: Feb 03, 2017 by Former user (Deleted)
3 min read

The queryAccountOpenAmounts operation retrieves 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.

queryAccountOpenAmounts
<sapbydesign.queryAccountOpenAmounts>
    <queryObject>{$ctx:queryObject}</queryObject>
    <processingConditionsObject>{$ctx:processingConditionsObject}</processingConditionsObject>
    <includeOpenOrders>{$ctx:includeOpenOrders}</includeOpenOrders>
    <includeOpenAndInPreparationOrders>{$ctx:includeOpenAndInPreparationOrders}</includeOpenAndInPreparationOrders>
</sapbydesign.queryAccountOpenAmounts>
Properties
  • queryObject: Contains all possible query parameters grouped within the AccountOpenAmountsSelection node.
  • processingConditionsObject: The xml object that contains the conditions to manage the query result.
  • includeOpenOrders: When set to true, service and sales orders in the open status are retrieved.

  • includeOpenAndInPreparationOrders: When set to true, service and sales orders in the open and in preparation statuses are retrieved.

Sample request

Following is a sample REST/JSON request that can be handled by the queryAccountOpenAmounts operation.

Sample Request for queryAccountOpenAmounts
<queryAccountOpenAmounts>
    <username>USERNAME</username>
    <password>PASSWORD</password>
    <sapHost>HOST</sapHost>
    <blocking>false</blocking>
    <queryObject>
        <AccountOpenAmountsSelection>
            <CompanyID>
                <InclusionExclusionCode>I</InclusionExclusionCode>
                <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
                <LowerBoundaryIdentifier>123</LowerBoundaryIdentifier>
            </CompanyID>
            <AccountID>
                <InclusionExclusionCode>I</InclusionExclusionCode>
                <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
                <LowerBoundaryIdentifier>A*</LowerBoundaryIdentifier>
            </AccountID>
        </AccountOpenAmountsSelection>
    </queryObject>
    <processingConditionsObject>
        <ProcessingConditions>
            <QueryHitsMaximumNumberValue>100</QueryHitsMaximumNumberValue>
            <QueryHitsUnlimitedIndicator>true</QueryHitsUnlimitedIndicator>
        </ProcessingConditions>
    </processingConditionsObject>
    <includeOpenOrders>true</includeOpenOrders>
    <includeOpenAndInPreparationOrders>true</includeOpenAndInPreparationOrders>
</queryAccountOpenAmounts>
Related SAP Business ByDesign documentation

http://help.sap.com/saphelp_byd1611/en/PUBLISHING/PSM_ISI_R_II_QUERY_ACCOUNT_OPEN_AMNT_IN.html

You can also browse the related documentation available in your SAP Business ByDesign system.

Sample configuration

Following is a sample proxy service that illustrates how to connect to SAP Business ByDesign with the init operation and use the queryAccountOpenAmounts operation. The sample request for this proxy can be found in queryAccountOpenAmounts sample request. 

Sample Proxy
<proxy xmlns="http://ws.apache.org/ns/synapse"
       name="sapbydesign_queryAccountOpenAmounts"
       transports="https,http"
       statistics="disable"
       trace="disable"
       startOnLoad="true">
   <target>
      <inSequence onError="faultHandlerSeq">
         <property name="username" expression="//username"/>
         <property name="password" expression="//password"/>
         <property name="sapHost" expression="//sapHost"/>
         <property name="blocking" expression="//blocking"/>
         <property name="queryObject" expression="//queryObject/*"/>
         <property name="processingConditionsObject" expression="//processingConditionsObject/*"/>
         <property name="includeOpenOrders" expression="//includeOpenOrders"/>
         <property name="includeOpenAndInPreparationOrders" expression="//includeOpenAndInPreparationOrders"/>
         <sapbydesign.init>
             <username>{$ctx:username}</username>
             <password>{$ctx:password}</password>
             <sapHost>{$ctx:sapHost}</sapHost>
             <blocking>{$ctx:blocking}</blocking>
         </sapbydesign.init>
         <sapbydesign.queryAccountOpenAmounts>
             <queryObject>{$ctx:queryObject}</queryObject>
             <processingConditionsObject>{$ctx:processingConditionsObject}</processingConditionsObject>
             <includeOpenOrders>{$ctx:includeOpenOrders}</includeOpenOrders>
             <includeOpenAndInPreparationOrders>{$ctx:includeOpenAndInPreparationOrders}</includeOpenAndInPreparationOrders>
         </sapbydesign.queryAccountOpenAmounts>
         <respond/>
      </inSequence>
      <outSequence>
         <send/>
      </outSequence>
   </target>
   <description/>
</proxy>