QCPR

QM quality certificates in procurement | #transactional | Component: Quality Certificates
Column Name Description
MANDT FK Client
CERTNO Quality Certificate
Column Name Description
Column Name Description
Column Name Description
BUDAT Posting Date in the Document
REMDAT Reminder Date
ESCDAT Escalation Date
CERTDAT Date of Certificate Receipt
ERSTELDAT Date in Time Zone Where Data Was Created
ERSTELZEIT Time in Time Zone Where Data Was Created
AENDERDAT Date in Time Zone Where Data Was Changed
AENDERZEIT Time in Time Zone Where Data Was Changed
Column Name Description
STATUS Certificate Status Show values
CVP_XBLCK Business Purpose Completed Flag Show values
Column Name Description Domain name
LICHN Supplier Batch Number LICHN
LFSNR Number of External Delivery Note XBLNR1
MJAHR Material Document Year GJAHR
CERTREC Certificate Receipt Entered By QCERTREC
ERSTELLER Name of User Who Created the Data Record QAENDERER
AENDERER Name of User Who Last Changed Data Record QAENDERER
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • QCPR.MATNR == MCH1.MATNR
  • QCPR.MANDT == MCH1.MANDT
  • QCPR.CHARG == MCH1.CHARG
Number of Manufacturer
  • QCPR.MANDT == LFA1.MANDT
  • QCPR.HERSTELLER == LFA1.LIFNR
Vendor's account number
  • QCPR.MANDT == LFA1.MANDT
  • QCPR.LIFNR == LFA1.LIFNR
Client QCPR.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QCPR.MATNR == MARA.MATNR
  • QCPR.MANDT == MARA.MANDT
Plant
  • QCPR.MANDT == T001W.MANDT
  • QCPR.WERKS == T001W.WERKS
Certificate Type
  • QCPR.MANDT == TQ05.MANDT
  • QCPR.ZGTYP == TQ05.ZGTYP