C_QM_InspectionLots

Inspection lots for main page | view: CQMINSPLOTS | Extraction: Not supported | Component: Quality Management
Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QAPP, QAVE, QAVE, QASV, QASR, JSTO, JEST, TCA01, TCA02, T411, T411T, TQ31, TQ31T, TQ30, TQ30T, TQ79, MARA, MAKT, TQ01B, TQ01C, T006, T006A
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
InspectionLotQuantity Inspection Lot Quantity
InspectionLotContainer QM - No. of Containers
InspectionLotSampleQuantity Inspection Sample Size
InspLotQtyToFree Unrestricted-Use Stock
InspLotQtyToScrap Scrap Quantity
InspLotQtyToSample Quantity Posted to Sample
InspLotQtyToBlocked Blocked Stock
InspLotQtyToReserves Quantity Posted to Reserves
InspLotQtyToAnotherMaterial New Material
InspLotQtyReturnedToSupplier Return to Supplier
InspLotQtyToSpecialStock Other Quantity
InspLotQtyToOtherStock Other Quantity 2
InspLotQtyToBePosted Quantity to Be Posted
InspLotSmplQtyForLongTermChar Long-Term Sample Quantity
InspLotQtyInspected Inspected Quantity
InspLotQtyDestroyed Destroyed Quantity
InspectionLotActualQuantity Actual Lot Quantity
InspectionLotDefectiveQuantity Defective Quantity
Column Name Description
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
InspLotSelectionValidFromDate Key Date for Selecting Records or Changing Task Lists
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
InspectionLotUsageDecidedOn Date When Usage Decision Was Made
InspLotUsageDecisionTime Time When Usage Decision Was Made
InspLotUsageDecisionChangedOn Date When Usage Decision Was Changed
InspLotUsgeDcsnChangedTime Time When Usage Decision Was Changed
InspectionLotStartTime null
InspectionLotEndTime null
InspectionSubsetDate null
InspectionSubsetTime null
Column Name Description
InspLotUsageDecisionValuation Code Valuation Show values
InspectionLotHasQuantity Posted to Inspection Stock Show values
InspectionLotApproval Inspection Lot Approval Show values
InspLotDigitalSgntrResultsRecg Digital Signature for Insp. Lot in Results Recording Show values
InspLotDigitalSgntrInUsgeDcsn Digital Signature Usage Decision Show values
MaterialIsBatchManaged Batch Required Show values
InspLotIsSerialNmbrPossible Serial Numbers Possible Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
InspLotUsgeDcsnDynValuation Dynamic Modif. Valuation According to Worst Case Principle Show values
InspectionLotHasPartialLots Partial Lots Exist Show values
Column Name Description Domain name
MaterialSampleCount null
InspectionLotOriginText Inspection Lot Origin Text QKURZTEXT
InspectionLotTypeText Inspection Type Text QKURZTEXT
MaterialName Material Description TEXT40
InspCharCount null
InspectionLotText Inspection Lot Text QKURZTEXT
InspectionLotObjectText Short Text for Inspection Object QKURZTEXT
MatlQltyAuthorizationGrpText Material Authorization Group Text for Activities in QM QKURZTEXT
GoodsReceiptIsMovedToBlkdStock GR Blocked Stock KZWES
InspectionLotCreatedBy Name of User Who Created the Data Record QAENDERER
InspectionLotChangedBy Name of User Who Last Changed Data Record QAENDERER
BillOfOperationsTypeName Description of the Task List Type TEXT30
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsUsageDesc Description TEXT20
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
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
MaterialByCustomer Customer Material IDNEX
InspCharOpenCount null
InspCharAcceptedCount null
InspCharRejectedCount null
InspOpNmbrOfOpen null
InspOpNmbrOfRjctd null
InspOpNmbrOfAccepted null
InspOpNmbrOfAcceptedCmpltd null
InspOpNmbrOfRjctdCmpltd null
InspOpNmbrOfOpenCmpltd null
InspLotNmbrAddlRecordedCharc null
InspLotNmbrOpenShortTermCharc null
InspLotNmbrOpenLongTermCharc null
InspectionLotQuantityUnit External Unit of Measurement in Commercial Format (3-Char.) MSEH3
InspectionLotContainerUnit External Unit of Measurement in Commercial Format (3-Char.) MSEH3
InspectionLotSampleUnit External Unit of Measurement in Commercial Format (3-Char.) MSEH3
InspectionLotScrapRatio Share of Scrap in Inspection Lot QFLTP16
SalesOrdStockWBSElement null
InspLotExternalNumber Inspection Document Number QPLEXT_INSP_DOC_NUMBER
InspectionLotQualityScore Quality Score QKENNZAHL
InspectionLotUsageDecidedBy Usage Decision Made By QAENDERER
InspLotUsageDecisionChangedBy Usage Decision Changed By QAENDERER
BatchBySupplier Supplier Batch Number LICHN
InspLotCostCollectorWBSElement null
SystemStatus Concatenated System Status
UserStatus Concatenated User Status
InspLotQuantityUnitDecPlaces No. of decimal places for rounding ANDEC
InspLotSampleQtyUnitDecPlaces No. of decimal places for rounding ANDEC
InspLotContainerUnitDecPlaces No. of decimal places for rounding ANDEC
InspLotRsltRecgStatus null
InspLotIsStockPostingCompleted null
InspectionLotIsSkipped null
InspectionLotIsFullInspection null
NumberOfSerialNumbers null
SmplDrwgProcedIsConfRequired null
InspectionDynamicStage null
InspectionSeverity null
InspLotIsAutomUsgeDcsnPossible null
InspLotHasConfignSpecification null
InspLotIsTaskListRequired null
InspLotHasManualSampleSize null
InspLotHasMaterialSpec null
InspLotIsBatchRequired null
InspectionLotHasUsageDecision null
InspLotIsDocumentationRequired null
InspectionOperation null
InspectionOperationPlant null
OperationControlProfile null
OperationText null
InspectionSubSystem null
OperationConfirmation null
WorkCenter 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
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_QM_INSPECTIONLOTS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_QM_INSPECTIONLOTS.MANDT == T163K.MANDT
Document Type
  • Document Type
  • Client
  • C_QM_INSPECTIONLOTS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_QM_INSPECTIONLOTS.MANDT == T003.MANDT
