CurrenciesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - CurrenciesMD
Overview
This reporting view provides information about currencies used in SAP systems. It combines data from three tables: tcurc, tcurx, and tcurt. The view includes fields such as client, currency code, currency ISO code, currency decimals, language, currency short text, and currency long text.
Data Sources
| Source Table/View | Description |
|---|---|
| tcurc | Currency table containing general currency information |
| tcurx | Currency exchange rate table containing currency decimal information |
| tcurt | Currency text table containing currency short and long texts |
Key Use Cases
- Display currency information in reports and dashboards
- Analyze currency usage across different clients and languages
- Identify currencies with specific decimal precision requirements
Query Logic
The view joins the tcurc, tcurx, and tcurt tables on the waers field to retrieve comprehensive currency information. The mandt field is used to filter the results to a specific client.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| OB08 | Maintain Currencies |
| OB22 | Maintain 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 |