CurrencyConvUtil
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - 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 calculate conversion factors and determine the valid date ranges for currency conversions.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_cdc_processed_s4 }}.tcurf |
Contains currency conversion rates and validity periods. |
{{ project_id_src }}.{{ dataset_cdc_processed_s4 }}.tcurx |
Contains currency decimal places information. |
Key Use Cases
- Currency conversion in financial reporting and analysis.
- Maintaining currency exchange rates and validity periods.
Query Logic
The query first identifies the latest currency conversion rates (tcurf) for a given client (mandt_s4) and currency pair (fcurr, tcurr). It then calculates the conversion factor and determines the valid date range for the conversion. Finally, it joins the results with the tcurx table to obtain the currency decimal places.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB08 | Maintain Currency Translation Types |
| OBBS | Maintain Exchange Rates |
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 |