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

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-PA (Application Component) Personnel Administration
     ⤷ PBAS (Package) SAP HR Master Data Application Development

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIP0021	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	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
2	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
3	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
12	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
13	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
14	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
15	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
16	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
17	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
18	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
19	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
22	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
23	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
24	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
25	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
26	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
27	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
28	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
29	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
30	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
31	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	*
32	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
33	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
34	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
35	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
36	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
37	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
38	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
39	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
40	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
41	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
42	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
43	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
44	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
45	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
46	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
47	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
48	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
49	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
50	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
51	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
52	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
53	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
54	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
55	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
56	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
57	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
58	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
59	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
60	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
61	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
62	NAMEOFGESCH	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
63	NAMEOFGBDEP	☐	BEZEI20	TEXT20	CHAR	20	0	Description
64	NAMEOFGBLND	☐	LANDX	TEXT15	CHAR	15	0	Country Name
65	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
66	NAMEOFNATI2	☐	NATIO	TEXT15	CHAR	15	0	Nationality
67	NAMEOFNATI3	☐	NATIO	TEXT15	CHAR	15	0	Nationality
68	NAMEOFFAMSA	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
69	DELIMIT_DATE	☐	HRDELIMITDATE	DATS	DATS	8	0	Key date for delimiting an infotype record

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in