1. Home
  2. Resources
  3. SAP Tables
  4. P0414 - HR Master Record for Infotype 0414

SAP Table P0414

HR Master Record for Infotype 0414

P0414 (HR Master Record for Infotype 0414) 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 P0414 to other SAP tables.

P0414 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
SCD01 Seniority code PPL_SENCD CHAR 2 0
SID01 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY01 Seniority period - years PPL_SENYY NUMC 2 0
SMM01 Seniority period - months PPL_SENMM NUMC 2 0
SDD01 Seniority period - days PPL_SENDD NUMC 3 0
SCD02 Seniority code PPL_SENCD CHAR 2 0
SID02 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY02 Seniority period - years PPL_SENYY NUMC 2 0
SMM02 Seniority period - months PPL_SENMM NUMC 2 0
SDD02 Seniority period - days PPL_SENDD NUMC 3 0
SCD03 Seniority code PPL_SENCD CHAR 2 0
SID03 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY03 Seniority period - years PPL_SENYY NUMC 2 0
SMM03 Seniority period - months PPL_SENMM NUMC 2 0
SDD03 Seniority period - days PPL_SENDD NUMC 3 0
SCD04 Seniority code PPL_SENCD CHAR 2 0
SID04 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY04 Seniority period - years PPL_SENYY NUMC 2 0
SMM04 Seniority period - months PPL_SENMM NUMC 2 0
SDD04 Seniority period - days PPL_SENDD NUMC 3 0
SCD05 Seniority code PPL_SENCD CHAR 2 0
SID05 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY05 Seniority period - years PPL_SENYY NUMC 2 0
SMM05 Seniority period - months PPL_SENMM NUMC 2 0
SDD05 Seniority period - days PPL_SENDD NUMC 3 0
SCD06 Seniority code PPL_SENCD CHAR 2 0
SID06 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY06 Seniority period - years PPL_SENYY NUMC 2 0
SMM06 Seniority period - months PPL_SENMM NUMC 2 0
SDD06 Seniority period - days PPL_SENDD NUMC 3 0
SCD07 Seniority code PPL_SENCD CHAR 2 0
SID07 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY07 Seniority period - years PPL_SENYY NUMC 2 0
SMM07 Seniority period - months PPL_SENMM NUMC 2 0
SDD07 Seniority period - days PPL_SENDD NUMC 3 0
SCD08 Seniority code PPL_SENCD CHAR 2 0
SID08 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY08 Seniority period - years PPL_SENYY NUMC 2 0
SMM08 Seniority period - months PPL_SENMM NUMC 2 0
SDD08 Seniority period - days PPL_SENDD NUMC 3 0
SCD09 Seniority code PPL_SENCD CHAR 2 0
SID09 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY09 Seniority period - years PPL_SENYY NUMC 2 0
SMM09 Seniority period - months PPL_SENMM NUMC 2 0
SDD09 Seniority period - days PPL_SENDD NUMC 3 0
SCD10 Seniority code PPL_SENCD CHAR 2 0
SID10 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY10 Seniority period - years PPL_SENYY NUMC 2 0
SMM10 Seniority period - months PPL_SENMM NUMC 2 0
SDD10 Seniority period - days PPL_SENDD NUMC 3 0
SCD11 Seniority code PPL_SENCD CHAR 2 0
SID11 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY11 Seniority period - years PPL_SENYY NUMC 2 0
SMM11 Seniority period - months PPL_SENMM NUMC 2 0
SDD11 Seniority period - days PPL_SENDD NUMC 3 0
SCD12 Seniority code PPL_SENCD CHAR 2 0
SID12 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY12 Seniority period - years PPL_SENYY NUMC 2 0
SMM12 Seniority period - months PPL_SENMM NUMC 2 0
SDD12 Seniority period - days PPL_SENDD NUMC 3 0
SCD13 Seniority code PPL_SENCD CHAR 2 0
SID13 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY13 Seniority period - years PPL_SENYY NUMC 2 0
SMM13 Seniority period - months PPL_SENMM NUMC 2 0
SDD13 Seniority period - days PPL_SENDD NUMC 3 0
SCD14 Seniority code PPL_SENCD CHAR 2 0
SID14 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY14 Seniority period - years PPL_SENYY NUMC 2 0
SMM14 Seniority period - months PPL_SENMM NUMC 2 0
SDD14 Seniority period - days PPL_SENDD NUMC 3 0
SCD15 Seniority code PPL_SENCD CHAR 2 0
SID15 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY15 Seniority period - years PPL_SENYY NUMC 2 0
SMM15 Seniority period - months PPL_SENMM NUMC 2 0
SDD15 Seniority period - days PPL_SENDD NUMC 3 0
SCD16 Seniority code PPL_SENCD CHAR 2 0
SID16 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY16 Seniority period - years PPL_SENYY NUMC 2 0
SMM16 Seniority period - months PPL_SENMM NUMC 2 0
SDD16 Seniority period - days PPL_SENDD NUMC 3 0
SCD17 Seniority code PPL_SENCD CHAR 2 0
SID17 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY17 Seniority period - years PPL_SENYY NUMC 2 0
SMM17 Seniority period - months PPL_SENMM NUMC 2 0
SDD17 Seniority period - days PPL_SENDD NUMC 3 0
SCD18 Seniority code PPL_SENCD CHAR 2 0
SID18 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY18 Seniority period - years PPL_SENYY NUMC 2 0
SMM18 Seniority period - months PPL_SENMM NUMC 2 0
SDD18 Seniority period - days PPL_SENDD NUMC 3 0
SCD19 Seniority code PPL_SENCD CHAR 2 0
SID19 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY19 Seniority period - years PPL_SENYY NUMC 2 0
SMM19 Seniority period - months PPL_SENMM NUMC 2 0
SDD19 Seniority period - days PPL_SENDD NUMC 3 0
SCD20 Seniority code PPL_SENCD CHAR 2 0
SID20 Seniority identifier PPL_SENID CHAR 1 0
0 Not subject
+ Increase period
- Decrease period
SYY20 Seniority period - years PPL_SENYY NUMC 2 0
SMM20 Seniority period - months PPL_SENMM NUMC 2 0
SDD20 Seniority period - days PPL_SENDD NUMC 3 0
PERTX Period description PPL_PERTX CHAR 50 0
LDPER Leave days at previous employer PPL_LDPER DEC 7 5
EVRP6 Evidence for RP-6 form code PPL_EVRP6 T7PLA0 CHAR 1 0
FLFLG First leave after 12 months flag PPL_FLFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RLDPR Requested leave days at previous employer PPL_RLDPR DEC 6 5
FEFLG First employment flag PPL_FEFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
CHALL Child Care Leave Deduction PPL_CHALL DEC 7 5
FAMAL Family member care leave PPL_FAMAL DEC 7 5
CHL14 Utilized Child Allowance < 14 years old PPL_CHL14 DEC 7 5
PTURN Deduction rehabilitation leave for previous employer PPL_PTURN CHAR 1 0
LEAPE Leave taken over from previous employer PPL_LEAPE DEC 7 5
GENLE Forcing leave generation PPL_GENLE CHAR 1 0

P0414 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0414 EVRP6 * T7PLA0 Evidence codes for RP-6 form MANDT
P0414 EVRP6 P0414 EVRP6 T7PLA0 Evidence codes for RP-6 form EVRP6
P0414 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0414 INFTY P0414 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0414 PREAS SYST MADNT T530E Reasons for Changes MANDT
P0414 PREAS P0414 INFTY T530E Reasons for Changes INFTY
P0414 PREAS P0414 PREAS T530E Reasons for Changes PREAS