SAP MCQALSB_BW Table in S/4 HANA - Inspection lot with cancellation flag
MCQALSB_BW is a standard SAP Table which is used to store Inspection lot with cancellation flag data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MCQALSB_BW table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MCQALSB_BW
MCQALSB_BW table structure field list
Below is the full MCQALSB_BW field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1(0) | BOOLE | |||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12(0) | QPLOS | QLS | QALS | PRUEFLOS | ||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
ART | Inspection Type | QPART | CHAR | 8(0) | Assigned to domain | QPART | QLA | |||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2(0) | Assigned to domain | QHERK | QHK | |||
OBJNR | Object number | J_OBJNR | CHAR | 22(0) | Assigned to domain | J_OBJNR | ONR | |||
OBTYP | Object Category | J_OBTYP | CHAR | 3(0) | Assigned to domain | J_OBTYP | ||||
WERK | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
CHARG | Batch Number | CHARG_D | CHAR | 10(0) | Assigned to domain | CHARG | CHA | |||
LAGORTCHRG | Storage location | LGORT_D | CHAR | 4(0) | Assigned to domain | LGORT | LAG | |||
MJAHR | Material Document Year | MJAHR | NUMC | 4(0) | GJAHR | GJAHR | MJA | |||
MBLNR | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
ZEILE | Item in Material Document | MBLPO | NUMC | 4(0) | MBLPO | POS | ||||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4(0) | Assigned to domain | WERKS | ||||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4(0) | Assigned to domain | LGORT | ||||
LS_KUNAG | Sold-To Party | KUNAG | CHAR | 10(0) | Assigned to domain | ALPHA | KUNNR | VAG | ||
KUNNR | Customer (Ship-To Party) | QKUNWE | CHAR | 10(0) | ALPHA | KUNNR | DEBI | KUNNR | ||
LS_VKORG | Sales Organization | VKORG | CHAR | 4(0) | VKORG | VKO | C_VKORG | VKORG | ||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
LS_KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10(0) | ALPHA | VBELN | VL | |||
LS_POSNR | Delivery Item | POSNR_VL | NUMC | 6(0) | Assigned to domain | POSNR | ||||
LS_KDMAT | Customer Material | KDMAT | CHAR | 35(0) | IDNEX | |||||
LIFNR | Vendor's account number | ELIFN | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | LIF | ||
EMATNR | Material number corresponding to manufacturer part number | EMATN | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | HTN | ||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | Assigned to domain | EKORG | EKO | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | Assigned to domain | EBELP | BSP | |||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
GSBER | Business Area | GSBER | CHAR | 4(0) | Assigned to domain | GSBER | GSB | |||
AUFNR | Order Number | AUFNR | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | ANR | ||
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12(0) | Assigned to domain | ALPHA | SA_AUFNR | |||
ENSTEHDAT | Date of Lot Creation | QENTST | DATS | 8(0) | DATUM | |||||
ENTSTEZEIT | Time of Lot Creation | QENTSTZEIT | TIMS | 6(0) | QZEIT | |||||
PASTRTERM | Start Date of Inspection | QPRSTART | DATS | 8(0) | DATUM | |||||
PASTRZEIT | Inspection Start Time | QSTARTZEIT | TIMS | 6(0) | QZEIT | |||||
PAENDTERM | End Date of Inspection | QPRENDE | DATS | 8(0) | DATUM | |||||
PAENDZEIT | Inspection End Time | QENDEZEIT | TIMS | 6(0) | QZEIT | |||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12(0) | QAENDERER | |||||
ERSTELDAT | Date on Which Data Record Was Created | QDATUMERST | DATS | 8(0) | DATUM | |||||
ERSTELZEIT | Time of Lot Creation | QERSTEZEIT | TIMS | 6(0) | QZEIT | |||||
AENDERER | Name of User Who Last Changed Data Record | QAENDERER | CHAR | 12(0) | QAENDERER | |||||
AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8(0) | DATUM | |||||
AENDERZEIT | Time of Lot Change | QAENDEZEIT | TIMS | 6(0) | QZEIT | |||||
LMENGEIST | Actual Lot Quantity | QLMENGEIST | QUAN | 13(3) | QMENGEPLOS | |||||
MENGENEINH | Base Unit of Measure for Inspection Lot Quantity | QLOSMENGEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | |||||
GEBEH | Lot Container | QGEBEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
ZHLQALS | Number of inspection lots | QZHL_ILOTS | INT4 | 10(0) | QANZAHL4 | |||||
ZHLQALS_SKIP | Number of lots with skip | QZHL_ILOTS_SKIP | INT4 | 10(0) | QANZAHL4 | |||||
QTYQALS_SKIP | Skip quantity | QQTY_ILOTS_SKIP | QUAN | 13(3) | QMENGEPLOS | |||||
STAT02 | Partial Lots Exist | QKZQALT | CHAR | 1(0) | QKZ | |||||
STAT07 | Inspection with Inspection Points | QKZFERTPRF | CHAR | 1(0) | QKZ | |||||
STAT35 | Usage Decision Has Been Made | QSTAT35 | CHAR | 1(0) | QKZ | |||||
KZSKIPLOT | Lot Skipped | QKZSKIPLOT | CHAR | 1(0) | QKZ | |||||
SLWBEZ | Identifier for Inspection Point Field Combination | QSLWBEZ | CHAR | 3(0) | Assigned to domain | QSLWBEZ | QBK | |||
STAT13 | Inspection Point Type | QPPKTTYP | CHAR | 1(0) | QPPKTTYP | |||||
PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1(0) | QPPKZTLZU |
Search for further information about these or an SAP related objects