SAP table T551A (Period Work Schedules)

SAP table T551A has 4 primary key fields being MANDT,MOTPR,ZMODN,WONUM.

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
ZMODN Period Work Schedule CHAR 4 0 DZMODN
WONUM Week Number NUMC 3 0 WONUM
TPRG1 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG2 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG3 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG4 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG5 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG6 Daily Work Schedule CHAR 4 0 T550A TPROG
TPRG7 Daily Work Schedule CHAR 4 0 T550A TPROG

T551A foreign key relationships

Table Field Check Table Check Field
0 T551A TPRG1 T550A Daily Work Schedule MANDT
0 T551A TPRG1 T550A Daily Work Schedule MOTPR
0 T551A TPRG1 T550A Daily Work Schedule TPROG
0 T551A TPRG1 T550A Daily Work Schedule VARIA
0 T551A TPRG1 T550A Daily Work Schedule SEQNO
0 T551A TPRG1 T550A Daily Work Schedule ENDDA
1 T551A TPRG2 T550A Daily Work Schedule MANDT
1 T551A TPRG2 T550A Daily Work Schedule MOTPR
1 T551A TPRG2 T550A Daily Work Schedule TPROG
1 T551A TPRG2 T550A Daily Work Schedule VARIA
1 T551A TPRG2 T550A Daily Work Schedule SEQNO
1 T551A TPRG2 T550A Daily Work Schedule ENDDA
0 T551A TPRG3 T550A Daily Work Schedule MANDT
0 T551A TPRG3 T550A Daily Work Schedule MOTPR
0 T551A TPRG3 T550A Daily Work Schedule TPROG
0 T551A TPRG3 T550A Daily Work Schedule VARIA
0 T551A TPRG3 T550A Daily Work Schedule SEQNO
0 T551A TPRG3 T550A Daily Work Schedule ENDDA
1 T551A TPRG4 T550A Daily Work Schedule MANDT
1 T551A TPRG4 T550A Daily Work Schedule MOTPR
1 T551A TPRG4 T550A Daily Work Schedule TPROG
1 T551A TPRG4 T550A Daily Work Schedule VARIA
1 T551A TPRG4 T550A Daily Work Schedule SEQNO
1 T551A TPRG4 T550A Daily Work Schedule ENDDA
0 T551A TPRG5 T550A Daily Work Schedule MANDT
0 T551A TPRG5 T550A Daily Work Schedule MOTPR
0 T551A TPRG5 T550A Daily Work Schedule TPROG
0 T551A TPRG5 T550A Daily Work Schedule VARIA
0 T551A TPRG5 T550A Daily Work Schedule SEQNO
0 T551A TPRG5 T550A Daily Work Schedule ENDDA
1 T551A TPRG6 T550A Daily Work Schedule MANDT
1 T551A TPRG6 T550A Daily Work Schedule MOTPR
1 T551A TPRG6 T550A Daily Work Schedule TPROG
1 T551A TPRG6 T550A Daily Work Schedule VARIA
1 T551A TPRG6 T550A Daily Work Schedule SEQNO
1 T551A TPRG6 T550A Daily Work Schedule ENDDA
0 T551A TPRG7 T550A Daily Work Schedule MANDT
0 T551A TPRG7 T550A Daily Work Schedule MOTPR
0 T551A TPRG7 T550A Daily Work Schedule TPROG
0 T551A TPRG7 T550A Daily Work Schedule VARIA
0 T551A TPRG7 T550A Daily Work Schedule SEQNO
0 T551A TPRG7 T550A Daily Work Schedule ENDDA