C_Insplot_Object

Inspection Lot Object Page | view: CINSPLOTOBJECT | Extraction: Not supported | Component: Inspection Lot Worklist

Tables used: QALS, QAVE, MARA, PLKO, TCA01, TCA02, KNA1, TQ31T, TQ30T, ILOA, MPOS, MPLA, T399W, T351T, MAKT, T001W, NRIV, TQ80, MARA, MKAL, T024E, LFA1, T006, T006A, QPCD, QPCT, MKAL_AEND, MKAL_AEND, T350, TPAER

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

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description
InspectionLotQuantity	Inspection Lot Quantity
InspectionLotActualQuantity	Actual Lot Quantity
InspectionLotSampleQuantity	Inspection Sample Size
InspLotQtyDestroyed	Destroyed Quantity
InspectionLotDefectiveQuantity	Defective Quantity
InspQtyPosted	Quantity to Be Posted

Column Name	Description
InspectionLotStartDate	Start Date of Inspection in Local Time Zone
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
InspectionLotCreatedOnTime	System Time of Creation
InspectionLotCreatedOn	System Date on Which Data Record Was Created
InspectionLotChangeDate	System Date on Which Data Record Was Changed
InspectionLotChangeTime	System Time of Change
InspectionLotUsageDecidedOn	Date When Usage Decision Was Made
InspLotUsageDecisionTime	Time When Usage Decision Was Made
InspLotUsageDecisionChangedOn	Date When Usage Decision Was Changed
InspLotUsgeDcsnChangedTime	Time When Usage Decision Was Changed
InspLotSelectionValidFromDate	Key Date for Selecting Records or Changing Task Lists

Column Name	Description
MaterialIsBatchManaged	Batch Required	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
InspectionLotObjectText	Short Text for Inspection Object	QKURZTEXT
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspectionLotQuantityUnit	External Unit of Measurement in Commercial Format (3-Char.)	MSEH3
PlantName	Plant Name	TEXT30
BatchBySupplier	Supplier Batch Number	LICHN
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
BillOfOperationsChangeStateID	Internal counter	CIM_COUNT
BillOfOperationsDesc	Routing Description	TEXT40
BillOfOperationsTypeName	Description of the Task List Type	TEXT30
InspectionLotCreatedBy	Name of User Who Created the Data Record	QAENDERER
InspectionLotChangedBy	Name of User Who Last Changed Data Record	QAENDERER
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspectionLotQualityScore	Quality Score	QKENNZAHL
InspectionLotUsageDecidedBy	Usage Decision Made By	QAENDERER
InspLotUsageDecisionChangedBy	Usage Decision Changed By	QAENDERER
InspectionLotSampleUnit	External Unit of Measurement in Commercial Format (3-Char.)	MSEH3
InspectionLotOriginText	Inspection Lot Origin Text	QKURZTEXT
CustomerName	Name of Customer	TEXT80
SupplierName	Name of Supplier	TEXT80
ManufacturerName	Name of Supplier	TEXT80
MaterialName	Material Description	TEXT40
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingDocumentItem	null
MaterialDocumentYear	null
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	null
DeliveryDocument	Delivery Document	VBELN
DeliveryDocumentItem	null
ProductionVersionText	Short Text for Production Version	TEXT40
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	null
MaintenancePlanItemIntID	Maintenance item	POSNU
MaintenancePlanDesc	Maintenance Plan Text	TEXT40
MaintenancePlanItemDesc	Item Short Text	TEXT40
MaintenanceStrategyDesc	Description of maintenance strategy	TXT30
InspLotQuantityUnitDecPlaces	No. of decimal places for rounding	ANDEC
InspLotSampleQtyUnitDecPlaces	No. of decimal places for rounding	ANDEC

