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.
BAPIs and functions used
- READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the previous valid rate for the deviation check
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KURST | Target rate type | Single value | TCURR-KURST | Yes | M |
| P_DATE | Rate date | Single value | SY-DATUM | Yes | 17.11.2026 |
| S_FCURR | From currency | Range / multiple | TCURR-FCURR | No | USD, EUR, GBP |
| P_TCURR | To currency | Single value | TCURR-TCURR | Yes | TRY |
| P_SRATE | Source rate (forex buying, forex selling, banknote buying, banknote selling) | Single value | — | Yes | Döviz alış |
| P_MAXDEV | Allowed daily deviation (%) | Single value | — | No | 10 |
| P_HOLID | Copy the last rate to weekends and holidays | Checkbox | — | No | X |
| P_TEST | Test mode (list without writing to the table) | Checkbox | — | No | — |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Rate type | TCURR-KURST |
| 2 | From currency | TCURR-FCURR |
| 3 | To currency | TCURR-TCURR |
| 4 | Valid from | Calculated TCURR-GDATU converted from inverted date format to a normal date |
| 5 | Rate | TCURR-UKURS |
| 6 | From factor | TCURR-FFACT |
| 7 | To factor | TCURR-TFACT |
| 8 | Previous rate | Calculated Previous valid rate read with READ_EXCHANGE_RATE |
| 9 | Change % | Calculated (Rate − previous rate) / previous rate × 100 |
| 10 | Status | Calculated Written, copied (holiday), skipped (deviation) or error |
| 11 | Message | Calculated Information or error message for the row |
Sample result list
| Rate type | From currency | To currency | Valid from | Rate | From factor | To factor | Previous rate | Change % | Status | Message |
|---|---|---|---|---|---|---|---|---|---|---|
| M | USD | TRY | 11/17/2026 | 34.65 | 1 | 1 | 34.59 | 0.18 | Written | Rate saved |
| M | EUR | TRY | 11/17/2026 | 40.10 | 1 | 1 | 40.02 | 0.20 | Written | Rate saved |
| M | JPY | TRY | 11/17/2026 | 22.44 | 100 | 1 | 22.40 | 0.19 | Written | Saved per 100 units |
| M | GBP | TRY | 11/17/2026 | 0 | 1 | 1 | 45.23 | 0 | Error | No rate for this currency in the file |
How does the program work?
- 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.
- 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).
- 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.
- 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.
- 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
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 …
Related reports
Foreign Currency Open Items Exchange Difference Preview Report
A custom ALV report that reads customer and vendor open items by document currency, revalues them at the key-date rate and shows the unrealized …
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.