I_InspectionLotFilter

Inspection Lot Filter | view: IINSPLOTFIL | TRAN | Extraction: Not supported | Component: Quality Management
Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QASV, QASR, QPRS, JSTO, JEST, MARA, MAKT, CRHD
Column Name Description
InspectionLot Inspection Lot Number
InspectionOperation Operation/Activity Number
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
InspectionLotQuantity Inspection Lot Quantity
Column Name Description
Column Name Description
InspectionLotHasUsageDecision Usage Decision Made Show values
InspectionLotHasQuantity Posted to Inspection Stock Show values
InspectionLotHasPartialLots Partial Lots Exist Show values
InspLotIsDocumentationRequired Documentation Required Show values
InspectionLotApproval Inspection Lot Approval Show values
InspLotDigitalSgntrInUsgeDcsn Digital Signature Usage Decision Show values
InspectionLotIsSkipped Skip Lot Show values
InspectionLotIsFullInspection 100% Inspection Show values
SmplDrwgProcedIsConfRequired Confirmation Required for Sample Drawing Show values
MaterialIsBatchManaged Batch Required Show values
InspLotIsSerialNmbrPossible Serial Numbers Possible Show values
InspLotIsAutomUsgeDcsnPossible Automatic Usage Decision Planned Show values
InspLotHasConfignSpecification Inspection Specifications from Configuration Show values
InspLotIsTaskListRequired Inspection Plan Required Show values
InspLotHasManualSampleSize Enter Sample Manually Show values
InspLotHasMaterialSpec Inspect with Material Specification Show values
InspLotDigitalSgntrResultsRecg Digital Signature for Insp. Lot in Results Recording Show values
InspLotIsBatchRequired Approved Batch Record Required Show values
InspLotIsStockPostingCompleted Stock Postings Completed Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
InspSubsetUsageDcsnValuation Code Valuation Show values
Column Name Description Domain name
InspectionLotText Inspection Lot Text QKURZTEXT
InspLotCreatedOnLocalDate null
MaterialName Material Description TEXT40
InspLotNmbrOpenLongTermCharc Open Long-Term Characteristics INT2
InspectionLotObjectText Short Text for Inspection Object QKURZTEXT
GoodsReceiptIsMovedToBlkdStock GR Blocked Stock KZWES
InspLotCreatedOnLocalTime null
InspectionLotCreatedBy Name of User Who Created the Data Record QAENDERER
InspectionLotCreatedOn null
InspectionLotCreatedOnTime null
InspectionLotChangedBy Name of User Who Last Changed Data Record QAENDERER
InspectionLotChangeDate null
InspectionLotChangeTime null
InspectionLotStartDate null
InspectionLotStartTime null
InspectionLotEndDate null
InspectionLotEndTime null
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
InspLotSelectionValidFromDate null
MaterialRevisionLevel Revision Level REVLV
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MatlDocLatestPostgDate null
SalesOrder Sales Order Number VBELN
DeliveryDocument Delivery Document VBELN
MaterialByCustomer Customer Material IDNEX
InspLotNmbrAddlRecordedCharc Number of Characteristics Recorded Additionally INT2
InspLotNmbrOpenShortTermCharc Number of Outstanding Short-Term Chars That Require Confirm. INT2
NumberOfSerialNumbers Number of serial numbers INT4
BatchBySupplier Supplier Batch Number LICHN
InspLotRsltRecgStatus null
OperationText Operation Short Text TEXT40
WorkCenter Work Center ARBPL
OperationConfirmation Completion confirmation number for the operation CO_RUECK
InspectionSubSystem Subsystem Identifier for QM Subsystem Interface QEIFSUBSYS
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspSpecInformationField1 Text Line for Additional Information QTXT10
InspSpecInformationField2 Text Line for Additional Information QTXT20
InspSpecInformationField3 Text Line for Additional Information QTXT40
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSubsetSortKey Key Field (Sort Field) for Inspection Point QPPSORT
InspectionSubsetLongCharKey User Field for 18 Characters QUSRCHAR18
InspectionSubsetShortCharKey User Field for 10 Characters QUSRCHAR10
InspSubsetLongNumericKey User Field for 10 Digits QUSRNUMC10
InspSubsetShortNumericKey User Field for 3 Digits QUSRNUMC3
InspectionSubsetDate null
InspectionSubsetTime null
MaterialSampleChangedOn null
MaterialSampleDrawingLocation Location of Sample Drawing (Functional Location) TPLNR
MatlSmplDrawingLocDescription Description of Sample-Drawing Location CHAR60
MaterialSampleDrawingOnDate null
MaterialSampleDrawingOnTime null
MaterialSampleResponsibleName Processor Responsible for the Sample, Sample Taker CHAR20
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • I_INSPECTIONLOTFILTER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_INSPECTIONLOTFILTER.MANDT == T003.MANDT
Batch Number
  • Batch Number
  • Material Number
  • Client
  • I_INSPECTIONLOTFILTER.BATCH == MCH1.CHARG
  • I_INSPECTIONLOTFILTER.MATERIAL == MCH1.MATNR
  • I_INSPECTIONLOTFILTER.MANDT == MCH1.MANDT
