FI Program Custom development Interface

Daily Central Bank Exchange Rate Import Interface

Short answer: A custom interface program that reads the daily exchange rates published by the central bank over the internet and writes them into the SAP rate table per rate type. It checks the deviation from the previous day, uses the last valid rate on holidays and reports the result by email.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
3
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

OB08 is for entering rates by hand or copying them in the table view; someone has to enter them after the morning publication, and a delay or typo flows straight into invoices. The standard market data transfer expects specific data-provider formats and a separate setup; it does not read the central bank's XML feed directly.

Who uses it? General ledger and treasury teams, users who enter exchange rates by hand every morning, and SAP Basis / integration teams.

Closest standard alternatives

  • OB08 Maintain Exchange Rates. For entering rates by hand; no automatic import or deviation check.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
TCURRExchange RatesExchange rates: rate type, currency pair, validity date and rateWriteECC + S/4
TCURFCurrency Conversion FactorsRatio factors for the currency pairReadECC + S/4
TCURVExchange Rate TypesExchange rate type definitionReadECC + S/4

BAPIs and functions used

  • READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the previous valid rate for the deviation check

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KURSTTarget rate typeSingle valueTCURR-KURSTYesM
P_DATERate dateSingle valueSY-DATUMYes17.11.2026
S_FCURRFrom currencyRange / multipleTCURR-FCURRNoUSD, EUR, GBP
P_TCURRTo currencySingle valueTCURR-TCURRYesTRY
P_SRATESource rate (forex buying, forex selling, banknote buying, banknote selling)Single value—YesDöviz alış
P_MAXDEVAllowed daily deviation (%)Single value—No10
P_HOLIDCopy the last rate to weekends and holidaysCheckbox—NoX
P_TESTTest mode (list without writing to the table)Checkbox—No—

Result list columns

#ColumnSource
1Rate typeTCURR-KURST
2From currencyTCURR-FCURR
3To currencyTCURR-TCURR
4Valid fromCalculated TCURR-GDATU converted from inverted date format to a normal date
5RateTCURR-UKURS
6From factorTCURR-FFACT
7To factorTCURR-TFACT
8Previous rateCalculated Previous valid rate read with READ_EXCHANGE_RATE
9Change %Calculated (Rate − previous rate) / previous rate × 100
10StatusCalculated Written, copied (holiday), skipped (deviation) or error
11MessageCalculated Information or error message for the row

Sample result list

Rate typeFrom currencyTo currencyValid fromRateFrom factorTo factorPrevious rateChange %StatusMessage
MUSDTRY11/17/202634.651134.590.18WrittenRate saved
MEURTRY11/17/202640.101140.020.20WrittenRate saved
MJPYTRY11/17/202622.44100122.400.19WrittenSaved per 100 units
MGBPTRY11/17/202601145.230ErrorNo rate for this currency in the file
A view built with fictional sample data; not real system data.

How does the program work?

  1. A background job runs at a set time every working day; the central bank’s daily rate file (XML) is read over HTTP. Connection and address are managed through the SM59 / STRUST settings.
  2. For every currency in the file, the selected source rate (forex buying, forex selling, banknote) is mapped to an SAP rate type; the mapping lives in a settings table (e.g. forex buying → M, banknote selling → a separate rate type).
  3. Ratio factors are read from TCURF; the unit in the file (e.g. 100 JPY) is converted by the factor. The rate type is validated against TCURV.
  4. The previous valid rate is read with READ_EXCHANGE_RATE; if the daily deviation exceeds the P_MAXDEV percentage, the row is not written and a warning is issued.
  5. Test mode only produces the list; a real run writes TCURR with the validity date in inverted date format (GDATU). On weekends and holidays, the last rate is copied to those days by selection; results and errors are emailed.

Performance notes

A few dozen rows are written per day, so runtime is a matter of seconds. On a connection error, the job retries at set intervals and sends an error email after the last attempt.

Features

  • Runs as a background job Runs automatically every working day after the rates are published.
  • Test mode (check without posting)
  • Line-by-line result and error log
  • Send the result by email A summary of successful runs and any errors is sent to the accounting team.

Authorization objects

  • S_EXCHRATEExchange rate maintenance authorization by rate type (for the background user)
  • S_TABU_DISMaintenance authorization for the rate table's authorization group

Frequently asked questions

Can a source other than the central bank be used?

Yes. The reading layer is separate; your bank's rate service or another data provider can be connected with the same mapping table. A reader class is added for each new source according to its file format.

What happens on weekends and public holidays?

If the central bank publishes no rate that day, the program uses the last valid rate. By selection this rate is also copied to the holiday dates; copied rows are shown with their own status in the list.

Does it work on S/4HANA and in the cloud?

Yes. The rate table is the same on S/4HANA. With a clean core approach the write goes through the released exchange rate API, and the program can be built under ABAP Cloud rules.

Packages that include this solution

FI Package Custom

Currency Valuation and VAT Reconciliation Pack

A four-component pack that brings period-end valuation and tax checks together: daily automatic import of central bank exchange rates, an exchange …

4 components · v1.0

Related reports

Let us build this program for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Daily Central Bank Exchange Rate Import Interface