C_InspectionLotOVP

Inspection Lot Overview Page | view: CINSPLOTOVP | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QAVE, QASV, QASR, QMEL, QMFE, JSTO, JEST, PRTE, KNA1, TQ31, TQ31T, TQ30, TQ30T, MARA, MAKT, T001W, PROJ, T024E, TVKO, TVKOT, LFA1, QPCD, QPGR, QPGT, QPCT, PRPS, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (1)
☰ Categorical (3)
Other (3)
🔗 Relations (12)

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity

Column Name	Description
InspectionLotCreatedOn	System Date on Which Data Record Was Created

Column Name	Description
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspLotCompltnStatus	Inspection Lot Status	Show values
InspectionLotHasQuantity	Checkbox	Show values

Column Name	Description	Domain name
MaterialName	Material Description	TEXT40
BillOfOperationsGroup	null
InspLotIsTaskListRequired	null

Master Data Relations	Join Conditions
Storage Location for Batch Storage Location for Batch Client Plant ? Material Number	`C_INSPECTIONLOTOVP.BATCHSTORAGELOCATION == MCHB.LGORT` `C_INSPECTIONLOTOVP.MANDT == MCHB.MANDT` `C_INSPECTIONLOTOVP.PLANT == MCHB.WERKS` `C_INSPECTIONLOTOVP.[column in domain "CHARG_D"] == MCHB.CHARG` `C_INSPECTIONLOTOVP.MATERIAL == MCHB.MATNR`
Inspection Lot Origin	`C_INSPECTIONLOTOVP.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`C_INSPECTIONLOTOVP.MANDT == T006.MANDT` `C_INSPECTIONLOTOVP.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Inspection Type Client Inspection Type	`C_INSPECTIONLOTOVP.MANDT == TQ30.MANDT` `C_INSPECTIONLOTOVP.INSPECTIONLOTTYPE == TQ30.ART`
Number of Manufacturer Number of Manufacturer Client	`C_INSPECTIONLOTOVP.MANUFACTURER == LFA1.LIFNR` `C_INSPECTIONLOTOVP.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_INSPECTIONLOTOVP.MANUFACTURERPARTNMBR == MARA.MATNR` `C_INSPECTIONLOTOVP.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_INSPECTIONLOTOVP.MANDT == MARA.MANDT` `C_INSPECTIONLOTOVP.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_INSPECTIONLOTOVP.MANDT == TQ01B.MANDT` `C_INSPECTIONLOTOVP.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_INSPECTIONLOTOVP.MANDT == T001W.MANDT` `C_INSPECTIONLOTOVP.PLANT == T001W.WERKS`
Purchasing Organization Purchasing Organization Client	`C_INSPECTIONLOTOVP.PURCHASINGORGANIZATION == T024E.EKORG` `C_INSPECTIONLOTOVP.MANDT == T024E.MANDT`
Serial Number Profile Serial Number Profile Client	`C_INSPECTIONLOTOVP.SERIALNUMBERPROFILE == T377P.SERAIL` `C_INSPECTIONLOTOVP.MANDT == T377P.MANDT`
Vendor's account number Client Vendor's account number	`C_INSPECTIONLOTOVP.MANDT == LFA1.MANDT` `C_INSPECTIONLOTOVP.SUPPLIER == LFA1.LIFNR`