CurrencyConversion
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CurrencyConversion
Overview
This reporting view provides exchange rate information for SAP systems. It includes the client, exchange rate type, from currency, to currency, exchange rate, start date, end date, and conversion date.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.currency_conversion |
This table stores the exchange rate information. |
Key Use Cases
- Reporting on exchange rates for financial transactions.
- Analyzing currency fluctuations over time.
- Converting currencies for budgeting and forecasting purposes.
Query Logic
The query selects all columns from the currency_conversion table. It also includes a UNION ALL statement to add a row for the latest available exchange rate if the currency conversion DAG is not working or set up.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB08 | Maintain Exchange Rates |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| ExchangeRateType_KURST | Exchange rate type | |
| FromCurrency_FCURR | From currency | |
| ToCurrency_TCURR | To currency | |
| ExchangeRate_UKURS | Exchange rate | |
| StartDate | Start date of the exchange rate validity period | |
| EndDate | End date of the exchange rate validity period | |
| ConvDate | Date of the exchange rate conversion |