Batch Number
  • Client
  • Batch Number
  • Material Number
  • C_QM_INSPECTIONLOTS.MANDT == MCH1.MANDT
  • C_QM_INSPECTIONLOTS.BATCH == MCH1.CHARG
  • C_QM_INSPECTIONLOTS.MATERIAL == MCH1.MATNR
Storage Location for Batch
  • Storage Location for Batch
  • Client
  • Plant
  • Batch Number
  • Material Number
  • C_QM_INSPECTIONLOTS.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_QM_INSPECTIONLOTS.MANDT == MCHB.MANDT
  • C_QM_INSPECTIONLOTS.PLANT == MCHB.WERKS
  • C_QM_INSPECTIONLOTS.BATCH == MCHB.CHARG
  • C_QM_INSPECTIONLOTS.MATERIAL == MCHB.MATNR
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • C_QM_INSPECTIONLOTS.MANDT == TCA01.MANDT
  • C_QM_INSPECTIONLOTS.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Bill of Operations Usage
  • Client
  • Bill of Operations Usage
  • C_QM_INSPECTIONLOTS.MANDT == T411.MANDT
  • C_QM_INSPECTIONLOTS.BILLOFOPERATIONSUSAGE == T411.VERWE
Destination Country/Region
  • Destination Country/Region
  • Client
  • C_QM_INSPECTIONLOTS.BILLTOPARTYCOUNTRY == T005.LAND1
  • C_QM_INSPECTIONLOTS.MANDT == T005.MANDT
Business Area
  • Business Area
  • Client
  • C_QM_INSPECTIONLOTS.BUSINESSAREA == TGSB.GSBER
  • C_QM_INSPECTIONLOTS.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • C_QM_INSPECTIONLOTS.MANDT == T001.MANDT
  • C_QM_INSPECTIONLOTS.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_QM_INSPECTIONLOTS.CONTROLLINGAREA == TKA01.KOKRS
  • C_QM_INSPECTIONLOTS.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • C_QM_INSPECTIONLOTS.[column in domain "DATBI"] == CSKS.DATBI
  • C_QM_INSPECTIONLOTS.CONTROLLINGAREA == CSKS.KOKRS
  • C_QM_INSPECTIONLOTS.COSTCENTER == CSKS.KOSTL
  • C_QM_INSPECTIONLOTS.MANDT == CSKS.MANDT
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_QM_INSPECTIONLOTS.CUSTOMER == KNA1.KUNNR
  • C_QM_INSPECTIONLOTS.MANDT == KNA1.MANDT
