SAP table T508S (Text Table for Work Schedule Rules (T508A))
SAP table T508S has 6 primary key fields being MANDT,ZEITY,MOFID,MOSID,SCHKZ,SPRSL.
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 | * | HIDENT | |
| MOSID | Personnel Subarea Grouping for Work Schedules | NUMC | 2 | 0 | * | MOSID | |
| SCHKZ | Work Schedule Rule | CHAR | 8 | 0 | T508A | SCHKN | |
| SPRSL | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| RTEXT | Text for Work Schedule Rule (Planned Working Time Infotype) | CHAR | 25 | 0 | RETEXT |
T508S foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | MANDT |
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | ZEITY |
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | MOFID |
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | MOSID |
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | SCHKZ |
| 0 T508S | SCHKZ | T508A | Work Schedule Rules | ENDDA |