SAP ABAP Table P0021 (HR Master Record: Infotype 0021 (Family))

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	P0021	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0021 (Family)

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in