I_MaterialSampleDrawing

Material Sample Drawing | view: IMATLSMPLDRW | TRAN | Extraction: Not supported | Component: Quality Inspection
Tables used: QPRN
Column Name Description
MaterialSampleDrawing Sample-Drawing Number
Column Name Description
Column Name Description
Column Name Description
CreationDate System Date When Material Sample Was Created
CreationTime Time at Which Material Sample Was Created
MaterialSampleReleaseDate Material Sample Release Date
MaterialSampleReleaseTime Time of Material Sample Release
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
MatlQualityAuthorizationGroup Material Authorization Group for Activities in QM QMATAUTH
CreatedByUser User Who Created the Material Sample QAENDERER
MaterialSampleReleasedBy User Who Released the Material Sample QAENDERER
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Material Number
  • I_MATERIALSAMPLEDRAWING.MANDT == MCH1.MANDT
  • I_MATERIALSAMPLEDRAWING.BATCH == MCH1.CHARG
  • I_MATERIALSAMPLEDRAWING.MATERIAL == MCH1.MATNR
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_MATERIALSAMPLEDRAWING.MANDT == KNA1.MANDT
  • I_MATERIALSAMPLEDRAWING.CUSTOMER == KNA1.KUNNR
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • I_MATERIALSAMPLEDRAWING.MANDT == LFA1.MANDT
  • I_MATERIALSAMPLEDRAWING.MANUFACTURER == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_MATERIALSAMPLEDRAWING.MANDT == MARA.MANDT
  • I_MATERIALSAMPLEDRAWING.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_MATERIALSAMPLEDRAWING.MANDT == T001W.MANDT
  • I_MATERIALSAMPLEDRAWING.PLANT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_MATERIALSAMPLEDRAWING.SUPPLIER == LFA1.LIFNR
  • I_MATERIALSAMPLEDRAWING.MANDT == LFA1.MANDT