CurrenciesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - CurrenciesMD
Overview
This reporting view provides a comprehensive overview of currency-related information from SAP systems. It combines data from three tables: tcurc, tcurx, and tcurt, providing insights into currency codes, decimals, languages, and both short and long currency descriptions.
Data Sources
| Source Table/View | Description |
|---|---|
| tcurc | Currency table containing currency codes, ISO codes, and client-specific information. |
| tcurx | Currency exchange table providing currency decimals. |
| tcurt | Currency text table containing currency descriptions in multiple languages. |
Key Use Cases
- Currency conversion and exchange rate calculations.
- Financial reporting and analysis.
- Master data management for currencies.
Query Logic
The view joins the three tables on the waers field, ensuring that currency-related information is accurately linked. The query retrieves currency codes, decimals, languages, and both short and long currency descriptions.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB08 | Maintain Currencies |
| OB22 | Maintain Currency Exchange Rates |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client ID | |
| CurrencyCode_WAERS | Currency Code | |
| CurrencyISO_ISOCD | Currency ISO Code | |
| CurrencyDecimals_CURRDEC | Currency Decimals | |
| Language | Language | |
| CurrShortText_KTEXT | Currency Short Text | |
| CurrLongText_LTEXT | Currency Long Text |