C_QM_InspectionLotsByOperation

Inspection lots for main page - group by operation | view: CQMINSPLBOP | Extraction: Not supported | Component: Quality Management

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QAVE, QASV, QASR, JSTO, JEST, TQ31, TQ31T, TQ30, TQ30T, TQ79, MARA, MAKT, CRTX, T006, T006A, CRHD

🔑 Keys (2)
💰 Amounts
∑ Quantities (1)
📅 Dates (16)
☰ Categorical (11)
Other (97)
🔗 Relations (47)

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

Column Name	Description

Column Name	Description
InspectionLotQuantity	Inspection Lot 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
InspectionLotEndDate	End Date of Inspection in Local Time Zone
InspOpUsageDecidedOn	System Date When Usage Decision Was Recorded
InspOpUsageDecisionTime	System Time When Usage Decision Was Recorded
InspOpUsageDecisionChangedOn	System Date When Usage Decision Changed
InspOpUsgeDcsnChangedTime	System Time When Usage Decision Changed
InspLotSelectionValidFromDate	Key Date for Selecting Records or Changing Task Lists
MatlDocLatestPostgDate	Posting Date in the Document
InspectionSubsetDate	null
InspectionSubsetTime	null

Column Name	Description
InspOpUsageDecisionValuation	Code Valuation	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values
InspOpUsgeDcsnDynValuation	Dynamic Modif. Valuation According to Worst Case Principle	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspectionLotHasPartialLots	Partial Lots Exist	Show values
InspectionLotHasQuantity	Posted to Inspection Stock	Show values
InspLotIsDocumentationRequired	Documentation Required	Show values
InspectionLotApproval	Inspection Lot Approval	Show values
InspLotDigitalSgntrInUsgeDcsn	Digital Signature Usage Decision	Show values
MaterialIsBatchManaged	Batch Required	Show values
InspLotIsSerialNmbrPossible	Serial Numbers Possible	Show values

Column Name	Description	Domain name
MaterialSampleCount	null
InspCharAcceptedCount	null
InspCharRejectedCount	null
InspCharOpenCount	null
InspCharCount	null
WorkCenter	Work Center	ARBPL
WorkCenterText	Work Center Text	TEXT40
InspectionLotOriginText	Inspection Lot Origin Text	QKURZTEXT
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
OperationText	Operation Short Text	TEXT40
MaterialName	Material Description	TEXT40
InspectionLotObjectText	Short Text for Inspection Object	QKURZTEXT
InspectionLotCreatedBy	Name of User Who Created the Data Record	QAENDERER
InspectionLotChangedBy	Name of User Who Last Changed Data Record	QAENDERER
MaterialRevisionLevel	Revision Level	REVLV
MaterialDocumentYear	Material Document Year	GJAHR
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
DeliveryDocument	Delivery Document	VBELN
DeliveryDocumentItem	Delivery Document Item	POSNR
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspLotQuantityUnitDecPlaces	No. of decimal places for rounding	ANDEC
InspectionLotQuantityUnit	External Unit of Measurement in Commercial Format (3-Char.)	MSEH3
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	Sales Order Item	NUM06
InspectionLotQualityScore	Quality Score	QKENNZAHL
InspectionOpUsageDecidedBy	Person Who Made the Usage Decision	QAENDERER
InspOpUsageDecisionChangedBy	Person Who Changed the Usage Decision	QAENDERER
SystemStatus	Concatenated System Status
UserStatus	Concatenated User Status
InspLotRsltRecgStatus	null
BatchBySupplier	null
InspLotIsStockPostingCompleted	null
InspectionLotIsSkipped	null
InspectionLotIsFullInspection	null
NumberOfSerialNumbers	null
SmplDrawingProcedure	null
SmplDrwgProcedIsConfRequired	null
InspectionDynamicStage	null
InspectionSeverity	null
InspLotIsAutomUsgeDcsnPossible	null
InspLotHasConfignSpecification	null
InspLotIsTaskListRequired	null
InspLotHasManualSampleSize	null
InspLotHasMaterialSpec	null
InspLotDigitalSgntrResultsRecg	null
InspLotIsBatchRequired	null
InspectionLotHasUsageDecision	null
GoodsReceiptIsMovedToBlkdStock	GR Blocked Stock	KZWES
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
MaterialByCustomer	Customer Material	IDNEX
InspLotNmbrAddlRecordedCharc	null
InspLotNmbrOpenShortTermCharc	null
InspLotNmbrOpenLongTermCharc	null
SalesOrdStockWBSElement	null
InspLotUsageDecisionCodeGroup	null
InspectionLotUsageDecisionCode	null
InspectionOperationPlant	null
OperationControlProfile	null
InspectionSubSystem	null
OperationConfirmation	null
InspectionCharacteristic	null
InspectionCharacteristicStatus	null
InspectionMethodPlant	null
InspectionMethod	null
InspectionSpecificationPlant	null
InspectionSpecification	null
InspSpecImportanceCode	null
InspectionCharacteristicText	null
InspectorQualification	null
InspSpecInformationField1	null
InspSpecInformationField2	null
InspSpecInformationField3	null
InspectionSubsetSortKey	null
Equipment	null
FunctionalLocation	null
MaterialSample	Material Sample Number	QPHYSPRNR
InspectionSubsetLongCharKey	null
InspectionSubsetShortCharKey	null
InspSubsetLongNumericKey	null
InspSubsetShortNumericKey	null
InspSubsetUsageDcsnCodeGroup	null
InspSubsetUsageDcsnCode	null
InspSubsetUsageDcsnValuation	null
MaterialSampleType	null
MaterialSampleCategory	null
StorageLocation	null
MaterialSampleStorageLocation	null
MaterialSampleChangedOn	null
MaterialSampleDrawingLocation	null
MatlSmplDrawingLocDescription	null
MaterialSampleDrawingOnDate	null
MaterialSampleDrawingOnTime	null
MaterialSampleResponsibleName	null
ProductionPlant	null
InspectionSpecificationText	null

