A_InspectionLot

Inspection Lot Data | view: AINSPECTIONLOT | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QALS
Column Name Description
InspectionLot Inspection Lot Number
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
InspectionLotActualQuantity Actual Lot Quantity
InspectionLotDefectiveQuantity Defective Quantity
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
📏 Lot Container (InspectionLotContainerUnit):
InspectionLotContainer QM - No. of Containers
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity Inspection Sample Size
InspLotSmplQtyForLongTermChar Long-Term Sample Quantity
InspLotQtyInspected Inspected Quantity
InspLotQtyDestroyed Destroyed 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
InspectionLotStartTime Inspection Started At
InspectionLotEndDate End Date of Inspection in Local Time Zone
InspectionLotEndTime Inspection Ended At
InspLotSelectionValidFromDate Key Date for Selecting Records or Changing Task Lists
MatlDocLatestPostgDate Posting Date in the Document
Column Name Description
InspectionLotHasQuantity Posted to Inspection Stock Show values
InspLotIsCreatedAutomatically Inspection Lot Is Created Automatically Show values
InspectionLotHasPartialLots Partial Lots Exist Show values
InspectionLotHasAppraisalCosts Record Appraisal Costs in Individual QM Order Show values
InspLotHasSubsets Inspection with Inspection Points Show values
InspLotIsAutomUsgeDcsnPossible Automatic Usage Decision Planned Show values
PurchasingDocumentCategory Source Inspection Show values
InspLotHasConfignSpecification Inspection Specifications from Configuration Show values
InspLotIsDocumentationRequired Documentation Required Show values
InspLotIsTaskListRequired Inspection Plan Required Show values
InspLotHasManualSampleSize Enter Sample Manually Show values
InspLotHasMaterialSpec Inspect with Material Specification 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
InspLotIsBatchRequired Approved Batch Record Required Show values
InspLotUsageInStabilityStudy Inspection Lot for Stability Study Show values
InspLotIsStockPostingCompleted Stock Postings Completed Show values
InspectionLotHasUsageDecision Usage Decision Made Show values
InspLotIsSerialNmbrPossible Serial Numbers Possible Show values
InspectionLotIsSkipped Skip Lot Show values
InspectionLotIsFullInspection 100% Inspection Show values
InspectionSubsetType Inspection Point Type Show values
SmplDrwgProcedIsConfRequired Confirmation Required for Sample Drawing Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
MaterialIsBatchManaged Batch Required Show values
InspLotDynamicTrggrPoint Time of Dynamic Modification in Inspection Lot Show values
InspLotUsageDecisionTool Usage Decision Mode (UD Origin) Show values
ConsumptionPosting Consumption posting Show values
InspLotAcctAssgmtKey Account Assignment Key: Inspection Lot Show values
Column Name Description Domain name
OrderInternalBillOfOperations Routing number of operations in the order AUFPL
InspectionLotText Inspection Lot Text QKURZTEXT
InspLotNmbrOpenLongTermCharc Open Long-Term Characteristics INT2
InspectionLotObjectText Short Text for Inspection Object QKURZTEXT
GoodsReceiptIsMovedToBlkdStock GR Blocked Stock KZWES
NumberOfSerialNumbers Number of serial numbers INT4
InspectionLotCreatedBy Name of User Who Created the Data Record QAENDERER
InspectionLotChangedBy Name of User Who Last Changed Data Record QAENDERER
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
BillOfOperationsChangeStateID Internal counter CIM_COUNT
SmplDrawingProcedureVersion Version No. of the Sample-Drawing Procedure QVERSNR
InspLotSelMatlRevisionLvl Revision Level REVLV
BatchBySupplier Supplier Batch Number LICHN
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
InspLotNmbrAddlRecordedCharc Number of Characteristics Recorded Additionally INT2
InspLotNmbrOpenShortTermCharc Number of Outstanding Short-Term Chars That Require Confirm. INT2
InspectionLotScrapRatio Share of Scrap in Inspection Lot QFLTP16
InspectionLotAllowedScrapRatio Allowed Share of Scrap QPMATLOS
ReservationItem Item Number of Reservation / Dependent Requirements RSPOS
NetworkActivityInternalID Internal counter CIM_COUNT
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Sales Order Item of Valuated Sales Order Stock NUM06
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
InspLotCostCollectorSalesOrder Sales Order Number VBELN
InspLotCostCollectorSlsOrdItem Item number in Sales Order NUM06
InspLotExternalNumber Inspection Document Number QPLEXT_INSP_DOC_NUMBER
InspectionLotPriorityPoints Priority Points QPLEXT_PRIOP
MaintenancePlanItemIntID Maintenance item POSNU
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • A_INSPECTIONLOT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • A_INSPECTIONLOT.MANDT == T163K.MANDT
Document Type
  • Client
  • Document Type
  • A_INSPECTIONLOT.MANDT == T003.MANDT
  • A_INSPECTIONLOT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Batch Number
  • Client
  • Material Number
  • Batch Number
  • A_INSPECTIONLOT.MANDT == MCH1.MANDT
  • A_INSPECTIONLOT.MATERIAL == MCH1.MATNR
  • A_INSPECTIONLOT.BATCH == MCH1.CHARG
