I_QltyProcmtCert

Certificate Receipts | view: IQLTYPROCMTCERT | 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
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
QltyProcmtCertChgDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_QLTYPROCMTCERT.MATERIAL == MCH1.MATNR
  • I_QLTYPROCMTCERT.BATCH == MCH1.CHARG
  • I_QLTYPROCMTCERT.MANDT == MCH1.MANDT
Material Number
  • Material Number
  • Client
  • I_QLTYPROCMTCERT.MATERIAL == MARA.MATNR
  • I_QLTYPROCMTCERT.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • I_QLTYPROCMTCERT.PLANT == T001W.WERKS
  • I_QLTYPROCMTCERT.MANDT == T001W.MANDT
Certificate Type
  • Certificate Type
  • Client
  • I_QLTYPROCMTCERT.QUALITYCERTIFICATETYPE == TQ05.ZGTYP
  • I_QLTYPROCMTCERT.MANDT == TQ05.MANDT
Supplier Account Number
  • Supplier Account Number
  • Client
  • I_QLTYPROCMTCERT.SUPPLIER == LFA1.LIFNR
  • I_QLTYPROCMTCERT.MANDT == LFA1.MANDT