C_Qm_Inspectlot_Filterbar

Result Recording filter bar | view: CQMINSPLOTFILBAR | Extraction: Not supported | Component: Quality Management

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QASV, QASR, QPRS, JSTO, JEST, CRHD

🔑 Keys (2)
💰 Amounts
∑ Quantities (1)
📅 Dates (9)
☰ Categorical (2)
Other (38)
🔗 Relations (52)

Column Name	Description
InspectionLot	Inspection Lot Number
InspectionCharacteristic	Inspection Characteristic Number

Column Name	Description

Column Name	Description
InspectionLotQuantity	Inspection Lot Quantity

Column Name	Description
InspectionLotStartDate	Start Date of Inspection in Local Time Zone
InspectionLotEndDate	End Date of Inspection in Local Time Zone
MatlDocLatestPostgDate	Posting Date in the Document
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

Column Name	Description
InspectionSubsetType	Inspection Point Type	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
OrderInternalBillOfOperations	Routing number of operations in the order	AUFPL
InspectionLotText	Inspection Lot Text
InspLotRsltRecgStatus	null
InspLotIsTaskListRequired	Inspection Plan Required
MaterialRevisionLevel	Revision Level
MaterialIsBatchManaged	Batch Required
BatchBySupplier	Supplier Batch Number
InspectionLotObjectText	Short Text for Inspection Object
MaterialDocumentYear	Material Document Year
MaterialDocument	Number of Material Document
GoodsReceiptIsMovedToBlkdStock	GR Blocked Stock
InspectionLotHasQuantity	null
InspLotIsStockPostingCompleted	null
DeliveryDocument	Delivery Document
MaterialByCustomer	Customer Material
SalesOrder	Sales Order Number
BillOfOperationsGroup	Bill of Operations Group
BillOfOperationsVariant	Bill of Operations Group Counter
InspLotNmbrAddlRecordedCharc	Number of Characteristics Recorded Additionally
InspLotNmbrOpenShortTermCharc	Number of Outstanding Short-Term Chars That Require Confirm.
InspLotNmbrOpenLongTermCharc	Open Long-Term Characteristics
InspLotDigitalSgntrInUsgeDcsn	Digital Signature Usage Decision
InspLotDigitalSgntrResultsRecg	Digital Signature for Insp. Lot in Results Recording
InspectionLotCreatedBy	Name of User Who Created the Data Record
InspectionLotChangedBy	Name of User Who Last Changed Data Record
InspectionOperation	Operation/Activity Number
OperationText	Operation Short Text
InspectionSubSystem	Subsystem Identifier for QM Subsystem Interface
OperationConfirmation	Completion confirmation number for the operation
WorkCenter	Work Center
InspectionSpecificationPlant	Plant for Master Inspection Characteristic
InspectionSpecificationVersion	Version Number of Master Inspection Characteristic	QVERSNR
InspectionSpecificationText	Short Text for Inspection Characteristic
InspSpecInformationField1	Text Line for Additional Information
InspSpecInformationField2	Text Line for Additional Information
InspSpecInformationField3	Text Line for Additional Information
InspectionSubsetSortKey	Key Field (Sort Field) for Inspection Point
InspSubsetUsageDcsnValuation	Code Valuation

