I_InspectionLotValueHelp

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

Tables used: QAMV, QALS, AFVC, QAOP, QAPP, QPRS, MARA, MAKT, CRHD

🔑 Keys (3)
💰 Amounts
∑ Quantities (1)
📅 Dates
☰ Categorical (21)
Other (53)
🔗 Relations (60)

Column Name	Description
InspectionLot	Inspection Lot Number
InspectionOperation	Operation/Activity Number
InspectionCharacteristic	Inspection Characteristic Number

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
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
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 Client Document Type	`I_INSPECTIONLOTVALUEHELP.MANDT == T003.MANDT` `I_INSPECTIONLOTVALUEHELP.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Batch Number Client Material Number Batch Number	`I_INSPECTIONLOTVALUEHELP.MANDT == MCH1.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIAL == MCH1.MATNR` `I_INSPECTIONLOTVALUEHELP.BATCH == MCH1.CHARG`
Storage Location for Batch Client Material Number Batch Number Storage Location for Batch Plant	`I_INSPECTIONLOTVALUEHELP.MANDT == MCHB.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIAL == MCHB.MATNR` `I_INSPECTIONLOTVALUEHELP.BATCH == MCHB.CHARG` `I_INSPECTIONLOTVALUEHELP.BATCHSTORAGELOCATION == MCHB.LGORT` `I_INSPECTIONLOTVALUEHELP.PLANT == MCHB.WERKS`
Bill of Operations Type Client Bill of Operations Type	`I_INSPECTIONLOTVALUEHELP.MANDT == TCA01.MANDT` `I_INSPECTIONLOTVALUEHELP.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Bill of Operations Usage Client Bill of Operations Usage	`I_INSPECTIONLOTVALUEHELP.MANDT == T411.MANDT` `I_INSPECTIONLOTVALUEHELP.BILLOFOPERATIONSUSAGE == T411.VERWE`
Destination Country/Region Destination Country/Region Client	`I_INSPECTIONLOTVALUEHELP.BILLTOPARTYCOUNTRY == T005.LAND1` `I_INSPECTIONLOTVALUEHELP.MANDT == T005.MANDT`
Business Area Client Business Area	`I_INSPECTIONLOTVALUEHELP.MANDT == TGSB.MANDT` `I_INSPECTIONLOTVALUEHELP.BUSINESSAREA == TGSB.GSBER`
Company Code Company Code Client	`I_INSPECTIONLOTVALUEHELP.COMPANYCODE == T001.BUKRS` `I_INSPECTIONLOTVALUEHELP.MANDT == T001.MANDT`
Controlling Area Client Controlling Area	`I_INSPECTIONLOTVALUEHELP.MANDT == TKA01.MANDT` `I_INSPECTIONLOTVALUEHELP.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client ? Cost Center Controlling Area	`I_INSPECTIONLOTVALUEHELP.MANDT == CSKS.MANDT` `I_INSPECTIONLOTVALUEHELP.[column in domain "DATBI"] == CSKS.DATBI` `I_INSPECTIONLOTVALUEHELP.COSTCENTER == CSKS.KOSTL` `I_INSPECTIONLOTVALUEHELP.CONTROLLINGAREA == CSKS.KOKRS`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`I_INSPECTIONLOTVALUEHELP.MANDT == KNA1.MANDT` `I_INSPECTIONLOTVALUEHELP.CUSTOMER == KNA1.KUNNR`
Delivery Category Client Delivery Category	`I_INSPECTIONLOTVALUEHELP.MANDT == TVLV.MANDT` `I_INSPECTIONLOTVALUEHELP.DELIVERYCATEGORY == TVLV.ABRVW`
Equipment Number Client Equipment Number	`I_INSPECTIONLOTVALUEHELP.MANDT == EQUI.MANDT` `I_INSPECTIONLOTVALUEHELP.EQUIPMENT == EQUI.EQUNR`
Functional Location Client Functional Location	`I_INSPECTIONLOTVALUEHELP.MANDT == IFLOT.MANDT` `I_INSPECTIONLOTVALUEHELP.FUNCTIONALLOCATION == IFLOT.TPLNR`
G/L Account Number Client ? G/L Account Number	`I_INSPECTIONLOTVALUEHELP.MANDT == SKA1.MANDT` `I_INSPECTIONLOTVALUEHELP.[column in domain "KTOPL"] == SKA1.KTOPL` `I_INSPECTIONLOTVALUEHELP.GLACCOUNT == SKA1.SAKNR`
Movement type (inventory management) Client Movement type (inventory management)	`I_INSPECTIONLOTVALUEHELP.MANDT == T156.MANDT` `I_INSPECTIONLOTVALUEHELP.GOODSMOVEMENTTYPE == T156.BWART`
Specification Record Status	`I_INSPECTIONLOTVALUEHELP.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS`
Inspection Stage ? Client Inspection Stage	`I_INSPECTIONLOTVALUEHELP.[column in domain "QDYNREGEL"] == QDPS.DYNREGEL` `I_INSPECTIONLOTVALUEHELP.MANDT == QDPS.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE`
Inspection Lot Origin	`I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Plant for Inspection Lot Client Plant for Inspection Lot	`I_INSPECTIONLOTVALUEHELP.MANDT == T001W.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTPLANT == T001W.WERKS`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`I_INSPECTIONLOTVALUEHELP.MANDT == T006.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Storage Location for Inspection Lot Stock Client Plant for Inspection Lot Storage Location for Inspection Lot Stock	`I_INSPECTIONLOTVALUEHELP.MANDT == T001L.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTPLANT == T001L.WERKS` `I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT`
Inspection Type Client Inspection Type	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ30.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONLOTTYPE == TQ30.ART`
Inspection Method Client Plant for Inspection Method ? Inspection Method	`I_INSPECTIONLOTVALUEHELP.MANDT == QMTB.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONMETHODPLANT == QMTB.WERKS` `I_INSPECTIONLOTVALUEHELP.[column in domain "QVERSNRPM"] == QMTB.VERSION` `I_INSPECTIONLOTVALUEHELP.INSPECTIONMETHOD == QMTB.PMTNR`
Plant for Inspection Method Client Plant for Inspection Method	`I_INSPECTIONLOTVALUEHELP.MANDT == T001W.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONMETHODPLANT == T001W.WERKS`
Plant Client Plant	`I_INSPECTIONLOTVALUEHELP.MANDT == T001W.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONOPERATIONPLANT == T001W.WERKS`
Inspection Severity Client Inspection Severity	`I_INSPECTIONLOTVALUEHELP.MANDT == QDEP.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONSEVERITY == QDEP.PRSCHAERFE`
Master Inspection Characteristic Client Plant for Master Inspection Characteristic Master Inspection Characteristic ?	`I_INSPECTIONLOTVALUEHELP.MANDT == QPMK.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER` `I_INSPECTIONLOTVALUEHELP.INSPECTIONSPECIFICATION == QPMK.MKMNR` `I_INSPECTIONLOTVALUEHELP.[column in domain "QVERSNRMK"] == QPMK.VERSION`
Inspector Qualification Client Inspector Qualification	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ11.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTORQUALIFICATION == TQ11.PRFQL`
Weighting of Characteristic Client Weighting of Characteristic	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ17A.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE`
Usage Decision Code ? ? Client Usage Decision Code Code Group of the Usage Decision	`I_INSPECTIONLOTVALUEHELP.[column in domain "QKATART"] == QPCD.KATALOGART` `I_INSPECTIONLOTVALUEHELP.[column in domain "QVERSNR"] == QPCD.VERSION` `I_INSPECTIONLOTVALUEHELP.MANDT == QPCD.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPSUBSETUSAGEDCSNCODE == QPCD.CODE` `I_INSPECTIONLOTVALUEHELP.INSPSUBSETUSAGEDCSNCODEGROUP == QPCD.CODEGRUPPE`
Code Group of the Usage Decision ? Client Code Group of the Usage Decision	`I_INSPECTIONLOTVALUEHELP.[column in domain "QKATART"] == QPGR.KATALOGART` `I_INSPECTIONLOTVALUEHELP.MANDT == QPGR.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPSUBSETUSAGEDCSNCODEGROUP == QPGR.CODEGRUPPE`
Number of Manufacturer Client Number of Manufacturer	`I_INSPECTIONLOTVALUEHELP.MANDT == LFA1.MANDT` `I_INSPECTIONLOTVALUEHELP.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Manufacturer Material Client	`I_INSPECTIONLOTVALUEHELP.MANUFACTURERPARTNMBR == MARA.MATNR` `I_INSPECTIONLOTVALUEHELP.MANDT == MARA.MANDT`
Order Number (Production Order) Order Number (Production Order) Client	`I_INSPECTIONLOTVALUEHELP.MANUFACTURINGORDER == AUFK.AUFNR` `I_INSPECTIONLOTVALUEHELP.MANDT == AUFK.MANDT`
Material Number Client Material Number	`I_INSPECTIONLOTVALUEHELP.MANDT == MARA.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIAL == MARA.MATNR`
Special Stock Indicator Client Special Stock Indicator	`I_INSPECTIONLOTVALUEHELP.MANDT == T148.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ`
Sample Category	`I_INSPECTIONLOTVALUEHELP.MATERIALSAMPLECATEGORY == TQ44.PRTYP`
Material Sample Location Client Material Sample Location Plant	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ41.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONOPERATIONPLANT == TQ41.WERKS`
Physical-sample type Client Material Sample Type	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ40.MANDT` `I_INSPECTIONLOTVALUEHELP.MATERIALSAMPLETYPE == TQ40.PRART`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`I_INSPECTIONLOTVALUEHELP.MANDT == TQ01B.MANDT` `I_INSPECTIONLOTVALUEHELP.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Control key ? Client Control key	`I_INSPECTIONLOTVALUEHELP.[column in domain "PLNAW"] == T430.PLNAW` `I_INSPECTIONLOTVALUEHELP.MANDT == T430.MANDT` `I_INSPECTIONLOTVALUEHELP.OPERATIONCONTROLPROFILE == T430.STEUS`
Plant Client Plant	`I_INSPECTIONLOTVALUEHELP.MANDT == T001W.MANDT` `I_INSPECTIONLOTVALUEHELP.PLANT == T001W.WERKS`
Production Version Client Production Version Material Number Plant	`I_INSPECTIONLOTVALUEHELP.MANDT == MKAL.MANDT` `I_INSPECTIONLOTVALUEHELP.PRODUCTIONVERSION == MKAL.VERID` `I_INSPECTIONLOTVALUEHELP.MATERIAL == MKAL.MATNR` `I_INSPECTIONLOTVALUEHELP.PLANT == MKAL.WERKS`
Profit Center Client ? ? Profit Center	`I_INSPECTIONLOTVALUEHELP.MANDT == CEPC.MANDT` `I_INSPECTIONLOTVALUEHELP.[column in domain "KOKRS"] == CEPC.KOKRS` `I_INSPECTIONLOTVALUEHELP.[column in domain "DATBI"] == CEPC.DATBI` `I_INSPECTIONLOTVALUEHELP.PROFITCENTER == CEPC.PRCTR`
Purchasing Organization Purchasing Organization Client	`I_INSPECTIONLOTVALUEHELP.PURCHASINGORGANIZATION == T024E.EKORG` `I_INSPECTIONLOTVALUEHELP.MANDT == T024E.MANDT`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`I_INSPECTIONLOTVALUEHELP.MANDT == AUFK.MANDT` `I_INSPECTIONLOTVALUEHELP.QUALITYCOSTCOLLECTOR == AUFK.AUFNR`
Route Client Route	`I_INSPECTIONLOTVALUEHELP.MANDT == TVRO.MANDT` `I_INSPECTIONLOTVALUEHELP.ROUTE == TVRO.ROUTE`
Sales Organization Client Sales Organization	`I_INSPECTIONLOTVALUEHELP.MANDT == TVKO.MANDT` `I_INSPECTIONLOTVALUEHELP.SALESORGANIZATION == TVKO.VKORG`
Serial Number Profile Client Serial Number Profile	`I_INSPECTIONLOTVALUEHELP.MANDT == T377P.MANDT` `I_INSPECTIONLOTVALUEHELP.SERIALNUMBERPROFILE == T377P.SERAIL`
Sample-Drawing Procedure Client Sample-Drawing Procedure ?	`I_INSPECTIONLOTVALUEHELP.MANDT == QPRVK.MANDT` `I_INSPECTIONLOTVALUEHELP.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF` `I_INSPECTIONLOTVALUEHELP.[column in domain "QVERSNPRZV"] == QPRVK.VERSION`
Customer (Sold-To Party) Client Customer (Sold-To Party)	`I_INSPECTIONLOTVALUEHELP.MANDT == KNA1.MANDT` `I_INSPECTIONLOTVALUEHELP.SOLDTOPARTY == KNA1.KUNNR`
Storage Bin Client Storage Bin Warehouse Number / Warehouse Complex Storage Type	`I_INSPECTIONLOTVALUEHELP.MANDT == LAGP.MANDT` `I_INSPECTIONLOTVALUEHELP.STORAGEBIN == LAGP.LGPLA` `I_INSPECTIONLOTVALUEHELP.WAREHOUSE == LAGP.LGNUM` `I_INSPECTIONLOTVALUEHELP.STORAGETYPE == LAGP.LGTYP`
Storage location Client Plant Storage location	`I_INSPECTIONLOTVALUEHELP.MANDT == T001L.MANDT` `I_INSPECTIONLOTVALUEHELP.INSPECTIONOPERATIONPLANT == T001L.WERKS` `I_INSPECTIONLOTVALUEHELP.STORAGELOCATION == T001L.LGORT`
Storage Type Client Warehouse Number / Warehouse Complex Storage Type	`I_INSPECTIONLOTVALUEHELP.MANDT == T301.MANDT` `I_INSPECTIONLOTVALUEHELP.WAREHOUSE == T301.LGNUM` `I_INSPECTIONLOTVALUEHELP.STORAGETYPE == T301.LGTYP`
Vendor's account number Client Vendor's account number	`I_INSPECTIONLOTVALUEHELP.MANDT == LFA1.MANDT` `I_INSPECTIONLOTVALUEHELP.SUPPLIER == LFA1.LIFNR`
Warehouse Number / Warehouse Complex Client Warehouse Number / Warehouse Complex	`I_INSPECTIONLOTVALUEHELP.MANDT == T300.MANDT` `I_INSPECTIONLOTVALUEHELP.WAREHOUSE == T300.LGNUM`