SAP table T508A (Work Schedule Rules)
SAP table T508A has 6 primary key fields being MANDT,ZEITY,MOFID,MOSID,SCHKZ,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 | |||||||
ZEITY | Employee Subgroup Grouping for Work Schedules | CHAR | 1 | 0 | DZEITY | ||||||||
MOFID | Public Holiday Calendar | CHAR | 2 | 0 | THOCI | HIDENT | |||||||
MOSID | Personnel Subarea Grouping for Work Schedules | NUMC | 2 | 0 | T508Z | MOSID | |||||||
SCHKZ | Work Schedule Rule | CHAR | 8 | 0 | SCHKN | ||||||||
ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||||||||
BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||||||||
KUGKZ | Work schedule rule for reduced hours | CHAR | 1 | 0 | KUGKZ | ||||||||
SCHZU | Shift premium | DEC | 5 | 0 | SCHZU | ||||||||
ZMODN | Period Work Schedule | CHAR | 4 | 0 | T551A | DZMODN | |||||||
KUGKN | RHC Work Schedule Rule for This Work Schedule Rule | CHAR | 8 | 0 | T508A | KUGKN | |||||||
KKRKH | Sickness indicator (Austria) | CHAR | 1 | 0 | KKRKH | ||||||||
BZPKT | Reference Date for Period Work Schedule | DATS | 8 | 0 | BZPKT | ||||||||
OFFBZ | Starting Point in Period Work Schedule | NUMC | 3 | 0 | OFFBZ | ||||||||
MOTPR | Personnel Subarea Grouping for Daily Work Schedules | NUMC | 2 | 0 | MOTPR | ||||||||
MOTTY | Rule for day types | NUMC | 2 | 0 | T553A | MOTTY | |||||||
TGSTD | Daily hours | DEC | 5 | 2 | TGSTD | ||||||||
WOSTD | Hours per week | DEC | 5 | 2 | WOSTD | ||||||||
M1STD | Monthly hours | DEC | 5 | 2 | MOSTD | ||||||||
M2STD | Additional Monthly Hours | DEC | 5 | 2 | M2STD | ||||||||
WKWDY | Weekly workdays | DEC | 5 | 2 | WKWDY | ||||||||
JRSTD | Annual working hours | DEC | 7 | 2 | JRSTD | ||||||||
STABY | Indicator showing if WS rule is allowed for availability | CHAR | 1 | 0 | STABY | ||||||||
GENWS | Automatic Regeneration of Period Work Schedules | CHAR | 1 | 0 | TIM_GENWS |
|
T508A foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 T508A | KUGKN | T508A | Work Schedule Rules | MANDT |
0 T508A | KUGKN | T508A | Work Schedule Rules | ZEITY |
0 T508A | KUGKN | T508A | Work Schedule Rules | MOFID |
0 T508A | KUGKN | T508A | Work Schedule Rules | MOSID |
0 T508A | KUGKN | T508A | Work Schedule Rules | SCHKZ |
0 T508A | KUGKN | T508A | Work Schedule Rules | ENDDA |
1 T508A | MOSID | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | MANDT |
1 T508A | MOSID | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | MOSID |
0 T508A | MOTTY | T553A | Definition Rules for Day Types | MANDT |
0 T508A | MOTTY | T553A | Definition Rules for Day Types | MOTTY |
1 T508A | ZMODN | T551A | Period Work Schedules | MANDT |
1 T508A | ZMODN | T551A | Period Work Schedules | MOTPR |
1 T508A | ZMODN | T551A | Period Work Schedules | ZMODN |