C_Materialsampleobjpage

Material Sample | view: CSAMPLEOP | Extraction: Not supported | Component: Sample Management

Tables used: QALS, QAVE, QPRS, QPRN, JSTO, JEST, KNA1, IFLOTX, MARA, TQ44, TQ44T, TQ40, TQ40T, MAKT, TQ41, TQ41T, TQ42, TQ42T, T001W, T001L, LFA1, QPCD, QPCT, USR21

🔑 Keys (1)
💰 Amounts
∑ Quantities (4)
📅 Dates (6)
☰ Categorical (3)
Other (29)
🔗 Relations (21)

Column Name	Description
MaterialSample	Material Sample Number

Column Name	Description

Column Name	Description
📏 Unit of Measure for Material Sample Size (MaterialSampleSizeUnit):
MaterialSampleSize	Size of Material Sample
📏 Lot Container (InspectionLotContainerUnit):
InspectionLotContainer	QM - No. of Containers
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity
📏 Sample Unit of Measure (InspectionLotSampleUnit):
InspectionLotSampleQuantity	Inspection Sample Size

Column Name	Description
MaterialSampleDrawingOnDate	Date of Sample Drawing
MatlSmplStorageEndDate	Storage Deadline for Sample
CreationDate	System Date When Material Sample Was Created
CreationTime	Time at Which Material Sample Was Created
MaterialSampleChangedOn	System Date When Sample Changed
MaterialSampleChangeTime	System Time When Sample Record Changed

Column Name	Description
SmplDrwgProcedIsConfRequired	Confirmation Required for Sample Drawing	Show values
InspLotHasMaterialSpec	Inspect with Material Specification	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
PlantName	Plant Name	TEXT30
MaterialSampleCategoryText	Material Sample Category Text	QKURZTEXT
MatlSmplContainerTypeText	Short Text	QKURZTEXT
SmplDrwgProcedPartialSampleTo	Highest Partial Sample No. Valid for Instruction	QPROBEPL
MaterialSampleTypeText	Short Text	QKURZTEXT
MaterialName	Material Description	TEXT40
MaterialSampleText	Short Text for Material Sample	TEXT80
MaterialSampleDrawingLocation	Location of Sample Drawing (Functional Location)	TPLNR
FunctionalLocationName	Description of functional location	TEXT40
MatlSmplDrawingLocDescription	Description of Sample-Drawing Location	CHAR60
SupplierName	Name of Supplier	TEXT80
ManufacturerName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
MaterialSampleResponsibleName	Processor Responsible for the Sample, Sample Taker	CHAR20
InspectionLotText	Inspection Lot Text	QKURZTEXT
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
InspectionLotQualityScore	Quality Score	QKENNZAHL
UsageDecisionCodeText	Text for Code	QKURZTEXT
StorageLocationName	Storage Location Name	TEXT16
MatlSampleStorageLocationText	Text for Material Sample Location	TEXT120
MatlSmplStorageInformation	Storage Information for the Material Sample	TEXT80
MatlSmplStorageDuration	Storage Duration of the Material Sample in Days	DEC5
MaterialSampleIsStored	null
MaterialSampleIsNotExisting	null
CreatedByUser	User Who Created the Material Sample	QAENDERER
FullName	User Description	SUIDTECHDESC
MaterialSampleChangedBy	Last User Who Changed the Sample Record	QAENDERER
UserDescription	User Description	SUIDTECHDESC