Storage Location for Batch
  • Storage Location for Batch
  • Client
  • Material Number
  • Plant
  • Batch Number
  • A_INSPECTIONLOT.BATCHSTORAGELOCATION == MCHB.LGORT
  • A_INSPECTIONLOT.MANDT == MCHB.MANDT
  • A_INSPECTIONLOT.MATERIAL == MCHB.MATNR
  • A_INSPECTIONLOT.PLANT == MCHB.WERKS
  • A_INSPECTIONLOT.BATCH == MCHB.CHARG
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • A_INSPECTIONLOT.MANDT == TCA01.MANDT
  • A_INSPECTIONLOT.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Bill of Operations Usage
  • Client
  • Bill of Operations Usage
  • A_INSPECTIONLOT.MANDT == T411.MANDT
  • A_INSPECTIONLOT.BILLOFOPERATIONSUSAGE == T411.VERWE
Destination Country/Region
  • Client
  • Destination Country/Region
  • A_INSPECTIONLOT.MANDT == T005.MANDT
  • A_INSPECTIONLOT.BILLTOPARTYCOUNTRY == T005.LAND1
Business Area
  • Business Area
  • Client
  • A_INSPECTIONLOT.BUSINESSAREA == TGSB.GSBER
  • A_INSPECTIONLOT.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • A_INSPECTIONLOT.COMPANYCODE == T001.BUKRS
  • A_INSPECTIONLOT.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • A_INSPECTIONLOT.CONTROLLINGAREA == TKA01.KOKRS
  • A_INSPECTIONLOT.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • A_INSPECTIONLOT.[column in domain "DATBI"] == CSKS.DATBI
  • A_INSPECTIONLOT.CONTROLLINGAREA == CSKS.KOKRS
  • A_INSPECTIONLOT.COSTCENTER == CSKS.KOSTL
  • A_INSPECTIONLOT.MANDT == CSKS.MANDT
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • A_INSPECTIONLOT.CUSTOMER == KNA1.KUNNR
  • A_INSPECTIONLOT.MANDT == KNA1.MANDT
Delivery Category
  • Delivery Category
  • Client
  • A_INSPECTIONLOT.DELIVERYCATEGORY == TVLV.ABRVW
  • A_INSPECTIONLOT.MANDT == TVLV.MANDT
Asset Subnumber
  • Main Asset Number
  • Company Code
  • Client
  • Asset Subnumber
  • A_INSPECTIONLOT.MASTERFIXEDASSET == ANLA.ANLN1
  • A_INSPECTIONLOT.COMPANYCODE == ANLA.BUKRS
  • A_INSPECTIONLOT.MANDT == ANLA.MANDT
  • A_INSPECTIONLOT.FIXEDASSET == ANLA.ANLN2
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • A_INSPECTIONLOT.[column in domain "KTOPL"] == SKA1.KTOPL
  • A_INSPECTIONLOT.MANDT == SKA1.MANDT
  • A_INSPECTIONLOT.GLACCOUNT == SKA1.SAKNR
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • A_INSPECTIONLOT.MANDT == T156.MANDT
  • A_INSPECTIONLOT.GOODSMOVEMENTTYPE == T156.BWART
Inspection Stage
  • Dynamic Modification Rule
  • Client
  • Inspection Stage
  • A_INSPECTIONLOT.INSPLOTDYNAMICRULE == QDPS.DYNREGEL
  • A_INSPECTIONLOT.MANDT == QDPS.MANDT
  • A_INSPECTIONLOT.INSPECTIONDYNAMICSTAGE == QDPS.PRSTUFE
Lot Container
  • Client
  • Lot Container
  • A_INSPECTIONLOT.MANDT == T006.MANDT
  • A_INSPECTIONLOT.INSPECTIONLOTCONTAINERUNIT == T006.MSEHI
Level at Which Dynamic Modification Parameters Are Defined A_INSPECTIONLOT.INSPECTIONLOTDYNAMICLEVEL == TQ39A.DYNLEVEL
Inspection Lot Origin A_INSPECTIONLOT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Plant for Inspection Lot
  • Client
  • Plant for Inspection Lot
  • A_INSPECTIONLOT.MANDT == T001W.MANDT
  • A_INSPECTIONLOT.INSPECTIONLOTPLANT == T001W.WERKS
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • A_INSPECTIONLOT.MANDT == T006.MANDT
  • A_INSPECTIONLOT.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • A_INSPECTIONLOT.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
  • A_INSPECTIONLOT.MANDT == T006.MANDT
