SAP Table
TCURC Currency Codes
SAP table TCURC has 2 primary key fields being MANDT,WAERS.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCURC columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| KeyWAERS | Currency Key | CUKY | 5 | 0 | WAERS_CURC | ||
| ISOCD | ISO currency code | CHAR | 3 | 0 | ISOCD | ||
| ALTWR | Alternative key for currencies | CHAR | 3 | 0 | ALTWR | ||
| GDATU | Date until which the currency is valid | DATS | 8 | 0 | DATUM_CURC | ||
| XPRIMARY | Primary SAP Currency Code for ISO Code | CHAR | 1 | 0 | XPRIMARY |