SAP ABAP Table QEWLA (QM Handheld: Structure QEWLD + ALV Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-IM-RR (Application Component) Results Recording
     ⤷ QEHH (Package) QM Handheld Devices

Basic Data

Table Category	INTTAB	Structure
Structure	QEWLA	Table Relationship Diagram
Short Description	QM Handheld: Structure QEWLD + ALV 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	EXCP	☐	QEHHLIGHTS	ICON	CHAR	4	0	Status of Allocation	*
2	.INCLUDE	☐				0	0	QM Handheld: Structure QEWL + Dialog Data
3	.INCLUDE	☐				0	0	QM Handheld: Structure QEWL + Update Indicator
4	.INCLUDE	☐				0	0	QM Handheld: Worklist for Transfer
5	MANDANT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
7	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
8	ZAEHLER	☐	QEHHZAEHLER	Q_COUNT	NUMC	6	0	QM Handheld: Continuous Counter
9	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
10	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
11	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
12	ERSTELLDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
13	ERSTELZEIT	☐	QERSTZEIT	QZEIT	TIMS	6	0	Time Data Record Was Created
14	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
15	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
16	AENDERZEIT	☐	QAENZEIT	QZEIT	TIMS	6	0	Time of Last Data Record Change
17	RUECKMELDER	☐	QEHHRUECKP	QAENDERER	CHAR	12	0	QM Handheld: Person Making Confirmation
18	RUECKMEDAT	☐	QEHHRUECKD	DATUM	DATS	8	0	QM Handheld: Date of Last Confirmation
19	RUECKMEZEIT	☐	QEHHRUECKZ	QZEIT	TIMS	6	0	QM Handheld: Time of Last Confirmation
20	HHANW	☐	QEHHANWD	QEHHANWD	CHAR	6	0	Mobile Application	TQ90
21	PRUEFER	☐	QEHHPRUEFER	XUBNAME	CHAR	12	0	QM Handheld: Name of Inspector	USR02
22	STATUS	☐	QEHHSTAT	QEHHSTAT	CHAR	1	0	Transfer Status
23	MBEWERTG	☐	QMBEWERTG	QEEBEWERTG	CHAR	1	0	Inspection Result Valuation
24	FEHLERKZ	☐	QEHHFEHLER	QKZ	CHAR	1	0	QM Handheld: Confirmation Incorrect
25	LOGNUMBER	☐	BALOGNR	BALOGNR	CHAR	20	0	Application log: log number	BALHDR
26	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
27	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
28	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
29	UPSL	☐	QUPSL	QUPSL	CHAR	1	0	Data Base Access
30	APLFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
31	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
32	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
33	LTXA1	☐	LTXA1	TEXT40	CHAR	40	0	Operation short text
34	TXTSP	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
35	PRPLATZ	☐	QPRPLATZ	ARBPL	CHAR	8	0	Work Center
36	PRPLATZWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
37	PRPLATZTXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
38	SUBSYS	☐	QEIFSUBSYS	QEIFSUBSYS	CHAR	6	0	Subsystem Identifier for QM Subsystem Interface	*
39	IDENT	☐	OPRID	CHAR8	CHAR	8	0	Operation ID
40	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
41	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
43	STATUSD	☐	QEHHSTAT	QEHHSTAT	CHAR	1	0	Transfer Status
44	STATUSD_TEXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
45	HHANW_TEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
46	XSLEX	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)
47	.INCLU-LOT	☐				0	0	QM Handheld: Include Structure for Inspection Lot Data
48	STTXTLOT	☐	CO_STTXT	CHAR40	CHAR	40	0	System Status
49	USTXTLOT	☐	CO_ASTTX	CHAR40	CHAR	40	0	Field displaying user status
50	WERKLOT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
51	ARTLOT	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
52	HERKUNFTLOT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	*
53	OBJNRLOT	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
54	OBTYPLOT	☐	J_OBTYP	J_OBTYP	CHAR	3	0	Object Category	*
55	KTEXTMATLOT	☐	QKTEXTOBJ	QKURZTEXT	CHAR	40	0	Short Text for Inspection Object
56	STSMALOT	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
57	STAT02LOT	☐	QKZQALT	QKZ	CHAR	1	0	Partial Lots Exist
58	STAT07LOT	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
59	STAT09LOT	☐	QABNAHMPRF	BSTYP	CHAR	1	0	Source Inspection
60	STAT19LOT	☐	QSTAT19	QKZ	CHAR	1	0	Documentation Required for Inspection Lot
61	KZSKIPLOTLOT	☐	QKZSKIPLOT	QKZ	CHAR	1	0	Lot Skipped
62	HPZLOT	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
63	ENSTEHDATLOT	☐	QENTST	DATUM	DATS	8	0	Date of Lot Creation
64	ENTSTEZEITLOT	☐	QENTSTZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
65	ERSTELLERLOT	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
66	ERSTELDATLOT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
67	ERSTELZEITLOT	☐	QERSTEZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
68	AENDERERLOT	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
69	AENDERDATLOT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
70	AENDERZEITLOT	☐	QAENDEZEIT	QZEIT	TIMS	6	0	Time of Lot Change
71	PASTRTERMLOT	☐	QPRSTART	DATUM	DATS	8	0	Inspection Start Date
72	PASTRZEITLOT	☐	QSTARTZEIT	QZEIT	TIMS	6	0	Inspection Start Time
73	PAENDTERMLOT	☐	QPRENDE	DATUM	DATS	8	0	End Date of the Inspection
74	PAENDZEITLOT	☐	QENDEZEIT	QZEIT	TIMS	6	0	Inspection End Time
75	STAT13LOT	☐	QPPKTTYP	QPPKTTYP	CHAR	1	0	Inspection Point Type
76	AUFNRLOT	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
77	VERIDLOT	☐	VERID	VERID	CHAR	4	0	Production Version	*
78	KUNNRLOT	☐	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	*
79	LIFNRLOT	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
80	HERSTELLERLOT	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	*
81	EMATNRLOT	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
82	MATNRLOT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
83	REVLVLOT	☐	REVLV	REVLV	CHAR	2	0	Revision level
84	XCHPFLOT	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
85	CHARGLOT	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
86	LICHNLOT	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
87	LAGORTCHRGLOT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
88	EBELNLOT	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
89	EBELPLOT	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
90	MJAHRLOT	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
91	MBLNRLOT	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
92	ZEILELOT	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
93	WERKVORGLOT	☐	QWERKVORG	WERKS	CHAR	4	0	Plant Where Stock for Inspection Lot Is Held	*
94	LAGORTVORGLOT	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	*
95	LGNUMLOT	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
96	LGTYPLOT	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
97	LGPLALOT	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
98	SPRACHELOT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
99	KTEXTLOSLOT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
100	ZUSMKZAEHLLOT	☐	QZUSMKZHL	INT2	INT2	5	0	Number of Characteristics Recorded Additionally
101	OFFENNLZMKLOT	☐	QOFFENLZMK	INT2	INT2	5	0	Number of Outstanding Short-Term Chars Which Require Conf.
102	OFFEN_LZMKLOT	☐	QOFFELZMK	INT2	INT2	5	0	Number of Outstanding Long-Term Chars Which Require Conf.
103	LOSMENGELOT	☐	QLOSMENGE	QMENGEPLOS	QUAN	13	3	Inspection Lot Quantity
104	MENGENEINHLOT	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	*
105	ANZGEBLOT	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
106	GEBEHLOT	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	*
107	GESSTICHPRLOT	☐	QGESTICH	QMENGEPLOS	QUAN	13	3	Sample Size
108	EINHPROBELOT	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	*
109	PS_PSP_PNRLOT	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
110	KDAUFLOT	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
111	KDPOSLOT	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
112	SOBKZLOT	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
113	LS_KDAUFLOT	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
114	LS_KDPOSLOT	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
115	LS_VBELNLOT	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
116	LS_POSNRLOT	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
117	LS_KDMATLOT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
118	STYLE_TAB	☐	LVC_T_STYL		TTYP	0	0
119	BOX	☐	QKZ	QKZ	CHAR	1	0	X and Blank (Indicator)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QEWLA	ARBID	CRID	OBJID
2	QEWLA	HHANW	TQ90	HHANW	KEY	1	CN
3	QEWLA	LOGNUMBER	BALHDR	LOGNUMBER	KEY	1	CN
4	QEWLA	PRUEFER	USR02	BNAME	KEY	1	CN
5	QEWLA	TXTSP	T002	SPRAS	KEY
6	QEWLA	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in