Master Data Relations	Join Conditions
Document Type Client Document Type	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T003.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Batch Number Client Material Number Batch Number	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == MCH1.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATERIAL == MCH1.MATNR` `C_QM_INSPECTIONLOTSBYOPERATION.BATCH == MCH1.CHARG`
Storage Location for Batch Storage Location for Batch Client Material Number Batch Number Plant	`C_QM_INSPECTIONLOTSBYOPERATION.BATCHSTORAGELOCATION == MCHB.LGORT` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == MCHB.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATERIAL == MCHB.MATNR` `C_QM_INSPECTIONLOTSBYOPERATION.BATCH == MCHB.CHARG` `C_QM_INSPECTIONLOTSBYOPERATION.PLANT == MCHB.WERKS`
Bill of Operations Type Client Bill of Operations Type	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TCA01.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Bill of Operations Usage Client Bill of Operations Usage	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T411.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.BILLOFOPERATIONSUSAGE == T411.VERWE`
Destination Country/Region Client Destination Country/Region	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T005.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.BILLTOPARTYCOUNTRY == T005.LAND1`
Business Area Client Business Area	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TGSB.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.BUSINESSAREA == TGSB.GSBER`
Company Code Client Company Code	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T001.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.COMPANYCODE == T001.BUKRS`
Controlling Area Controlling Area Client	`C_QM_INSPECTIONLOTSBYOPERATION.CONTROLLINGAREA == TKA01.KOKRS` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Client Cost Center	`C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "DATBI"] == CSKS.DATBI` `C_QM_INSPECTIONLOTSBYOPERATION.CONTROLLINGAREA == CSKS.KOKRS` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == CSKS.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.COSTCENTER == CSKS.KOSTL`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == KNA1.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.CUSTOMER == KNA1.KUNNR`
Delivery Category Delivery Category Client	`C_QM_INSPECTIONLOTSBYOPERATION.DELIVERYCATEGORY == TVLV.ABRVW` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TVLV.MANDT`
G/L Account Number ? G/L Account Number Client	`C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "KTOPL"] == SKA1.KTOPL` `C_QM_INSPECTIONLOTSBYOPERATION.GLACCOUNT == SKA1.SAKNR` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == SKA1.MANDT`
Movement type (inventory management) Client Movement type (inventory management)	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T156.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.GOODSMOVEMENTTYPE == T156.BWART`
Inspection Lot Origin	`C_QM_INSPECTIONLOTSBYOPERATION.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Plant for Inspection Lot Client Plant for Inspection Lot	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T001W.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPECTIONLOTPLANT == T001W.WERKS`
Storage Location for Inspection Lot Stock Client Plant for Inspection Lot Storage Location for Inspection Lot Stock	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T001L.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPECTIONLOTPLANT == T001L.WERKS` `C_QM_INSPECTIONLOTSBYOPERATION.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT`
Inspection Type Inspection Type Client	`C_QM_INSPECTIONLOTSBYOPERATION.INSPECTIONLOTTYPE == TQ30.ART` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TQ30.MANDT`
Catalog Client Catalog	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TQ15.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSAGEDECISIONCATALOG == TQ15.KATALOGART`
Follow-Up Action Client Follow-Up Action	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TQ07.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSGEDCSNFOLLOWUPACTION == TQ07.FOLGEAKTI`
Selected Set of the Usage Decision Client Selected Set of the Usage Decision Catalog ?	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == QPAM.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSGEDCSNSELECTEDSET == QPAM.AUSWAHLMGE` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSAGEDECISIONCATALOG == QPAM.KATALOGART` `C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "WERKS_D"] == QPAM.WERKS`
Inspection Point Identification Client Identifier for Inspection Point Field Combination	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TQ79.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ`
Plant Plant Client	`C_QM_INSPECTIONLOTSBYOPERATION.MAINTENANCEWORKCENTERPLANT == T001W.WERKS` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T001W.MANDT`
Number of Manufacturer Client Number of Manufacturer	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == LFA1.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Client Manufacturer Material	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == MARA.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MANUFACTURERPARTNMBR == MARA.MATNR`
Order Number (Production Order) Client Order Number (Production Order)	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == AUFK.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MANUFACTURINGORDER == AUFK.AUFNR`
Material Number Client Material Number	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == MARA.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATERIAL == MARA.MATNR`
Special Stock Indicator Client Special Stock Indicator	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T148.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TQ01B.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T001W.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.PLANT == T001W.WERKS`
Production Version Client Material Number Production Version Plant	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == MKAL.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.MATERIAL == MKAL.MATNR` `C_QM_INSPECTIONLOTSBYOPERATION.PRODUCTIONVERSION == MKAL.VERID` `C_QM_INSPECTIONLOTSBYOPERATION.PLANT == MKAL.WERKS`
Profit Center ? ? Client Profit Center	`C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "KOKRS"] == CEPC.KOKRS` `C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "DATBI"] == CEPC.DATBI` `C_QM_INSPECTIONLOTSBYOPERATION.MANDT == CEPC.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.PROFITCENTER == CEPC.PRCTR`
Purchasing Organization Client Purchasing Organization	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T024E.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.PURCHASINGORGANIZATION == T024E.EKORG`
Order Number for Recording Appraisal Costs Client Order Number for Recording Appraisal Costs	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == AUFK.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.QUALITYCOSTCOLLECTOR == AUFK.AUFNR`
Route Client Route	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TVRO.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.ROUTE == TVRO.ROUTE`
Sales Organization Client Sales Organization	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == TVKO.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.SALESORGANIZATION == TVKO.VKORG`
Serial Number Profile Client Serial Number Profile	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T377P.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.SERIALNUMBERPROFILE == T377P.SERAIL`
Customer (Sold-To Party) Client Customer (Sold-To Party)	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == KNA1.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.SOLDTOPARTY == KNA1.KUNNR`
Storage Bin Client Storage Bin Storage Type Warehouse Number / Warehouse Complex	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == LAGP.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.STORAGEBIN == LAGP.LGPLA` `C_QM_INSPECTIONLOTSBYOPERATION.STORAGETYPE == LAGP.LGTYP` `C_QM_INSPECTIONLOTSBYOPERATION.WAREHOUSE == LAGP.LGNUM`
Storage Type Client Storage Type Warehouse Number / Warehouse Complex	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T301.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.STORAGETYPE == T301.LGTYP` `C_QM_INSPECTIONLOTSBYOPERATION.WAREHOUSE == T301.LGNUM`
Vendor's account number Client Vendor's account number	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == LFA1.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.SUPPLIER == LFA1.LIFNR`
Usage Decision Code Client Code Group of the Usage Decision ? Usage Decision Code Catalog	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == QPCD.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.USAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE` `C_QM_INSPECTIONLOTSBYOPERATION.[column in domain "QVERSNR"] == QPCD.VERSION` `C_QM_INSPECTIONLOTSBYOPERATION.USAGEDECISIONCODE == QPCD.CODE` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSAGEDECISIONCATALOG == QPCD.KATALOGART`
Code Group of the Usage Decision Client Code Group of the Usage Decision Catalog	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == QPGR.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.USAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE` `C_QM_INSPECTIONLOTSBYOPERATION.INSPOPUSAGEDECISIONCATALOG == QPGR.KATALOGART`
Warehouse Number / Warehouse Complex Client Warehouse Number / Warehouse Complex	`C_QM_INSPECTIONLOTSBYOPERATION.MANDT == T300.MANDT` `C_QM_INSPECTIONLOTSBYOPERATION.WAREHOUSE == T300.LGNUM`