I_QltyCertPrflMaterial

Quality Certificate Profile Material | view: IQLTYCERTPFMAT | Extraction: Not supported | Component: Quality Certificates
Tables used: QCVV
Column Name Description
QualityCertificateType FK Certificate Type
QltyCertificateProfile FK Certificate Profile ID
QltyCertProfileVersion Version Number of Certificate Profile
QltyCertPrflCharcValueOrigin Category of Data Origin (Insp. Lot/Batch) for Certificate Show values
Material FK Material Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
QltyCertPrflCharcValueOrigin Category of Data Origin (Insp. Lot/Batch) for Certificate Show values
Column Name Description Domain name
QltyCertPrflGroup Number of Characteristic Block NUMC4
QltyCertPrflMaterialSortNumber Sort Number in List of Materials for Certificate Profile NUMC4
Master Data Relations Join Conditions
Inspection Lot Origin I_QLTYCERTPRFLMATERIAL.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • I_QLTYCERTPRFLMATERIAL.MANDT == TQ30.MANDT
  • I_QLTYCERTPRFLMATERIAL.INSPECTIONLOTTYPE == TQ30.ART
Material Number
  • Client
  • Material Number
  • I_QLTYCERTPRFLMATERIAL.MANDT == MARA.MANDT
  • I_QLTYCERTPRFLMATERIAL.MATERIAL == MARA.MATNR
Certificate Profile ID
  • Client
  • Certificate Type
  • Version Number of Certificate Profile
  • Certificate Profile ID
  • I_QLTYCERTPRFLMATERIAL.MANDT == QCVK.MANDANT
  • I_QLTYCERTPRFLMATERIAL.QUALITYCERTIFICATETYPE == QCVK.CTYP
  • I_QLTYCERTPRFLMATERIAL.QLTYCERTPROFILEVERSION == QCVK.VERSION
  • I_QLTYCERTPRFLMATERIAL.QLTYCERTIFICATEPROFILE == QCVK.VORLNR
Certificate Type
  • Client
  • Certificate Type
  • I_QLTYCERTPRFLMATERIAL.MANDT == TQ05.MANDT
  • I_QLTYCERTPRFLMATERIAL.QUALITYCERTIFICATETYPE == TQ05.ZGTYP