Master Data Relations	Join Conditions
Batch Number Client Batch Number Material Number	`C_INSPLOT_OBJECT.MANDT == MCH1.MANDT` `C_INSPLOT_OBJECT.BATCH == MCH1.CHARG` `C_INSPLOT_OBJECT.MATERIAL == MCH1.MATNR`
Bill of Operations Type Client Bill of Operations Type	`C_INSPLOT_OBJECT.MANDT == TCA01.MANDT` `C_INSPLOT_OBJECT.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`C_INSPLOT_OBJECT.MANDT == KNA1.MANDT` `C_INSPLOT_OBJECT.CUSTOMER == KNA1.KUNNR`
Inspection Lot Origin	`C_INSPLOT_OBJECT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Client Inspection Type	`C_INSPLOT_OBJECT.MANDT == TQ30.MANDT` `C_INSPLOT_OBJECT.INSPECTIONLOTTYPE == TQ30.ART`
Usage Decision Code Client Usage Decision Code ? Usage Decision Code Group ?	`C_INSPLOT_OBJECT.MANDT == QPCD.MANDT` `C_INSPLOT_OBJECT.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE` `C_INSPLOT_OBJECT.[column in domain "QVERSNR"] == QPCD.VERSION` `C_INSPLOT_OBJECT.INSPLOTUSAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE` `C_INSPLOT_OBJECT.[column in domain "QKATART"] == QPCD.KATALOGART`
Usage Decision Code Group Client Usage Decision Code Group ?	`C_INSPLOT_OBJECT.MANDT == QPGR.MANDT` `C_INSPLOT_OBJECT.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE` `C_INSPLOT_OBJECT.[column in domain "QKATART"] == QPGR.KATALOGART`
Follow-Up Action Client Follow-Up Action	`C_INSPLOT_OBJECT.MANDT == TQ07.MANDT` `C_INSPLOT_OBJECT.INSPLOTUSGEDCSNFOLLOWUPACTION == TQ07.FOLGEAKTI`
Maintenance Plan Client Maintenance Plan	`C_INSPLOT_OBJECT.MANDT == MPLA.MANDT` `C_INSPLOT_OBJECT.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Strategy Client Maintenance Strategy	`C_INSPLOT_OBJECT.MANDT == T351.MANDT` `C_INSPLOT_OBJECT.MAINTENANCESTRATEGY == T351.STRAT`
Number of Manufacturer Number of Manufacturer Client	`C_INSPLOT_OBJECT.MANUFACTURER == LFA1.LIFNR` `C_INSPLOT_OBJECT.MANDT == LFA1.MANDT`
Manufacturer Material Client Manufacturer Material	`C_INSPLOT_OBJECT.MANDT == MARA.MANDT` `C_INSPLOT_OBJECT.MANUFACTURERPARTNMBR == MARA.MATNR`
Order Number (Production Order) Client Order Number (Production Order)	`C_INSPLOT_OBJECT.MANDT == AUFK.MANDT` `C_INSPLOT_OBJECT.MANUFACTURINGORDER == AUFK.AUFNR`
Material Number Client Material Number	`C_INSPLOT_OBJECT.MANDT == MARA.MANDT` `C_INSPLOT_OBJECT.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_INSPLOT_OBJECT.MANDT == TQ01B.MANDT` `C_INSPLOT_OBJECT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_INSPLOT_OBJECT.MANDT == T001W.MANDT` `C_INSPLOT_OBJECT.PLANT == T001W.WERKS`
Production Version Client Production Version Material Number Plant	`C_INSPLOT_OBJECT.MANDT == MKAL.MANDT` `C_INSPLOT_OBJECT.PRODUCTIONVERSION == MKAL.VERID` `C_INSPLOT_OBJECT.MATERIAL == MKAL.MATNR` `C_INSPLOT_OBJECT.PLANT == MKAL.WERKS`
Purchasing Organization Client Purchasing Organization	`C_INSPLOT_OBJECT.MANDT == T024E.MANDT` `C_INSPLOT_OBJECT.PURCHASINGORGANIZATION == T024E.EKORG`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`C_INSPLOT_OBJECT.MANDT == AUFK.MANDT` `C_INSPLOT_OBJECT.QUALITYCOSTCOLLECTOR == AUFK.AUFNR`
Vendor's account number Client Vendor's account number	`C_INSPLOT_OBJECT.MANDT == LFA1.MANDT` `C_INSPLOT_OBJECT.SUPPLIER == LFA1.LIFNR`