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

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-PA (Application Component) Personnel Administration
     ⤷ PBAS (Package) SAP HR Master Data Application Development

Basic Data

Table Category	INTTAB	Structure
Structure	P0002	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	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	HR Master Record: Infotype 0002 (Personal Data)
28	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
29	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
30	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
31	NACH2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
32	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
33	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
34	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
35	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	T535N
36	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
37	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
38	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	T535N
39	RUFNM	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
40	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
41	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
42	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
43	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
44	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
45	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
46	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
47	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
48	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
49	NATI2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
50	NATI3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
51	SPRSL	☐	PAD_SPRAS	SPRAS	LANG	1	0	Communication Language	T002
52	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
53	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
54	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
55	ANZKD	☐	ANZKD	DEC03	DEC	3	0	Number of Children
56	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
57	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
58	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
59	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
60	FNAMK	☐	P22J_PFNMK	P22J_PNAME	CHAR	40	0	First name (Katakana)
61	LNAMK	☐	P22J_PLNMK	P22J_PNAME	CHAR	40	0	Last name (Katakana)
62	FNAMR	☐	P22J_PFNMR	P22J_PNAME	CHAR	40	0	First Name (Romaji)
63	LNAMR	☐	P22J_PLNMR	P22J_PNAME	CHAR	40	0	Last Name (Romaji)
64	NABIK	☐	P22J_PNBIK	P22J_PNAME	CHAR	40	0	Name of Birth (Katakana)
65	NABIR	☐	P22J_PNBIR	P22J_PNAME	CHAR	40	0	Name of Birth (Romaji)
66	NICKK	☐	P22J_PNCKK	P22J_PNAME	CHAR	40	0	Koseki (Katakana)
67	NICKR	☐	P22J_PNCKR	P22J_PNAME	CHAR	40	0	Koseki (Romaji)
68	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
69	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
70	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
71	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
72	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
73	NAMZ2	☐	NAMZ2	TITEL	CHAR	15	0	Name Affix for Name at Birth	T535N
74	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0002	ANRED	T522G	ANRED
2	P0002	GBDEP	T005S	BLAND
3	P0002	GBLND	T005	LAND1
4	P0002	INFTY	T582A	INFTY
5	P0002	NAMZ2	T535N	TITEL
6	P0002	NAMZU	T535N	TITEL
7	P0002	NATI2	T005	LAND1
8	P0002	NATI3	T005	LAND1
9	P0002	NATIO	T005	LAND1
10	P0002	PREAS	T530E	PREAS
11	P0002	SPRSL	T002	SPRAS
12	P0002	TITEL	T535N	TITEL
13	P0002	TITL2	T535N	TITEL
14	P0002	VORS2	T535N	TITEL
15	P0002	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in