QPRN

Sample Drawing of Material Samples | #transactional | Component: Sample Management
Column Name Description
MANDT FK Client
PN_NR Sample-Drawing Number
Column Name Description
Column Name Description
Column Name Description
ANLDT System Date When Material Sample Was Created
ANLZT Time at Which Material Sample Was Created
FRGDT Material Sample Release Date
FRGZT Time of Material Sample Release
Column Name Description
CVP_XBLCK Business Purpose Completed Flag Show values
KZQUIT Confirmation Required for Sample Drawing Show values
SIG_IL_SDR Digital Signature for Confirmation of Sample Drawing Show values
Column Name Description Domain name
REVLV Revision Level REVLV
MBLNR Number of Material Document BELNR
ZEILE Item in Material Document MBLPO
MJAHR Material Document Year GJAHR
ANLNA User Who Created the Material Sample QAENDERER
QMATAUTH Material Authorization Group for Activities in QM QMATAUTH
FRGNA User Who Released the Material Sample QAENDERER
PZTXT Comments on Sample Drawing TEXT40
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • QPRN.AUFNR == AUFK.AUFNR
  • QPRN.MANDT == AUFK.MANDT
Batch Number
  • Material Number
  • Client
  • Batch Number
  • QPRN.MATNR == MCH1.MATNR
  • QPRN.MANDT == MCH1.MANDT
  • QPRN.CHARG == MCH1.CHARG
Number of Manufacturer
  • QPRN.MANDT == LFA1.MANDT
  • QPRN.HRSTL == LFA1.LIFNR
Customer (Ship-To Party)
  • QPRN.MANDT == KNA1.MANDT
  • QPRN.KUNNR == KNA1.KUNNR
Vendor's account number
  • QPRN.MANDT == LFA1.MANDT
  • QPRN.LIFNR == LFA1.LIFNR
Client QPRN.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QPRN.MATNR == MARA.MATNR
  • QPRN.MANDT == MARA.MANDT
Run schedule header number
  • Run schedule header number
  • Client
  • QPRN.SA_AUFNR == SAFK.AUFNR
  • QPRN.MANDT == SAFK.MANDT
Production Version
  • Plant
  • Material Number
  • Production Version
  • Client
  • QPRN.WERKS == MKAL.WERKS
  • QPRN.MATNR == MKAL.MATNR
  • QPRN.VERID == MKAL.VERID
  • QPRN.MANDT == MKAL.MANDT
Plant
  • QPRN.MANDT == T001W.MANDT
  • QPRN.WERKS == T001W.WERKS