SAP ABAP Table REC_PT_UIA_TMW_EE_NAVIGATION (TMW: Data Table for Employee Navigation)

Hierarchy

☛ EA-HRRXX (Software Component) Sub component EA-HRRXX of EA-HR
   ⤷ PT-RC (Application Component) Time Data Recording and Administration
     ⤷ PAOC_TIM_TMW_UIA_OBJECTS (Package) TMW: UIA Objects

Basic Data

Table Category	INTTAB	Structure
Structure	REC_PT_UIA_TMW_EE_NAVIGATION	Table Relationship Diagram
Short Description	TMW: Data Table for Employee Navigation

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	*
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: Infotype 0001 (Org. Assignment)
12	.INCLUDE	☐				0	0	HR Master Record: Infotype 0001 (Org. Assignment)
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
15	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
16	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
17	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	T527O
18	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
20	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
21	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
22	ANSVH	☐	ANSVH	ANSVH	CHAR	2	0	Work Contract	T542A
23	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
24	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
25	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
26	STELL	☐	STELL	STELL	NUMC	8	0	Job	T513
27	MSTBR	☐	MSTBR	MSTBR	CHAR	8	0	Supervisor Area
28	SACHA	☐	SACHA	SACHA	CHAR	3	0	Payroll Administrator	T526
29	SACHP	☐	SACHP	SACHA	CHAR	3	0	Administrator for HR Master Data	T526
30	SACHZ	☐	SACHZ	SACHA	CHAR	3	0	Administrator for Time Recording	T526
31	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
32	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
33	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
34	SBMOD	☐	SBMOD	CHAR4	CHAR	4	0	Administrator Group
35	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
36	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
37	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
38	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
39	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
40	SGMNT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	HR Master Record: Infotype 0002 (Personal Data)
43	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
44	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
45	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
46	NACH2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
47	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
48	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
49	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
50	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	T535N
51	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
52	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
53	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	T535N
54	RUFNM	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
55	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
56	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
57	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
58	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
59	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
60	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
61	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
62	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
63	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
64	NATI2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
65	NATI3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
66	SPRSL	☐	PAD_SPRAS	SPRAS	LANG	1	0	Communication Language	T002
67	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
68	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
69	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
70	ANZKD	☐	ANZKD	DEC03	DEC	3	0	Number of Children
71	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
72	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
73	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
74	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
75	FNAMK	☐	P22J_PFNMK	P22J_PNAME	CHAR	40	0	First name (Katakana)
76	LNAMK	☐	P22J_PLNMK	P22J_PNAME	CHAR	40	0	Last name (Katakana)
77	FNAMR	☐	P22J_PFNMR	P22J_PNAME	CHAR	40	0	First Name (Romaji)
78	LNAMR	☐	P22J_PLNMR	P22J_PNAME	CHAR	40	0	Last Name (Romaji)
79	NABIK	☐	P22J_PNBIK	P22J_PNAME	CHAR	40	0	Name of Birth (Katakana)
80	NABIR	☐	P22J_PNBIR	P22J_PNAME	CHAR	40	0	Name of Birth (Romaji)
81	NICKK	☐	P22J_PNCKK	P22J_PNAME	CHAR	40	0	Koseki (Katakana)
82	NICKR	☐	P22J_PNCKR	P22J_PNAME	CHAR	40	0	Koseki (Romaji)
83	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
84	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
85	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
86	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
87	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
88	NAMZ2	☐	NAMZ2	TITEL	CHAR	15	0	Name Affix for Name at Birth	T535N
89	.INCLUDE	☐				0	0
90	.INCLUDE	☐				0	0	HR Master Record: Infotype 0007 (Planned Working Time)
91	SCHKZ	☐	SCHKN	SCHKN	CHAR	8	0	Work Schedule Rule	*
92	ZTERF	☐	PT_ZTERF	ZTERF	NUMC	1	0	Employee Time Management Status	T555U
93	EMPCT	☐	EMPCT	BSGRD	DEC	5	2	Employment percentage
94	MOSTD	☐	MOSTD	STDAZ	DEC	5	2	Monthly hours
95	WOSTD	☐	WOSTD	STDAZ	DEC	5	2	Hours per week
96	ARBST	☐	STDTG	STDAZ	DEC	5	2	Daily Working Hours
97	WKWDY	☐	WARST	DEC2_2	DEC	4	2	Weekly Workdays
98	JRSTD	☐	JRSTD	JRSTD	DEC	7	2	Annual working hours
99	TEILK	☐	TEILK	XFELD	CHAR	1	0	Indicator Part-Time Employee
100	MINTA	☐	MINTA	STDAZ	DEC	5	2	Minimum number of work hours per day
101	MAXTA	☐	MAXTA	STDAZ	DEC	5	2	Maximum number of work hours per day
102	MINWO	☐	MINWO	STDAZ	DEC	5	2	Minimum weekly working hours
103	MAXWO	☐	MAXWO	STDAZ	DEC	5	2	Maximum number of work hours per week
104	MINMO	☐	MINMO	STDAZ	DEC	5	2	Minimum number of work hours per month
105	MAXMO	☐	MAXMO	STDAZ	DEC	5	2	Maximum number of work hours per month
106	MINJA	☐	MINJA	JRSTD	DEC	7	2	Minimum annual working hours
107	MAXJA	☐	MAXJA	JRSTD	DEC	7	2	Maximum Number of Working Hours Per Year
108	DYSCH	☐	DYSCH	XFELD	CHAR	1	0	Create Daily Work Schedule Dynamically
109	KZTIM	☐	KZTIM	KZTIM	CHAR	2	0	Additional indicator for time management
110	WWEEK	☐	WWEEK	WWEEK	CHAR	2	0	Working week	T559A
111	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
112	.INCLUDE	☐				0	0
113	.INCLUDE	☐				0	0	HR Master Record: Infotype 0050 (Time Recording Info.)
114	ZAUSW	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
115	ZAUVE	☐	DZAUVE	PT_ZAUVE	CHAR	1	0	ID version
116	ZABAR	☐	DZABAR	ZABAR	CHAR	1	0	Employee grouping for the time evaluation rule	T555N
117	BDEGR	☐	BDEGR	BDEGR	CHAR	3	0	Grouping for Connection to Subsystem	T705T
118	ZANBE	☐	DZANBE	ZANBE	CHAR	2	0	Access control group	T555O
119	ZDGBE	☐	DZDGBE	CHAR1	CHAR	1	0	Off-site work athorization
120	ZMAIL	☐	DZMAIL	CHAR1	CHAR	1	0	Mail indicator
121	ZPINC	☐	DZPINC	CHAR4	CHAR	4	0	Personal code
122	GLMAX	☐	GLMAX	DEC3_2	DEC	5	2	Flextime maximum
123	GLMIN	☐	GLMIN	DEC3_2	DEC	5	2	Flextime minimum
124	ZTZUA	☐	DZTZUA	DECV3_2	DEC	5	2	Time Bonus/Deduction
125	ZMGEN	☐	DZMGEN	CHAR1	CHAR	1	0	Standard overtime
126	ZUSKZ	☐	DZUSKZ	CHAR1	CHAR	1	0	Additional indicator
127	PMBDE	☐	PMBDE	PMBDE	NUMC	2	0	Work time event type group	T705F
128	GRAWG	☐	GRAWG	GRAWG	CHAR	3	0	Grouping of Attendance/Absence Reasons	T705I
129	GRELG	☐	GRELG	GRELG	CHAR	3	0	Grouping for Employee Expenses	T705J
130	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REC_PT_UIA_TMW_EE_NAVIGATION	ABKRS	T549A	ABKRS
2	REC_PT_UIA_TMW_EE_NAVIGATION	ANRED	T522G	ANRED
3	REC_PT_UIA_TMW_EE_NAVIGATION	ANSVH	T542A	ANSVH
4	REC_PT_UIA_TMW_EE_NAVIGATION	BDEGR	T705T	BDEGR
5	REC_PT_UIA_TMW_EE_NAVIGATION	BTRTL	T001P	BTRTL
6	REC_PT_UIA_TMW_EE_NAVIGATION	BUKRS	T001	BUKRS
7	REC_PT_UIA_TMW_EE_NAVIGATION	GBDEP	T005S	BLAND
8	REC_PT_UIA_TMW_EE_NAVIGATION	GBLND	T005	LAND1
9	REC_PT_UIA_TMW_EE_NAVIGATION	GRAWG	T705I	GRAWG
10	REC_PT_UIA_TMW_EE_NAVIGATION	GRELG	T705J	GRELG
11	REC_PT_UIA_TMW_EE_NAVIGATION	GSBER	TGSB	GSBER
12	REC_PT_UIA_TMW_EE_NAVIGATION	INFTY	T582A	INFTY
13	REC_PT_UIA_TMW_EE_NAVIGATION	KOKRS	TKA01	KOKRS
14	REC_PT_UIA_TMW_EE_NAVIGATION	KOSTL	CSKS	KOSTL
15	REC_PT_UIA_TMW_EE_NAVIGATION	NAMZ2	T535N	TITEL
16	REC_PT_UIA_TMW_EE_NAVIGATION	NAMZU	T535N	TITEL
17	REC_PT_UIA_TMW_EE_NAVIGATION	NATI2	T005	LAND1
18	REC_PT_UIA_TMW_EE_NAVIGATION	NATI3	T005	LAND1
19	REC_PT_UIA_TMW_EE_NAVIGATION	NATIO	T005	LAND1
20	REC_PT_UIA_TMW_EE_NAVIGATION	ORGEH	T527X	ORGEH
21	REC_PT_UIA_TMW_EE_NAVIGATION	OTYPE	T778O	OTYPE
22	REC_PT_UIA_TMW_EE_NAVIGATION	PERSG	T501	PERSG
23	REC_PT_UIA_TMW_EE_NAVIGATION	PERSK	T503K	PERSK
24	REC_PT_UIA_TMW_EE_NAVIGATION	PLANS	T528B	PLANS
25	REC_PT_UIA_TMW_EE_NAVIGATION	PMBDE	T705F	PMBDE
26	REC_PT_UIA_TMW_EE_NAVIGATION	SACHA	T526	SACHX
27	REC_PT_UIA_TMW_EE_NAVIGATION	SACHP	T526	SACHX
28	REC_PT_UIA_TMW_EE_NAVIGATION	SACHZ	T526	SACHX
29	REC_PT_UIA_TMW_EE_NAVIGATION	SPRSL	T002	SPRAS
30	REC_PT_UIA_TMW_EE_NAVIGATION	STELL	T513	STELL
31	REC_PT_UIA_TMW_EE_NAVIGATION	TITEL	T535N	TITEL
32	REC_PT_UIA_TMW_EE_NAVIGATION	TITL2	T535N	TITEL
33	REC_PT_UIA_TMW_EE_NAVIGATION	VDSK1	T527O	ORGKY
34	REC_PT_UIA_TMW_EE_NAVIGATION	VORS2	T535N	TITEL
35	REC_PT_UIA_TMW_EE_NAVIGATION	VORSW	T535N	TITEL
36	REC_PT_UIA_TMW_EE_NAVIGATION	WERKS	T500P	PERSA
37	REC_PT_UIA_TMW_EE_NAVIGATION	WWEEK	T559A	WWEEK
38	REC_PT_UIA_TMW_EE_NAVIGATION	ZABAR	T555N	ABART
39	REC_PT_UIA_TMW_EE_NAVIGATION	ZANBE	T555O	ZANBE
40	REC_PT_UIA_TMW_EE_NAVIGATION	ZTERF	T555U	ZTERF

History

Last changed by/on	SAP	20110901
SAP Release Created in