SAP Table P2003

HR Time Record: Infotype 2003 (Substitutions)

P2003 (HR Time Record: Infotype 2003 (Substitutions)) 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 P2003 to other SAP tables.

P2003 table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY T582A CHAR 4 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
BEGUZ Start Time BEGUZ TIMS 6 0
ENDUZ End Time ENDUZ TIMS 6 0
VTKEN Previous Day Indicator VTKEN CHAR 1 0
X Yes
NULL No
VTART Substitution Type VTART T556 CHAR 2 0
STDAZ Substitution hours VTSTD DEC 7 2
PAMOD Work Break Schedule PAMOD T550P CHAR 4 0
PBEG1 Start of Break PDBEG TIMS 6 0
PEND1 End of Break PDEND TIMS 6 0
PBEZ1 Paid Break Period PDBEZ DEC 4 2
PUNB1 Unpaid Break Period PDUNB DEC 4 2
PBEG2 Start of Break PDBEG TIMS 6 0
PEND2 End of Break PDEND TIMS 6 0
PBEZ2 Paid Break Period PDBEZ DEC 4 2
PUNB2 Unpaid Break Period PDUNB DEC 4 2
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
MOTPR Personnel Subarea Grouping for Daily Work Schedules MOTPR NUMC 2 0
TPROG Daily Work Schedule TPROG T550A CHAR 4 0
VARIA Daily Work Schedule Variant VARIA CHAR 1 0
NULL blank = Standard variant
0
A
TAGTY Day Type TAGTY T553T CHAR 1 0
TPKLA Daily Work Schedule Class TPKLA CHAR 1 0
0 Daily work schedule class 0
1 Daily work schedule class 1
2 Daily work schedule class 2
3 Daily work schedule class 3
4 Daily work schedule class 4
5 Daily work schedule class 5
6 Daily work schedule class 6
7 Daily work schedule class 7
8 Daily work schedule class 8
9 Daily work schedule class 9
VPERN Substitute Personnel Number VPERN NUMC 8 0
AUFKZ Extra Pay Indicator AUFKN CHAR 1 0
NULL No extra pay: Valuation basis used as is
- Valuation basis used as amount deducted
+ Valuation basis used as amount added
BWGRL Valuation Basis for Different Payment PTM_VBAS7S CURR 13 2
TRFGR Pay Scale Group TRFGR CHAR 8 0
TRFST Pay Scale Level TRFST CHAR 2 0
PRAKN Premium Number PRAKN T510P CHAR 2 0
PRAKZ Premium Indicator PRAKZ NUMC 4 0
OTYPE Object Type OTYPE T778O CHAR 2 0
PLANS Position PLANS NUMC 8 0
EXBEL External Document Number EXBEL CHAR 8 0
WAERS Currency Key WAERS TCURC CUKY 5 0
WTART Work tax area WTART CHAR 4 0
TDLANGU Definition Set for IDs TMW_TDLANGU CHAR 10 0
TDSUBLA Definition Subset for IDs TMW_TDSUBLA CHAR 3 0
TDTYPE Time Data ID Type TDTYPE CHAR 4 0
LOGSYS Logical system LOGSYS CHAR 10 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWREF Reference Document Number AWREF CHAR 10 0
AWORG Reference Organizational Units AWORG CHAR 10 0
NXDFL Next Day Indicator PTM_NXDFL CHAR 1 0
X Yes
NULL No
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.

P2003 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P2003 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P2003 INFTY P2003 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P2003 MOFID P2003 MOFID THOCI Public holiday calendar index IDENT
P2003 MOSID SYST MANDT T508Z Assignment of PS Grouping for Work Schedules to Daily WS MANDT
P2003 MOSID P2003 MOSID T508Z Assignment of PS Grouping for Work Schedules to Daily WS MOSID
P2003 OTYPE SYST MANDT T778O Object Types MANDT
P2003 OTYPE P2003 OTYPE T778O Object Types OTYPE
P2003 PAMOD SY MANDT T550P Break Schedules MANDT
P2003 PAMOD P2003 MOTPR T550P Break Schedules MOTPR
P2003 PAMOD P2003 PAMOD T550P Break Schedules PAMOD
P2003 PAMOD * T550P Break Schedules SEQNO
P2003 PRAKN P2003 PRAKZ T510P Premium Table PRAKZ
P2003 PRAKN * T510P Premium Table ENDDA
P2003 PRAKN SYST MANDT T510P Premium Table MANDT
P2003 PRAKN T001P MOPTB T510P Premium Table MODIF
P2003 PRAKN P2003 PRAKN T510P Premium Table PRAKN
P2003 PREAS SYST MADNT T530E Reasons for Changes MANDT
P2003 PREAS P2003 INFTY T530E Reasons for Changes INFTY
P2003 PREAS P2003 PREAS T530E Reasons for Changes PREAS
P2003 SCHKZ SY MANDT T508A Work Schedule Rules MANDT
P2003 SCHKZ P2003 ZEITY T508A Work Schedule Rules ZEITY
P2003 SCHKZ P2003 MOFID T508A Work Schedule Rules MOFID
P2003 SCHKZ P2003 MOSID T508A Work Schedule Rules MOSID
P2003 SCHKZ P2003 SCHKZ T508A Work Schedule Rules SCHKZ
P2003 SCHKZ * T508A Work Schedule Rules ENDDA
P2003 TAGTY SYST LANGU T553T Day Type Texts SPRSL
P2003 TAGTY P2003 TAGTY T553T Day Type Texts TAGTY
P2003 TAGTY SYST MANDT T553T Day Type Texts MANDT
P2003 TPROG SY MANDT T550A Daily Work Schedule MANDT
P2003 TPROG P2003 MOTPR T550A Daily Work Schedule MOTPR
P2003 TPROG P2003 TPROG T550A Daily Work Schedule TPROG
P2003 TPROG * T550A Daily Work Schedule VARIA
P2003 TPROG * T550A Daily Work Schedule SEQNO
P2003 TPROG * T550A Daily Work Schedule ENDDA
P2003 VTART SYST MANDT T556 Substitution Types MANDT
P2003 VTART T001P MOVER T556 Substitution Types MOVER
P2003 VTART P2003 VTART T556 Substitution Types VTART
P2003 WAERS SYST MANDT TCURC Currency Codes MANDT
P2003 WAERS P2003 WAERS TCURC Currency Codes WAERS