I_MtrlSmplInsplotVH

Inspection Lot Value Help for Sample | view: IMATSMPLINSPLOTH | TRAN | Extraction: Not supported | Component: Sample Management

Tables used: QALS, TQ30, TQ30T, MARA, MAKT, T001W

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (6)
🔗 Relations (7)

Column Name	Description
InspectionLot	Inspection Lot Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
InspectionLotText	Inspection Lot Text	QKURZTEXT
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
MaterialName	Material Description	TEXT40
PlantName	Plant Name	TEXT30
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80

Master Data Relations	Join Conditions
Batch Number Material Number Batch Number Client	`I_MTRLSMPLINSPLOTVH.MATERIAL == MCH1.MATNR` `I_MTRLSMPLINSPLOTVH.BATCH == MCH1.CHARG` `I_MTRLSMPLINSPLOTVH.MANDT == MCH1.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`I_MTRLSMPLINSPLOTVH.CUSTOMER == KNA1.KUNNR` `I_MTRLSMPLINSPLOTVH.MANDT == KNA1.MANDT`
Inspection Type Inspection Type Client	`I_MTRLSMPLINSPLOTVH.INSPECTIONLOTTYPE == TQ30.ART` `I_MTRLSMPLINSPLOTVH.MANDT == TQ30.MANDT`
Number of Manufacturer Number of Manufacturer Client	`I_MTRLSMPLINSPLOTVH.MANUFACTURER == LFA1.LIFNR` `I_MTRLSMPLINSPLOTVH.MANDT == LFA1.MANDT`
Material Number Material Number Client	`I_MTRLSMPLINSPLOTVH.MATERIAL == MARA.MATNR` `I_MTRLSMPLINSPLOTVH.MANDT == MARA.MANDT`
Plant Plant Client	`I_MTRLSMPLINSPLOTVH.PLANT == T001W.WERKS` `I_MTRLSMPLINSPLOTVH.MANDT == T001W.MANDT`
Vendor's account number Vendor's account number Client	`I_MTRLSMPLINSPLOTVH.SUPPLIER == LFA1.LIFNR` `I_MTRLSMPLINSPLOTVH.MANDT == LFA1.MANDT`