SAP Table T500W
Valid Country Currencies
T500W (Valid Country Currencies) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T500W to other SAP tables.
T500W table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||
T500W foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T500W | LAND1 | T500W | LAND1 | T005 | Countries | LAND1 |
| T500W | LAND1 | T500W | MANDT | T005 | Countries | MANDT |
| T500W | MANDT | T500W | MANDT | T000 | Clients | MANDT |
| T500W | WAERS | T500W | MANDT | TCURC | Currency Codes | MANDT |
| T500W | WAERS | T500W | WAERS | TCURC | Currency Codes | WAERS |