Delivery Category
  • Client
  • Delivery Category
  • C_QM_INSPECTIONLOTS.MANDT == TVLV.MANDT
  • C_QM_INSPECTIONLOTS.DELIVERYCATEGORY == TVLV.ABRVW
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • C_QM_INSPECTIONLOTS.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_QM_INSPECTIONLOTS.MANDT == SKA1.MANDT
  • C_QM_INSPECTIONLOTS.GLACCOUNT == SKA1.SAKNR
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • C_QM_INSPECTIONLOTS.MANDT == T156.MANDT
  • C_QM_INSPECTIONLOTS.GOODSMOVEMENTTYPE == T156.BWART
Inspection Lot Origin C_QM_INSPECTIONLOTS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Plant for Inspection Lot
  • Client
  • Plant for Inspection Lot
  • C_QM_INSPECTIONLOTS.MANDT == T001W.MANDT
  • C_QM_INSPECTIONLOTS.INSPECTIONLOTPLANT == T001W.WERKS
Storage Location for Inspection Lot Stock
  • Client
  • Plant for Inspection Lot
  • Storage Location for Inspection Lot Stock
  • C_QM_INSPECTIONLOTS.MANDT == T001L.MANDT
  • C_QM_INSPECTIONLOTS.INSPECTIONLOTPLANT == T001L.WERKS
  • C_QM_INSPECTIONLOTS.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT
Inspection Type
  • Inspection Type
  • Client
  • C_QM_INSPECTIONLOTS.INSPECTIONLOTTYPE == TQ30.ART
  • C_QM_INSPECTIONLOTS.MANDT == TQ30.MANDT
Usage Decision Code
  • Client
  • Usage Decision Code
  • Usage Decision Code Group
  • Catalog
  • ?
  • C_QM_INSPECTIONLOTS.MANDT == QPCD.MANDT
  • C_QM_INSPECTIONLOTS.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCODEGROUP == QPCD.CODEGRUPPE
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCATALOG == QPCD.KATALOGART
  • C_QM_INSPECTIONLOTS.[column in domain "QVERSNR"] == QPCD.VERSION
Batch Transferred To
  • Batch Transferred To
  • Client
  • Material Posted To
  • C_QM_INSPECTIONLOTS.INSPLOTBATCHTRANSFERREDTO == MCH1.CHARG
  • C_QM_INSPECTIONLOTS.MANDT == MCH1.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTMATERIALPOSTEDTO == MCH1.MATNR
Material Posted To
  • Client
  • Material Posted To
  • C_QM_INSPECTIONLOTS.MANDT == MARA.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTMATERIALPOSTEDTO == MARA.MATNR
Catalog
  • Client
  • Catalog
  • C_QM_INSPECTIONLOTS.MANDT == TQ15.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCATALOG == TQ15.KATALOGART
Usage Decision Code Group
  • Client
  • Usage Decision Code Group
  • Catalog
  • C_QM_INSPECTIONLOTS.MANDT == QPGR.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCODEGROUP == QPGR.CODEGRUPPE
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCATALOG == QPGR.KATALOGART
Follow-Up Action
  • Client
  • Follow-Up Action
  • C_QM_INSPECTIONLOTS.MANDT == TQ07.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTUSGEDCSNFOLLOWUPACTION == TQ07.FOLGEAKTI
Selected Set of the Usage Decision
  • Selected Set of the Usage Decision
  • ?
  • Client
  • Catalog
  • C_QM_INSPECTIONLOTS.INSPLOTUSGEDCSNSELECTEDSET == QPAM.AUSWAHLMGE
  • C_QM_INSPECTIONLOTS.[column in domain "WERKS_D"] == QPAM.WERKS
  • C_QM_INSPECTIONLOTS.MANDT == QPAM.MANDT
  • C_QM_INSPECTIONLOTS.INSPLOTUSAGEDECISIONCATALOG == QPAM.KATALOGART
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • C_QM_INSPECTIONLOTS.MANDT == LFA1.MANDT
  • C_QM_INSPECTIONLOTS.MANUFACTURER == LFA1.LIFNR
Manufacturer Material
  • Client
  • Manufacturer Material
  • C_QM_INSPECTIONLOTS.MANDT == MARA.MANDT
  • C_QM_INSPECTIONLOTS.MANUFACTURERPARTNMBR == MARA.MATNR
Order Number (Production Order)
  • Client
  • Order Number (Production Order)
  • C_QM_INSPECTIONLOTS.MANDT == AUFK.MANDT
  • C_QM_INSPECTIONLOTS.MANUFACTURINGORDER == AUFK.AUFNR
