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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |