CurrencyConversion
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CurrencyConversion
Overview
This reporting view provides exchange rate information for SAP systems. It combines data from the currency_conversion table to display exchange rates for various currency pairs and time periods.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.currency_conversion |
Contains historical exchange rate data for different currency pairs and time periods. |
Key Use Cases
- Reporting on exchange rates for financial analysis and planning.
- Converting currency values between different currencies for reporting purposes.
- Tracking exchange rate fluctuations over time.
Query Logic
The query retrieves exchange rate data from the currency_conversion table based on the specified client, currency pairs, and time period. It also includes a UNION ALL statement to provide 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 |
|---|---|
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 |