Storage Location for Inspection Lot Stock
  • Client
  • Plant for Inspection Lot
  • Storage Location for Inspection Lot Stock
  • A_INSPECTIONLOT.MANDT == T001L.MANDT
  • A_INSPECTIONLOT.INSPECTIONLOTPLANT == T001L.WERKS
  • A_INSPECTIONLOT.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT
Inspection Type
  • Client
  • Inspection Type
  • A_INSPECTIONLOT.MANDT == TQ30.MANDT
  • A_INSPECTIONLOT.INSPECTIONLOTTYPE == TQ30.ART
Inspection Severity
  • Client
  • Inspection Severity
  • A_INSPECTIONLOT.MANDT == QDEP.MANDT
  • A_INSPECTIONLOT.INSPECTIONSEVERITY == QDEP.PRSCHAERFE
Batch Transferred To
  • Client
  • Material Posted To
  • Batch Transferred To
  • A_INSPECTIONLOT.MANDT == MCH1.MANDT
  • A_INSPECTIONLOT.INSPLOTMATERIALPOSTEDTO == MCH1.MATNR
  • A_INSPECTIONLOT.INSPLOTBATCHTRANSFERREDTO == MCH1.CHARG
Dynamic Modification Rule
  • Dynamic Modification Rule
  • Client
  • A_INSPECTIONLOT.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
  • A_INSPECTIONLOT.MANDT == QDDR.MANDT
Material Posted To
  • Client
  • Material Posted To
  • A_INSPECTIONLOT.MANDT == MARA.MANDT
  • A_INSPECTIONLOT.INSPLOTMATERIALPOSTEDTO == MARA.MATNR
Task List Usage
  • Task List Usage
  • Client
  • A_INSPECTIONLOT.INSPLOTSELBILLOFOPERATIONSUSGE == T411.VERWE
  • A_INSPECTIONLOT.MANDT == T411.MANDT
Account number of customer
  • Client
  • Account number of customer
  • A_INSPECTIONLOT.MANDT == KNA1.MANDT
  • A_INSPECTIONLOT.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • A_INSPECTIONLOT.MANDT == LFA1.MANDT
  • A_INSPECTIONLOT.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • A_INSPECTIONLOT.MANDT == MARA.MANDT
  • A_INSPECTIONLOT.INSPLOTSELECTIONMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • A_INSPECTIONLOT.MANDT == T001W.MANDT
  • A_INSPECTIONLOT.INSPLOTSELECTIONPLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • A_INSPECTIONLOT.MANDT == LFA1.MANDT
  • A_INSPECTIONLOT.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Inspection Point Identification
  • Client
  • Identifier for Inspection Point Field Combination
  • A_INSPECTIONLOT.MANDT == TQ79.MANDT
  • A_INSPECTIONLOT.INSPSUBSETFIELDCOMBINATION == TQ79.SLWBEZ
Language Key A_INSPECTIONLOT.LANGUAGE == T002.SPRAS
Maintenance Plan
  • Client
  • Maintenance Plan
  • A_INSPECTIONLOT.MANDT == MPLA.MANDT
  • A_INSPECTIONLOT.MAINTENANCEPLAN == MPLA.WARPL
Maintenance Strategy
  • Maintenance Strategy
  • Client
  • A_INSPECTIONLOT.MAINTENANCESTRATEGY == T351.STRAT
  • A_INSPECTIONLOT.MANDT == T351.MANDT
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • A_INSPECTIONLOT.MANDT == LFA1.MANDT
  • A_INSPECTIONLOT.MANUFACTURER == LFA1.LIFNR
Manufacturer Material
  • Manufacturer Material
  • Client
  • A_INSPECTIONLOT.MANUFACTURERPARTNMBR == MARA.MATNR
  • A_INSPECTIONLOT.MANDT == MARA.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • A_INSPECTIONLOT.MANUFACTURINGORDER == AUFK.AUFNR
  • A_INSPECTIONLOT.MANDT == AUFK.MANDT
Material Number
  • Client
  • Material Number
  • A_INSPECTIONLOT.MANDT == MARA.MANDT
  • A_INSPECTIONLOT.MATERIAL == MARA.MATNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • A_INSPECTIONLOT.MANDT == T148.MANDT
  • A_INSPECTIONLOT.MATERIALCOMPISSPECIALSTOCK == T148.SOBKZ
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • A_INSPECTIONLOT.MANDT == TQ01B.MANDT
  • A_INSPECTIONLOT.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • A_INSPECTIONLOT.MANDT == T001W.MANDT
  • A_INSPECTIONLOT.PLANT == T001W.WERKS
