I_InspectionLotVH

Inspection Lot Value Help | view: IINSPECTIONLOTVH | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALSKNA1TQ30TQ30TMARAMAKTT001WLFA1
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
InspLotCreatedOnLocalDate Date in Time Zone Where Lot Created
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
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • I_INSPECTIONLOTVH.MANDT == MCH1.MANDT
  • I_INSPECTIONLOTVH.MATERIAL == MCH1.MATNR
  • I_INSPECTIONLOTVH.BATCH == MCH1.CHARG
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_INSPECTIONLOTVH.MANDT == KNA1.MANDT
  • I_INSPECTIONLOTVH.CUSTOMER == KNA1.KUNNR
Inspection Type
  • Client
  • Inspection Type
  • I_INSPECTIONLOTVH.MANDT == TQ30.MANDT
  • I_INSPECTIONLOTVH.INSPECTIONLOTTYPE == TQ30.ART
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • I_INSPECTIONLOTVH.MANDT == LFA1.MANDT
  • I_INSPECTIONLOTVH.MANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_INSPECTIONLOTVH.MANDT == MARA.MANDT
  • I_INSPECTIONLOTVH.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_INSPECTIONLOTVH.MANDT == TQ01B.MANDT
  • I_INSPECTIONLOTVH.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • I_INSPECTIONLOTVH.MANDT == T001W.MANDT
  • I_INSPECTIONLOTVH.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • I_INSPECTIONLOTVH.MANDT == LFA1.MANDT
  • I_INSPECTIONLOTVH.SUPPLIER == LFA1.LIFNR