Material Number
  • Client
  • Material Number
  • C_QM_INSPECTIONLOTS.MANDT == MARA.MANDT
  • C_QM_INSPECTIONLOTS.MATERIAL == MARA.MATNR
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • C_QM_INSPECTIONLOTS.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ
  • C_QM_INSPECTIONLOTS.MANDT == T148.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_QM_INSPECTIONLOTS.MANDT == TQ01B.MANDT
  • C_QM_INSPECTIONLOTS.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • C_QM_INSPECTIONLOTS.MANDT == T001W.MANDT
  • C_QM_INSPECTIONLOTS.PLANT == T001W.WERKS
Production Version
  • Client
  • Plant
  • Material Number
  • Production Version
  • C_QM_INSPECTIONLOTS.MANDT == MKAL.MANDT
  • C_QM_INSPECTIONLOTS.PLANT == MKAL.WERKS
  • C_QM_INSPECTIONLOTS.MATERIAL == MKAL.MATNR
  • C_QM_INSPECTIONLOTS.PRODUCTIONVERSION == MKAL.VERID
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_QM_INSPECTIONLOTS.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_QM_INSPECTIONLOTS.[column in domain "DATBI"] == CEPC.DATBI
  • C_QM_INSPECTIONLOTS.MANDT == CEPC.MANDT
  • C_QM_INSPECTIONLOTS.PROFITCENTER == CEPC.PRCTR
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_QM_INSPECTIONLOTS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_QM_INSPECTIONLOTS.MANDT == T024E.MANDT
Order Number for Recording Appraisal Costs
  • Order Number for Recording Appraisal Costs
  • Client
  • C_QM_INSPECTIONLOTS.QUALITYCOSTCOLLECTOR == AUFK.AUFNR
  • C_QM_INSPECTIONLOTS.MANDT == AUFK.MANDT
Route
  • Route
  • Client
  • C_QM_INSPECTIONLOTS.ROUTE == TVRO.ROUTE
  • C_QM_INSPECTIONLOTS.MANDT == TVRO.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_QM_INSPECTIONLOTS.MANDT == TVKO.MANDT
  • C_QM_INSPECTIONLOTS.SALESORGANIZATION == TVKO.VKORG
Serial Number Profile
  • Serial Number Profile
  • Client
  • C_QM_INSPECTIONLOTS.SERIALNUMBERPROFILE == T377P.SERAIL
  • C_QM_INSPECTIONLOTS.MANDT == T377P.MANDT
Sample-Drawing Procedure
  • Client
  • ?
  • Sample-Drawing Procedure
  • C_QM_INSPECTIONLOTS.MANDT == QPRVK.MANDT
  • C_QM_INSPECTIONLOTS.[column in domain "QVERSNPRZV"] == QPRVK.VERSION
  • C_QM_INSPECTIONLOTS.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF
Customer (Sold-To Party)
  • Client
  • Customer (Sold-To Party)
  • C_QM_INSPECTIONLOTS.MANDT == KNA1.MANDT
  • C_QM_INSPECTIONLOTS.SOLDTOPARTY == KNA1.KUNNR
Storage Bin
  • Client
  • Storage Bin
  • Storage Type
  • Warehouse Number / Warehouse Complex
  • C_QM_INSPECTIONLOTS.MANDT == LAGP.MANDT
  • C_QM_INSPECTIONLOTS.STORAGEBIN == LAGP.LGPLA
  • C_QM_INSPECTIONLOTS.STORAGETYPE == LAGP.LGTYP
  • C_QM_INSPECTIONLOTS.WAREHOUSE == LAGP.LGNUM
Storage Type
  • Client
  • Storage Type
  • Warehouse Number / Warehouse Complex
  • C_QM_INSPECTIONLOTS.MANDT == T301.MANDT
  • C_QM_INSPECTIONLOTS.STORAGETYPE == T301.LGTYP
  • C_QM_INSPECTIONLOTS.WAREHOUSE == T301.LGNUM
Vendor's account number
  • Client
  • Vendor's account number
  • C_QM_INSPECTIONLOTS.MANDT == LFA1.MANDT
  • C_QM_INSPECTIONLOTS.SUPPLIER == LFA1.LIFNR
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • C_QM_INSPECTIONLOTS.MANDT == T300.MANDT
  • C_QM_INSPECTIONLOTS.WAREHOUSE == T300.LGNUM