Master Data Relations	Join Conditions
Batch Number Batch Number Client Material Number	`C_MATERIALSAMPLEOBJPAGE.BATCH == MCH1.CHARG` `C_MATERIALSAMPLEOBJPAGE.MANDT == MCH1.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATERIAL == MCH1.MATNR`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_MATERIALSAMPLEOBJPAGE.CUSTOMER == KNA1.KUNNR` `C_MATERIALSAMPLEOBJPAGE.MANDT == KNA1.MANDT`
Lot Container Lot Container Client	`C_MATERIALSAMPLEOBJPAGE.INSPECTIONLOTCONTAINERUNIT == T006.MSEHI` `C_MATERIALSAMPLEOBJPAGE.MANDT == T006.MANDT`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`C_MATERIALSAMPLEOBJPAGE.MANDT == T006.MANDT` `C_MATERIALSAMPLEOBJPAGE.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Sample Unit of Measure Sample Unit of Measure Client	`C_MATERIALSAMPLEOBJPAGE.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI` `C_MATERIALSAMPLEOBJPAGE.MANDT == T006.MANDT`
Number of Manufacturer Number of Manufacturer Client	`C_MATERIALSAMPLEOBJPAGE.MANUFACTURER == LFA1.LIFNR` `C_MATERIALSAMPLEOBJPAGE.MANDT == LFA1.MANDT`
Material Number Client Material Number	`C_MATERIALSAMPLEOBJPAGE.MANDT == MARA.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATERIAL == MARA.MATNR`
Sample Category	`C_MATERIALSAMPLEOBJPAGE.MATERIALSAMPLECATEGORY == TQ44.PRTYP`
Unit of Measure for Material Sample Size Client Unit of Measure for Material Sample Size	`C_MATERIALSAMPLEOBJPAGE.MANDT == T006.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATERIALSAMPLESIZEUNIT == T006.MSEHI`
Material Sample Location Plant Plant Client Material Sample Location	`C_MATERIALSAMPLEOBJPAGE.MATLSAMPLEPLANT == TQ41.WERKS` `C_MATERIALSAMPLEOBJPAGE.PLANT == TQ41.WERKS` `C_MATERIALSAMPLEOBJPAGE.MANDT == TQ41.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT`
Physical-sample type Client Material Sample Type	`C_MATERIALSAMPLEOBJPAGE.MANDT == TQ40.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATERIALSAMPLETYPE == TQ40.PRART`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_MATERIALSAMPLEOBJPAGE.MANDT == TQ01B.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Plant Plant Client	`C_MATERIALSAMPLEOBJPAGE.MATLSAMPLEPLANT == T001W.WERKS` `C_MATERIALSAMPLEOBJPAGE.PLANT == T001W.WERKS` `C_MATERIALSAMPLEOBJPAGE.MANDT == T001W.MANDT`
Material Sample Container Client Material Sample Container	`C_MATERIALSAMPLEOBJPAGE.MANDT == TQ42.MANDT` `C_MATERIALSAMPLEOBJPAGE.MATLSMPLCONTAINERTYPE == TQ42.GEBINDETYP`
Plant Plant Plant Client	`C_MATERIALSAMPLEOBJPAGE.MATLSAMPLEPLANT == T001W.WERKS` `C_MATERIALSAMPLEOBJPAGE.PLANT == T001W.WERKS` `C_MATERIALSAMPLEOBJPAGE.MANDT == T001W.MANDT`
Sample-Drawing Procedure ? Client Sample-Drawing Procedure	`C_MATERIALSAMPLEOBJPAGE.[column in domain "QVERSNPRZV"] == QPRVK.VERSION` `C_MATERIALSAMPLEOBJPAGE.MANDT == QPRVK.MANDT` `C_MATERIALSAMPLEOBJPAGE.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF`
Storage location Storage location Plant Plant Client	`C_MATERIALSAMPLEOBJPAGE.STORAGELOCATION == T001L.LGORT` `C_MATERIALSAMPLEOBJPAGE.MATLSAMPLEPLANT == T001L.WERKS` `C_MATERIALSAMPLEOBJPAGE.PLANT == T001L.WERKS` `C_MATERIALSAMPLEOBJPAGE.MANDT == T001L.MANDT`
Vendor's account number Client Vendor's account number	`C_MATERIALSAMPLEOBJPAGE.MANDT == LFA1.MANDT` `C_MATERIALSAMPLEOBJPAGE.SUPPLIER == LFA1.LIFNR`