P_InspLotRsltRecgStatus

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

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QASV, QASR, JSTO, JEST

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

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
InspLotRsltRecgStatus	Results Recording Status for an Inspection Lot	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspectionLotHasQuantity	Posted to Inspection Stock	Show values
InspectionLotHasUsageDecision	Usage Decision Made	Show values

Column Name	Description	Domain name
InspLotRsltRecgStatusText	Results Recording Status for an Inspection Lot Text	DDTEXT

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