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
ROCANCELIndicator: Cancel Data RecordROCANCELCHAR1(0) BOOLE
PRUEFLOSInspection Lot NumberQPLOSNUMC12(0) QPLOSQLSQALSPRUEFLOS
AUFPLRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
ARTInspection TypeQPARTCHAR8(0) Assigned to domainQPARTQLA
HERKUNFTInspection Lot OriginQHERKCHAR2(0) Assigned to domainQHERKQHK
OBJNRObject numberJ_OBJNRCHAR22(0) Assigned to domainJ_OBJNRONR
OBTYPObject CategoryJ_OBTYPCHAR3(0) Assigned to domainJ_OBTYP
WERKPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
REVLVRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
CHARGBatch NumberCHARG_DCHAR10(0) Assigned to domainCHARGCHA
LAGORTCHRGStorage locationLGORT_DCHAR4(0) Assigned to domainLGORTLAG
MJAHRMaterial Document YearMJAHRNUMC4(0) GJAHRGJAHRMJA
MBLNRNumber of Material DocumentMBLNRCHAR10(0) ALPHABELNRMBN
ZEILEItem in Material DocumentMBLPONUMC4(0) MBLPOPOS
WERKVORGPlant Where Stock for Inspection Lot Is HeldQWERKVORGCHAR4(0) Assigned to domainWERKS
LAGORTVORGStorage Location for Inspection Lot StockQLGORTVORGCHAR4(0) Assigned to domainLGORT
LS_KUNAGSold-To PartyKUNAGCHAR10(0) Assigned to domainALPHAKUNNRVAG
KUNNRCustomer (Ship-To Party)QKUNWECHAR10(0) ALPHAKUNNRDEBIKUNNR
LS_VKORGSales OrganizationVKORGCHAR4(0) VKORGVKOC_VKORGVKORG
LS_KDAUFSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
LS_KDPOSItem number in Sales OrderKDPOSNUMC6(0) NUM06KPO
LS_VBELNDeliveryVBELN_VLCHAR10(0) ALPHAVBELNVL
LS_POSNRDelivery ItemPOSNR_VLNUMC6(0) Assigned to domainPOSNR
LS_KDMATCustomer MaterialKDMATCHAR35(0) IDNEX
LIFNRVendor's account numberELIFNCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
HERSTELLERNumber of ManufacturerQLIFNRCHAR10(0) Assigned to domainALPHALIFNRLIF
EMATNRMaterial number corresponding to manufacturer part numberEMATNCHAR40(0) Assigned to domainMATN1MATNRHTN
EKORGPurchasing organizationEKORGCHAR4(0) Assigned to domainEKORGEKO
EBELNPurchasing Document NumberEBELNCHAR10(0) ALPHAEBELNBESMEKK_CEBELN
EBELPItem Number of Purchasing DocumentEBELPNUMC5(0) Assigned to domainEBELPBSP
PRCTRProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
GSBERBusiness AreaGSBERCHAR4(0) Assigned to domainGSBERGSB
AUFNROrder NumberAUFNRCHAR12(0) Assigned to domainALPHAAUFNRANR
SA_AUFNRRun schedule header numberSA_AUFNRCHAR12(0) Assigned to domainALPHASA_AUFNR
ENSTEHDATDate of Lot CreationQENTSTDATS8(0) DATUM
ENTSTEZEITTime of Lot CreationQENTSTZEITTIMS6(0) QZEIT
PASTRTERMStart Date of InspectionQPRSTARTDATS8(0) DATUM
PASTRZEITInspection Start TimeQSTARTZEITTIMS6(0) QZEIT
PAENDTERMEnd Date of InspectionQPRENDEDATS8(0) DATUM
PAENDZEITInspection End TimeQENDEZEITTIMS6(0) QZEIT
ERSTELLERName of User Who Created the Data RecordQERSTELLERCHAR12(0) QAENDERER
ERSTELDATDate on Which Data Record Was CreatedQDATUMERSTDATS8(0) DATUM
ERSTELZEITTime of Lot CreationQERSTEZEITTIMS6(0) QZEIT
AENDERERName of User Who Last Changed Data RecordQAENDERERCHAR12(0) QAENDERER
AENDERDATDate on Which Data Record Was ChangedQDATUMAENDDATS8(0) DATUM
AENDERZEITTime of Lot ChangeQAENDEZEITTIMS6(0) QZEIT
LMENGEISTActual Lot QuantityQLMENGEISTQUAN13(3) QMENGEPLOS
MENGENEINHBase Unit of Measure for Inspection Lot QuantityQLOSMENGEHUNIT3(0) Assigned to domainCUNITMEINS
ANZGEBQM - No. of ContainersQANZGEBQUAN6(3) QGEBPLOS
GEBEHLot ContainerQGEBEHUNIT3(0) Assigned to domainCUNITMEINS
ZHLQALSNumber of inspection lotsQZHL_ILOTSINT410(0) QANZAHL4
ZHLQALS_SKIPNumber of lots with skipQZHL_ILOTS_SKIPINT410(0) QANZAHL4
QTYQALS_SKIPSkip quantityQQTY_ILOTS_SKIPQUAN13(3) QMENGEPLOS
STAT02Partial Lots ExistQKZQALTCHAR1(0) QKZ
STAT07Inspection with Inspection PointsQKZFERTPRFCHAR1(0) QKZ
STAT35Usage Decision Has Been MadeQSTAT35CHAR1(0) QKZ
KZSKIPLOTLot SkippedQKZSKIPLOTCHAR1(0) QKZ
SLWBEZIdentifier for Inspection Point Field CombinationQSLWBEZCHAR3(0) Assigned to domainQSLWBEZQBK
STAT13Inspection Point TypeQPPKTTYPCHAR1(0) QPPKTTYP
PPKZTLZUPartial Lot Assignment in an Inspection During ProductionQPPKZTLZUCHAR1(0) QPPKZTLZU




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!