Storage Location for Batch
  • Batch Number
  • Plant
  • Storage Location for Batch
  • Material Number
  • Client
  • I_INSPECTIONLOTFILTER.BATCH == MCHB.CHARG
  • I_INSPECTIONLOTFILTER.PLANT == MCHB.WERKS
  • I_INSPECTIONLOTFILTER.BATCHSTORAGELOCATION == MCHB.LGORT
  • I_INSPECTIONLOTFILTER.MATERIAL == MCHB.MATNR
  • I_INSPECTIONLOTFILTER.MANDT == MCHB.MANDT
Bill of Operations Type
  • Bill of Operations Type
  • Client
  • I_INSPECTIONLOTFILTER.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_INSPECTIONLOTFILTER.MANDT == TCA01.MANDT
Bill of Operations Usage
  • Client
  • Bill of Operations Usage
  • I_INSPECTIONLOTFILTER.MANDT == T411.MANDT
  • I_INSPECTIONLOTFILTER.BILLOFOPERATIONSUSAGE == T411.VERWE
Destination Country/Region
  • Destination Country/Region
  • Client
  • I_INSPECTIONLOTFILTER.BILLTOPARTYCOUNTRY == T005.LAND1
  • I_INSPECTIONLOTFILTER.MANDT == T005.MANDT
Business Area
  • Business Area
  • Client
  • I_INSPECTIONLOTFILTER.BUSINESSAREA == TGSB.GSBER
  • I_INSPECTIONLOTFILTER.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_INSPECTIONLOTFILTER.COMPANYCODE == T001.BUKRS
  • I_INSPECTIONLOTFILTER.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_INSPECTIONLOTFILTER.CONTROLLINGAREA == TKA01.KOKRS
  • I_INSPECTIONLOTFILTER.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • I_INSPECTIONLOTFILTER.[column in domain "DATBI"] == CSKS.DATBI
  • I_INSPECTIONLOTFILTER.CONTROLLINGAREA == CSKS.KOKRS
  • I_INSPECTIONLOTFILTER.COSTCENTER == CSKS.KOSTL
  • I_INSPECTIONLOTFILTER.MANDT == CSKS.MANDT
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • I_INSPECTIONLOTFILTER.CUSTOMER == KNA1.KUNNR
  • I_INSPECTIONLOTFILTER.MANDT == KNA1.MANDT
Delivery Category
  • Delivery Category
  • Client
  • I_INSPECTIONLOTFILTER.DELIVERYCATEGORY == TVLV.ABRVW
  • I_INSPECTIONLOTFILTER.MANDT == TVLV.MANDT
Equipment Number
  • Equipment Number
  • Client
  • I_INSPECTIONLOTFILTER.EQUIPMENT == EQUI.EQUNR
  • I_INSPECTIONLOTFILTER.MANDT == EQUI.MANDT
Functional Location
  • Client
  • Functional Location
  • I_INSPECTIONLOTFILTER.MANDT == IFLOT.MANDT
  • I_INSPECTIONLOTFILTER.FUNCTIONALLOCATION == IFLOT.TPLNR
G/L Account Number
  • ?
  • G/L Account Number
  • Client
  • I_INSPECTIONLOTFILTER.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_INSPECTIONLOTFILTER.GLACCOUNT == SKA1.SAKNR
  • I_INSPECTIONLOTFILTER.MANDT == SKA1.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_INSPECTIONLOTFILTER.GOODSMOVEMENTTYPE == T156.BWART
  • I_INSPECTIONLOTFILTER.MANDT == T156.MANDT
Specification Record Status I_INSPECTIONLOTFILTER.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS
Inspection Stage
  • Inspection Stage
  • ?
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE
  • I_INSPECTIONLOTFILTER.[column in domain "QDYNREGEL"] == QDPS.DYNREGEL
  • I_INSPECTIONLOTFILTER.MANDT == QDPS.MANDT
