MCQALSB_BW SAP (Inspection lot with cancellation flag) Structure details
Description: Inspection lot with cancellation flag
Structure field list including key, data, relationships and ABAP select examples
MCQALSB_BW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Inspection lot with cancellation flag" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCQALSB_BW TYPE MCQALSB_BW.
The MCQALSB_BW table consists of various fields, each holding specific information or linking keys about Inspection lot with cancellation flag data available in SAP. These include PRUEFLOS (Inspection Lot Number), AUFPL (Routing number of operations in the order), ART (Inspection Type), HERKUNFT (Inspection Lot Origin).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCQALSB_BW structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1 | BOOLE | ||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
ART | Inspection Type | QPART | CHAR | 8 | Assigned to domain | QPART | QLA | ||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2 | Assigned to domain | QHERK | QHK | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
OBTYP | Object Category | J_OBTYP | CHAR | 3 | Assigned to domain | J_OBTYP | |||
WERK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
LAGORTCHRG | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4 | Assigned to domain | WERKS | |||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | Assigned to domain | LGORT | |||
LS_KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KUNNR | Customer (Ship-To Party) | QKUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEBI | |
LS_VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
LS_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
LS_KDMAT | Material belonging to the customer | KDMAT | CHAR | 35 | IDNEX | ||||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | Assigned to domain | MATN1 | MATNR | HTN | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | SA_AUFNR | ||
ENSTEHDAT | Date of Lot Creation | QENTST | DATS | 8 | DATUM | ||||
ENTSTEZEIT | Time of Lot Creation | QENTSTZEIT | TIMS | 6 | QZEIT | ||||
PASTRTERM | Inspection Start Date | QPRSTART | DATS | 8 | DATUM | ||||
PASTRZEIT | Inspection Start Time | QSTARTZEIT | TIMS | 6 | QZEIT | ||||
PAENDTERM | End Date of the Inspection | QPRENDE | DATS | 8 | DATUM | ||||
PAENDZEIT | Inspection End Time | QENDEZEIT | TIMS | 6 | QZEIT | ||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
ERSTELDAT | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
ERSTELZEIT | Time of Lot Creation | QERSTEZEIT | TIMS | 6 | QZEIT | ||||
AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
AENDERZEIT | Time of Lot Change | QAENDEZEIT | TIMS | 6 | QZEIT | ||||
LMENGEIST | Actual Lot Quantity | QLMENGEIST | QUAN | 13(3) | QMENGEPLOS | ||||
MENGENEINH | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | ||||
GEBEH | Lot Container | QGEBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ZHLQALS | Number of inspection lots | QZHL_ILOTS | INT4 | 10 | QANZAHL4 | ||||
ZHLQALS_SKIP | Number of lots with skip | QZHL_ILOTS_SKIP | INT4 | 10 | QANZAHL4 | ||||
QTYQALS_SKIP | Skip quantity | QQTY_ILOTS_SKIP | QUAN | 13(3) | QMENGEPLOS | ||||
STAT02 | Partial Lots Exist | QKZQALT | CHAR | 1 | QKZ | ||||
STAT07 | Inspection with Inspection Points | QKZFERTPRF | CHAR | 1 | QKZ | ||||
STAT35 | Usage Decision Has Been Made | QSTAT35 | CHAR | 1 | QKZ | ||||
KZSKIPLOT | Lot Skipped | QKZSKIPLOT | CHAR | 1 | QKZ | ||||
SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | CHAR | 3 | Assigned to domain | QSLWBEZ | QBK | ||
STAT13 | Inspection Point Type | QPPKTTYP | CHAR | 1 | QPPKTTYP | ||||
PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1 | QPPKZTLZU |
Key field | Non-key field |
How do I retrieve data from SAP structure MCQALSB_BW using ABAP code?
As MCQALSB_BW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCQALSB_BW as there is no data to select.How to access SAP table MCQALSB_BW
Within an ECC or HANA version of SAP you can also view further information about MCQALSB_BW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects