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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in