P0414 SAP (HR Master Record for Infotype 0414) Structure details

Dictionary Type: Structure
Description: HR Master Record for Infotype 0414




ABAP Code to SELECT data from P0414
Related tables to P0414
Access table P0414




Structure field list including key, data, relationships and ABAP select examples

P0414 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "HR Master Record for Infotype 0414" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_P0414 TYPE P0414.

The P0414 table consists of various fields, each holding specific information or linking keys about HR Master Record for Infotype 0414 data available in SAP. These include PERNR (Personnel Number), INFTY (Infotype), SUBTY (Subtype), OBJPS (Object Identification).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP P0414 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4T582AINFOTYPITP
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
SCD01Seniority code PPL_SENCDCHAR2CHAR2
SID01Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY01Seniority period - years PPL_SENYYNUMC2NUMC2
SMM01Seniority period - months PPL_SENMMNUMC2NUM2
SDD01Seniority period - days PPL_SENDDNUMC3NUMC3
SCD02Seniority code PPL_SENCDCHAR2CHAR2
SID02Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY02Seniority period - years PPL_SENYYNUMC2NUMC2
SMM02Seniority period - months PPL_SENMMNUMC2NUM2
SDD02Seniority period - days PPL_SENDDNUMC3NUMC3
SCD03Seniority code PPL_SENCDCHAR2CHAR2
SID03Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY03Seniority period - years PPL_SENYYNUMC2NUMC2
SMM03Seniority period - months PPL_SENMMNUMC2NUM2
SDD03Seniority period - days PPL_SENDDNUMC3NUMC3
SCD04Seniority code PPL_SENCDCHAR2CHAR2
SID04Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY04Seniority period - years PPL_SENYYNUMC2NUMC2
SMM04Seniority period - months PPL_SENMMNUMC2NUM2
SDD04Seniority period - days PPL_SENDDNUMC3NUMC3
SCD05Seniority code PPL_SENCDCHAR2CHAR2
SID05Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY05Seniority period - years PPL_SENYYNUMC2NUMC2
SMM05Seniority period - months PPL_SENMMNUMC2NUM2
SDD05Seniority period - days PPL_SENDDNUMC3NUMC3
SCD06Seniority code PPL_SENCDCHAR2CHAR2
SID06Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY06Seniority period - years PPL_SENYYNUMC2NUMC2
SMM06Seniority period - months PPL_SENMMNUMC2NUM2
SDD06Seniority period - days PPL_SENDDNUMC3NUMC3
SCD07Seniority code PPL_SENCDCHAR2CHAR2
SID07Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY07Seniority period - years PPL_SENYYNUMC2NUMC2
SMM07Seniority period - months PPL_SENMMNUMC2NUM2
SDD07Seniority period - days PPL_SENDDNUMC3NUMC3
SCD08Seniority code PPL_SENCDCHAR2CHAR2
SID08Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY08Seniority period - years PPL_SENYYNUMC2NUMC2
SMM08Seniority period - months PPL_SENMMNUMC2NUM2
SDD08Seniority period - days PPL_SENDDNUMC3NUMC3
SCD09Seniority code PPL_SENCDCHAR2CHAR2
SID09Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY09Seniority period - years PPL_SENYYNUMC2NUMC2
SMM09Seniority period - months PPL_SENMMNUMC2NUM2
SDD09Seniority period - days PPL_SENDDNUMC3NUMC3
SCD10Seniority code PPL_SENCDCHAR2CHAR2
SID10Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY10Seniority period - years PPL_SENYYNUMC2NUMC2
SMM10Seniority period - months PPL_SENMMNUMC2NUM2
SDD10Seniority period - days PPL_SENDDNUMC3NUMC3
SCD11Seniority code PPL_SENCDCHAR2CHAR2
SID11Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY11Seniority period - years PPL_SENYYNUMC2NUMC2
SMM11Seniority period - months PPL_SENMMNUMC2NUM2
SDD11Seniority period - days PPL_SENDDNUMC3NUMC3
SCD12Seniority code PPL_SENCDCHAR2CHAR2
SID12Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY12Seniority period - years PPL_SENYYNUMC2NUMC2
SMM12Seniority period - months PPL_SENMMNUMC2NUM2
SDD12Seniority period - days PPL_SENDDNUMC3NUMC3
SCD13Seniority code PPL_SENCDCHAR2CHAR2
SID13Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY13Seniority period - years PPL_SENYYNUMC2NUMC2
SMM13Seniority period - months PPL_SENMMNUMC2NUM2
SDD13Seniority period - days PPL_SENDDNUMC3NUMC3
SCD14Seniority code PPL_SENCDCHAR2CHAR2
SID14Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY14Seniority period - years PPL_SENYYNUMC2NUMC2
SMM14Seniority period - months PPL_SENMMNUMC2NUM2
SDD14Seniority period - days PPL_SENDDNUMC3NUMC3
SCD15Seniority code PPL_SENCDCHAR2CHAR2
SID15Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY15Seniority period - years PPL_SENYYNUMC2NUMC2
SMM15Seniority period - months PPL_SENMMNUMC2NUM2
SDD15Seniority period - days PPL_SENDDNUMC3NUMC3
SCD16Seniority code PPL_SENCDCHAR2CHAR2
SID16Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY16Seniority period - years PPL_SENYYNUMC2NUMC2
SMM16Seniority period - months PPL_SENMMNUMC2NUM2
SDD16Seniority period - days PPL_SENDDNUMC3NUMC3
SCD17Seniority code PPL_SENCDCHAR2CHAR2
SID17Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY17Seniority period - years PPL_SENYYNUMC2NUMC2
SMM17Seniority period - months PPL_SENMMNUMC2NUM2
SDD17Seniority period - days PPL_SENDDNUMC3NUMC3
SCD18Seniority code PPL_SENCDCHAR2CHAR2
SID18Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY18Seniority period - years PPL_SENYYNUMC2NUMC2
SMM18Seniority period - months PPL_SENMMNUMC2NUM2
SDD18Seniority period - days PPL_SENDDNUMC3NUMC3
SCD19Seniority code PPL_SENCDCHAR2CHAR2
SID19Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY19Seniority period - years PPL_SENYYNUMC2NUMC2
SMM19Seniority period - months PPL_SENMMNUMC2NUM2
SDD19Seniority period - days PPL_SENDDNUMC3NUMC3
SCD20Seniority code PPL_SENCDCHAR2CHAR2
SID20Seniority identifier PPL_SENIDCHAR1PPL_SENID
SYY20Seniority period - years PPL_SENYYNUMC2NUMC2
SMM20Seniority period - months PPL_SENMMNUMC2NUM2
SDD20Seniority period - days PPL_SENDDNUMC3NUMC3
PERTXPeriod description PPL_PERTXCHAR50TEXT50
LDPERLeave days at previous employer PPL_LDPERDEC7(5) PPL_LDPER
EVRP6Evidence for RP-6 form code PPL_EVRP6CHAR1T7PLA0CHAR1
FLFLGFirst leave after 12 months flag PPL_FLFLGCHAR1FLAG
RLDPRRequested leave days at previous employer PPL_RLDPRDEC6(5) PPL_RLDPR
FEFLGFirst employment flag PPL_FEFLGCHAR1FLAG
CHALLChild Care Leave Deduction PPL_CHALLDEC7(5) PPL_LDPER
FAMALFamily member care leave PPL_FAMALDEC7(5) PPL_LDPER
CHL14Utilized Child Allowance < 14 years old PPL_CHL14DEC7(5) PPL_LDPER
PTURNDeduction rehabilitation leave for previous employer PPL_PTURNCHAR1CHAR1
LEAPELeave taken over from previous employer PPL_LEAPEDEC7(5) PPL_LDPER
GENLEForcing leave generation PPL_GENLECHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP structure P0414 using ABAP code?

As P0414 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on P0414 as there is no data to select.

How to access SAP table P0414

Within an ECC or HANA version of SAP you can also view further information about P0414 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!