SAP Table
TC20 "Formula Parameters"
SAP table TC20 has 2 primary key fields being MANDT,PARID.
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
TC20 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyPARID | Parameter ID | CHAR | 6 | 0 | PARAMID | ||
| VRWRT | Origin of the parameter value | CHAR | 1 | 0 | VORGWRTKZ | ||
| FLDPL | Field from Data Dictionary to be expected | CHAR | 21 | 0 | FIELD_CIM | ||
| FLDFA | Field from Data Dictionary to be expected | CHAR | 21 | 0 | FIELD_CIM | ||
| DIMEN | Dimension key | CHAR | 6 | 0 | T006D | DIMID | |
| UNIT | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VALUE_DEF | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGFLD | Field name | CHAR | 10 | 0 | TC22 | CR_FIELD | |
| VKALK | Indicates it is allowed for costing | CHAR | 1 | 0 | CR_VWKALK | ||
| VKAPA | Indicator: work center is allowed for capacity requirements | CHAR | 1 | 0 | CR_VWKAPA | ||
| VKAPF | Indicator: PRT allowed for requirements | CHAR | 1 | 0 | CR_VWKAPF | ||
| VTERM | Indicator: Allowed for scheduling | CHAR | 1 | 0 | CR_VWTER |
/ Relationships