SAP ABAP Table PEHV6 (Master personnel record infotype 0021 (Family members))

Hierarchy

☛ SAP_HRCVE (Software Component) Sub component SAP_HRCVE of SAP_HR
   ⤷ PA-PA-VE (Application Component) Venezuela
     ⤷ PB17 (Package) HR master data: Venezuela

Basic Data

Table Category	INTTAB	Structure
Structure	PEHV6	Table Relationship Diagram
Short Description	Master personnel record infotype 0021 (Family members)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Key for HR Master Data
2	EMPLOYEENO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	SUBTYPE	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJECTID	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	LOCKINDIC	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	VALIDEND	☐	ENDDA	DATUM	DATS	8	0	End Date
7	VALIDBEGIN	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	RECORDNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	MEMBERTYPE	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
10	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
11	LANDOFBIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	*
12	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
13	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
14	FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
15	LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
16	PLACEOFBIRTH	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
17	STATEOFBIRTH	☐	GBDEP	REGIO	CHAR	3	0	State	*
18	REFPERSNO	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
19	MAIDENNAME	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
20	SECONDNAME	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
21	FULLNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
22	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
23	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
24	SURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
25	SECONDSURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
26	ARISTOCRATICTITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
27	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
28	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
29	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
30	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
31	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
32	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
33	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
34	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
35	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
36	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
37	AUSVL	☐	PVE_VLSSO	NUM4	NUMC	4	0	1st part social insurance number
38	AUSVG	☐	PVE_VGSSO	NUM8	NUMC	8	0	2nd part social insurance number
39	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
40	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
41	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
42	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
43	NATIONALITY2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
44	NATIONALITY3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
45	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
46	ACADEMICTITLE	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
47	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
48	NAMEOFGENDER	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
49	NAMEOFSTATEOFBIRTH	☐	BEZEI20	TEXT20	CHAR	20	0	Description
50	NAMEOFLANDOFBIRTH	☐	LANDX	TEXT15	CHAR	15	0	Country Name
51	NAMEOFNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
52	NAMEOFNATIONALITY2	☐	NATIO	TEXT15	CHAR	15	0	Nationality
53	NAMEOFNATIONALITY3	☐	NATIO	TEXT15	CHAR	15	0	Nationality
54	NAMEOFMEMBERTYPE	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
55	DELIMIT_DATE	☐	HRDELIMITDATE	DATS	DATS	8	0	Key date for delimiting an infotype record
56	CARDIDNUMBER	☐	PVE_CEDU2	DEC9	DEC	9	0	Identity Card

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PEHV6	ACADEMICTITLE	T535N	TITEL
2	PEHV6	ARISTOCRATICTITLE	T535N	TITEL
3	PEHV6	FASAR	T517T	SLART
4	PEHV6	KDART	T577	AUSPR
5	PEHV6	KDBSL	T577	AUSPR
6	PEHV6	KDGBR	T577	AUSPR
7	PEHV6	KDSVH	T577	AUSPR
8	PEHV6	KDUTB	T577	AUSPR
9	PEHV6	KDVBE	T577	AUSPR
10	PEHV6	KDZUG	T577	AUSPR
11	PEHV6	KDZUL	T577	AUSPR
12	PEHV6	NATIONALITY2	T005	LAND1
13	PEHV6	NATIONALITY3	T005	LAND1
14	PEHV6	SECONDSURNAMEPREFIX	T535N	TITEL
15	PEHV6	SURNAMEPREFIX	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in	46B