SAP Table MCQALSX

Inspection lot

MCQALSX (Inspection lot) 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 MCQALSX to other SAP tables.

MCQALSX table fields

Field Data element Checktable Datatype Length Decimals
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 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
WERK Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
CHARG Batch Number CHARG_D CHAR 10 0
LAGORTCHRG Storage Location LGORT_D CHAR 4 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
LS_KUNAG Sold-to party KUNAG CHAR 10 0
KUNNR Customer (Ship-To Party) QKUNWE CHAR 10 0
LS_VKORG Sales Organization VKORG CHAR 4 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
LIFNR Vendor Account Number ELIFN CHAR 10 0
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 0
EMATNR Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
EKORG Purchasing Organization EKORG CHAR 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
PRCTR Profit Center PRCTR CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
AUFNR Order Number AUFNR CHAR 12 0
SA_AUFNR Run schedule header number SA_AUFNR CHAR 12 0
ENSTEHDAT Date of Lot Creation QENTST DATS 8 0
ENTSTEZEIT Time of Lot Creation QENTSTZEIT 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
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
LMENGEIST Actual Lot Quantity QLMENGEIST 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
ZHLQALS Number of inspection lots QZHL_ILOTS INT4 10 0
ZHLQALS_SKIP Number of lots with skip QZHL_ILOTS_SKIP INT4 10 0
QTYQALS_SKIP Skip quantity QQTY_ILOTS_SKIP QUAN 13 3
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
STAT35 Usage Decision Has Been Made QSTAT35 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
SLWBEZ Identification for the Inspection Point Field Combination QSLWBEZ CHAR 3 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
PPKZTLZU Partial Lot Assignment in an Inspection During Production QPPKZTLZU CHAR 1 0
NULL Partial lot assignment according to plant default values
0 Partial lots not supported
1 Partial lot for each inspection point
2 Partial lot and batch for each insp. point
3 Partial lot for inspection points of 'last' inspection oper.
4 Partial lot and batch for insp. points of 'last' operation