I_InspectionLotVH2

Inspection Lot Value Help | view: IIL__VH3 | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS, KNA1, TQ30, TQ30T, MARA, MAKT, T001W, LFA1
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspectionLotText Inspection Lot Text QKURZTEXT
InspectionLotTypeText Inspection Type Text QKURZTEXT
MaterialName Material Description TEXT40
CustomerName Name of Customer TEXT80
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_INSPECTIONLOTVH2.MATERIAL == MCH1.MATNR
  • I_INSPECTIONLOTVH2.BATCH == MCH1.CHARG
  • I_INSPECTIONLOTVH2.MANDT == MCH1.MANDT
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_INSPECTIONLOTVH2.MANDT == KNA1.MANDT
  • I_INSPECTIONLOTVH2.CUSTOMER == KNA1.KUNNR
Inspection Type
  • Client
  • Inspection Type
  • I_INSPECTIONLOTVH2.MANDT == TQ30.MANDT
  • I_INSPECTIONLOTVH2.INSPECTIONLOTTYPE == TQ30.ART
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • I_INSPECTIONLOTVH2.MANDT == LFA1.MANDT
  • I_INSPECTIONLOTVH2.MANUFACTURER == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • I_INSPECTIONLOTVH2.MATERIAL == MARA.MATNR
  • I_INSPECTIONLOTVH2.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_INSPECTIONLOTVH2.MANDT == TQ01B.MANDT
  • I_INSPECTIONLOTVH2.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • I_INSPECTIONLOTVH2.PLANT == T001W.WERKS
  • I_INSPECTIONLOTVH2.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_INSPECTIONLOTVH2.SUPPLIER == LFA1.LIFNR
  • I_INSPECTIONLOTVH2.MANDT == LFA1.MANDT