SAP Table QCVM

Certificate profile characteristic level

QCVM (Certificate profile characteristic level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QCVM to other SAP tables.

QCVM table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
CTYP Certificate Type QZGTYP TQ05 CHAR 4 0
VORLNR Certificate Profile Number QVORLNR QCVK CHAR 12 0
VERSION Version Number of Certificate Profile QCVERSION CHAR 6 0
BLOCKNR Number of Characteristic Block QBLOCKNR NUMC 4 0
MERKMALNR Consecutive Characteristic Number QMKNR NUMC 4 0
SORTNR Sort Number QSORTNR NUMC 4 0
TEXT_ELEM Assignment of a Characteristic to a Form Text Element QCTEXTELEM CHAR 4 0
KATEGORIE Characteristic Category for Certificates QCCHARCAT CHAR 1 0
1 Master inspection characteristic
2 Class characteristic
ZAEHLER Plant WERKS_D CHAR 4 0
MKMNR Master Inspection Characteristics QMERKNR QPMK CHAR 8 0
VERSIONMK Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 0
CMERKMALID Internal characteristic ATINN NUMC 10 0
KZHERKWERT Origin of the Characteristic Result on the Certificate QKZHERKWT TQ61 CHAR 2 0
KZHERKTEXT Origin of Characteristic Short Text QKZHERKTXT TQ64 CHAR 2 0
KZAUSGFMT Characteristic Output Format QKZAUSGFMT CHAR 2 0
NULL Actual value
01 Actual value
02 Greater than lower tolerance
03 Less than upper tolerance
04 Within tolerance
05 Text dependent on tolerance comparison
KZMETHODE Output Inspection Method QKZMETHODE CHAR 2 0
01 Short text
02 Long text
NULL No
KZESEL Level for Result Selection QKZESEL CHAR 1 0
1 Summary
2 Mean value of the sample / inspection point
3 Original value
KZHERKVG Origin of Inspection Specifications QKZHERKVG TQ63 CHAR 2 0
KZSTRSKIP Output Strategy for Skip Characteristics QKZSTRSKIP TQ62 CHAR 2 0
MASSEINHSW Unit of Measurement, in Which Quantitative Data Is Stored QMASSEH T006 UNIT 3 0
AUSGLEN Output Length QLAENGE INT1 3 0
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) QSTELLEN INT1 3 0
KZEXPDS Indicator: Exponential Notation QKZEXPDS CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZOFFSPTX Additional Text When Result Is Outside Specifications QKZOFFSPTX CHAR 1 0
< If less than lower limit
> If greater than upper limit
1 If outside of specification
0 No
NULL No
KZOBL Indicator: Characteristic Required QKZMKOBL CHAR 1 0
NULL Indicator is not set
X Indicator is set
VMSORTNR Sort Number in List of Materials for Certificate Profile QCSORTNR NUMC 4 0
COLUMNSORT Display by Columns QCCOLSORT CHAR 1 0
NULL Indicator is not set
X Indicator is set
COLUMNS Number of Columns QCCOLUMNS NUMC 2 0
UNITNRSORT Sort by Term for Inspected Unit QCUNITSORT CHAR 1 0
NULL Indicator is not set
X Indicator is set
CHARACT_ID1 Characteristic Description for Quality Data Exchange QCHARACT_ID1 CHAR 40 0

QCVM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QCVM CTYP QCVM MANDANT TQ05 QM certificate categories for procurement MANDT
QCVM CTYP QCVM CTYP TQ05 QM certificate categories for procurement ZGTYP
QCVM KZHERKTEXT QCVM MANDANT TQ64 Origin of characteristic short text for certificates MANDANT
QCVM KZHERKTEXT QCVM KZHERKTEXT TQ64 Origin of characteristic short text for certificates KZHERKTEXT
QCVM KZHERKVG QCVM MANDANT TQ63 Origin of insp. specs for certificates (function modules) MANDANT
QCVM KZHERKVG QCVM KZHERKVG TQ63 Origin of insp. specs for certificates (function modules) KZHERKVG
QCVM KZHERKWERT QCVM KZHERKWERT TQ61 Result value origin for certificates KZHERKWERT
QCVM KZHERKWERT QCVM MANDANT TQ61 Result value origin for certificates MANDANT
QCVM KZSTRSKIP QCVM MANDANT TQ62 Output strategy for skip characteristics MANDANT
QCVM KZSTRSKIP QCVM KZSTRSKIP TQ62 Output strategy for skip characteristics KZSTRSKIP
QCVM MANDANT QCVM MANDANT T000 Clients MANDT
QCVM MASSEINHSW QCVM MANDANT T006 Units of Measurement MANDT
QCVM MASSEINHSW QCVM MASSEINHSW T006 Units of Measurement MSEHI
QCVM MKMNR QCVM MANDANT QPMK Inspection characteristic master MANDT
QCVM MKMNR QCVM ZAEHLER QPMK Inspection characteristic master ZAEHLER
QCVM MKMNR QCVM MKMNR QPMK Inspection characteristic master MKMNR
QCVM MKMNR QCVM VERSIONMK QPMK Inspection characteristic master VERSION
QCVM VORLNR QCVM VERSION QCVK Certificate profile header VERSION
QCVM VORLNR QCVM MANDANT QCVK Certificate profile header MANDANT
QCVM VORLNR QCVM CTYP QCVK Certificate profile header CTYP
QCVM VORLNR QCVM VORLNR QCVK Certificate profile header VORLNR