C_InspLotMltplRsltRec

Inspection Lots for Mltpl Rslt Recording | view: CINSPLOTSMLTPL | TRAN | Extraction: Not supported | Component: Results Recording

Tables used: DRAT, QAMV, QALS, AFVC, QAOP, QAMR, QAVE, AFFH, JSTO, JEST, CRVD_A, DRAW, EQUI, CRVE_A, EQKT, EQUZ, IFLOT, QMTT, QPMT, T002, CRVM_A, MAKT, IMPTT, CRVS_A, CRVP_A, IMPTT, CRFH, CRTX, T006, T006D, T006A, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (8)
☰ Categorical (2)
Other (19)
🔗 Relations (12)

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description
InspectionLotQuantity	Inspection Lot Quantity

Column Name	Description
InspectionLotEndDate	End Date of Inspection in Local Time Zone
InspLotCreatedOnLocalDate	Date in Time Zone Where Lot Created
InspLotCreatedOnLocalTime	Time in Time Zone Where Lot Created
InspectionLotCreatedOn	System Date on Which Data Record Was Created
InspectionLotCreatedOnTime	System Time of Creation
InspectionLotChangeDate	System Date on Which Data Record Was Changed
InspectionLotChangeTime	System Time of Change
InspectionLotStartDate	Start Date of Inspection in Local Time Zone

Column Name	Description
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspLotIsSerialNmbrPossible	Serial Numbers Possible	Show values

Column Name	Description	Domain name
InspCharAcceptedCount	null
InspCharRejectedCount	null
InspCharOpenCount	null
InspCharacteristicCount	null
InspCharLongTermOpenCount	null
InspectionSpecification	null
InspectionSpecificationPlant	Plant for Master Inspection Characteristic
InspectionSpecificationText	Short Text for Inspection Characteristic
InspectionLotCreatedBy	Name of User Who Created the Data Record
InspectionLotChangedBy	Name of User Who Last Changed Data Record
MaterialRevisionLevel	Revision Level
MaterialIsBatchManaged	Batch Required
BatchBySupplier	Supplier Batch Number
InspectionLotObjectText	Short Text for Inspection Object
OrderInternalBillOfOperations	Routing number of operations in the order	AUFPL
InspectionLotText	Inspection Lot Text
ProductionResourceTool	Production Resource/Tool Number
ProductionResourceToolDesc	Description of the Production Resource/Tool
WorkCenter	Work Center	ARBPL

Master Data Relations	Join Conditions
Batch Number Batch Number Client Material Number	`C_INSPLOTMLTPLRSLTREC.BATCH == MCH1.CHARG` `C_INSPLOTMLTPLRSLTREC.MANDT == MCH1.MANDT` `C_INSPLOTMLTPLRSLTREC.MATERIAL == MCH1.MATNR`
Storage Location for Batch Storage Location for Batch Batch Number Client Material Number Plant	`C_INSPLOTMLTPLRSLTREC.BATCHSTORAGELOCATION == MCHB.LGORT` `C_INSPLOTMLTPLRSLTREC.BATCH == MCHB.CHARG` `C_INSPLOTMLTPLRSLTREC.MANDT == MCHB.MANDT` `C_INSPLOTMLTPLRSLTREC.MATERIAL == MCHB.MATNR` `C_INSPLOTMLTPLRSLTREC.PLANT == MCHB.WERKS`
Bill of Operations Type Bill of Operations Type Client	`C_INSPLOTMLTPLRSLTREC.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `C_INSPLOTMLTPLRSLTREC.MANDT == TCA01.MANDT`
Specification Record Status	`C_INSPLOTMLTPLRSLTREC.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS`
Inspection Lot Origin	`C_INSPLOTMLTPLRSLTREC.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Inspection Type Client	`C_INSPLOTMLTPLRSLTREC.INSPECTIONLOTTYPE == TQ30.ART` `C_INSPLOTMLTPLRSLTREC.MANDT == TQ30.MANDT`
Inspection Method Plant for Inspection Method Inspection Method Client ?	`C_INSPLOTMLTPLRSLTREC.INSPECTIONMETHODPLANT == QMTB.WERKS` `C_INSPLOTMLTPLRSLTREC.INSPECTIONMETHOD == QMTB.PMTNR` `C_INSPLOTMLTPLRSLTREC.MANDT == QMTB.MANDT` `C_INSPLOTMLTPLRSLTREC.[column in domain "QVERSNRPM"] == QMTB.VERSION`
Plant for Inspection Method Plant for Inspection Method Client	`C_INSPLOTMLTPLRSLTREC.INSPECTIONMETHODPLANT == T001W.WERKS` `C_INSPLOTMLTPLRSLTREC.MANDT == T001W.MANDT`
Material Number Client Material Number	`C_INSPLOTMLTPLRSLTREC.MANDT == MARA.MANDT` `C_INSPLOTMLTPLRSLTREC.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_INSPLOTMLTPLRSLTREC.MANDT == TQ01B.MANDT` `C_INSPLOTMLTPLRSLTREC.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_INSPLOTMLTPLRSLTREC.MANDT == T001W.MANDT` `C_INSPLOTMLTPLRSLTREC.PLANT == T001W.WERKS`
Serial Number Profile Client Serial Number Profile	`C_INSPLOTMLTPLRSLTREC.MANDT == T377P.MANDT` `C_INSPLOTMLTPLRSLTREC.SERIALNUMBERPROFILE == T377P.SERAIL`