SHSM_QPRN

Material Sample Drawing | view: SHSMQPRN | TRAN | Extraction: Not supported | Component: Sample Management
Tables used: QPRN
Column Name Description
PN_NR Sample-Drawing Number
Column Name Description
Column Name Description
Column Name Description
ANLDT System Date When Material Sample Was Created
FRGDT Material Sample Release Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
ANLNA User Who Created the Material Sample QAENDERER
FRGNA User Who Released the Material Sample QAENDERER
MatlQualityAuthorizationGroup Material Authorization Group for Activities in QM QMATAUTH
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • SHSM_QPRN.CHARG == MCH1.CHARG
  • SHSM_QPRN.MANDT == MCH1.MANDT
  • SHSM_QPRN.MATNR == MCH1.MATNR
Vendor's account number
  • Vendor's account number
  • Client
  • SHSM_QPRN.LIFNR == LFA1.LIFNR
  • SHSM_QPRN.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • SHSM_QPRN.MANDT == MARA.MANDT
  • SHSM_QPRN.MATNR == MARA.MATNR
Plant
  • Plant
  • Plant
  • Client
  • SHSM_QPRN.WERKS == T001W.WERKS
  • SHSM_QPRN.PLANT == T001W.WERKS
  • SHSM_QPRN.MANDT == T001W.MANDT
Plant
  • Plant
  • Plant
  • Client
  • SHSM_QPRN.WERKS == T001W.WERKS
  • SHSM_QPRN.PLANT == T001W.WERKS
  • SHSM_QPRN.MANDT == T001W.MANDT