Inspection Lot Origin I_INSPECTIONLOTFILTER.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Plant for Inspection Lot
  • Plant for Inspection Lot
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONLOTPLANT == T001W.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == T001W.MANDT
Storage Location for Inspection Lot Stock
  • Plant for Inspection Lot
  • Storage Location for Inspection Lot Stock
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONLOTPLANT == T001L.WERKS
  • I_INSPECTIONLOTFILTER.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT
  • I_INSPECTIONLOTFILTER.MANDT == T001L.MANDT
Inspection Type
  • Inspection Type
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONLOTTYPE == TQ30.ART
  • I_INSPECTIONLOTFILTER.MANDT == TQ30.MANDT
Inspection Method
  • Inspection Method
  • Plant for Inspection Method
  • Client
  • ?
  • I_INSPECTIONLOTFILTER.INSPECTIONMETHOD == QMTB.PMTNR
  • I_INSPECTIONLOTFILTER.INSPECTIONMETHODPLANT == QMTB.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == QMTB.MANDT
  • I_INSPECTIONLOTFILTER.[column in domain "QVERSNRPM"] == QMTB.VERSION
Plant for Inspection Method
  • Plant for Inspection Method
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONMETHODPLANT == T001W.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == T001W.MANDT
Plant
  • Plant
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONOPERATIONPLANT == T001W.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == T001W.MANDT
Inspection Severity
  • Inspection Severity
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONSEVERITY == QDEP.PRSCHAERFE
  • I_INSPECTIONLOTFILTER.MANDT == QDEP.MANDT
Master Inspection Characteristic
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • Client
  • ?
  • I_INSPECTIONLOTFILTER.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_INSPECTIONLOTFILTER.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_INSPECTIONLOTFILTER.MANDT == QPMK.MANDT
  • I_INSPECTIONLOTFILTER.[column in domain "QVERSNRMK"] == QPMK.VERSION
Inspector Qualification
  • Inspector Qualification
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTORQUALIFICATION == TQ11.PRFQL
  • I_INSPECTIONLOTFILTER.MANDT == TQ11.MANDT
Weighting of Characteristic
  • Weighting of Characteristic
  • Client
  • I_INSPECTIONLOTFILTER.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
  • I_INSPECTIONLOTFILTER.MANDT == TQ17A.MANDT
Usage Decision Code
  • ?
  • Code Group of the Usage Decision
  • Usage Decision Code
  • Client
  • ?
  • I_INSPECTIONLOTFILTER.[column in domain "QVERSNR"] == QPCD.VERSION
  • I_INSPECTIONLOTFILTER.INSPSUBSETUSAGEDCSNCODEGROUP == QPCD.CODEGRUPPE
  • I_INSPECTIONLOTFILTER.INSPSUBSETUSAGEDCSNCODE == QPCD.CODE
  • I_INSPECTIONLOTFILTER.MANDT == QPCD.MANDT
  • I_INSPECTIONLOTFILTER.[column in domain "QKATART"] == QPCD.KATALOGART
Code Group of the Usage Decision
  • Code Group of the Usage Decision
  • Client
  • ?
  • I_INSPECTIONLOTFILTER.INSPSUBSETUSAGEDCSNCODEGROUP == QPGR.CODEGRUPPE
  • I_INSPECTIONLOTFILTER.MANDT == QPGR.MANDT
  • I_INSPECTIONLOTFILTER.[column in domain "QKATART"] == QPGR.KATALOGART
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • I_INSPECTIONLOTFILTER.MANUFACTURER == LFA1.LIFNR
  • I_INSPECTIONLOTFILTER.MANDT == LFA1.MANDT
Manufacturer Material
  • Manufacturer Material
  • Client
  • I_INSPECTIONLOTFILTER.MANUFACTURERPARTNMBR == MARA.MATNR
  • I_INSPECTIONLOTFILTER.MANDT == MARA.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • I_INSPECTIONLOTFILTER.MANUFACTURINGORDER == AUFK.AUFNR
  • I_INSPECTIONLOTFILTER.MANDT == AUFK.MANDT
Material Number
  • Material Number
  • Client
  • I_INSPECTIONLOTFILTER.MATERIAL == MARA.MATNR
  • I_INSPECTIONLOTFILTER.MANDT == MARA.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_INSPECTIONLOTFILTER.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ
  • I_INSPECTIONLOTFILTER.MANDT == T148.MANDT
Sample Category I_INSPECTIONLOTFILTER.MATERIALSAMPLECATEGORY == TQ44.PRTYP
Material Sample Location
  • Material Sample Location
  • Plant
  • Client
  • I_INSPECTIONLOTFILTER.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT
  • I_INSPECTIONLOTFILTER.INSPECTIONOPERATIONPLANT == TQ41.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == TQ41.MANDT
