SAP ABAP Table PS0021 (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	PS0021	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	FAMSA	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
2	FGBDT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
3	FGBLD	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
4	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
5	FASEX	☐	GESCH	GESCH	CHAR	1	0	Gender Key
6	FAVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
7	FANAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
8	FGBOT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
9	FGDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
10	ERBNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
11	FGBNA	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
12	FNAC2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
13	FCNAM	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
14	FKNZN	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
15	FINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
16	FVRSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
17	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
18	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
19	AHVNR	☐	AHVNR	P02_AHVNR	CHAR	11	0	AHV Number
20	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	T577
21	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	T577
22	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	T577
23	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	T577
24	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	T577
25	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	T577
26	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	T577
27	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	T577
28	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
29	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
30	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
31	FASDT	☐	FASDT	DATUM	DATS	8	0	End of Family Member's Education/Training
32	FASAR	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	T517T
33	FASIN	☐	FASIN	TEXT20	CHAR	20	0	Educational Institute
34	EGAGA	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
35	FANA2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
36	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
37	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
38	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
39	EMRGN	☐	PAD_EMRGN	XFELD	CHAR	1	0	Emergency Contact
40	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in