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

Hierarchy

☛ SAP_HRCMY (Software Component) Sub component SAP_HRCMY of SAP_HR
   ⤷ PA-PA-MY (Application Component) Malaysia
     ⤷ PB14 (Package) HR master data: Malaysia

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIP0021MY	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	☐	P14_AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
52	AUSVG	☐	P14_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	HANCH	☐	P14_HANCH	XFELD	CHAR	1	0	Child handicap status
63	CHCUS	☐	P14_CHCUS	XFELD	CHAR	1	0	Child custody status
64	MARST	☐	P14_MARST	XFELD	CHAR	1	0	Marital status for income tax purpose (MY)
65	BTHID	☐	P14_BTHID	CHAR20	CHAR	20	0	Birth certificate ID
66	NAMEOFSCHOOLTYPE	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
67	NAMEOFGESCH	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
68	NAMEOFGBDEP	☐	BEZEI20	TEXT20	CHAR	20	0	Description
69	NAMEOFGBLND	☐	LANDX	TEXT15	CHAR	15	0	Country Name
70	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
71	NAMEOFNATI2	☐	NATIO	TEXT15	CHAR	15	0	Nationality
72	NAMEOFNATI3	☐	NATIO	TEXT15	CHAR	15	0	Nationality
73	NAMEOFFAMSA	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
74	DELIMIT_DATE	☐	HRDELIMITDATE	DATS	DATS	8	0	Key date for delimiting an infotype record
75	ICNUM	☐	ICNUM	ICNUM	CHAR	20	0	IC number
76	PASNR	☐	P14_PASNR	CHAR20	CHAR	20	0	Passport number
77	TNOEE	☐	P14_TNOEE	CHAR20	CHAR	20	0	Income tax number of employee (MY)
78	STXOF	☐	P14_STXOF	CHAR4	CHAR	4	0	Spouse tax office Malaysia
79	EBRNR	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
80	SEMPS	☐	P14_SEMPS	XFELD	CHAR	1	0	Spouse employment status
81	STLTX	☐	STLTX	TEXT25	CHAR	25	0	Job Title
82	SPEMR	☐	P14_SPEMR	CHAR40	CHAR	40	0	Spouse employer
83	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
84	RELATIONTEXT	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
85	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
86	LOCAT	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
87	ORT02	☐	ORT02	TEXT25	CHAR	25	0	District
88	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
89	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
90	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
91	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
92	NAME2	☐	CONAM	NACHN	CHAR	25	0	C/O Name
93	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
94	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
95	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
96	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
97	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
98	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
99	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
100	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
101	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
102	NAMEOFREGION	☐	BEZEI20	TEXT20	CHAR	20	0	Description

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	46B