Physical-sample type
  • Client
  • Material Sample Type
  • I_INSPECTIONLOTFILTER.MANDT == TQ40.MANDT
  • I_INSPECTIONLOTFILTER.MATERIALSAMPLETYPE == TQ40.PRART
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_INSPECTIONLOTFILTER.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_INSPECTIONLOTFILTER.MANDT == TQ01B.MANDT
Control key
  • Client
  • Control key
  • ?
  • I_INSPECTIONLOTFILTER.MANDT == T430.MANDT
  • I_INSPECTIONLOTFILTER.OPERATIONCONTROLPROFILE == T430.STEUS
  • I_INSPECTIONLOTFILTER.[column in domain "PLNAW"] == T430.PLNAW
Plant
  • Plant
  • Client
  • I_INSPECTIONLOTFILTER.PLANT == T001W.WERKS
  • I_INSPECTIONLOTFILTER.MANDT == T001W.MANDT
Production Version
  • Plant
  • Material Number
  • Production Version
  • Client
  • I_INSPECTIONLOTFILTER.PLANT == MKAL.WERKS
  • I_INSPECTIONLOTFILTER.MATERIAL == MKAL.MATNR
  • I_INSPECTIONLOTFILTER.PRODUCTIONVERSION == MKAL.VERID
  • I_INSPECTIONLOTFILTER.MANDT == MKAL.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_INSPECTIONLOTFILTER.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_INSPECTIONLOTFILTER.[column in domain "DATBI"] == CEPC.DATBI
  • I_INSPECTIONLOTFILTER.PROFITCENTER == CEPC.PRCTR
  • I_INSPECTIONLOTFILTER.MANDT == CEPC.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • I_INSPECTIONLOTFILTER.PURCHASINGORGANIZATION == T024E.EKORG
  • I_INSPECTIONLOTFILTER.MANDT == T024E.MANDT
Order Number for Recording Appraisal Costs
  • Order Number for Recording Appraisal Costs
  • Client
  • I_INSPECTIONLOTFILTER.QUALITYCOSTCOLLECTOR == AUFK.AUFNR
  • I_INSPECTIONLOTFILTER.MANDT == AUFK.MANDT
Route
  • Route
  • Client
  • I_INSPECTIONLOTFILTER.ROUTE == TVRO.ROUTE
  • I_INSPECTIONLOTFILTER.MANDT == TVRO.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_INSPECTIONLOTFILTER.SALESORGANIZATION == TVKO.VKORG
  • I_INSPECTIONLOTFILTER.MANDT == TVKO.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • I_INSPECTIONLOTFILTER.SERIALNUMBERPROFILE == T377P.SERAIL
  • I_INSPECTIONLOTFILTER.MANDT == T377P.MANDT
Sample-Drawing Procedure
  • ?
  • Sample-Drawing Procedure
  • Client
  • I_INSPECTIONLOTFILTER.[column in domain "QVERSNPRZV"] == QPRVK.VERSION
  • I_INSPECTIONLOTFILTER.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF
  • I_INSPECTIONLOTFILTER.MANDT == QPRVK.MANDT
Customer (Sold-To Party)
  • Customer (Sold-To Party)
  • Client
  • I_INSPECTIONLOTFILTER.SOLDTOPARTY == KNA1.KUNNR
  • I_INSPECTIONLOTFILTER.MANDT == KNA1.MANDT
Storage Bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Client
  • I_INSPECTIONLOTFILTER.STORAGEBIN == LAGP.LGPLA
  • I_INSPECTIONLOTFILTER.WAREHOUSE == LAGP.LGNUM
  • I_INSPECTIONLOTFILTER.STORAGETYPE == LAGP.LGTYP
  • I_INSPECTIONLOTFILTER.MANDT == LAGP.MANDT
Storage location
  • Plant
  • Storage location
  • Client
  • I_INSPECTIONLOTFILTER.INSPECTIONOPERATIONPLANT == T001L.WERKS
  • I_INSPECTIONLOTFILTER.STORAGELOCATION == T001L.LGORT
  • I_INSPECTIONLOTFILTER.MANDT == T001L.MANDT
Storage Type
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Client
  • I_INSPECTIONLOTFILTER.WAREHOUSE == T301.LGNUM
  • I_INSPECTIONLOTFILTER.STORAGETYPE == T301.LGTYP
  • I_INSPECTIONLOTFILTER.MANDT == T301.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_INSPECTIONLOTFILTER.SUPPLIER == LFA1.LIFNR
  • I_INSPECTIONLOTFILTER.MANDT == LFA1.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • I_INSPECTIONLOTFILTER.WAREHOUSE == T300.LGNUM
  • I_INSPECTIONLOTFILTER.MANDT == T300.MANDT