SAP table TC20 ("Formula Parameters")
SAP table TC20 has 2 primary key fields being MANDT,PARID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PARID | 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 |
TC20 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TC20 | DIMEN | T006D | Dimensions | DIMID |
| 1 TC20 | UNIT | T006 | Units of Measurement | MANDT |
| 1 TC20 | UNIT | T006 | Units of Measurement | MSEHI |
| 0 TC20 | VGFLD | TC22 | Field Name of Value from Transport Structure | MANDT |
| 0 TC20 | VGFLD | TC22 | Field Name of Value from Transport Structure | PARHK |