Production Version
  • Client
  • Material Number
  • Plant
  • Production Version
  • A_INSPECTIONLOT.MANDT == MKAL.MANDT
  • A_INSPECTIONLOT.MATERIAL == MKAL.MATNR
  • A_INSPECTIONLOT.PLANT == MKAL.WERKS
  • A_INSPECTIONLOT.PRODUCTIONVERSION == MKAL.VERID
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • A_INSPECTIONLOT.[column in domain "KOKRS"] == CEPC.KOKRS
  • A_INSPECTIONLOT.[column in domain "DATBI"] == CEPC.DATBI
  • A_INSPECTIONLOT.MANDT == CEPC.MANDT
  • A_INSPECTIONLOT.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • A_INSPECTIONLOT.PROJECTNETWORK == AUFK.AUFNR
  • A_INSPECTIONLOT.MANDT == AUFK.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • A_INSPECTIONLOT.MANDT == T163.MANDT
  • A_INSPECTIONLOT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Organization
  • Client
  • Purchasing Organization
  • A_INSPECTIONLOT.MANDT == T024E.MANDT
  • A_INSPECTIONLOT.PURCHASINGORGANIZATION == T024E.EKORG
Order Number for Recording Appraisal Costs
  • Client
  • Order Number for Recording Appraisal Costs
  • A_INSPECTIONLOT.MANDT == AUFK.MANDT
  • A_INSPECTIONLOT.QUALITYCOSTCOLLECTOR == AUFK.AUFNR
Route
  • Client
  • Route
  • A_INSPECTIONLOT.MANDT == TVRO.MANDT
  • A_INSPECTIONLOT.ROUTE == TVRO.ROUTE
Production Version Number
  • Client
  • Run Schedule Header
  • A_INSPECTIONLOT.MANDT == SAFK.MANDT
  • A_INSPECTIONLOT.SALESOPERATIONSPLANNINGORDER == SAFK.AUFNR
Sales Organization
  • Client
  • Sales Organization
  • A_INSPECTIONLOT.MANDT == TVKO.MANDT
  • A_INSPECTIONLOT.SALESORGANIZATION == TVKO.VKORG
Sampling Procedure
  • Client
  • Sampling Procedure
  • A_INSPECTIONLOT.MANDT == QDSV.MANDT
  • A_INSPECTIONLOT.SAMPLINGPROCEDURE == QDSV.STICHPRVER
Serial Number Profile
  • Client
  • Serial Number Profile
  • A_INSPECTIONLOT.MANDT == T377P.MANDT
  • A_INSPECTIONLOT.SERIALNUMBERPROFILE == T377P.SERAIL
Sample-Drawing Procedure
  • Sample-Drawing Procedure
  • Client
  • Version No. of the Sample-Drawing Procedure
  • A_INSPECTIONLOT.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF
  • A_INSPECTIONLOT.MANDT == QPRVK.MANDT
  • A_INSPECTIONLOT.SMPLDRAWINGPROCEDUREVERSION == QPRVK.VERSION
Customer (Sold-To Party)
  • Customer (Sold-To Party)
  • Client
  • A_INSPECTIONLOT.SOLDTOPARTY == KNA1.KUNNR
  • A_INSPECTIONLOT.MANDT == KNA1.MANDT
Object Type A_INSPECTIONLOT.STATUSOBJECTCATEGORY == TJ03.OBTYP
Status Profile
  • Status Profile
  • Client
  • A_INSPECTIONLOT.STATUSPROFILE == TJ20.STSMA
  • A_INSPECTIONLOT.MANDT == TJ20.MANDT
Storage Bin
  • Client
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • A_INSPECTIONLOT.MANDT == LAGP.MANDT
  • A_INSPECTIONLOT.STORAGEBIN == LAGP.LGPLA
  • A_INSPECTIONLOT.WAREHOUSE == LAGP.LGNUM
  • A_INSPECTIONLOT.STORAGETYPE == LAGP.LGTYP
Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • A_INSPECTIONLOT.MANDT == T301.MANDT
  • A_INSPECTIONLOT.WAREHOUSE == T301.LGNUM
  • A_INSPECTIONLOT.STORAGETYPE == T301.LGTYP
Vendor's account number
  • Client
  • Vendor's account number
  • A_INSPECTIONLOT.MANDT == LFA1.MANDT
  • A_INSPECTIONLOT.SUPPLIER == LFA1.LIFNR
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • A_INSPECTIONLOT.MANDT == T300.MANDT
  • A_INSPECTIONLOT.WAREHOUSE == T300.LGNUM