SAP Table T77ED

Shift Planning: Definition of Shifts

T77ED (Shift Planning: Definition of Shifts) 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 T77ED to other SAP tables.

T77ED table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DIENSTGR Shift group for organizational units DIENSTGR T77DB CHAR 10 0
DIENSTE Shift abbreviation for Shift Planning DAYPROG CHAR 4 0
MOTPR Personnel Subarea Grouping for Daily Work Schedules MOTPR NUMC 2 0
TPROG Daily Work Schedule TPROG T550A CHAR 4 0
VARIA Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
TEILDIENST Indicator that a partial absence/attendance can be made TEILDIENST CHAR 1 0
DIENST_VON Start time of shift DIENST_VON TIMS 6 0
DIENST_BIS Shift end time DIENST_BIS TIMS 6 0
PAUSE Accumulated break time in "hours:minutes" PAUSEN TIMS 6 0
VON_TEXT Start time: Display times (string "hh:mm") TIME_FROM CHAR 10 0
BIS_TEXT End time: Display times (string "hh:mm") TIME_TO CHAR 10 0
PAUSE_TEXT Break time: Display of times (string "hh:mm") TIME_PAUSE CHAR 10 0
MOABW Personnel subarea grouping for absence and attendance types MOABW NUMC 2 0
AWART Attendance or Absence Type AWART T554S CHAR 4 0
AWTYP Attendance or absence indicator ART01 CHAR 1 0
P Valid for attendances
A Valid for absences
MOVER Personnel Subarea Grpg for Substitution/Availability Types MOVER NUMC 2 0
STNBY Availability Subtype STNBY T557 CHAR 2 0
TEILD1 Shift abbreviation for Shift Planning DAYPROG T77ED CHAR 4 0
TEILD2 Shift abbreviation for Shift Planning DAYPROG T77ED CHAR 4 0
TEILD3 Shift abbreviation for Shift Planning DAYPROG T77ED CHAR 4 0
TEILD4 Shift abbreviation for Shift Planning DAYPROG T77ED CHAR 4 0
COLOR Color Definition for Shift Abbreviation Field STYLE_COLOR NUMC 1 0
0 Background color (background dependent on GUI)
1 Gray-blue (titles dependent on GUI)
2 Light gray (normal - dependent on GUI)
3 Yellow (totals - dependent on GUI)
4 Blue-green (key fields - dependent on GUI)
5 Green (positive threshold value - dependent on GUI)
6 Red (negative threshold value - dependent on GUI)
7 Violet (groups - dependent on GUI)
INTENSIFIED Intensive Display of Colors STYLE_INTENSIFIED CHAR 1 0
INVERSE Inverse Display of Colors STYLE_INVERSE CHAR 1 0
BOLD Font Format: Bold STYLE_BOLD CHAR 1 0
ITALIC Font Format: Italics STYLE_ITALIC CHAR 1 0
UNDERLINED Font Format: Underlined STYLE_UNDERLINED CHAR 1 0
SEQNR Number for Sorting Shift Abbreviations Within Groups HRSP_SHIFT_SEQNR NUMC 4 0
NO_OVERLAP_CHECK No Overlap Check NO_OVERLAP_CHECK CHAR 1 0
SHIFT_GROUP Cumulation of Requirements: Groups of Shift Abbreviations HRSPP_SHIFT_GROUP CHAR 4 0

T77ED foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T77ED AWART T77ED MANDT T554S Attendance and Absence Types MANDT
T77ED AWART T77ED MOABW T554S Attendance and Absence Types MOABW
T77ED AWART T77ED AWART T554S Attendance and Absence Types SUBTY
T77ED AWART * T554S Attendance and Absence Types ENDDA
T77ED DIENSTGR T77ED MANDT T77DB Shift Groups for Organizational Units MANDT
T77ED DIENSTGR T77ED DIENSTGR T77DB Shift Groups for Organizational Units DIENSTGR
T77ED MANDT T77ED MANDT T000 Clients MANDT
T77ED STNBY T77ED MOVER T557 Availability Types MOVER
T77ED STNBY T77ED STNBY T557 Availability Types STNBY
T77ED STNBY SYST MANDT T557 Availability Types MANDT
T77ED TEILD1 T77ED TEILD1 T77ED Shift Planning: Definition of Shifts DIENSTE
T77ED TEILD1 T77ED MANDT T77ED Shift Planning: Definition of Shifts MANDT
T77ED TEILD1 T77ED DIENSTGR T77ED Shift Planning: Definition of Shifts DIENSTGR
T77ED TEILD2 T77ED MANDT T77ED Shift Planning: Definition of Shifts MANDT
T77ED TEILD2 T77ED DIENSTGR T77ED Shift Planning: Definition of Shifts DIENSTGR
T77ED TEILD2 T77ED TEILD2 T77ED Shift Planning: Definition of Shifts DIENSTE
T77ED TEILD3 T77ED DIENSTGR T77ED Shift Planning: Definition of Shifts DIENSTGR
T77ED TEILD3 T77ED TEILD3 T77ED Shift Planning: Definition of Shifts DIENSTE
T77ED TEILD3 T77ED MANDT T77ED Shift Planning: Definition of Shifts MANDT
T77ED TEILD4 T77ED MANDT T77ED Shift Planning: Definition of Shifts MANDT
T77ED TEILD4 T77ED DIENSTGR T77ED Shift Planning: Definition of Shifts DIENSTGR
T77ED TEILD4 T77ED TEILD4 T77ED Shift Planning: Definition of Shifts DIENSTE
T77ED TPROG T77ED MOTPR T550A Daily Work Schedule MOTPR
T77ED TPROG T77ED TPROG T550A Daily Work Schedule TPROG
T77ED TPROG T77ED VARIA T550A Daily Work Schedule VARIA
T77ED TPROG * T550A Daily Work Schedule SEQNO
T77ED TPROG * T550A Daily Work Schedule ENDDA
T77ED TPROG T77ED MANDT T550A Daily Work Schedule MANDT