SAP ABAP Table U_17006 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_17006	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
3	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
12	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
13	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
14	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
15	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
16	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
17	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	T535N
18	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
19	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
20	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	T535N
21	RUFNM	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
22	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
23	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
24	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
25	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
26	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
27	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
28	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
29	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
30	NATI2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
31	NATI3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
32	SPRSL	☐	PAD_SPRAS	SPRAS	LANG	1	0	Communication Language	T002
33	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key
34	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key
35	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
36	ANZKD	☐	ANZKD	DEC03	DEC	3	0	Number of Children
37	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
38	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
39	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
40	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
41	FNAMK	☐	P22J_PFNMK	P22J_PNAME	CHAR	40	0	First name (Katakana)
42	LNAMK	☐	P22J_PLNMK	P22J_PNAME	CHAR	40	0	Last name (Katakana)
43	FNAMR	☐	P22J_PFNMR	P22J_PNAME	CHAR	40	0	First Name (Romaji)
44	LNAMR	☐	P22J_PLNMR	P22J_PNAME	CHAR	40	0	Last Name (Romaji)
45	NABIK	☐	P22J_PNBIK	P22J_PNAME	CHAR	40	0	Name of Birth (Katakana)
46	NABIR	☐	P22J_PNBIR	P22J_PNAME	CHAR	40	0	Name of Birth (Romaji)
47	NICKK	☐	P22J_PNCKK	P22J_PNAME	CHAR	40	0	Koseki (Katakana)
48	NICKR	☐	P22J_PNCKR	P22J_PNAME	CHAR	40	0	Koseki (Romaji)
49	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
50	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
51	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
52	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
53	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
54	NACH2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
55	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
56	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in