SAP Table PSHFT

Screen Fields for Generating Shift Schedule

PSHFT (Screen Fields for Generating Shift Schedule) 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 PSHFT to other SAP tables.

Source: PSHFT (Screen Fields for Generating Shift Schedule)

PSHFT table fields

Field Data element Checktable Datatype Length Decimals
ZEITY Employee Subgroup Grouping for Work Schedules DZEITY CHAR 1 0
MOFID Public Holiday Calendar HIDENT THOCI CHAR 2 0
MOSID Personnel Subarea Grouping for Work Schedules MOSID T508Z NUMC 2 0
SCHKZ Work Schedule Rule SCHKN T508A CHAR 8 0
PRD01 Start period PRD01 CHAR 6 0
PRD02 End period PRD02 CHAR 6 0
WEEKN Week WEEKN CHAR 2 0
WDAYS First/last day of week WDAYS CHAR 5 0
BEGDA Start Date BEGDA DATS 8 0
ENDDA End Date ENDDA DATS 8 0
ACDAY Current day ACDAY NUMC 2 0
DAYTX Day text DAYTX CHAR 2 0
NYEAR Year for new month or new week NYEAR NUMC 4 0
NMONT Reset with this month NMONT NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
NWEEK Reset with this week NWEEK NUMC 2 0
01 Weeks
02 Weeks
03 Weeks
04 Weeks
05 Weeks
06 Weeks
07 Weeks
08 Weeks
09 Weeks
10 Weeks
11 Weeks
12 Weeks
13 Weeks
14 Weeks
15 Weeks
16 Weeks
17 Weeks
18 Weeks
19 Weeks
20 Weeks
21 Weeks
22 Weeks
23 Weeks
24 Weeks
25 Weeks
26 Weeks
27 Weeks
28 Weeks
29 Weeks
30 Weeks
31 Weeks
32 Weeks
33 Weeks
34 Weeks
35 Weeks
36 Weeks
37 Weeks
38 Weeks
39 Weeks
40 Weeks
41 Weeks
42 Weeks
43 Weeks
44 Weeks
45 Weeks
46 Weeks
47 Weeks
48 Weeks
49 Weeks
50 Weeks
51 Weeks
52 Weeks
53 Weeks
54 Weeks
55 Weeks
NDAYS Restart on day from current month NDAYS NUMC 2 0
01 Days in month
ADAT1 Current date ADAT1 DATS 8 0
ADAT2 Current date ADAT2 DATS 8 0
WDAT1 Valid from date WDAT1 DATS 8 0
WDAT2 To WDAT2 DATS 8 0
TPROG Daily Work Schedule TPROG T550A CHAR 4 0
FTKLA Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
TAGTY Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
VARIA Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
KONFE Religious Denomination Key KONFE CHAR 2 0
TTP01 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP02 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP03 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP04 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP05 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP06 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TTP07 Day Type TAGTY CHAR 1 0
NULL Day type BLANK: Work according to personal work schedule
0 System set to BLANK: Work acc. to personal work schedule
1 Day type 1: Day off
2 Day type 2: Day off
3 Day type 3: Day off
4 Day type 4: Day off
5 Day type 5: Day off
6 Day type 6: Day off
7 Day type 7: Day off
8 Day type 8: Day off
9 Day type 9: Day off
TPR01 Daily Work Schedule TPROG T550A CHAR 4 0
TPR02 Daily Work Schedule TPROG T550A CHAR 4 0
TPR03 Daily Work Schedule TPROG T550A CHAR 4 0
TPR04 Daily Work Schedule TPROG T550A CHAR 4 0
TPR05 Daily Work Schedule TPROG T550A CHAR 4 0
TPR06 Daily Work Schedule TPROG T550A CHAR 4 0
TPR07 Daily Work Schedule TPROG T550A CHAR 4 0
FTK01 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK02 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK03 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK04 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK05 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK06 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
FTK07 Public holiday class FTKLA CHAR 1 0
NULL Holiday class BLANK - no public holiday
0 System set to BLANK: Work acc. to personal work schedule
1 Holiday class 1 - public hol.
2 Holiday class 2 - public hol.
3 Holiday class 3 - public hol.
4 Holiday class 4 - public hol.
5 Holiday class 5 - public hol.
6 Holiday class 6 - public hol.
7 Holiday class 7 - public hol.
8 Holiday class 8 - public hol.
9 Holiday class 9 - public hol.
VAR01 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR02 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR03 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR04 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR05 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR06 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
VAR07 Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
KNF01 Religious Denomination Key KONFE CHAR 2 0
KNF02 Religious Denomination Key KONFE CHAR 2 0
KNF03 Religious Denomination Key KONFE CHAR 2 0
KNF04 Religious Denomination Key KONFE CHAR 2 0
KNF05 Religious Denomination Key KONFE CHAR 2 0
KNF06 Religious Denomination Key KONFE CHAR 2 0
KNF07 Religious Denomination Key KONFE CHAR 2 0
TAG01 Calendar: Day Short Text KURZT CHAR 2 0
TAG02 Calendar: Day Short Text KURZT CHAR 2 0
TAG03 Calendar: Day Short Text KURZT CHAR 2 0
TAG04 Calendar: Day Short Text KURZT CHAR 2 0
TAG05 Calendar: Day Short Text KURZT CHAR 2 0
TAG06 Calendar: Day Short Text KURZT CHAR 2 0
TAG07 Calendar: Day Short Text KURZT CHAR 2 0
TMO01 Current day ACDAY NUMC 2 0
TMO02 Current day ACDAY NUMC 2 0
TMO03 Current day ACDAY NUMC 2 0
TMO04 Current day ACDAY NUMC 2 0
TMO05 Current day ACDAY NUMC 2 0
TMO06 Current day ACDAY NUMC 2 0
TMO07 Current day ACDAY NUMC 2 0
SJAHR_BEG First year for work schedule maintenance or display SJAHR_BEG NUMC 4 0
SJAHR_END Last year for work schedule maintenance or display SJAHR_END NUMC 4 0
SMONAT_BEG First month for work schedule maintenance or display SMONAT_BEG NUMC 2 0
SMONAT_END Last month for work schedule maintenance or display SMONAT_END NUMC 2 0

