I_InspectionLot

Inspection Lot | view: IINSPECTIONLOT | TRAN | Extraction: Not supported | Component: Quality Inspection

Tables used: QALS

🔑 Keys (1)
💰 Amounts
∑ Quantities (18)
📅 Dates (12)
☰ Categorical (31)
Other (42)
🔗 Relations (72)

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
InspectionLotActualQuantity	Actual Lot Quantity
InspectionLotDefectiveQuantity	Defective Quantity
InspLotQtyToFree	Unrestricted-Use Stock
InspLotQtyToScrap	Scrap Quantity
InspLotQtyToSample	Quantity Posted to Sample
InspLotQtyToBlocked	Blocked Stock
InspLotQtyToReserves	Quantity Posted to Reserves
InspLotQtyToAnotherMaterial	New Material
InspLotQtyReturnedToSupplier	Return to Supplier
InspLotQtyToSpecialStock	Other Quantity
InspLotQtyToOtherStock	Other Quantity 2
InspLotQtyToBePosted	Quantity to Be Posted
📏 Lot Container (InspectionLotContainerUnit):
InspectionLotContainer	QM - No. of Containers
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity	Inspection Sample Size
InspLotSmplQtyForLongTermChar	Long-Term Sample Quantity
InspLotQtyInspected	Inspected Quantity
InspLotQtyDestroyed	Destroyed Quantity

Column Name	Description
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
InspectionLotStartTime	Inspection Started At
InspectionLotEndDate	End Date of Inspection in Local Time Zone
InspectionLotEndTime	Inspection Ended At
InspLotSelectionValidFromDate	Key Date for Selecting Records or Changing Task Lists
MatlDocLatestPostgDate	Posting Date in the Document

Column Name	Description
InspectionLotHasQuantity	Posted to Inspection Stock	Show values
InspLotIsCreatedAutomatically	Inspection Lot Is Created Automatically	Show values
InspectionLotHasPartialLots	Partial Lots Exist	Show values
InspectionLotHasAppraisalCosts	Record Appraisal Costs in Individual QM Order	Show values
InspLotHasSubsets	Inspection with Inspection Points	Show values
InspLotIsAutomUsgeDcsnPossible	Automatic Usage Decision Planned	Show values
PurchasingDocumentCategory	Source Inspection	Show values
InspLotHasConfignSpecification	Inspection Specifications from Configuration	Show values
InspLotIsDocumentationRequired	Documentation Required	Show values
InspLotIsTaskListRequired	Inspection Plan Required	Show values
InspLotHasManualSampleSize	Enter Sample Manually	Show values
InspLotHasMaterialSpec	Inspect with Material Specification	Show values
InspectionLotApproval	Inspection Lot Approval	Show values
InspLotDigitalSgntrResultsRecg	Digital Signature for Insp. Lot in Results Recording	Show values
InspLotDigitalSgntrInUsgeDcsn	Digital Signature Usage Decision	Show values
InspLotIsBatchRequired	Approved Batch Record Required	Show values
InspLotUsageInStabilityStudy	Inspection Lot for Stability Study	Show values
InspLotIsStockPostingCompleted	Stock Postings Completed	Show values
InspectionLotHasUsageDecision	Usage Decision Made	Show values
InspLotIsSerialNmbrPossible	Serial Numbers Possible	Show values
InspectionLotIsSkipped	Skip Lot	Show values
InspectionLotIsFullInspection	100% Inspection	Show values
InspectionSubsetType	Inspection Point Type	Show values
SmplDrwgProcedIsConfRequired	Confirmation Required for Sample Drawing	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
MaterialIsBatchManaged	Batch Required	Show values
InspLotDynamicTrggrPoint	Time of Dynamic Modification in Inspection Lot	Show values
InspLotUsageDecisionTool	Usage Decision Mode (UD Origin)	Show values
ConsumptionPosting	Consumption posting	Show values
InspLotAcctAssgmtKey	Account Assignment Key: Inspection Lot	Show values
InspUsgeDcsnDgtlSgntrType	Signature Type: Inspection Lot Usage Decision	Show values

