SAP ABAP Table PA0021 (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	TRANSP	Transparent table
Transparent table	PA0021	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0021 (Family)

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	T000
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
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 0021 (Family)
27	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
28	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
29	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
30	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
31	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
32	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
33	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
34	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
35	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
36	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
37	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
38	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
39	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
40	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
41	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
42	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
43	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
44	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
45	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
46	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
47	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
48	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
49	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
50	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
51	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
52	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
53	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
54	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
55	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
56	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
57	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
58	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
59	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
60	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
61	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
62	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
63	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
64	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
65	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
66	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in