SAP Table

TC21 Standard value key

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

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

TC21 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyVGWTS 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
PAR02 Parameter ID CHAR 6 0 TC20 PARAMID
BDE02 Transfer activity types to incentive wages CHAR 1 0 BDENR
PAR03 Parameter ID CHAR 6 0 TC20 PARAMID
BDE03 Transfer activity types to incentive wages CHAR 1 0 BDENR
PAR04 Parameter ID CHAR 6 0 TC20 PARAMID
BDE04 Transfer activity types to incentive wages CHAR 1 0 BDENR
PAR05 Parameter ID CHAR 6 0 TC20 PARAMID
BDE05 Transfer activity types to incentive wages CHAR 1 0 BDENR
PAR06 Parameter ID CHAR 6 0 TC20 PARAMID
BDE06 Transfer activity types to incentive wages CHAR 1 0 BDENR
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
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
SAKL_02 Record type group NUMC 1 0 SA_KLASSE
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
SAKL_03 Record type group NUMC 1 0 SA_KLASSE
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
SAKL_04 Record type group NUMC 1 0 SA_KLASSE
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
SAKL_05 Record type group NUMC 1 0 SA_KLASSE
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
SAKL_06 Record type group NUMC 1 0 SA_KLASSE
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
BDEP1 Transfer activity types to incentive wages CHAR 1 0 BDENR
SAKL_P1 Record type group NUMC 1 0 SA_KLASSE
/ Relationships

TC21 foreign keys.

Table Field Check Table Description Check Field
TC21 PAR01 TC20 "Formula Parameters" MANDT
TC21 PAR01 TC20 "Formula Parameters" PARID
TC21 PAR02 TC20 "Formula Parameters" MANDT
TC21 PAR02 TC20 "Formula Parameters" PARID
TC21 PAR03 TC20 "Formula Parameters" MANDT
TC21 PAR03 TC20 "Formula Parameters" PARID
TC21 PAR04 TC20 "Formula Parameters" MANDT
TC21 PAR04 TC20 "Formula Parameters" PARID
TC21 PAR05 TC20 "Formula Parameters" MANDT
TC21 PAR05 TC20 "Formula Parameters" PARID
TC21 PAR06 TC20 "Formula Parameters" MANDT
TC21 PAR06 TC20 "Formula Parameters" PARID
TC21 PARN1 TC20 "Formula Parameters" MANDT
TC21 PARN1 TC20 "Formula Parameters" PARID
TC21 RKRCFR_01 TC25 Work center formulas MANDT
TC21 RKRCFR_02 TC25 Work center formulas MANDT
TC21 RKRCFR_03 TC25 Work center formulas MANDT
TC21 RKRCFR_04 TC25 Work center formulas MANDT
TC21 RKRCFR_05 TC25 Work center formulas MANDT
TC21 RKRCFR_06 TC25 Work center formulas MANDT
Back to SAP tables