Master Data Relations	Join Conditions
Document Type Document Type Client	`C_QM_INSPECTLOT_FILTERBAR.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T003.MANDT`
Batch Number Batch Number Client Material Number	`C_QM_INSPECTLOT_FILTERBAR.BATCH == MCH1.CHARG` `C_QM_INSPECTLOT_FILTERBAR.MANDT == MCH1.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MATERIAL == MCH1.MATNR`
Bill of Operations Type Client Bill of Operations Type	`C_QM_INSPECTLOT_FILTERBAR.MANDT == TCA01.MANDT` `C_QM_INSPECTLOT_FILTERBAR.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Bill of Operations Usage Client Bill of Operations Usage	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T411.MANDT` `C_QM_INSPECTLOT_FILTERBAR.BILLOFOPERATIONSUSAGE == T411.VERWE`
Destination Country/Region Client Destination Country/Region	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T005.MANDT` `C_QM_INSPECTLOT_FILTERBAR.BILLTOPARTYCOUNTRY == T005.LAND1`
Business Area Business Area Client	`C_QM_INSPECTLOT_FILTERBAR.BUSINESSAREA == TGSB.GSBER` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TGSB.MANDT`
Company Code Company Code Client	`C_QM_INSPECTLOT_FILTERBAR.COMPANYCODE == T001.BUKRS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_QM_INSPECTLOT_FILTERBAR.CONTROLLINGAREA == TKA01.KOKRS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TKA01.MANDT`
Cost Center Controlling Area Client ? Cost Center	`C_QM_INSPECTLOT_FILTERBAR.CONTROLLINGAREA == CSKS.KOKRS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == CSKS.MANDT` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "DATBI"] == CSKS.DATBI` `C_QM_INSPECTLOT_FILTERBAR.COSTCENTER == CSKS.KOSTL`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_QM_INSPECTLOT_FILTERBAR.CUSTOMER == KNA1.KUNNR` `C_QM_INSPECTLOT_FILTERBAR.MANDT == KNA1.MANDT`
Delivery Category Delivery Category Client	`C_QM_INSPECTLOT_FILTERBAR.DELIVERYCATEGORY == TVLV.ABRVW` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TVLV.MANDT`
G/L Account Number G/L Account Number Client ?	`C_QM_INSPECTLOT_FILTERBAR.GLACCOUNT == SKA1.SAKNR` `C_QM_INSPECTLOT_FILTERBAR.MANDT == SKA1.MANDT` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "KTOPL"] == SKA1.KTOPL`
Movement type (inventory management) Movement type (inventory management) Client	`C_QM_INSPECTLOT_FILTERBAR.GOODSMOVEMENTTYPE == T156.BWART` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T156.MANDT`
Specification Record Status	`C_QM_INSPECTLOT_FILTERBAR.INSPECTIONCHARACTERISTICSTATUS == TQ76.STATUS`
Inspection Lot Origin	`C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Plant for Inspection Lot Client Plant for Inspection Lot	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T001W.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTPLANT == T001W.WERKS`
Storage Location for Inspection Lot Stock Client Plant for Inspection Lot Storage Location for Inspection Lot Stock	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T001L.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTPLANT == T001L.WERKS` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT`
Inspection Type Client Inspection Type	`C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ30.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTTYPE == TQ30.ART`
Usage Decision Code Usage Decision Code Client Usage Decision Code Group ? ?	`C_QM_INSPECTLOT_FILTERBAR.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE` `C_QM_INSPECTLOT_FILTERBAR.MANDT == QPCD.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPLOTUSAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "QVERSNR"] == QPCD.VERSION` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "QKATART"] == QPCD.KATALOGART`
Inspection Method Inspection Method Plant for Inspection Method Client ?	`C_QM_INSPECTLOT_FILTERBAR.INSPECTIONMETHOD == QMTB.PMTNR` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONMETHODPLANT == QMTB.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == QMTB.MANDT` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "QVERSNRPM"] == QMTB.VERSION`
Plant for Inspection Method Plant for Inspection Method Client	`C_QM_INSPECTLOT_FILTERBAR.INSPECTIONMETHODPLANT == T001W.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T001W.MANDT`
Master Inspection Characteristic Client Master Inspection Characteristic Plant for Master Inspection Characteristic ?	`C_QM_INSPECTLOT_FILTERBAR.MANDT == QPMK.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONSPECIFICATION == QPMK.MKMNR` `C_QM_INSPECTLOT_FILTERBAR.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "QVERSNRMK"] == QPMK.VERSION`
Inspector Qualification Inspector Qualification Client	`C_QM_INSPECTLOT_FILTERBAR.INSPECTORQUALIFICATION == TQ11.PRFQL` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ11.MANDT`
Usage Decision Code Group Client Usage Decision Code Group ?	`C_QM_INSPECTLOT_FILTERBAR.MANDT == QPGR.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "QKATART"] == QPGR.KATALOGART`
Weighting of Characteristic Client Weighting of Characteristic	`C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ17A.MANDT` `C_QM_INSPECTLOT_FILTERBAR.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE`
Number of Manufacturer Client Number of Manufacturer	`C_QM_INSPECTLOT_FILTERBAR.MANDT == LFA1.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Manufacturer Material Client	`C_QM_INSPECTLOT_FILTERBAR.MANUFACTURERPARTNMBR == MARA.MATNR` `C_QM_INSPECTLOT_FILTERBAR.MANDT == MARA.MANDT`
Order Number (Production Order) Client Order Number (Production Order)	`C_QM_INSPECTLOT_FILTERBAR.MANDT == AUFK.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MANUFACTURINGORDER == AUFK.AUFNR`
Material Number Client Material Number	`C_QM_INSPECTLOT_FILTERBAR.MANDT == MARA.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MATERIAL == MARA.MATNR`
Special Stock Indicator Special Stock Indicator Client	`C_QM_INSPECTLOT_FILTERBAR.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T148.MANDT`
Sample Category	`C_QM_INSPECTLOT_FILTERBAR.MATERIALSAMPLECATEGORY == TQ44.PRTYP`
Material Sample Location Plant Material Sample Location Client	`C_QM_INSPECTLOT_FILTERBAR.PRODUCTIONPLANT == TQ41.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ41.MANDT`
Physical-sample type Client Material Sample Type	`C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ40.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MATERIALSAMPLETYPE == TQ40.PRART`
Material Authorization Group for Activities in QM Material Authorization Group for Activities in QM Client	`C_QM_INSPECTLOT_FILTERBAR.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TQ01B.MANDT`
Control key ? Client Control key	`C_QM_INSPECTLOT_FILTERBAR.[column in domain "PLNAW"] == T430.PLNAW` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T430.MANDT` `C_QM_INSPECTLOT_FILTERBAR.OPERATIONCONTROLPROFILE == T430.STEUS`
Plant Plant Client	`C_QM_INSPECTLOT_FILTERBAR.PLANT == T001W.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T001W.MANDT`
Plant Plant Client	`C_QM_INSPECTLOT_FILTERBAR.PRODUCTIONPLANT == T001W.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T001W.MANDT`
Production Version Plant Client Material Number Production Version	`C_QM_INSPECTLOT_FILTERBAR.PLANT == MKAL.WERKS` `C_QM_INSPECTLOT_FILTERBAR.MANDT == MKAL.MANDT` `C_QM_INSPECTLOT_FILTERBAR.MATERIAL == MKAL.MATNR` `C_QM_INSPECTLOT_FILTERBAR.PRODUCTIONVERSION == MKAL.VERID`
Profit Center Client Profit Center ? ?	`C_QM_INSPECTLOT_FILTERBAR.MANDT == CEPC.MANDT` `C_QM_INSPECTLOT_FILTERBAR.PROFITCENTER == CEPC.PRCTR` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "KOKRS"] == CEPC.KOKRS` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "DATBI"] == CEPC.DATBI`
Purchasing Organization Client Purchasing Organization	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T024E.MANDT` `C_QM_INSPECTLOT_FILTERBAR.PURCHASINGORGANIZATION == T024E.EKORG`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`C_QM_INSPECTLOT_FILTERBAR.MANDT == AUFK.MANDT` `C_QM_INSPECTLOT_FILTERBAR.QUALITYCOSTCOLLECTOR == AUFK.AUFNR`
Route Client Route	`C_QM_INSPECTLOT_FILTERBAR.MANDT == TVRO.MANDT` `C_QM_INSPECTLOT_FILTERBAR.ROUTE == TVRO.ROUTE`
Sales Organization Sales Organization Client	`C_QM_INSPECTLOT_FILTERBAR.SALESORGANIZATION == TVKO.VKORG` `C_QM_INSPECTLOT_FILTERBAR.MANDT == TVKO.MANDT`
Serial Number Profile Serial Number Profile Client	`C_QM_INSPECTLOT_FILTERBAR.SERIALNUMBERPROFILE == T377P.SERAIL` `C_QM_INSPECTLOT_FILTERBAR.MANDT == T377P.MANDT`
Customer (Sold-To Party) Client Customer (Sold-To Party)	`C_QM_INSPECTLOT_FILTERBAR.MANDT == KNA1.MANDT` `C_QM_INSPECTLOT_FILTERBAR.SOLDTOPARTY == KNA1.KUNNR`
Object Type	`C_QM_INSPECTLOT_FILTERBAR.STATUSOBJECTCATEGORY == TJ03.OBTYP`
Vendor's account number Vendor's account number Client	`C_QM_INSPECTLOT_FILTERBAR.SUPPLIER == LFA1.LIFNR` `C_QM_INSPECTLOT_FILTERBAR.MANDT == LFA1.MANDT`
Warehouse Number / Warehouse Complex Client Warehouse Number / Warehouse Complex	`C_QM_INSPECTLOT_FILTERBAR.MANDT == T300.MANDT` `C_QM_INSPECTLOT_FILTERBAR.WAREHOUSE == T300.LGNUM`
Object ID of the resource Client ? Object ID of the resource	`C_QM_INSPECTLOT_FILTERBAR.MANDT == CRID.MANDT` `C_QM_INSPECTLOT_FILTERBAR.[column in domain "CR_OBJTY"] == CRID.OBJTY` `C_QM_INSPECTLOT_FILTERBAR.WORKCENTERINTERNALID == CRID.OBJID`