SAP ABAP Table /MRSS/T_SGM_PS0002 (HR Master Record: Infotype 0002 (Personal Data))

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC-MO (Application Component) Maintenance Orders
     ⤷ /MRSS/SGM (Package) Multiresource Planning: Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_SGM_PS0002	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	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
2	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
3	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
4	NACH2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
5	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
6	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
7	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
8	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	T535N
9	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
10	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
11	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	T535N
12	RUFNM	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
13	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
14	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
15	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
16	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
17	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
18	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
19	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
20	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
21	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
22	NATI2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
23	NATI3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
24	SPRSL	☐	PAD_SPRAS	SPRAS	LANG	1	0	Communication Language	T002
25	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
26	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
27	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
28	ANZKD	☐	ANZKD	DEC03	DEC	3	0	Number of Children
29	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
30	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
31	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
32	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
33	FNAMK	☐	P22J_PFNMK	P22J_PNAME	CHAR	40	0	First name (Katakana)
34	LNAMK	☐	P22J_PLNMK	P22J_PNAME	CHAR	40	0	Last name (Katakana)
35	FNAMR	☐	P22J_PFNMR	P22J_PNAME	CHAR	40	0	First Name (Romaji)
36	LNAMR	☐	P22J_PLNMR	P22J_PNAME	CHAR	40	0	Last Name (Romaji)
37	NABIK	☐	P22J_PNBIK	P22J_PNAME	CHAR	40	0	Name of Birth (Katakana)
38	NABIR	☐	P22J_PNBIR	P22J_PNAME	CHAR	40	0	Name of Birth (Romaji)
39	NICKK	☐	P22J_PNCKK	P22J_PNAME	CHAR	40	0	Koseki (Katakana)
40	NICKR	☐	P22J_PNCKR	P22J_PNAME	CHAR	40	0	Koseki (Romaji)
41	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
42	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
43	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
44	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
45	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
46	NAMZ2	☐	NAMZ2	TITEL	CHAR	15	0	Name Affix for Name at Birth	T535N
47	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20141109
SAP Release Created in	700