SAP ABAP Table BAPIP0021LNL (HR Master Record: Infotype 0021 (Family/Rel.Person))

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PA-PA-NL (Application Component) Netherlands
     ⤷ PB05 (Package) HR Master Data: Netherlands

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIP0021LNL	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0021 (Family/Rel.Person)

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	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
10	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
11	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
12	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
13	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
14	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
15	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
16	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
17	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	*
18	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
19	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
20	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
21	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
22	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
23	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
24	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
25	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
26	FNMZU	☐	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	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
38	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
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	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
44	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
45	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
46	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
47	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
48	NAMEOFGESCH	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
49	NAMEOFGBDEP	☐	BEZEI20	TEXT20	CHAR	20	0	Description
50	NAMEOFGBLND	☐	LANDX	TEXT15	CHAR	15	0	Country Name
51	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
52	NAMEOFNATI2	☐	NATIO	TEXT15	CHAR	15	0	Nationality
53	NAMEOFNATI3	☐	NATIO	TEXT15	CHAR	15	0	Nationality
54	NAMEOFFAMSA	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
55	DELIMIT_DATE	☐	HRDELIMITDATE	DATS	DATS	8	0	Key date for delimiting an infotype record
56	ZKVGP	☐	P05_ZKVGP	P05_ZKVGP	CHAR	2	0	Private Health Insurance Group
57	PKLAS	☐	P05_PKLAS	P05_PKLAS	CHAR	2	0	Contribution Scale for Health Insurance	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIP0021LNL	FANA2	T005	LAND1
2	BAPIP0021LNL	FANA3	T005	LAND1
3	BAPIP0021LNL	FANAT	T005	LAND1
4	BAPIP0021LNL	FASAR	T517T	SLART
5	BAPIP0021LNL	FGBLD	T005	LAND1
6	BAPIP0021LNL	FNMZU	T535N	TITEL
7	BAPIP0021LNL	FVRS2	T535N	TITEL
8	BAPIP0021LNL	FVRSW	T535N	TITEL
9	BAPIP0021LNL	KDART	T577	AUSPR
10	BAPIP0021LNL	KDBSL	T577	AUSPR
11	BAPIP0021LNL	KDGBR	T577	AUSPR
12	BAPIP0021LNL	KDSVH	T577	AUSPR
13	BAPIP0021LNL	KDUTB	T577	AUSPR
14	BAPIP0021LNL	KDVBE	T577	AUSPR
15	BAPIP0021LNL	KDZUG	T577	AUSPR
16	BAPIP0021LNL	KDZUL	T577	AUSPR
17	BAPIP0021LNL	TITEL	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in