SAP Table P0465

HR master record for infotype 0465

P0465 (HR master record for infotype 0465) 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 P0465 to other SAP tables.

P0465 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
TPDOC Document Type TPDOC T591A CHAR 4 0
DT_EMIS Document's Issue Date PBR_DEMIS DATS 8 0
ES_EMIS State (FU) PBR_ESTAD CHAR 3 0
AC Acre
AL Alagoas
AM Amazonas
AP Amap�
BA Bahia
CE Cear�
DF Distrito Federal
ES Esp�rito Santo
GO Goi�s
MA Maranh�o
MG Minas Gerais
MS Mato Grosso do Sul
MT Mato Grosso
PA Par�
PB Para�ba
PE Pernambuco
PI Piau�
PR Paran�
RJ Rio de Janeiro
RN Rio Grande do Norte
RO Rond�nia
RR Roraima
RS Rio Grande do Sul
SC Santa Catarina
SE Sergipe
SP S�o Paulo
TO Tocantins
CPF_NR Sole Proprietor's Registry number (CPF) PBR_CPFNR CHAR 15 0
IDENT_NR Identification Document number PBR_IDNR CHAR 16 0
IDENT_ORG Identification Document Issuer PBR_IDORG CHAR 8 0
CTPS_NR Worker's Card for Social Welfare number - WCSW PBR_CTNR CHAR 10 0
CTPS_SERIE Worker's Card series number - WCSW PBR_CTSR CHAR 6 0
CREG_NR Regional Council register number PBR_CRNR CHAR 15 0
CREG_NAME Regional Council name PBR_CRNAM CHAR 90 0
CREG_INIT Regional Council abbreviation PBR_CRIN CHAR 10 0
ELEC_NR Voter Registration Card number PBR_ELECN CHAR 15 0
ELEC_ZONE Voter Registration Card area PBR_ELECZ CHAR 5 0
ELEC_SECT Voting Section PBR_ELECS CHAR 5 0
PIS_NR SIP/PSHFP number PBR_PSNR CHAR 20 0
MIL_NR Military Certificate number PBR_MILNR CHAR 12 0
MIL_TYPE Military Certificate type PBR_MILTY CHAR 8 0
MIL_CAT Military Certificate category PBR_MILCA CHAR 3 0
IDFOR_NR Foreign Identification Document number PBR_IDFNR CHAR 20 0
VISA_NR Visa series number PBR_VISNR CHAR 6 0
VISA_TYPE Type of Visa PBR_VISTY CHAR 20 0
MARRY_BR Brazilian spouse PBR_MARBR CHAR 1 0
X Yes
NULL No
DT_ARRV Date of arrival in Brazil PBR_DTARR DATS 8 0
DRIVE_NR Professional Driver's License number PBR_DRVNR CHAR 12 0
DRIVE_CAT Driver's License category PBR_DRVCT CHAR 3 0
PASSP_NR Passport number PBR_PASNR CHAR 15 0
NIT_NR Employee Identification Number - EIN PBR_NITNR CHAR 11 0
CARTO Name of public notary PBR_CARTO CHAR 40 0
CDEAT Death certificate PBR_CDEAT CHAR 10 0
DEATH Date of death notification PBR_DEATH DATS 8 0
CAUDE Cause of death PBR_CAUDE CHAR 1 0
1 Natural
2 Non-natural
CHILDBR Children with Brazilian indicator HRPADBR_BRAZIL_CHILD CHAR 1 0

P0465 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0465 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0465 INFTY P0465 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0465 PREAS SYST MADNT T530E Reasons for Changes MANDT
P0465 PREAS P0465 INFTY T530E Reasons for Changes INFTY
P0465 PREAS P0465 PREAS T530E Reasons for Changes PREAS
P0465 TPDOC SYST MANDT T591A Subtype Characteristics MANDT
P0465 TPDOC '0465' T591A Subtype Characteristics INFTY
P0465 TPDOC P0465 TPDOC T591A Subtype Characteristics SUBTY