QCVV

Certificate Profile: List of Preliminary Products | #masterdata | Component: Basic Data for Certificates
Column Name Description
MANDANT FK Client
CTYP FK Certificate Type
VORLNR FK Certificate Profile ID
VERSION Version Number of Certificate Profile
VMKATEG Category of Data Origin (Insp. Lot/Batch) for Certificate Show values
MATNR FK Material Number
COUNTER Sequential Number for Material in a Certificate Profile
Column Name Description
Column Name Description
Column Name Description
Column Name Description
VMKATEG Category of Data Origin (Insp. Lot/Batch) for Certificate Show values
KZGUTLOSE Only Inspection Lots Whose Usage Decision Is OK Show values
Column Name Description Domain name
BLOCKNR Number of Characteristic Block NUMC4
VMSORTNR Sort Number in List of Materials for Certificate Profile NUMC4
MINQKZ Minimum Quality Score for Good Quality QKENNZAHL
Master Data Relations Join Conditions
Inspection Type
  • QCVV.MANDANT == TQ30.MANDT
  • QCVV.ART == TQ30.ART
Certificate Type
  • QCVV.MANDANT == TQ05.MANDT
  • QCVV.CTYP == TQ05.ZGTYP
Inspection Lot Origin QCVV.HERKUNFT == TQ31.HERKUNFT
Client QCVV.MANDANT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QCVV.MATNR == MARA.MATNR
  • QCVV.MANDANT == MARA.MANDT
Certificate Profile ID
  • Version Number of Certificate Profile
  • Certificate Type
  • Certificate Profile ID
  • Client
  • QCVV.VERSION == QCVK.VERSION
  • QCVV.CTYP == QCVK.CTYP
  • QCVV.VORLNR == QCVK.VORLNR
  • QCVV.MANDANT == QCVK.MANDANT