PSHFT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PSHFT MOFID PSHFT MOFID THOCI Public holiday calendar index IDENT
PSHFT MOSID SYST MANDT T508Z Assignment of PS Grouping for Work Schedules to Daily WS MANDT
PSHFT MOSID PSHFT MOSID T508Z Assignment of PS Grouping for Work Schedules to Daily WS MOSID
PSHFT SCHKZ * T508A Work Schedule Rules ENDDA
PSHFT SCHKZ PSHFT SCHKZ T508A Work Schedule Rules SCHKZ
PSHFT SCHKZ PSHFT MOSID T508A Work Schedule Rules MOSID
PSHFT SCHKZ PSHFT MOFID T508A Work Schedule Rules MOFID
PSHFT SCHKZ PSHFT ZEITY T508A Work Schedule Rules ZEITY
PSHFT SCHKZ SYST MANDT T508A Work Schedule Rules MANDT
PSHFT TPR01 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR01 * T550A Daily Work Schedule MOTPR
PSHFT TPR01 PSHFT TPR01 T550A Daily Work Schedule TPROG
PSHFT TPR01 PSHFT VAR01 T550A Daily Work Schedule VARIA
PSHFT TPR01 * T550A Daily Work Schedule SEQNO
PSHFT TPR01 * T550A Daily Work Schedule ENDDA
PSHFT TPR02 * T550A Daily Work Schedule MOTPR
PSHFT TPR02 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR02 PSHFT TPR02 T550A Daily Work Schedule TPROG
PSHFT TPR02 PSHFT VAR02 T550A Daily Work Schedule VARIA
PSHFT TPR02 * T550A Daily Work Schedule SEQNO
PSHFT TPR02 * T550A Daily Work Schedule ENDDA
PSHFT TPR03 PSHFT TPR03 T550A Daily Work Schedule TPROG
PSHFT TPR03 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR03 * T550A Daily Work Schedule MOTPR
PSHFT TPR03 PSHFT VAR03 T550A Daily Work Schedule VARIA
PSHFT TPR03 * T550A Daily Work Schedule SEQNO
PSHFT TPR03 * T550A Daily Work Schedule ENDDA
PSHFT TPR04 PSHFT VAR04 T550A Daily Work Schedule VARIA
PSHFT TPR04 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR04 * T550A Daily Work Schedule MOTPR
PSHFT TPR04 PSHFT TPR04 T550A Daily Work Schedule TPROG
PSHFT TPR04 * T550A Daily Work Schedule SEQNO
PSHFT TPR04 * T550A Daily Work Schedule ENDDA
PSHFT TPR05 * T550A Daily Work Schedule SEQNO
PSHFT TPR05 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR05 * T550A Daily Work Schedule MOTPR
PSHFT TPR05 PSHFT TPR05 T550A Daily Work Schedule TPROG
PSHFT TPR05 PSHFT VAR05 T550A Daily Work Schedule VARIA
PSHFT TPR05 * T550A Daily Work Schedule ENDDA
PSHFT TPR06 * T550A Daily Work Schedule ENDDA
PSHFT TPR06 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPR06 * T550A Daily Work Schedule MOTPR
PSHFT TPR06 PSHFT TPR06 T550A Daily Work Schedule TPROG
PSHFT TPR06 PSHFT VAR06 T550A Daily Work Schedule VARIA
PSHFT TPR06 * T550A Daily Work Schedule SEQNO
PSHFT TPR07 * T550A Daily Work Schedule ENDDA
PSHFT TPR07 * T550A Daily Work Schedule SEQNO
PSHFT TPR07 PSHFT VAR07 T550A Daily Work Schedule VARIA
PSHFT TPR07 PSHFT TPR07 T550A Daily Work Schedule TPROG
PSHFT TPR07 * T550A Daily Work Schedule MOTPR
PSHFT TPR07 SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPROG SYST MANDT T550A Daily Work Schedule MANDT
PSHFT TPROG * T550A Daily Work Schedule MOTPR
PSHFT TPROG PSHFT TPROG T550A Daily Work Schedule TPROG
PSHFT TPROG PSHFT VARIA T550A Daily Work Schedule VARIA
PSHFT TPROG * T550A Daily Work Schedule SEQNO
PSHFT TPROG * T550A Daily Work Schedule ENDDA