1. Home
  2. Resources
  3. SAP Tables
  4. QCVME - Certificate profile charac. level: Extended information

SAP Table QCVME

Certificate profile charac. level: Extended information

QCVME (Certificate profile charac. level: Extended information) 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 QCVME to other SAP tables.

Source: QCVME (Certificate profile charac. level: Extended information)

QCVME 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
TQ61_FBNAM Name of Function Module RS38L_FNAM TFDIR CHAR 30 0
FROM_LOT Indicator: Read Inspection Lots QKZFROMLOT CHAR 1 0
NULL Indicator is not set
X Indicator is set
TQ62_FBNAM Name of Function Module RS38L_FNAM TFDIR CHAR 30 0
TQ63_FBNAM Name of Function Module RS38L_FNAM TFDIR CHAR 30 0
TQ64_FBNAM Name of Function Module RS38L_FNAM TFDIR CHAR 30 0
INCOMPLETE X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ATNAM Characteristic Name ATNAM CHAR 30 0
VALUESORTNR Sort Number QSORTNR NUMC 4 0
IPMEDIUM Mean Value / Original Values from All Inspection Points QCIPMEDIUM CHAR 1 0
NULL Indicator is not set
X Indicator is set

QCVME foreign key relationships

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