P_InspectionLot

Inspection Lot | view: PINSPLOT | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QASV, QASR, JSTO, JEST
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InspectionLotHasQuantity Posted to Inspection Stock Show values
InspectionLotHasUsageDecision Usage Decision Made Show values
Column Name Description Domain name
InspLotRsltRecgStatus null
Master Data Relations Join Conditions
Storage Location for Batch
  • Material Number
  • ?
  • Storage Location for Batch
  • Client
  • Plant
  • P_INSPECTIONLOT.MATERIAL == MCHB.MATNR
  • P_INSPECTIONLOT.[column in domain "CHARG_D"] == MCHB.CHARG
  • P_INSPECTIONLOT.BATCHSTORAGELOCATION == MCHB.LGORT
  • P_INSPECTIONLOT.MANDT == MCHB.MANDT
  • P_INSPECTIONLOT.PLANT == MCHB.WERKS
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • P_INSPECTIONLOT.MANDT == KNA1.MANDT
  • P_INSPECTIONLOT.CUSTOMER == KNA1.KUNNR
Inspection Lot Origin P_INSPECTIONLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • P_INSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART
  • P_INSPECTIONLOT.MANDT == TQ30.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • P_INSPECTIONLOT.MANUFACTURER == LFA1.LIFNR
  • P_INSPECTIONLOT.MANDT == LFA1.MANDT
Manufacturer Material
  • Manufacturer Material
  • Client
  • P_INSPECTIONLOT.MANUFACTURERPARTNMBR == MARA.MATNR
  • P_INSPECTIONLOT.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • P_INSPECTIONLOT.MATERIAL == MARA.MATNR
  • P_INSPECTIONLOT.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • P_INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • P_INSPECTIONLOT.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • P_INSPECTIONLOT.MANDT == T001W.MANDT
  • P_INSPECTIONLOT.PLANT == T001W.WERKS
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_INSPECTIONLOT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_INSPECTIONLOT.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_INSPECTIONLOT.SALESORGANIZATION == TVKO.VKORG
  • P_INSPECTIONLOT.MANDT == TVKO.MANDT
Customer (Sold-To Party)
  • Customer (Sold-To Party)
  • Client
  • P_INSPECTIONLOT.SOLDTOPARTY == KNA1.KUNNR
  • P_INSPECTIONLOT.MANDT == KNA1.MANDT
Vendor's account number
  • Client
  • Vendor's account number
  • P_INSPECTIONLOT.MANDT == LFA1.MANDT
  • P_INSPECTIONLOT.SUPPLIER == LFA1.LIFNR