currency_decimal
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - currency_decimal
Overview
This reporting view provides currency decimal places information for SAP systems.
Data Sources
Source Table/View | Description |
---|---|
tcurx | Currency table containing currency keys and decimal places information. |
Key Use Cases
- Used in reporting and analysis to format currency values with the correct number of decimal places.
Query Logic
The view retrieves the currency decimal places for a given currency key (ip_curr) from the tcurx table.
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) |
---|---|---|
currdec | Currency decimal places |