SAP ABAP Table LSHR (HR Order Confirmations (Durations/Time Tickets))

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PT-RC-IW (Application Component) Time Tickets
     ⤷ PINW (Package) Incentive Wages

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LSHR	Table Relationship Diagram
Short Description	HR Order Confirmations (Durations/Time Tickets)

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	PDSNR	☑	PDSNR_D	PDSNR	NUMC	12	0	Sequential number for PDC messages	*
3	.INCLUDE	☐				0	0	Integration with Logistics: Confirmations
4	.INCLUDE	☐				0	0	CC1: Time Event, Data Part
5	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	ZAUSW	☐	DZAUSW	ZAUSW	NUMC	8	0	Time Recording ID Number
7	LDATE	☐	LDATE	DATUM	DATS	8	0	Logical Date
8	LTIME	☐	LTIME	UZEIT	TIMS	6	0	Logical time
9	ERDAT	☐	PHDAT	DATUM	DATS	8	0	Created on
10	ERTIM	☐	PHTIM	UZEIT	TIMS	6	0	Created at
11	SATZA	☐	RETYP	RETYP	CHAR	3	0	Time Event Type
12	TERID	☐	TERID	TERID	CHAR	4	0	Terminal ID
13	ABWGR	☐	ABWGR	ABWGR	CHAR	4	0	Attendance/Absence Reason	*
14	ORIGF	☐	ORIGF	ORIGF	CHAR	1	0	Origin Indicator of PDC Message
15	DALLF	☐	DALLF	DALLF	CHAR	1	0	Day assignment
16	PDC_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
17	PDC_PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	*
18	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
19	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	*
20	PDC_USRUP	☐	PDC_USRUP	CHAR20	CHAR	20	0	Customer-Specific Field
21	USER2	☐	HR_USRFLD	CHAR40	CHAR	40	0	Customer-Specific Field
22	INDEU	☐	INDEU	INDEU	CHAR	1	0	Insert/delete or update indicator
23	RUECK	☐	PW_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
24	RMZHL	☐	PW_RMZHL	CIM_COUNT	NUMC	8	0	Confirmation counter
25	STOKZ	☐	PW_STOKZ	FLAG	CHAR	1	0	Indicator: "Confirmation Cancelled"
26	STZHL	☐	PW_STZHL	CIM_COUNT	NUMC	8	0	Confirmation counter of cancelled confirmation
27	GRUNR	☐	PW_GRUNR	GRUNR	NUMC	8	0	Group number	*
28	GRUNA	☐	PW_GRUNA	CHAR20	CHAR	20	0	Group name
29	BUDAT	☐	PW_BUDAT	DATUM	DATS	8	0	Posting date
30	LSTYP	☐	PW_LSTYP	LSTYP	CHAR	2	0	Time ticket type	*
31	PRFOR	☐	PW_PRFOR	PRFOR	NUMC	3	0	Premium formula	*
32	APPKZ	☐	PW_APPKZ	PW_APPKZ	CHAR	2	0	Source application (for confirmations)
33	SRCSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
34	AUFTYP	☐	PW_AUFTYP	AUFTYP	NUMC	2	0	Order category
35	AUFART	☐	PW_AUFART	AUFART	CHAR	4	0	Order type	*
36	AUFNR	☐	PW_AUFNR	AUFNR	CHAR	12	0	Order Number	*
37	FOLGE	☐	PW_AUFFN	PLNFOLGE	CHAR	6	0	Sequence number
38	VORNR	☐	PW_AUFAV	VORNR	CHAR	4	0	Operation number
39	UVORN	☐	PW_AUFUV	VORNR	CHAR	4	0	Suboperation Number
40	SPLIT	☐	CY_SPLIT	INT1	INT1	3	0	Split number
41	KAPAR	☐	KAPAR	CHAR3	CHAR	3	0	Capacity category
42	LOARR	☐	PW_LGART	LGART	CHAR	4	0	Wage type	*
43	ARBPL	☐	PW_ARBPL	ARBPL	CHAR	8	0	Work Center
44	WERKS	☐	PW_WERKS	WERKS	CHAR	4	0	Plant	*
45	BUKRS	☐	PW_BUKRS	BUKRS	CHAR	4	0	Company code	*
46	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
47	KOSTL	☐	PW_KOSTL	KOSTL	CHAR	10	0	Cost center	*
48	LOGRR	☐	PW_TRFGR	CHAR8	CHAR	8	0	Pay Scale Group
49	TRFST	☐	PW_TRFST	CHAR2	CHAR	2	0	Pay scale level
50	.INCLUDE	☐				0	0	Incentive Wages: Quantities
51	MEINH	☐	PW_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
52	LMNGA	☐	PW_LMNGR	PW_QUAN13	QUAN	13	3	Yield
53	XMNGA	☐	PW_XMNGR	PW_QUAN13	QUAN	13	3	Scrap
54	GRUND	☐	PW_GRUND	CHAR4	CHAR	4	0	Scrap reason
55	BMSCH	☐	PW_BMSCH	PW_QUAN13	QUAN	13	3	Base quantity
56	.INCLUDE	☐				0	0	Incentive Wages: Activities
57	VGW01	☐	PW_VGWRT01	PW_QUAN13	QUAN	13	3	Standard value of processing time
58	VGE01	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
59	SOW01	☐	PW_SOWRT01	PW_QUAN13	QUAN	13	3	Target value of processing time
60	SOE01	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
61	RUW01	☐	PW_RUWRT01	PW_QUAN13	QUAN	13	3	Confirmed value of processing time
62	RUE01	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
63	BEG01	☐	PW_BEGUZ01	UZEIT	TIMS	6	0	Start of processing time
64	END01	☐	PW_ENDUZ01	UZEIT	TIMS	6	0	End of processing time
65	VGW02	☐	PW_VGWRT02	PW_QUAN13	QUAN	13	3	Standard value of setup time
66	VGE02	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
67	SOW02	☐	PW_SOWRT02	PW_QUAN13	QUAN	13	3	Target value of setup time
68	SOE02	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
69	RUW02	☐	PW_RUWRT02	PW_QUAN13	QUAN	13	3	Confirmed value of setup time
70	RUE02	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
71	BEG02	☐	PW_BEGUZ02	UZEIT	TIMS	6	0	Start of setup time
72	END02	☐	PW_ENDUZ02	UZEIT	TIMS	6	0	End of setup time
73	VGW03	☐	PW_VGWRT03	PW_QUAN13	QUAN	13	3	Standard value of machine time
74	VGE03	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
75	SOW03	☐	PW_SOWRT03	PW_QUAN13	QUAN	13	3	Target value of machine time
76	SOE03	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
77	RUW03	☐	PW_RUWRT03	PW_QUAN13	QUAN	13	3	Confirmed value of machine time
78	RUE03	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
79	BEG03	☐	PW_BEGUZ03	UZEIT	TIMS	6	0	Start machine time
80	END03	☐	PW_ENDUZ03	UZEIT	TIMS	6	0	End of machine time
81	VGW04	☐	PW_VGWRT04	PW_QUAN13	QUAN	13	3	Standard value of variable activity
82	VGE04	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
83	SOW04	☐	PW_SOWRT04	PW_QUAN13	QUAN	13	3	Target value of variable activity
84	SOE04	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
85	RUW04	☐	PW_RUWRT04	PW_QUAN13	QUAN	13	3	Confirmed value of variable activity
86	RUE04	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
87	BEG04	☐	PW_BEGUZ04	UZEIT	TIMS	6	0	Start of variable activity
88	END04	☐	PW_ENDUZ04	UZEIT	TIMS	6	0	End of variable activity
89	VGW05	☐	PW_VGWRT05	PW_QUAN13	QUAN	13	3	Standard value of teardown time
90	VGE05	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
91	SOW05	☐	PW_SOWRT05	PW_QUAN13	QUAN	13	3	Target value of teardown time
92	SOE05	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
93	RUW05	☐	PW_RUWRT05	PW_QUAN13	QUAN	13	3	Confirmed value of teardown time
94	RUE05	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
95	BEG05	☐	PW_BEGUZ05	UZEIT	TIMS	6	0	Start of teardown time
96	END05	☐	PW_ENDUZ05	UZEIT	TIMS	6	0	End of teardown time
97	VGW06	☐	PW_VGWRT06	PW_QUAN13	QUAN	13	3	Standard value of variable activity
98	VGE06	☐	PW_VGWRTEH	MEINS	UNIT	3	0	Measurement unit for standard value	T006
99	SOW06	☐	PW_SOWRT06	PW_QUAN13	QUAN	13	3	Target value of variable activity
100	SOE06	☐	PW_SOWRTEH	MEINS	UNIT	3	0	Measurement unit for target value	T006
101	RUW06	☐	PW_RUWRT06	PW_QUAN13	QUAN	13	3	Confirmed value of variable activity
102	RUE06	☐	PW_RUWRTEH	MEINS	UNIT	3	0	Measurement unit of confirmed value	T006
103	BEG06	☐	PW_BEGUZ06	UZEIT	TIMS	6	0	Start of variable activity
104	END06	☐	PW_ENDUZ06	UZEIT	TIMS	6	0	End of variable activity
105	.INCLUDE	☐				0	0	Substructure of Interface File for Log
106	UNAME1	☐	PW_UNAME1	UNAME	CHAR	12	0	User who wrote record to interface
107	DATUM1	☐	PW_DATUM1	DATUM	DATS	8	0	Date on which record was written to interface
108	UZEIT1	☐	PW_UZEIT1	UZEIT	TIMS	6	0	Time at which record was written to interface
109	PGMID1	☐	PW_PGMID1	PROGNAME	CHAR	40	0	Write Record to Interface Report
110	UNAME2	☐	PW_UNAME2	UNAME	CHAR	12	0	Name of user who initially accessed record
111	DATUM2	☐	PW_DATUM2	DATUM	DATS	8	0	Date on which record was initially accessed
112	UZEIT2	☐	PW_UZEIT2	UZEIT	TIMS	6	0	Time at which record was initially accessed
113	PGMID2	☐	PW_PGMID2	PROGNAME	CHAR	40	0	Report used to access record initially
114	STATU2	☐	PW_STATU2	PW_STATU	CHAR	1	0	Log status when record was first accessed
115	UNAME3	☐	PW_UNAME3	UNAME	CHAR	12	0	Last user to access record
116	DATUM3	☐	PW_DATUM3	DATUM	DATS	8	0	Date on which record was last accessed
117	UZEIT3	☐	PW_UZEIT3	UZEIT	TIMS	6	0	Time at which record was last accessed
118	PGMID3	☐	PW_PGMID3	PROGNAME	CHAR	40	0	Last Used to Access Record Program
119	STATU3	☐	PW_STATU3	PW_STATU	CHAR	1	0	Log status when record was last accessed
120	UNAME4	☐	PW_UNAME4	UNAME	CHAR	12	0	User who first retrieved the record successfully
121	DATUM4	☐	PW_DATUM4	DATUM	DATS	8	0	Date on which record was first retrieved successfully
122	UZEIT4	☐	PW_UZEIT4	UZEIT	TIMS	6	0	Time at which record was first retrieved successfully
123	PGMID4	☐	PW_PGMID4	PROGNAME	CHAR	40	0	Report first used to retrieve record successfully

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LSHR	MEINH	T006	MSEHI
2	LSHR	RUE01	T006	MSEHI
3	LSHR	RUE02	T006	MSEHI
4	LSHR	RUE03	T006	MSEHI
5	LSHR	RUE04	T006	MSEHI
6	LSHR	RUE05	T006	MSEHI
7	LSHR	RUE06	T006	MSEHI
8	LSHR	SOE01	T006	MSEHI
9	LSHR	SOE02	T006	MSEHI
10	LSHR	SOE03	T006	MSEHI
11	LSHR	SOE04	T006	MSEHI
12	LSHR	SOE05	T006	MSEHI
13	LSHR	SOE06	T006	MSEHI
14	LSHR	SRCSYS	TBDLS	LOGSYS
15	LSHR	VGE01	T006	MSEHI
16	LSHR	VGE02	T006	MSEHI
17	LSHR	VGE03	T006	MSEHI
18	LSHR	VGE04	T006	MSEHI
19	LSHR	VGE05	T006	MSEHI
20	LSHR	VGE06	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in