TC37A (Shift definition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TC37A to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
SCHGRUP
Grouping for Shift Definitions and Shift Sequences
|
SCHGRUP | TC39A |
CHAR
|
2 | 0 | |||||||||
|
KAPTPROG
Shift definition
|
KAPTPROG |
CHAR
|
4 | 0 | ||||||||||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||||
|
BEGDA
Start Date
|
BEGDA |
DATS
|
8 | 0 | ||||||||||
|
BEGZT
Start time
|
KAPBEGZEIT |
TIMS
|
6 | 0 | ||||||||||
|
ENDZT
Finish time
|
KAPENDZEIT |
TIMS
|
6 | 0 | ||||||||||
|
EINZT
Operating time in seconds (internal)
|
KAPEINZT |
INT4
|
10 | 0 | ||||||||||
|
PAPLAN
Work break schedule
|
PAUPLAN | TC37P |
CHAR
|
4 | 0 | |||||||||
|
KW_PROFIL
Picking wave profile
|
KW_PROFIL | T318 |
CHAR
|
6 | 0 | |||||||||
|
MOTPR
Personnel Subarea Grouping for Daily Work Schedules
|
MOTPR |
NUMC
|
2 | 0 | ||||||||||
|
TPROG
Daily Work Schedule
|
TPROG |
CHAR
|
4 | 0 | ||||||||||
|
VARIA
Daily Work Schedule Variant
|
VARIA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
HRENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TC37A | KW_PROFIL | TC37A | MANDT |
T318
Picking waves profile
|
MANDT |
| TC37A | KW_PROFIL | * |
T318
Picking waves profile
|
LGNUM | |
| TC37A | KW_PROFIL | TC37A | KW_PROFIL |
T318
Picking waves profile
|
KWPRO |
| TC37A | MANDT | TC37A | MANDT |
T000
Clients
|
MANDT |
| TC37A | PAPLAN | TC37A | PAPLAN |
TC37P
Break schedule
|
PAPLAN |
| TC37A | PAPLAN | * |
TC37P
Break schedule
|
PAUNR | |
| TC37A | PAPLAN | TC37A | MANDT |
TC37P
Break schedule
|
MANDT |
| TC37A | PAPLAN | TC37A | SCHGRUP |
TC37P
Break schedule
|
SCHGRUP |
| TC37A | SCHGRUP | TC37A | MANDT |
TC39A
Grouping shift definitions and shift sequences
|
MANDT |
| TC37A | SCHGRUP | TC37A | SCHGRUP |
TC39A
Grouping shift definitions and shift sequences
|
SCHGRUP |