SAP Table P2051
HR Time Record: Infotype 2051 (Monthly Calendar)
P2051 (HR Time Record: Infotype 2051 (Monthly Calendar)) 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 P2051 to other SAP tables.
P2051 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 |
Possible values
|
||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | BEGTI | TIMS | 6 | 0 | |||||||||
| ENDUZ | End Time | ENDTI | TIMS | 6 | 0 | |||||||||
| VTKEN | Previous Day Indicator | VTKEN | CHAR | 1 | 0 |
Possible values
|
||||||||
| WEEKN | Week | WEEKN | CHAR | 2 | 0 | |||||||||
| FIDAY | First day | FIDAY | CHAR | 2 | 0 | |||||||||
| LADAY | Last day | LADAY | CHAR | 2 | 0 | |||||||||
| TPR01 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG01 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ01 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR01 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR02 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG02 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ02 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR02 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR03 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG03 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ03 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR03 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR04 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG04 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ04 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR04 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR05 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG05 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ05 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR05 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR06 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG06 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ06 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR06 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
| TPR07 | Daily Work Schedule | TPROG | T550A | CHAR | 4 | 0 | ||||||||
| TAG07 | Absence/attendance category | ABSTP | CHAR | 1 | 0 | |||||||||
| KNZ07 | Indicator for time infotypes | KNINF | CHAR | 4 | 0 | |||||||||
| VAR07 | Daily Work Schedule Variant | VARIA | CHAR | 1 | 0 |
Possible values
|
||||||||
P2051 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P2051 | INFTY | P2051 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P2051 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P2051 | PREAS | SYST | MANDT | T530E | Reasons for Changes | MANDT |
| P2051 | PREAS | P2051 | INFTY | T530E | Reasons for Changes | INFTY |
| P2051 | PREAS | P2051 | PREAS | T530E | Reasons for Changes | PREAS |
| P2051 | TPR01 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR01 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR01 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR01 | P2051 | TPR01 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR01 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR01 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR02 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR02 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR02 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR02 | P2051 | TPR02 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR02 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR02 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR03 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR03 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR03 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR03 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR03 | P2051 | TPR03 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR03 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR04 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR04 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR04 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR04 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR04 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR04 | P2051 | TPR04 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR05 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR05 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR05 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR05 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR05 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR05 | P2051 | TPR05 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR06 | P2051 | TPR06 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR06 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR06 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR06 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR06 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
| P2051 | TPR06 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR07 | T508Z | MOTPR | T550A | Daily Work Schedule | MOTPR |
| P2051 | TPR07 | P2051 | TPR07 | T550A | Daily Work Schedule | TPROG |
| P2051 | TPR07 | * | T550A | Daily Work Schedule | VARIA | |
| P2051 | TPR07 | * | T550A | Daily Work Schedule | SEQNO | |
| P2051 | TPR07 | * | T550A | Daily Work Schedule | ENDDA | |
| P2051 | TPR07 | SYST | MANDT | T550A | Daily Work Schedule | MANDT |
