SAP ABAP Table PB0465 (HR master record infotype 0465)

Hierarchy

☛ SAP_HRCBR (Software Component) Sub component SAP_HRCBR of SAP_HR
   ⤷ PA-PA-BR (Application Component) Brazil
     ⤷ PB37 (Package) HR master data: Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PB0465	Table Relationship Diagram
Short Description	HR master record infotype 0465

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Key for applicant data
3	PERNR	☑	APLNO	APLNO	NUMC	8	0	Applicant number	PB4004
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	HR master record infotype 0465 (Documents)
27	TPDOC	☐	TPDOC	SUBTY_591A	CHAR	4	0	Document Type	T591A
28	DT_EMIS	☐	PBR_DEMIS	DATE	DATS	8	0	Document's Issue Date
29	ES_EMIS	☐	PBR_ESTAD	PBR_ESTAD	CHAR	3	0	State (FU)	*
30	CPF_NR	☐	PBR_CPFNR	PBR_CPFNR	CHAR	15	0	Sole Proprietor's Registry number (CPF)
31	IDENT_NR	☐	PBR_IDNR	PBR_IDNR	CHAR	16	0	Identification Document number
32	IDENT_ORG	☐	PBR_IDORG	PBR_IDORG	CHAR	8	0	Identification Document Issuer
33	CTPS_NR	☐	PBR_CTNR	PBR_CTNR	CHAR	10	0	Worker's Card for Social Welfare number - WCSW
34	CTPS_SERIE	☐	PBR_CTSR	PBR_CTSR	CHAR	6	0	Worker's Card series number - WCSW
35	CREG_NR	☐	PBR_CRNR	PBR_CRNR	CHAR	15	0	Regional Council register number
36	CREG_NAME	☐	PBR_CRNAM	PBR_CRNAM	CHAR	90	0	Regional Council name
37	CREG_INIT	☐	PBR_CRIN	PBR_CRIN	CHAR	10	0	Regional Council abbreviation
38	ELEC_NR	☐	PBR_ELECN	PBR_ELECN	CHAR	15	0	Voter Registration Card number
39	ELEC_ZONE	☐	PBR_ELECZ	PBR_ELECZ	CHAR	5	0	Voter Registration Card area
40	ELEC_SECT	☐	PBR_ELECS	PBR_ELECS	CHAR	5	0	Voting Section
41	PIS_NR	☐	PBR_PSNR	PBR_PSNR	CHAR	20	0	SIP/PSHFP number
42	MIL_NR	☐	PBR_MILNR	PBR_MILNR	CHAR	12	0	Military Certificate number
43	MIL_TYPE	☐	PBR_MILTY	PBR_MILTY	CHAR	8	0	Military Certificate type
44	MIL_CAT	☐	PBR_MILCA	PBR_MILCA	CHAR	3	0	Military Certificate category
45	IDFOR_NR	☐	PBR_IDFNR	PBR_IDFNR	CHAR	20	0	Foreign Identification Document number
46	VISA_NR	☐	PBR_VISNR	PBR_VISNR	CHAR	6	0	Visa series number
47	VISA_TYPE	☐	PBR_VISTY	PBR_VISTY	CHAR	20	0	Type of Visa
48	MARRY_BR	☐	PBR_MARBR	XFELD	CHAR	1	0	Brazilian spouse
49	DT_ARRV	☐	PBR_DTARR	DATE	DATS	8	0	Date of arrival in Brazil
50	DRIVE_NR	☐	PBR_DRVNR	PBR_DRVNR	CHAR	12	0	Professional Driver's License number
51	DRIVE_CAT	☐	PBR_DRVCT	PBR_DRVCT	CHAR	3	0	Driver's License category
52	PASSP_NR	☐	PBR_PASNR	PBR_PASNR	CHAR	15	0	Passport number
53	NIT_NR	☐	PBR_NITNR	PBR_NITNR	CHAR	11	0	Employee Identification Number - EIN
54	CARTO	☐	PBR_CARTO	TEXT40	CHAR	40	0	Name of public notary
55	CDEAT	☐	PBR_CDEAT	TEXT10	CHAR	10	0	Death certificate
56	DEATH	☐	PBR_DEATH	DATE	DATS	8	0	Date of death notification
57	CAUDE	☐	PBR_CAUDE	PBR_CAUDE	CHAR	1	0	Cause of death
58	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PB0465	PERNR	PB4004	PERNR
2	PB0465	PREAS	T530E	PREAS
3	PB0465	TPDOC	T591A	SUBTY	KEY	1	CN

History

Last changed by/on	SAP	20080626
SAP Release Created in	46C