SAP ABAP Table BAPIP0002L (HR Master Record: Infotype 0002 (Personal Data))

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	BAPIP0002L	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0002 (Personal Data)

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	FORMOFADDRESS	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	*
10	FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
11	LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
12	NAMEATBIRTH	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
13	SECONDNAME	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
14	MIDDLENAME	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
15	FULLNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
16	KNOWNAS	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
17	ACADEMICGRADE	☐	TITEL	TITEL	CHAR	15	0	Title	*
18	SECONDACADGRADE	☐	TITL2	TITEL	CHAR	15	0	Second Title	*
19	ARISTROCRATICTITLE	☐	NAMZU	TITEL	CHAR	15	0	Other Title	*
20	SURNAMEPREFIX	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	*
21	SECONDNAMEPREFIX	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	*
22	INITIALS	☐	INITS	TEXT10	CHAR	10	0	Initials
23	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
24	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
25	BIRTHPLACE	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
26	STATEOFBIRTH	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
27	COUNTRYOFBIRTH	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
28	MARITALSTATUS	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
29	MARITALSTATUSSINCE	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
30	NUMBEROFCHILDREN	☐	ANZKC	NUM3	NUMC	3	0	Number of Children
31	RELIGION	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	T516T
32	LANGUAGE	☐	SPRSL	SPRAS	LANG	1	0	Language Key	T002
33	LANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
34	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
35	SECONDNATIONALITY	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
36	THIRDNATIONALITY	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
37	IDNUMBER	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
38	NAMEOFFORMOFADDRESS	☐	ANRLT	TEXT15	CHAR	15	0	Long Text: Form of Address
39	NAMEOFGENDER	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
40	NAMEOFSTATEOFBIRTH	☐	BEZEI20	TEXT20	CHAR	20	0	Description
41	NAMEOFCOUNTRYOFBIRTH	☐	LANDX	TEXT15	CHAR	15	0	Country Name
42	NAMEOFMARITALSTATUS	☐	FATXT	FATXT	CHAR	6	0	Marital Status
43	NAMEOFRELIGION	☐	KNFTX	TEXT25	CHAR	25	0	Religious Denomination Long Text
44	NAMEOFLANGUAGE	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
45	NAMEOFNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
46	NAMEOFSECONDNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
47	NAMEOFTHIRDNATIONALITY	☐	NATIO	TEXT15	CHAR	15	0	Nationality
48	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	BAPIP0002L	COUNTRYOFBIRTH	T005	LAND1
2	BAPIP0002L	LANGUAGE	T002	SPRAS
3	BAPIP0002L	NATIONALITY	T005	LAND1
4	BAPIP0002L	RELIGION	T516T	KONFE
5	BAPIP0002L	SECONDNATIONALITY	T005	LAND1
6	BAPIP0002L	STATEOFBIRTH	T005S	BLAND
7	BAPIP0002L	THIRDNATIONALITY	T005	LAND1

History

Last changed by/on	SAP	20140117
SAP Release Created in