SAP ABAP Table P0021_ABA (HR Master Record: Infotype 0001 (Org. Assignment))

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-HR (Application Component) Cross-Application Objects in HR
     ⤷ BP (Package) Cross-Application Objects in HR

Basic Data

Table Category	INTTAB	Structure
Structure	P0021_ABA	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0001 (Org. Assignment)

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	HR Master Data Key
2	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype
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 Data: Administration Fields
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	*
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 Member/Dependents)
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	*
30	FANAT	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
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	*
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	*
43	FVRS2	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	*
44	FNMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	*
45	AHVNR	☐	AHVNR_ABA	CHAR11	CHAR	11	0	AHV Number
46	KDSVH	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	*
47	KDBSL	☐	KDBSL	AUSPR	CHAR	2	0	Allowance Authorization	*
48	KDUTB	☐	KDUTB	AUSPR	CHAR	2	0	Address of Child	*
49	KDGBR	☐	KDGBR	AUSPR	CHAR	2	0	Child Allowance Entitlement	*
50	KDART	☐	KDART	AUSPR	CHAR	2	0	Child Type	*
51	KDZUG	☐	KDZUG	AUSPR	CHAR	2	0	Child Bonuses	*
52	KDZUL	☐	KDZUL	AUSPR	CHAR	2	0	Child Allowances	*
53	KDVBE	☐	KDVBE	AUSPR	CHAR	2	0	Sickness Certificate Authorization	*
54	ERMNR	☐	ERMNR	CHAR8	CHAR	8	0	Authority Number
55	AUSVL	☐	AUSVL_ABA	NUM4	NUMC	4	0	1st Part of SI Number (Sequential Number)
56	AUSVG	☐	AUSVG_ABA	NUM8	NUMC	8	0	2nd Part of SI Number (Birth Date)
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	*
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	*
62	FANA3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	*
63	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
64	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	*
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	P0021_ABA	FANA2	T005	LAND1
2	P0021_ABA	FANA3	T005	LAND1
3	P0021_ABA	FANAT	T005	LAND1
4	P0021_ABA	FASAR	T517T	SLART
5	P0021_ABA	FGBLD	T005	LAND1
6	P0021_ABA	FGDEP	T005S	BLAND
7	P0021_ABA	FNMZU	T535N	TITEL
8	P0021_ABA	FVRS2	T535N	TITEL
9	P0021_ABA	FVRSW	T535N	TITEL
10	P0021_ABA	KDART	T577	AUSPR
11	P0021_ABA	KDBSL	T577	AUSPR
12	P0021_ABA	KDGBR	T577	AUSPR
13	P0021_ABA	KDSVH	T577	AUSPR
14	P0021_ABA	KDUTB	T577	AUSPR
15	P0021_ABA	KDVBE	T577	AUSPR
16	P0021_ABA	KDZUG	T577	AUSPR
17	P0021_ABA	KDZUL	T577	AUSPR
18	P0021_ABA	TITEL	T535N	TITEL

History

Last changed by/on	SAP	20110908
SAP Release Created in	640