CurrencyConvUtil
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CurrencyConvUtil
Overview
This reporting view provides currency conversion factors and validity periods for SAP systems. It combines data from the tcurf and tcurx tables to determine the conversion factor between two currencies on a specific date.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.tcurf |
Contains currency conversion rates and validity periods. |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.tcurx |
Contains currency decimal places information. |
Key Use Cases
- Currency conversion in financial reporting.
- Analysis of historical currency fluctuations.
- Data integration with other systems that require currency conversion.
Query Logic
The query first identifies the latest currency conversion rate for a given currency pair and date range (tcurf). It then joins this information with the currency decimal places (tcurx) to calculate the conversion factor. The final result includes the conversion factor, validity periods, and currency decimal places.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB08 | Maintain Currency Translation Types |
| OBBS | Display Currency Translation Types |
| FAGL_FC_VAL | Foreign Currency Valuation |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_mandt | Client mandate | |
| SourceCurrency_FCURR | Source currency | |
| TargetCurrency_TCURR | Target currency | |
| DateFROM | Date from | |
| DateTo | Date to | |
| FFACT | Factor from | |
| TFACT | Factor to | |
| FROMCurrDecimal | Decimal places for source currency | |
| toCurrDecimal | Decimal places for target currency | |
| ConversionFactor | Conversion factor | |
| validFROMDate | Valid from date | |
| validToDate | Valid to date |