SAP table T550A (Daily Work Schedule)
SAP table T550A has 6 primary key fields being MANDT,MOTPR,TPROG,VARIA,SEQNO,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 | |||||||||||||||||||||
| 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 |
|
|||||||||||||||||||||
| SEQNO | Sequential number of daily work schedule | NUMC | 2 | 0 | TPRSQ |
|
|||||||||||||||||||||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||||||||||||||||||||||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||||||||||||||||||||||
| REGEL | Daily work schedule selection rule | CHAR | 2 | 0 | T550X | REGVA | |||||||||||||||||||||
| TPKLA | Daily Work Schedule Class | CHAR | 1 | 0 | TPKLA |
|
|||||||||||||||||||||
| SOLLZ | Planned working hours | DEC | 5 | 2 | SOLLZ | ||||||||||||||||||||||
| SOMAX | Maximum working time | DEC | 4 | 2 | SOMAX | ||||||||||||||||||||||
| SOMIN | Minimum working time | DEC | 4 | 2 | SOMIN | ||||||||||||||||||||||
| VORHO | Compensation time | DEC | 4 | 2 | VORHO | ||||||||||||||||||||||
| NOBEG | Normal working time | TIMS | 6 | 0 | NOBEG | ||||||||||||||||||||||
| NOEND | End of normal working time | TIMS | 6 | 0 | NOEND | ||||||||||||||||||||||
| BTBEG | Begin tolerance time | TIMS | 6 | 0 | BTBEG | ||||||||||||||||||||||
| SOBEG | Start of planned working time | TIMS | 6 | 0 | SOBEG | ||||||||||||||||||||||
| BTEND | End of begin tolerance time | TIMS | 6 | 0 | BTEND | ||||||||||||||||||||||
| K1BEG | Begin core time 1 | TIMS | 6 | 0 | K1BEG | ||||||||||||||||||||||
| K1END | End core time 1 | TIMS | 6 | 0 | K1END | ||||||||||||||||||||||
| K2BEG | Begin core time 2 | TIMS | 6 | 0 | K2BEG | ||||||||||||||||||||||
| K2END | End core time 2 | TIMS | 6 | 0 | K2END | ||||||||||||||||||||||
| ETBEG | Begin end tolerance time | TIMS | 6 | 0 | ETBEG | ||||||||||||||||||||||
| SOEND | End of planned working time | TIMS | 6 | 0 | SOEND | ||||||||||||||||||||||
| ETEND | End Tolerance Time | TIMS | 6 | 0 | ETEND | ||||||||||||||||||||||
| ZUSTD | Additional hours | DEC | 4 | 2 | DZUSST | ||||||||||||||||||||||
| PAMOD | Work Break Schedule | CHAR | 4 | 0 | T550P | PAMOD | |||||||||||||||||||||
| RMEHR | Indicates whether overtime is allowed | CHAR | 1 | 0 | RMEHR | ||||||||||||||||||||||
| RKERN | Reaction to overtime in core time | CHAR | 1 | 0 | RKERN | ||||||||||||||||||||||
| RKEPA | Indicator for arbitrary use | CHAR | 1 | 0 | RKEPA | ||||||||||||||||||||||
| STABY | Indicator showing if WS rule is allowed for availability | CHAR | 1 | 0 | STABY | ||||||||||||||||||||||
| OVPOS | Automatic overtime | CHAR | 1 | 0 | OVPOS | ||||||||||||||||||||||
| START_PREV_DAY | Start on Previous Day | CHAR | 1 | 0 | PTM_START_PREV_DAY |
T550A foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T550A | PAMOD | T550P | Break Schedules | MANDT |
| 0 T550A | PAMOD | T550P | Break Schedules | MOTPR |
| 0 T550A | PAMOD | T550P | Break Schedules | PAMOD |
| 0 T550A | PAMOD | T550P | Break Schedules | SEQNO |
| 1 T550A | REGEL | T550X | Daily Work Schedule Selection Rules | MANDT |
| 1 T550A | REGEL | T550X | Daily Work Schedule Selection Rules | RECNO |
| 1 T550A | REGEL | T550X | Daily Work Schedule Selection Rules | REGEL |
| 1 T550A | REGEL | T550X | Daily Work Schedule Selection Rules | SEQNO |