SAP ABAP Table BAPIP0021LMY (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	BAPIP0021LMY	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	.INCLUDE	☐				0	0	Key for HR Master Data
2	EMPLOYEENO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	SUBTYPE	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJECTID	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	LOCKINDIC	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	VALIDEND	☐	ENDDA	DATUM	DATS	8	0	End Date
7	VALIDBEGIN	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	RECORDNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	MEMBERTYPE	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
10	MEMBERID	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
11	RELATIONSHIP	☐	KDSVH	AUSPR	CHAR	2	0	Relationship to Child	*
12	FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
13	LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
14	SURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
15	FULLNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
16	MAIDENNAME	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
17	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
18	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
19	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
20	PLACEOFBIRTH	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
21	LANDOFBIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
22	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
23	NAMEOFMEMBERTYPE	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
24	NAMEOFGENDER	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
25	NAMEOFLANDOFBIRTH	☐	LANDX	TEXT15	CHAR	15	0	Country Name
26	NAMEOFNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
27	NAMEOFSCHOOLTYPE	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
28	RELATIONTEXT	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
29	PERSONALID	☐	ICNUM	ICNUM	CHAR	20	0	IC number
30	PASSPORTNUMBER	☐	P14_PASNR	CHAR20	CHAR	20	0	Passport number
31	TAXNUMBER	☐	P14_TNOEE	CHAR20	CHAR	20	0	Income tax number of employee (MY)
32	TAXOFFICE	☐	P14_STXOF	CHAR4	CHAR	4	0	Spouse tax office Malaysia
33	REFERENCENUMBER	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
34	EMPLOYMENTSTATUS	☐	P14_SEMPS	XFELD	CHAR	1	0	Spouse employment status
35	JOBTITLE	☐	STLTX	TEXT25	CHAR	25	0	Job Title
36	EMPLOYERNAME	☐	P14_SPEMR	CHAR40	CHAR	40	0	Spouse employer
37	NAMEFORMAT	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
38	SCHOOLTYPE	☐	FASAR	SLART	CHAR	2	0	School Type of Family Member	*
39	BIRTHCERTIFICATEID	☐	P14_BTHID	CHAR20	CHAR	20	0	Birth certificate ID
40	HANDICAPPED	☐	P14_HANCH	XFELD	CHAR	1	0	Child handicap status
41	CHILDCUSTODY	☐	P14_CHCUS	XFELD	CHAR	1	0	Child custody status
42	MARITALSTATUS	☐	P14_MARST	XFELD	CHAR	1	0	Marital status for income tax purpose (MY)
43	STREET	☐	STRAS	TEXT30	CHAR	30	0	House number and street
44	SECONDADDRESS	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
45	THIRDADDRESS	☐	ORT02	TEXT25	CHAR	25	0	District
46	POSTALCODE	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
47	CITY	☐	ORT01	TEXT25	CHAR	25	0	City
48	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
49	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
50	CONAME	☐	CONAM	NACHN	CHAR	25	0	C/O Name
51	TELEPHONENUMBER	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
52	COMMTYPE1	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
53	COMMNUMBER1	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
54	COMMTYPE2	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
55	COMMNUMBER2	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
56	COMMTYPE3	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
57	COMMNUMBER3	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
58	COMMTYPE4	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
59	COMMNUMBER4	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
60	NAMEOFREGION	☐	BEZEI20	TEXT20	CHAR	20	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIP0021LMY	LANDOFBIRTH	T005	LAND1
2	BAPIP0021LMY	NATIONALITY	T005	LAND1
3	BAPIP0021LMY	SURNAMEPREFIX	T535N	TITEL

History

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