C_QltyLvlInspLotDetails

Quality Lvl Inspection Lot Details | view: CQLTYLVLINSPDT | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QALS, QAVE, KNA1, TQ30, TQ30T, LFA1, QPCD, QPCT

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates
☰ Categorical (3)
Other (12)
🔗 Relations (16)

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

Column Name	Description

Column Name	Description
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
InspectionLotHasUsageDecision	Checkbox	Show values
InspLotUsageDecisionValuation	Code Valuation	Show values

Column Name	Description	Domain name
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
MaterialDocumentYear	Material Document Year	GJAHR
InventorySpclStkSalesDocument	Inventory Special Stock Sales Document	VBELN
InventorySpclStkSalesDocItm	Sales Order Item of Valuated Sales Order Stock	NUM06
ManufacturerName	Name of Supplier	TEXT80
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspectionLotQualityScore	Quality Score	QKENNZAHL

Master Data Relations	Join Conditions
Batch Number Batch Number Client Material Number	`C_QLTYLVLINSPLOTDETAILS.BATCH == MCH1.CHARG` `C_QLTYLVLINSPLOTDETAILS.MANDT == MCH1.MANDT` `C_QLTYLVLINSPLOTDETAILS.MATERIAL == MCH1.MATNR`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`C_QLTYLVLINSPLOTDETAILS.MANDT == KNA1.MANDT` `C_QLTYLVLINSPLOTDETAILS.CUSTOMER == KNA1.KUNNR`
Inspection Lot Origin	`C_QLTYLVLINSPLOTDETAILS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`C_QLTYLVLINSPLOTDETAILS.MANDT == T006.MANDT` `C_QLTYLVLINSPLOTDETAILS.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Inspection Type Client Inspection Type	`C_QLTYLVLINSPLOTDETAILS.MANDT == TQ30.MANDT` `C_QLTYLVLINSPLOTDETAILS.INSPECTIONLOTTYPE == TQ30.ART`
Usage Decision Code Client Usage Decision Code ? ? ?	`C_QLTYLVLINSPLOTDETAILS.MANDT == QPCD.MANDT` `C_QLTYLVLINSPLOTDETAILS.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE` `C_QLTYLVLINSPLOTDETAILS.[column in domain "QVERSNR"] == QPCD.VERSION` `C_QLTYLVLINSPLOTDETAILS.[column in domain "QKATART"] == QPCD.KATALOGART` `C_QLTYLVLINSPLOTDETAILS.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE`
Number of Manufacturer Client Number of Manufacturer	`C_QLTYLVLINSPLOTDETAILS.MANDT == LFA1.MANDT` `C_QLTYLVLINSPLOTDETAILS.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Client Manufacturer Material	`C_QLTYLVLINSPLOTDETAILS.MANDT == MARA.MANDT` `C_QLTYLVLINSPLOTDETAILS.MANUFACTURERPARTNMBR == MARA.MATNR`
Order Number (Production Order) Client Order Number (Production Order)	`C_QLTYLVLINSPLOTDETAILS.MANDT == AUFK.MANDT` `C_QLTYLVLINSPLOTDETAILS.MANUFACTURINGORDER == AUFK.AUFNR`
Material Number Client Material Number	`C_QLTYLVLINSPLOTDETAILS.MANDT == MARA.MANDT` `C_QLTYLVLINSPLOTDETAILS.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QLTYLVLINSPLOTDETAILS.MANDT == TQ01B.MANDT` `C_QLTYLVLINSPLOTDETAILS.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QLTYLVLINSPLOTDETAILS.MANDT == T001W.MANDT` `C_QLTYLVLINSPLOTDETAILS.PLANT == T001W.WERKS`
Purchasing Organization Client Purchasing Organization	`C_QLTYLVLINSPLOTDETAILS.MANDT == T024E.MANDT` `C_QLTYLVLINSPLOTDETAILS.PURCHASINGORGANIZATION == T024E.EKORG`
Vendor's account number Client Vendor's account number	`C_QLTYLVLINSPLOTDETAILS.MANDT == LFA1.MANDT` `C_QLTYLVLINSPLOTDETAILS.SUPPLIER == LFA1.LIFNR`