I_MaterialSample

Material Sample | view: IMATERIALSAMPLE | Extraction: Not supported | Component: Quality Inspection
Tables used: QPRS
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
Column Name Description
MaterialSampleChangedOn System Date When Sample Changed
MaterialSampleDrawingOnDate Date of Sample Drawing
MaterialSampleDrawingOnTime Time of Sample Drawing
MatlSmplStorageEndDate Storage Deadline for Sample
MaterialSampleChangeTime System Time When Sample Record Changed
Column Name Description
Column Name Description Domain name
MaterialSampleText Short Text for Material Sample TEXT80
MaterialSampleDrawingLocation Location of Sample Drawing (Functional Location) TPLNR
MatlSmplDrawingLocDescription Description of Sample-Drawing Location CHAR60
MaterialSampleResponsibleName Processor Responsible for the Sample, Sample Taker CHAR20
MatlSmplStorageInformation Storage Information for the Material Sample TEXT80
MatlSmplStorageDuration Storage Duration of the Material Sample in Days DEC5
MatlSmplDrwgLocDescription Description of Sample-Drawing Location CHAR60
MaterialSampleChangedBy Last User Who Changed the Sample Record QAENDERER
SmplDrwgProcedPartialSampleTo Highest Partial Sample No. Valid for Instruction QPROBEPL
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • I_MATERIALSAMPLE.MANDT == MCH1.MANDT
  • I_MATERIALSAMPLE.MATERIAL == MCH1.MATNR
  • I_MATERIALSAMPLE.BATCH == MCH1.CHARG
Lot Container
  • Client
  • Lot Container
  • I_MATERIALSAMPLE.MANDT == T006.MANDT
  • I_MATERIALSAMPLE.INSPECTIONLOTCONTAINERUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • I_MATERIALSAMPLE.MANDT == MARA.MANDT
  • I_MATERIALSAMPLE.MATERIAL == MARA.MATNR
Sample Category I_MATERIALSAMPLE.MATERIALSAMPLECATEGORY == TQ44.PRTYP
Unit of Measure for Material Sample Size
  • Client
  • Unit of Measure for Material Sample Size
  • I_MATERIALSAMPLE.MANDT == T006.MANDT
  • I_MATERIALSAMPLE.MATERIALSAMPLESIZEUNIT == T006.MSEHI
Material Sample Location
  • Client
  • Plant
  • Material Sample Location
  • I_MATERIALSAMPLE.MANDT == TQ41.MANDT
  • I_MATERIALSAMPLE.PLANT == TQ41.WERKS
  • I_MATERIALSAMPLE.MATERIALSAMPLESTORAGELOCATION == TQ41.AUFBEWORT
Physical-sample type
  • Client
  • Material Sample Type
  • I_MATERIALSAMPLE.MANDT == TQ40.MANDT
  • I_MATERIALSAMPLE.MATERIALSAMPLETYPE == TQ40.PRART
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_MATERIALSAMPLE.MANDT == TQ01B.MANDT
  • I_MATERIALSAMPLE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Storage Condition
  • Client
  • Storage Condition
  • I_MATERIALSAMPLE.MANDT == TQ43.MANDT
  • I_MATERIALSAMPLE.MATLSAMPLESTORAGECONDITION == TQ43.STABICON
Material Sample Container
  • Client
  • Material Sample Container
  • I_MATERIALSAMPLE.MANDT == TQ42.MANDT
  • I_MATERIALSAMPLE.MATLSMPLCONTAINERTYPE == TQ42.GEBINDETYP
Plant
  • Client
  • Plant
  • I_MATERIALSAMPLE.MANDT == T001W.MANDT
  • I_MATERIALSAMPLE.PLANT == T001W.WERKS
Primary Packaging (Stability Study)
  • Client
  • Primary Packaging (Stability Study)
  • I_MATERIALSAMPLE.MANDT == TQ45.MANDT
  • I_MATERIALSAMPLE.QUALITYRELEVANTPACKAGING == TQ45.PRIMPACK
Sample-Drawing Procedure
  • Client
  • Sample-Drawing Procedure
  • Version No. of the Sample-Drawing Procedure
  • I_MATERIALSAMPLE.MANDT == QPRVK.MANDT
  • I_MATERIALSAMPLE.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF
  • I_MATERIALSAMPLE.SMPLDRAWINGPROCEDUREVERSION == QPRVK.VERSION
Version No. of the Sample-Drawing Procedure
  • Client
  • Sample-Drawing Procedure
  • Version No. of the Sample-Drawing Procedure
  • I_MATERIALSAMPLE.MANDT == QPRVK.MANDT
  • I_MATERIALSAMPLE.SMPLDRAWINGPROCEDURE == QPRVK.PRZIEHVERF
  • I_MATERIALSAMPLE.SMPLDRAWINGPROCEDUREVERSION == QPRVK.VERSION
Storage location
  • Client
  • Plant
  • Storage location
  • I_MATERIALSAMPLE.MANDT == T001L.MANDT
  • I_MATERIALSAMPLE.PLANT == T001L.WERKS
  • I_MATERIALSAMPLE.STORAGELOCATION == T001L.LGORT