SAP table TC21 (Standard value key)

SAP table TC21 has 2 primary key fields being MANDT,VGWTS.

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
VGWTS Standard Value Key CHAR 4 0 VORGSCHL
PAR01 Parameter ID CHAR 6 0 TC20 PARAMID
BDE01 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PAR02 Parameter ID CHAR 6 0 TC20 PARAMID
BDE02 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PAR03 Parameter ID CHAR 6 0 TC20 PARAMID
BDE03 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PAR04 Parameter ID CHAR 6 0 TC20 PARAMID
BDE04 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PAR05 Parameter ID CHAR 6 0 TC20 PARAMID
BDE05 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PAR06 Parameter ID CHAR 6 0 TC20 PARAMID
BDE06 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
PARN1 Parameter ID CHAR 6 0 TC20 PARAMID
GENER Internal indicator: Coding generated CHAR 1 0 CR_GENER
SAKL_01 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_01 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_01 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_01 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
SAKL_02 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_02 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_02 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_02 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
SAKL_03 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_03 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_03 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_03 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
SAKL_04 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_04 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_04 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_04 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
SAKL_05 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_05 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_05 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_05 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
SAKL_06 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown
RKRCFR_06 Formula Key CHAR 6 0 TC25 AP_FORMEL
RKRCZT_06 Retrograde calculation time NUMC 1 0 RKRECN_ZT
RKMLZT_06 Confirmation time NUMC 1 0 RKMELD_ZT
0 After setup and processing and teardown
1 Setup
2 Processing
3 Teardown
BDEP1 Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
SAKL_P1 Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown

TC21 foreign key relationships

Table Field Check Table Check Field
0 TC21 PAR01 TC20 "Formula Parameters" MANDT
0 TC21 PAR01 TC20 "Formula Parameters" PARID
1 TC21 PAR02 TC20 "Formula Parameters" MANDT
1 TC21 PAR02 TC20 "Formula Parameters" PARID
0 TC21 PAR03 TC20 "Formula Parameters" MANDT
0 TC21 PAR03 TC20 "Formula Parameters" PARID
1 TC21 PAR04 TC20 "Formula Parameters" MANDT
1 TC21 PAR04 TC20 "Formula Parameters" PARID
0 TC21 PAR05 TC20 "Formula Parameters" MANDT
0 TC21 PAR05 TC20 "Formula Parameters" PARID
1 TC21 PAR06 TC20 "Formula Parameters" MANDT
1 TC21 PAR06 TC20 "Formula Parameters" PARID
0 TC21 PARN1 TC20 "Formula Parameters" MANDT
0 TC21 PARN1 TC20 "Formula Parameters" PARID
1 TC21 RKRCFR_01 TC25 Work center formulas MANDT
0 TC21 RKRCFR_02 TC25 Work center formulas MANDT
1 TC21 RKRCFR_03 TC25 Work center formulas MANDT
0 TC21 RKRCFR_04 TC25 Work center formulas MANDT
1 TC21 RKRCFR_05 TC25 Work center formulas MANDT
0 TC21 RKRCFR_06 TC25 Work center formulas MANDT