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

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PA-PA-GB (Application Component) Great Britain
     ⤷ PB08 (Package) HR master data: UK

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIP0021LGB	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	FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
11	LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
12	SECONDNAME	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
13	ACADEMICTITLE	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
14	SURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
15	SECONDSURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
16	ARISTOCRATICTITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
17	FULLNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
18	MAIDENNAME	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
19	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
20	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
21	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
22	PLACEOFBIRTH	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
23	STATEOFBIRTH	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
24	LANDOFBIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
25	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
26	NATIONALITY2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
27	NATIONALITY3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
28	NAMEOFGENDER	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
29	NAMEOFSTATEOFBIRTH	☐	BEZEI20	TEXT20	CHAR	20	0	Description
30	NAMEOFLANDOFBIRTH	☐	LANDX	TEXT15	CHAR	15	0	Country Name
31	NAMEOFNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
32	NAMEOFNATIONALITY2	☐	NATIO	TEXT15	CHAR	15	0	Nationality
33	NAMEOFNATIONALITY3	☐	NATIO	TEXT15	CHAR	15	0	Nationality
34	NAMEOFMEMBERTYPE	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
35	MEMBEREMPLOYER	☐	EGAGA	VARGA	CHAR	8	0	Employer of Family Member
36	MEMBERREFNUMBER	☐	ERBNR	CHAR12	CHAR	12	0	Reference Personnel Number for Family Member
37	NAME_FORMAT_INDICATOR	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIP0021LGB	ACADEMICTITLE	T535N	TITEL
2	BAPIP0021LGB	ARISTOCRATICTITLE	T535N	TITEL
3	BAPIP0021LGB	LANDOFBIRTH	T005	LAND1
4	BAPIP0021LGB	NATIONALITY	T005	LAND1
5	BAPIP0021LGB	NATIONALITY2	T005	LAND1
6	BAPIP0021LGB	NATIONALITY3	T005	LAND1
7	BAPIP0021LGB	SECONDSURNAMEPREFIX	T535N	TITEL
8	BAPIP0021LGB	STATEOFBIRTH	T005S	BLAND
9	BAPIP0021LGB	SURNAMEPREFIX	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in