Managing Currency Exchange Rates
Use the Manage Currency Exchange Rates app to maintain controlled, predefined currency exchange rates for business processes that require consistent, approved conversion values. This app is provided as part of SAP Integrated Product Development and supports consistent currency handling across all dependent business processes.
Key Features
The app provides the following capabilities:
-
List existing exchange rate records
-
Import exchange rates using a structured Excel file
-
Automatically maintain validity periods for each currency pair
-
Validate all entries before importing to ensure data consistency
-
Delete existing records while keeping the timeline consistent
-
Emit system events when exchange rates are created, updated, or deleted
Many business processes rely on accurate and controlled monetary conversions, for example during cost calculations. To support these processes, administrators can define the valid exchange rates between currencies.
Working with Exchange Rates
Importing Exchange Rates
Administrators can bulk upload exchange rate records using an Excel file.
The Excel file must contain the following columns:
-
Source Currency
-
Target Currency
-
Exchange Rate
-
Valid From
A template file with the required headers is available for download within the app.
When you upload an Excel file, the system does the following:
-
Inserts new records
-
Updates existing records with the same unique key
-
Recalculates the full validity timeline for each affected currency pair after all rows are processed
Before the system saves the uploaded data, it validates all rows according to the following rules:
-
Source and Target Currency must exist in the system.
-
Exchange Rate must be a positive decimal number.
-
Valid From date must be within the supported date range (0001‑01‑01 to 9999‑12‑31).
-
All mandatory fields must be provided.
If any row contains invalid data, the system rejects the import and displays a detailed error report, listing all issues by row and field.
Deleting Exchange Rates
After you delete exchange rate records, the system automatically adjusts the validity periods of the affected currency pair according to the following rules:
-
Deleting the only record: The record is removed; no further adjustments are necessary.
-
Deleting the earliest record: The next record remains unchanged.
-
Deleting the latest record: The previous record is extended to 9999‑12‑31.
-
Deleting a middle record: The previous record is extended until the deleted record’s original Valid To value.
Data Model and Validity Handling
Each exchange rate entry consists of the following fields:
|
Field |
Description |
|---|---|
|
Source Currency |
ISO currency code used as the base currency |
|
Target Currency |
ISO currency code used as the conversion target |
|
Exchange Rate |
Positive decimal value with up to 9 digits and 5 decimal places |
|
Valid From |
Start date of the validity period |
|
Valid To |
Automatically calculated end date of the validity period (read-only) |