I_InspectionReportHeader

Inspection Report Header Information | view: IINSPREPHEAD | TRAN | Extraction: Not supported | Component: Inspection Lot Worklist

Tables used: QALS, QAVE, JSTO, JEST

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

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity	Inspection Sample Size

Column Name	Description
InspectionLotStartDate	Start Date of Inspection in Local Time Zone
InspectionLotEndDate	End Date of Inspection in Local Time Zone
InspReportUserCurrentTime	Field of type TIMS
InspReportUserCurrentDate	Field of type DATS

Column Name	Description
MaterialIsBatchManaged	Batch Required	Show values
InspectionLotHasPartialLots	Partial Lots Exist	Show values
InspectionLotHasUsageDecision	Usage Decision Made	Show values
InspLotHasSubsets	Inspection with Inspection Points	Show values
InspectionSubsetType	Inspection Point Type	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
BillOfOperationsChangeStateID	Internal counter	CIM_COUNT
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspectionLotObjectText	Short Text for Inspection Object	QKURZTEXT
InspLotUsgeDcsnValuationText	Lot Status: UD Made or Not Made	QKURZTEXT
InspectionLotDefectPresentText	Defects Present/No Defects Present	QKURZTEXT
InspLotStsDefectsRecorded	Object status	J_STATUS

Master Data Relations	Join Conditions
Batch Number Material Number Batch Number Client	`I_INSPECTIONREPORTHEADER.MATERIAL == MCH1.MATNR` `I_INSPECTIONREPORTHEADER.BATCH == MCH1.CHARG` `I_INSPECTIONREPORTHEADER.MANDT == MCH1.MANDT`
Bill of Operations Type Client Bill of Operations Type	`I_INSPECTIONREPORTHEADER.MANDT == TCA01.MANDT` `I_INSPECTIONREPORTHEADER.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`I_INSPECTIONREPORTHEADER.CUSTOMER == KNA1.KUNNR` `I_INSPECTIONREPORTHEADER.MANDT == KNA1.MANDT`
Inspection Lot Origin	`I_INSPECTIONREPORTHEADER.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Base Unit of Measure for Inspection Lot Quantity Client	`I_INSPECTIONREPORTHEADER.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI` `I_INSPECTIONREPORTHEADER.MANDT == T006.MANDT`
Sample Unit of Measure Sample Unit of Measure Client	`I_INSPECTIONREPORTHEADER.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `I_INSPECTIONREPORTHEADER.MANDT == T006.MANDT`
Inspection Type Inspection Type Client	`I_INSPECTIONREPORTHEADER.INSPECTIONLOTTYPE == TQ30.ART` `I_INSPECTIONREPORTHEADER.MANDT == TQ30.MANDT`
Usage Decision Code Group ? Client Usage Decision Code Group	`I_INSPECTIONREPORTHEADER.[column in domain "QKATART"] == QPGR.KATALOGART` `I_INSPECTIONREPORTHEADER.MANDT == QPGR.MANDT` `I_INSPECTIONREPORTHEADER.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE`
Inspection Point Identification Identifier for Inspection Point Field Combination Client	`I_INSPECTIONREPORTHEADER.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ` `I_INSPECTIONREPORTHEADER.MANDT == TQ79.MANDT`
Language Key	`I_INSPECTIONREPORTHEADER.LANGUAGE == T002.SPRAS`
Material Number Material Number Client	`I_INSPECTIONREPORTHEADER.MATERIAL == MARA.MATNR` `I_INSPECTIONREPORTHEADER.MANDT == MARA.MANDT`
Material Authorization Group for Activities in QM Material Authorization Group for Activities in QM Client	`I_INSPECTIONREPORTHEADER.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH` `I_INSPECTIONREPORTHEADER.MANDT == TQ01B.MANDT`
Plant Plant Client	`I_INSPECTIONREPORTHEADER.PLANT == T001W.WERKS` `I_INSPECTIONREPORTHEADER.MANDT == T001W.MANDT`
Vendor's account number Vendor's account number Client	`I_INSPECTIONREPORTHEADER.SUPPLIER == LFA1.LIFNR` `I_INSPECTIONREPORTHEADER.MANDT == LFA1.MANDT`