P_InspLotResultRecording

Inspection Lot Result Recording | view: PINSPLOTRESREC | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QAVE, QASV, QASR, JSTO, JEST, TCA01, TCA02, T411, T411T, TQ31, TQ31T, TQ30, TQ30T, TQ79, MARA, MAKT, TQ01B, TQ01C, T006, T006A

🔑 Keys
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (4)
Other (6)
🔗 Relations (13)

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
InspectionLotEndDate	End Date of Inspection in Local Time Zone

Column Name	Description
InspLotEndDateGrp	Inspection Lot End Date Group	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspectionLotHasQuantity	Checkbox	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values

Column Name	Description	Domain name
InspectionLot	Inspection Lot Number	QPLOS
InspectionLotHasUsageDecision	null
InspLotIsTaskListRequired	null
InspLotHasMaterialSpec	null
InspLotNmbrOpenLongTermCharc	null
InspLotRsltRecgStatus	null

Master Data Relations	Join Conditions
Storage Location for Batch ? Material Number Storage Location for Batch Plant Client	`P_INSPLOTRESULTRECORDING.[column in domain "CHARG_D"] == MCHB.CHARG` `P_INSPLOTRESULTRECORDING.MATERIAL == MCHB.MATNR` `P_INSPLOTRESULTRECORDING.BATCHSTORAGELOCATION == MCHB.LGORT` `P_INSPLOTRESULTRECORDING.PLANT == MCHB.WERKS` `P_INSPLOTRESULTRECORDING.MANDT == MCHB.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`P_INSPLOTRESULTRECORDING.CUSTOMER == KNA1.KUNNR` `P_INSPLOTRESULTRECORDING.MANDT == KNA1.MANDT`
Inspection Lot Origin	`P_INSPLOTRESULTRECORDING.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Inspection Type Client	`P_INSPLOTRESULTRECORDING.INSPECTIONLOTTYPE == TQ30.ART` `P_INSPLOTRESULTRECORDING.MANDT == TQ30.MANDT`
Number of Manufacturer Number of Manufacturer Client	`P_INSPLOTRESULTRECORDING.MANUFACTURER == LFA1.LIFNR` `P_INSPLOTRESULTRECORDING.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`P_INSPLOTRESULTRECORDING.MANUFACTURERPARTNMBR == MARA.MATNR` `P_INSPLOTRESULTRECORDING.MANDT == MARA.MANDT`
Material Number Material Number Client	`P_INSPLOTRESULTRECORDING.MATERIAL == MARA.MATNR` `P_INSPLOTRESULTRECORDING.MANDT == MARA.MANDT`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`P_INSPLOTRESULTRECORDING.MANDT == TQ01B.MANDT` `P_INSPLOTRESULTRECORDING.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Plant Client	`P_INSPLOTRESULTRECORDING.PLANT == T001W.WERKS` `P_INSPLOTRESULTRECORDING.MANDT == T001W.MANDT`
Purchasing Organization Purchasing Organization Client	`P_INSPLOTRESULTRECORDING.PURCHASINGORGANIZATION == T024E.EKORG` `P_INSPLOTRESULTRECORDING.MANDT == T024E.MANDT`
Sales Organization Sales Organization Client	`P_INSPLOTRESULTRECORDING.SALESORGANIZATION == TVKO.VKORG` `P_INSPLOTRESULTRECORDING.MANDT == TVKO.MANDT`
Customer (Sold-To Party) Customer (Sold-To Party) Client	`P_INSPLOTRESULTRECORDING.SOLDTOPARTY == KNA1.KUNNR` `P_INSPLOTRESULTRECORDING.MANDT == KNA1.MANDT`
Vendor's account number Vendor's account number Client	`P_INSPLOTRESULTRECORDING.SUPPLIER == LFA1.LIFNR` `P_INSPLOTRESULTRECORDING.MANDT == LFA1.MANDT`