C_Qm_InspectionlotsByMtrSmpl

Inspection lots for main page - group by material sample | view: CQMINSPLBMS | Extraction: Not supported | Component: Quality Management
Tables used: QALSAFVCQAOPQAPPQAVEQASVQASRQPRSJSTOJESTTQ31TQ31TTQ30TQ30TMARAMAKTT006T006A
Column Name Description
InspectionLot Inspection Lot Number
MaterialSample FK Material Sample Number
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
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
MatlDocLatestPostgDate null
InspectionSubsetDate null
InspectionSubsetTime null
MaterialSampleChangedOn System Date When Sample Changed
MaterialSampleDrawingOnDate Date of Sample Drawing
MaterialSampleDrawingOnTime Time of Sample Drawing
Column Name Description
InspLotIsDocumentationRequired Documentation Required Show values
InspLotIsSerialNmbrPossible Serial Numbers Possible Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
InspectionLotHasPartialLots Partial Lots Exist Show values
MaterialIsBatchManaged Batch Required Show values
Column Name Description Domain name
SystemStatus Concatenated System Status
UserStatus Concatenated User Status
InspCharAcceptedCount null
InspCharRejectedCount null
InspCharOpenCount null
InspOperationCount null
InspectionLotOriginText Inspection Lot Origin Text QKURZTEXT
InspectionLotTypeText Inspection Type Text QKURZTEXT
MaterialName Material Description TEXT40
InspCharCount null
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
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
DeliveryDocument Delivery Document VBELN
DeliveryDocumentItem Delivery Document Item POSNR
InspectionLotText Inspection Lot Text QKURZTEXT
InspLotQuantityUnitDecPlaces No. of decimal places for rounding ANDEC
InspectionOperation Operation or Phase Number VDM_VORNR
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
PurchasingOrganization null
GoodsMovementType null
ManufacturerPartNmbr null
GoodsReceiptIsMovedToBlkdStock null
InspectionLotHasQuantity null
Warehouse null
StorageType null
StorageBin null
MaterialCompIsSpecialStock null
InspectionLotStorageLocation null
SoldToParty null
DeliveryCategory null
Route null
BillToPartyCountry null
SalesOrganization null
MaterialByCustomer null
BillOfOperationsType null
BillOfOperationsGroup null
BillOfOperationsUsage null
BillOfOperationsVariant null
InspLotNmbrAddlRecordedCharc null
InspLotNmbrOpenShortTermCharc null
InspLotNmbrOpenLongTermCharc null
CostCenter null
SalesOrdStockWBSElement null
QualityCostCollector null
ProfitCenter null
BusinessArea null
GLAccount null
ControllingArea null
CompanyCode null
InspLotDigitalSgntrInUsgeDcsn null
WorkCenter null
InspLotUsageDecisionCodeGroup null
InspectionLotUsageDecisionCode null
StorageLocation null
InspectionOperationPlant null
OperationControlProfile null
InspectionSubSystem null
OperationConfirmation null
OperationText 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
InspectionSubsetLongCharKey null
InspectionSubsetShortCharKey null
InspSubsetLongNumericKey null
InspSubsetShortNumericKey null
InspSubsetUsageDcsnCodeGroup null
InspSubsetUsageDcsnCode null
InspSubsetUsageDcsnValuation null
ProductionPlant null
InspectionLotPlant null
InspectionSpecificationText null
MaterialSampleDrawingLocation Location of Sample Drawing (Functional Location) TPLNR
MatlSmplDrawingLocDescription Description of Sample-Drawing Location CHAR60
MaterialSampleResponsibleName Processor Responsible for the Sample, Sample Taker CHAR20
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == T003.MANDT
Batch Number
  • Client
  • Material Number
  • Batch Number
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == MCH1.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIAL == MCH1.MATNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.BATCH == MCH1.CHARG
Storage Location for Batch
  • Storage Location for Batch
  • Client
  • Material Number
  • Plant
  • Batch Number
  • C_QM_INSPECTIONLOTSBYMTRSMPL.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == MCHB.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIAL == MCHB.MATNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.PLANT == MCHB.WERKS
  • C_QM_INSPECTIONLOTSBYMTRSMPL.BATCH == MCHB.CHARG
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == KNA1.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.CUSTOMER == KNA1.KUNNR
Inspection Lot Origin C_QM_INSPECTIONLOTSBYMTRSMPL.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Base Unit of Measure for Inspection Lot Quantity
  • Base Unit of Measure for Inspection Lot Quantity
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == T006.MANDT
Inspection Type
  • Client
  • Inspection Type
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == TQ30.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.INSPECTIONLOTTYPE == TQ30.ART
Inspection Point Identification
  • Identifier for Inspection Point Field Combination
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == TQ79.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANUFACTURER == LFA1.LIFNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == LFA1.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANUFACTURINGORDER == AUFK.AUFNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == MARA.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIAL == MARA.MATNR
Sample Category C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIALSAMPLECATEGORY == TQ44.PRTYP
Material Sample Location
  • Material Sample Location
  • Client
  • ?
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == TQ41.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.[column in domain "WERKS_D"] == TQ41.WERKS
Physical-sample type
  • Client
  • Material Sample Type
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == TQ40.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIALSAMPLETYPE == TQ40.PRART
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == TQ01B.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == T001W.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.PLANT == T001W.WERKS
Production Version
  • Client
  • Material Number
  • Production Version
  • Plant
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == MKAL.MANDT
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MATERIAL == MKAL.MATNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.PRODUCTIONVERSION == MKAL.VERID
  • C_QM_INSPECTIONLOTSBYMTRSMPL.PLANT == MKAL.WERKS
Production Version Number
  • Run Schedule Header
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.SALESOPERATIONSPLANNINGORDER == SAFK.AUFNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == SAFK.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.SERIALNUMBERPROFILE == T377P.SERAIL
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == T377P.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_QM_INSPECTIONLOTSBYMTRSMPL.SUPPLIER == LFA1.LIFNR
  • C_QM_INSPECTIONLOTSBYMTRSMPL.MANDT == LFA1.MANDT