C_QltyProcmtCertMng

Certificate Receipts | view: CQLTYPRMCTCERTMG | TRAN | Extraction: Not supported | Component: Quality Certificates
Tables used: QCPR
Column Name Description
QualityProcurementCertificate Quality Certificate
Column Name Description
Column Name Description
Column Name Description
GoodsReceiptPostingDate Goods Receipt Posting Date
QltyProcmtCertReceiptDate Certificate Received On
QltyProcmtCertCrtnDte Date in Time Zone Where Data Was Created
QltyProcmtCertCrtnTme Time in Time Zone Where Data Was Created
QltyProcmtCertChgDte Date in Time Zone Where Data Was Changed
QltyProcmtCertChgTme Time in Time Zone Where Data Was Changed
Column Name Description
QltyProcmtCertStatus Certificate Status Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
QltyProcmtCertStatusCritlty null
MaterialDocumentYear Material Document Year GJAHR
BatchBySupplier Supplier Batch Number LICHN
DeliveryNote Number of External Delivery Note XBLNR1
QltyProcmtCertCrtedByUsr Name of User Who Created the Data Record QAENDERER
QltyProcmtCertChgdBy Name of User Who Last Changed Data Record QAENDERER
LinkedSAPObjectKey Document Management Object Key OBJKY
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • C_QLTYPROCMTCERTMNG.MANDT == MCH1.MANDT
  • C_QLTYPROCMTCERTMNG.MATERIAL == MCH1.MATNR
  • C_QLTYPROCMTCERTMNG.BATCH == MCH1.CHARG
Material Number
  • Client
  • Material Number
  • C_QLTYPROCMTCERTMNG.MANDT == MARA.MANDT
  • C_QLTYPROCMTCERTMNG.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_QLTYPROCMTCERTMNG.MANDT == T001W.MANDT
  • C_QLTYPROCMTCERTMNG.PLANT == T001W.WERKS
Certificate Type
  • Client
  • Certificate Type
  • C_QLTYPROCMTCERTMNG.MANDT == TQ05.MANDT
  • C_QLTYPROCMTCERTMNG.QUALITYCERTIFICATETYPE == TQ05.ZGTYP
Supplier Account Number
  • Supplier Account Number
  • Client
  • C_QLTYPROCMTCERTMNG.SUPPLIER == LFA1.LIFNR
  • C_QLTYPROCMTCERTMNG.MANDT == LFA1.MANDT