Column Name	Description	Domain name
OrderInternalBillOfOperations	Routing number of operations in the order	AUFPL
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspLotNmbrOpenLongTermCharc	Open Long-Term Characteristics	INT2
InspectionLotObjectText	Short Text for Inspection Object	QKURZTEXT
Equipment	Equipment Number	EQUNR
FunctionalLocation	Functional Location	TPLNR
GoodsReceiptIsMovedToBlkdStock	GR Blocked Stock	KZWES
NumberOfSerialNumbers	Number of serial numbers	INT4
InspectionLotCreatedBy	Name of User Who Created the Data Record	QAENDERER
InspectionLotChangedBy	Name of User Who Last Changed Data Record	QAENDERER
ChangedDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
BillOfOperationsChangeStateID	Internal counter	CIM_COUNT
SmplDrawingProcedureVersion	Version No. of the Sample-Drawing Procedure	QVERSNR
InspLotSelMatlRevisionLvl	Revision Level	REVLV
BatchBySupplier	Supplier Batch Number	LICHN
MaterialRevisionLevel	Revision Level	REVLV
MaterialDocumentYear	Material Document Year	GJAHR
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	Sales Order Item	NUM06
DeliveryDocument	Delivery Document	VBELN
DeliveryDocumentItem	Delivery Document Item	POSNR
MaterialByCustomer	Customer Material	IDNEX
InspLotNmbrAddlRecordedCharc	Number of Characteristics Recorded Additionally	INT2
InspLotNmbrOpenShortTermCharc	Number of Outstanding Short-Term Chars That Require Confirm.	INT2
InspectionLotScrapRatio	Share of Scrap in Inspection Lot	QFLTP16
InspectionLotAllowedScrapRatio	Allowed Share of Scrap	QPMATLOS
ReservationItem	Item Number of Reservation / Dependent Requirements	RSPOS
NetworkActivityInternalID	Internal counter	CIM_COUNT
InventorySpclStkSalesDocument	Inventory Special Stock Sales Document	VBELN
InventorySpclStkSalesDocItm	Sales Order Item of Valuated Sales Order Stock	NUM06
ProfitabilitySegment	Deprecated: Profitability Segment	RKEOBJNR_NUMC
ProfitabilitySegment_2	Profitability Segment	RKEOBJNR_CHAR
InspLotCostCollectorSalesOrder	Sales Order Number	VBELN
InspLotCostCollectorSlsOrdItem	Item number in Sales Order	NUM06
InspLotExternalNumber	Inspection Document Number	QPLEXT_INSP_DOC_NUMBER
InspectionLotPriorityPoints	Priority Points	QPLEXT_PRIOP
MaintenancePlanItemIntID	Maintenance item	POSNU
InspUsgeDcsnDgtlSgntrStrgy	Signature Strategy with Individual Signature: Usage Decision	SIGNSTRAT

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`I_INSPECTIONLOT.MANDT == T163K.MANDT` `I_INSPECTIONLOT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Document Type Client Document Type	`I_INSPECTIONLOT.MANDT == T003.MANDT` `I_INSPECTIONLOT.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Batch Number Client Material Number Batch Number	`I_INSPECTIONLOT.MANDT == MCH1.MANDT` `I_INSPECTIONLOT.MATERIAL == MCH1.MATNR` `I_INSPECTIONLOT.BATCH == MCH1.CHARG`
Storage Location for Batch Client Material Number Batch Number Plant Storage Location for Batch	`I_INSPECTIONLOT.MANDT == MCHB.MANDT` `I_INSPECTIONLOT.MATERIAL == MCHB.MATNR` `I_INSPECTIONLOT.BATCH == MCHB.CHARG` `I_INSPECTIONLOT.PLANT == MCHB.WERKS` `I_INSPECTIONLOT.BATCHSTORAGELOCATION == MCHB.LGORT`
Bill of Operations Type Client Bill of Operations Type	`I_INSPECTIONLOT.MANDT == TCA01.MANDT` `I_INSPECTIONLOT.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Bill of Operations Usage Client Bill of Operations Usage	`I_INSPECTIONLOT.MANDT == T411.MANDT` `I_INSPECTIONLOT.BILLOFOPERATIONSUSAGE == T411.VERWE`
Destination Country/Region Client Destination Country/Region	`I_INSPECTIONLOT.MANDT == T005.MANDT` `I_INSPECTIONLOT.BILLTOPARTYCOUNTRY == T005.LAND1`
Business Area Client Business Area	`I_INSPECTIONLOT.MANDT == TGSB.MANDT` `I_INSPECTIONLOT.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`I_INSPECTIONLOT.COMPANYCODE == T001.BUKRS` `I_INSPECTIONLOT.MANDT == T001.MANDT`
Controlling Area Client Controlling Area	`I_INSPECTIONLOT.MANDT == TKA01.MANDT` `I_INSPECTIONLOT.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client ? Cost Center Controlling Area	`I_INSPECTIONLOT.MANDT == CSKS.MANDT` `I_INSPECTIONLOT.[column in domain "DATBI"] == CSKS.DATBI` `I_INSPECTIONLOT.COSTCENTER == CSKS.KOSTL` `I_INSPECTIONLOT.CONTROLLINGAREA == CSKS.KOKRS`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`I_INSPECTIONLOT.MANDT == KNA1.MANDT` `I_INSPECTIONLOT.CUSTOMER == KNA1.KUNNR`
Delivery Category Client Delivery Category	`I_INSPECTIONLOT.MANDT == TVLV.MANDT` `I_INSPECTIONLOT.DELIVERYCATEGORY == TVLV.ABRVW`
Asset Subnumber Company Code Client Main Asset Number Asset Subnumber	`I_INSPECTIONLOT.COMPANYCODE == ANLA.BUKRS` `I_INSPECTIONLOT.MANDT == ANLA.MANDT` `I_INSPECTIONLOT.MASTERFIXEDASSET == ANLA.ANLN1` `I_INSPECTIONLOT.FIXEDASSET == ANLA.ANLN2`
G/L Account Number Client ? G/L Account Number	`I_INSPECTIONLOT.MANDT == SKA1.MANDT` `I_INSPECTIONLOT.[column in domain "KTOPL"] == SKA1.KTOPL` `I_INSPECTIONLOT.GLACCOUNT == SKA1.SAKNR`
Movement type (inventory management) Client Movement type (inventory management)	`I_INSPECTIONLOT.MANDT == T156.MANDT` `I_INSPECTIONLOT.GOODSMOVEMENTTYPE == T156.BWART`
Inspection Stage Client Dynamic Modification Rule Inspection Stage	`I_INSPECTIONLOT.MANDT == QDPS.MANDT` `I_INSPECTIONLOT.INSPLOTDYNAMICRULE == QDPS.DYNREGEL` `I_INSPECTIONLOT.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE`
Lot Container Client Lot Container	`I_INSPECTIONLOT.MANDT == T006.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTCONTAINERUNIT == T006.MSEHI`
Level at Which Dynamic Modification Parameters Are Defined	`I_INSPECTIONLOT.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL`
Inspection Lot Origin	`I_INSPECTIONLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Plant for Inspection Lot Client Plant for Inspection Lot	`I_INSPECTIONLOT.MANDT == T001W.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTPLANT == T001W.WERKS`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`I_INSPECTIONLOT.MANDT == T006.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Sample Unit of Measure Client Sample Unit of Measure	`I_INSPECTIONLOT.MANDT == T006.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI`
Storage Location for Inspection Lot Stock Storage Location for Inspection Lot Stock Client Plant for Inspection Lot	`I_INSPECTIONLOT.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT` `I_INSPECTIONLOT.MANDT == T001L.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTPLANT == T001L.WERKS`
Inspection Type Client Inspection Type	`I_INSPECTIONLOT.MANDT == TQ30.MANDT` `I_INSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART`
Inspection Severity Client Inspection Severity	`I_INSPECTIONLOT.MANDT == QDEP.MANDT` `I_INSPECTIONLOT.INSPECTIONSEVERITY == QDEP.PRSCHAERFE`
Batch Transferred To Batch Transferred To Client Material Posted To	`I_INSPECTIONLOT.INSPLOTBATCHTRANSFERREDTO == MCH1.CHARG` `I_INSPECTIONLOT.MANDT == MCH1.MANDT` `I_INSPECTIONLOT.INSPLOTMATERIALPOSTEDTO == MCH1.MATNR`
Dynamic Modification Rule Client Dynamic Modification Rule	`I_INSPECTIONLOT.MANDT == QDDR.MANDT` `I_INSPECTIONLOT.INSPLOTDYNAMICRULE == QDDR.DYNREGEL`
Material Posted To Client Material Posted To	`I_INSPECTIONLOT.MANDT == MARA.MANDT` `I_INSPECTIONLOT.INSPLOTMATERIALPOSTEDTO == MARA.MATNR`
Task List Usage Client Task List Usage	`I_INSPECTIONLOT.MANDT == T411.MANDT` `I_INSPECTIONLOT.INSPLOTSELBILLOFOPERATIONSUSGE == T411.VERWE`
Account number of customer Client Account number of customer	`I_INSPECTIONLOT.MANDT == KNA1.MANDT` `I_INSPECTIONLOT.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR`
Number of Manufacturer Client Number of Manufacturer	`I_INSPECTIONLOT.MANDT == LFA1.MANDT` `I_INSPECTIONLOT.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR`
Material Number Client Material Number	`I_INSPECTIONLOT.MANDT == MARA.MANDT` `I_INSPECTIONLOT.INSPLOTSELECTIONMATERIAL == MARA.MATNR`
Plant Client Plant	`I_INSPECTIONLOT.MANDT == T001W.MANDT` `I_INSPECTIONLOT.INSPLOTSELECTIONPLANT == T001W.WERKS`
Vendor's account number Client Vendor's account number	`I_INSPECTIONLOT.MANDT == LFA1.MANDT` `I_INSPECTIONLOT.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR`
Inspection Point Identification Client Identifier for Inspection Point Field Combination	`I_INSPECTIONLOT.MANDT == TQ79.MANDT` `I_INSPECTIONLOT.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ`
Language Key	`I_INSPECTIONLOT.LANGUAGE == T002.SPRAS`
Maintenance Plan Client Maintenance Plan	`I_INSPECTIONLOT.MANDT == MPLA.MANDT` `I_INSPECTIONLOT.MAINTENANCEPLAN == MPLA.WARPL`
Maintenance Strategy Client Maintenance Strategy	`I_INSPECTIONLOT.MANDT == T351.MANDT` `I_INSPECTIONLOT.MAINTENANCESTRATEGY == T351.STRAT`
Number of Manufacturer Client Number of Manufacturer	`I_INSPECTIONLOT.MANDT == LFA1.MANDT` `I_INSPECTIONLOT.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Client Manufacturer Material	`I_INSPECTIONLOT.MANDT == MARA.MANDT` `I_INSPECTIONLOT.MANUFACTURERPARTNMBR == MARA.MATNR`
Order Number (Production Order) Client Order Number (Production Order)	`I_INSPECTIONLOT.MANDT == AUFK.MANDT` `I_INSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR`
Material Number Client Material Number	`I_INSPECTIONLOT.MANDT == MARA.MANDT` `I_INSPECTIONLOT.MATERIAL == MARA.MATNR`
Special Stock Indicator Client Special Stock Indicator	`I_INSPECTIONLOT.MANDT == T148.MANDT` `I_INSPECTIONLOT.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`I_INSPECTIONLOT.MANDT == TQ01B.MANDT` `I_INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`I_INSPECTIONLOT.MANDT == T001W.MANDT` `I_INSPECTIONLOT.PLANT == T001W.WERKS`
Production Version Client Material Number Production Version Plant	`I_INSPECTIONLOT.MANDT == MKAL.MANDT` `I_INSPECTIONLOT.MATERIAL == MKAL.MATNR` `I_INSPECTIONLOT.PRODUCTIONVERSION == MKAL.VERID` `I_INSPECTIONLOT.PLANT == MKAL.WERKS`
Profit Center Client Profit Center ? ?	`I_INSPECTIONLOT.MANDT == CEPC.MANDT` `I_INSPECTIONLOT.PROFITCENTER == CEPC.PRCTR` `I_INSPECTIONLOT.[column in domain "KOKRS"] == CEPC.KOKRS` `I_INSPECTIONLOT.[column in domain "DATBI"] == CEPC.DATBI`
Network Number for Account Assignment Client Network Number for Account Assignment	`I_INSPECTIONLOT.MANDT == AUFK.MANDT` `I_INSPECTIONLOT.PROJECTNETWORK == AUFK.AUFNR`
Item category in purchasing document Client Item category in purchasing document	`I_INSPECTIONLOT.MANDT == T163.MANDT` `I_INSPECTIONLOT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Organization Client Purchasing Organization	`I_INSPECTIONLOT.MANDT == T024E.MANDT` `I_INSPECTIONLOT.PURCHASINGORGANIZATION == T024E.EKORG`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`I_INSPECTIONLOT.MANDT == AUFK.MANDT` `I_INSPECTIONLOT.QUALITYCOSTCOLLECTOR == AUFK.AUFNR`
Route Client Route	`I_INSPECTIONLOT.MANDT == TVRO.MANDT` `I_INSPECTIONLOT.ROUTE == TVRO.ROUTE`
Production Version Number Client Run Schedule Header	`I_INSPECTIONLOT.MANDT == SAFK.MANDT` `I_INSPECTIONLOT.SALESOPERATIONSPLANNINGORDER == SAFK.AUFNR`
Sales Organization Client Sales Organization	`I_INSPECTIONLOT.MANDT == TVKO.MANDT` `I_INSPECTIONLOT.SALESORGANIZATION == TVKO.VKORG`
Sampling Procedure Client Sampling Procedure	`I_INSPECTIONLOT.MANDT == QDSV.MANDT` `I_INSPECTIONLOT.SAMPLINGPROCEDURE == QDSV.STICHPRVER`
Serial Number Profile Client Serial Number Profile	`I_INSPECTIONLOT.MANDT == T377P.MANDT` `I_INSPECTIONLOT.SERIALNUMBERPROFILE == T377P.SERAIL`
Sample-Drawing Procedure Client Sample-Drawing Procedure Version No. of the Sample-Drawing Procedure	`I_INSPECTIONLOT.MANDT == QPRVK.MANDT` `I_INSPECTIONLOT.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF` `I_INSPECTIONLOT.SMPLDRAWINGPROCEDUREVERSION == QPRVK.VERSION`
Customer (Sold-To Party) Client Customer (Sold-To Party)	`I_INSPECTIONLOT.MANDT == KNA1.MANDT` `I_INSPECTIONLOT.SOLDTOPARTY == KNA1.KUNNR`
Object Type	`I_INSPECTIONLOT.STATUSOBJECTCATEGORY == TJ03.OBTYP`
Status Profile Client Status Profile	`I_INSPECTIONLOT.MANDT == TJ20.MANDT` `I_INSPECTIONLOT.STATUSPROFILE == TJ20.STSMA`
Storage Bin Storage Bin Client Storage Type Warehouse Number / Warehouse Complex	`I_INSPECTIONLOT.STORAGEBIN == LAGP.LGPLA` `I_INSPECTIONLOT.MANDT == LAGP.MANDT` `I_INSPECTIONLOT.STORAGETYPE == LAGP.LGTYP` `I_INSPECTIONLOT.WAREHOUSE == LAGP.LGNUM`
Storage Type Client Storage Type Warehouse Number / Warehouse Complex	`I_INSPECTIONLOT.MANDT == T301.MANDT` `I_INSPECTIONLOT.STORAGETYPE == T301.LGTYP` `I_INSPECTIONLOT.WAREHOUSE == T301.LGNUM`
Vendor's account number Client Vendor's account number	`I_INSPECTIONLOT.MANDT == LFA1.MANDT` `I_INSPECTIONLOT.SUPPLIER == LFA1.LIFNR`
Warehouse Number / Warehouse Complex Client Warehouse Number / Warehouse Complex	`I_INSPECTIONLOT.MANDT == T300.MANDT` `I_INSPECTIONLOT.WAREHOUSE == T300.LGNUM`