SAP ABAP Table HRWPC_S_PERSONALDATA (Personal Data (Infotype 0002 Fields with Text))

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ EP-PCT-MGR-HR (Application Component) Business Package for Manager Self-Service (HR)
     ⤷ PWPC_MAN_GENERAL (Package) PWPC_MAN_GENERAL

Basic Data

Table Category	INTTAB	Structure
Structure	HRWPC_S_PERSONALDATA	Table Relationship Diagram
Short Description	Personal Data (Infotype 0002 Fields with Text)

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	Personal Data (Infotype 0002 Fields)
2	.INCLUDE	☐				0	0	Header Data for PA Infotypes
3	.INCLUDE	☐				0	0	Key Definition for PA Infotypes
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
6	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
7	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
8	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
9	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
10	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
11	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
12	.INCLUDE	☐				0	0	Administration Data for PA Infotypes
13	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
16	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
17	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
18	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
19	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
20	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
21	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
25	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
27	.INCLUDE	☐				0	0	Personal Data (Infotype 0002 Data Fields)
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	T516T
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	TITEL_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
75	TITL2_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
76	NAMZU_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
77	VORSW_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
78	VORS2_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix
79	ANRED_TEXT	☐	ANREX	ANREX	CHAR	5	0	Form of address text
80	ANRED_TEXT2	☐	ANRLT	TEXT15	CHAR	15	0	Long Text: Form of Address
81	GESCH_TEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
82	GBLND_TEXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
83	GBDEP_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
84	NATIO_TEXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
85	NATI2_TEXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
86	NATI3_TEXT	☐	NATIO	TEXT15	CHAR	15	0	Nationality
87	SPRSL_TEXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
88	KONFE_TEXT	☐	KITXT	KITXT	CHAR	4	0	Religious Denomination
89	KONFE_TEXT2	☐	KNFTX	TEXT25	CHAR	25	0	Religious Denomination Long Text
90	FAMST_TEXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
91	NAMZ2_TEXT	☐	TTOUT	TEXT15	CHAR	15	0	Output text for name affix

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in