SAP Table QEWLL

QM Handheld: Include Structure for Inspection Lot Data

QEWLL (QM Handheld: Include Structure for Inspection Lot Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QEWLL to other SAP tables.

QEWLL table fields

Field Data element Checktable Datatype Length Decimals
STTXT System Status CO_STTXT CHAR 40 0
USTXT Field displaying user status CO_ASTTX CHAR 40 0
WERK Plant WERKS_D CHAR 4 0
ART Inspection Type QPART CHAR 8 0
HERKUNFT Inspection Lot Origin QHERK CHAR 2 0
OBJNR Object number J_OBJNR CHAR 22 0
OBTYP Object Category J_OBTYP CHAR 3 0
KTEXTMAT Short Text for Inspection Object QKTEXTOBJ CHAR 40 0
STSMA Status Profile J_STSMA CHAR 8 0
STAT02 Partial Lots Exist QKZQALT CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT07 Inspection with Inspection Points QKZFERTPRF CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT09 Source Inspection QABNAHMPRF CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
STAT19 Documentation Required for Inspection Lot QSTAT19 CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZSKIPLOT Lot Skipped QKZSKIPLOT CHAR 1 0
NULL Indicator is not set
X Indicator is set
HPZ 100% Inspection QHPZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ENSTEHDAT Date of Lot Creation QENTST DATS 8 0
ENTSTEZEIT Time of Lot Creation QENTSTZEIT TIMS 6 0
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELDAT Date on Which the Data Record Was Created QDATUMERST DATS 8 0
ERSTELZEIT Time of Lot Creation QERSTEZEIT TIMS 6 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDAT Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
AENDERZEIT Time of Lot Change QAENDEZEIT TIMS 6 0
PASTRTERM Inspection Start Date QPRSTART DATS 8 0
PASTRZEIT Inspection Start Time QSTARTZEIT TIMS 6 0
PAENDTERM End Date of the Inspection QPRENDE DATS 8 0
PAENDZEIT Inspection End Time QENDEZEIT TIMS 6 0
STAT13 Inspection Point Type QPPKTTYP CHAR 1 0
NULL Freely-defined inspection point
1 Inspection point for equipment
2 Inspection point for funct. location
3 Inspection point for phys. sample
AUFNR Order Number AUFNR CHAR 12 0
VERID Production Version VERID CHAR 4 0
KUNNR Customer (Ship-To Party) QKUNWE CHAR 10 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 0
EMATNR Material Number EMATNR CHAR 18 0
MATNR Material Number MATNR CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
CHARG Batch Number CHARG_D CHAR 10 0
LICHN Vendor Batch Number LICHN CHAR 15 0
LAGORTCHRG Storage Location LGORT_D CHAR 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLNR Number of Material Document MBLNR CHAR 10 0
ZEILE Item in Material Document MBLPO NUMC 4 0
WERKVORG Plant Where Stock for Inspection Lot Is Held QWERKVORG CHAR 4 0
LAGORTVORG Storage Location for Inspection Lot Stock QLGORTVORG CHAR 4 0
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LGTYP Storage Type LGTYP CHAR 3 0
LGPLA Storage Bin LGPLA CHAR 10 0
SPRACHE Language Key SPRAS LANG 1 0
KTEXTLOS Short Text QKURZTEXT CHAR 40 0
ZUSMKZAEHL Number of Characteristics Recorded Additionally QZUSMKZHL INT2 5 0
OFFENNLZMK Number of Outstanding Short-Term Chars Which Require Conf. QOFFENLZMK INT2 5 0
OFFEN_LZMK Number of Outstanding Long-Term Chars Which Require Conf. QOFFELZMK INT2 5 0
LOSMENGE Inspection Lot Quantity QLOSMENGE QUAN 13 3
MENGENEINH Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH UNIT 3 0
ANZGEB QM - No. of Containers QANZGEB QUAN 6 3
GEBEH Lot Container QGEBEH UNIT 3 0
GESSTICHPR Sample Size QGESTICH QUAN 13 3
EINHPROBE Base Unit of Measure for the Sample Unit QPROBEMGEH UNIT 3 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
LS_KDAUF Sales Order Number KDAUF CHAR 10 0
LS_KDPOS Item Number in Sales Order KDPOS NUMC 6 0
LS_VBELN Delivery VBELN_VL CHAR 10 0
LS_POSNR Delivery Item POSNR_VL NUMC 6 0
LS_KDMAT Material belonging to the customer KDMAT CHAR 35 0