3646979 - Query a List of Exchange Rates via Web Service

Our requirement is to regularly export applicable exchange rates from SAP Business ByDesign. 
Since this process shall be automated the conventional export function via  Microsoft Excel® does not suffice. 

SAP Business ByDesign

1. Go to the General Ledger Work Center.
2. Go to the Edit Exchange Rates View.
3. Filter for the Source Currency ABC and the Target Currency DEF.

The currently valid rates DEF/ABC per Rate Type are listed. 
Via View Exchange Rate History past rates for exchange rate pair DEF/ABC are shown.
In both views the table's content can be exported to Microsoft Excel®.
This process should be automated via a suitable API, for example web service.

In Application and User Management work center SAP Business ByDesign offers the service QueryExchangeRateIn_V1 (Query Exchange Rates) and Operation FindByElements (Find exchange rates).

This service can be added in a Communication Scenario and adopted in a pertinent Communication Arrangement for such a web service. 

The example below illustrates a web service request to produce all maintained exchange rates EUR (Euro) to USD (US Dollar), the price of 1 USD in EUR, valid in the current year 2025. 

<glob:ExchangeRateByElementsQuery_sync>
         <ExchangeRateSelectionByElements>
            <SelectionBySourceCurrencyCode>
               <InclusionExclusionCode>I</InclusionExclusionCode>
               <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
               <LowerBoundaryCurrencyCode>USD</LowerBoundaryCurrencyCode>
            </SelectionBySourceCurrencyCode>
            <SelectionByTargetCurrencyCode>
               <InclusionExclusionCode>I</InclusionExclusionCode>
               <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
               <LowerBoundaryCurrencyCode>EUR</LowerBoundaryCurrencyCode>
            </SelectionByTargetCurrencyCode>
            <SelectionByValidFromDateTime>
               <InclusionExclusionCode>I</InclusionExclusionCode>
               <IntervalBoundaryTypeCode>9</IntervalBoundaryTypeCode>
               <LowerBoundaryDateTime>2025-01-01T00:00:00.0000000Z</LowerBoundaryDateTime>
            </SelectionByValidFromDateTime>
            <SelectionByValidToDateTime>
               <InclusionExclusionCode>I</InclusionExclusionCode>
               <IntervalBoundaryTypeCode>7</IntervalBoundaryTypeCode>
               <LowerBoundaryDateTime>2025-12-31T23:59:59.9999999Z</LowerBoundaryDateTime>
            </SelectionByValidToDateTime>
         </ExchangeRateSelectionByElements>
         <ProcessingConditions>
            <QueryHitsUnlimitedIndicator>true</QueryHitsUnlimitedIndicator>
         </ProcessingConditions>
</glob:ExchangeRateByElementsQuery_sync>

More information regarding this and other Web Service APIs can be found via Help Portal: Web Service APIs in SAP Business ByDesign

KBA , AP-ACC , Business ByDesign: Financial Accounting , Problem