SAP table TC37A (Shift definition)

SAP table TC37A has 4 primary key fields being MANDT,SCHGRUP,KAPTPROG,ENDDA.

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
SCHGRUP Grouping for Shift Definitions and Shift Sequences CHAR 2 0 TC39A SCHGRUP
KAPTPROG Shift Definition CHAR 4 0 KAPTPROG
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
BEGZT Start Time TIMS 6 0 KAPBEGZEIT
ENDZT End Time TIMS 6 0 KAPENDZEIT
EINZT Operating Duration in Seconds INT4 10 0 KAPEINZT
PAPLAN Work Break Schedule CHAR 4 0 TC37P PAUPLAN
KW_PROFIL Picking wave profile CHAR 6 0 T318 KW_PROFIL
MOTPR Personnel Subarea Grouping for Daily Work Schedules NUMC 2 0 MOTPR
TPROG Daily Work Schedule CHAR 4 0 * TPROG
VARIA Daily Work Schedule Variant CHAR 1 0 VARIA
blank = Standard variant
0
A
HRENDDA End Date DATS 8 0 ENDDA

TC37A foreign key relationships

Table Field Check Table Check Field
0 TC37A KW_PROFIL T318 Picking waves profile MANDT
0 TC37A KW_PROFIL T318 Picking waves profile LGNUM
1 TC37A PAPLAN TC37P Break schedule MANDT
1 TC37A PAPLAN TC37P Break schedule PAPLAN
0 TC37A SCHGRUP TC39A Grouping shift definitions and shift sequences MANDT
0 TC37A SCHGRUP TC39A Grouping shift definitions and shift sequences SCHGRUP