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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KZMETHODE
Output Inspection Method
|
QKZMETHODE |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZESEL
Level for Result Selection
|
QKZESEL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KZOFFSPTX
Additional Text When Result Is Outside Specifications
|
QKZOFFSPTX |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
KZOBL
Indicator: Characteristic Required
|
QKZMKOBL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VMSORTNR
Sort Number in List of Materials for Certificate Profile
|
QCSORTNR |
NUMC
|
4 | 0 | ||||||||||||||||
|
COLUMNSORT
Display by Columns
|
QCCOLSORT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
COLUMNS
Number of Columns
|
QCCOLUMNS |
NUMC
|
2 | 0 | ||||||||||||||||
|
UNITNRSORT
Sort by Term for Inspected Unit
|
QCUNITSORT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | MANDANT |
TQ61
Result value origin for certificates
|
MANDANT |
| QCVM | KZHERKWERT | QCVM | KZHERKWERT |
TQ61
Result value origin for certificates
|
KZHERKWERT |
| QCVM | KZSTRSKIP | QCVM | KZSTRSKIP |
TQ62
Output strategy for skip characteristics
|
KZSTRSKIP |
| QCVM | KZSTRSKIP | QCVM | MANDANT |
TQ62
Output strategy for skip characteristics
|
MANDANT |
| 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 | MKMNR |
QPMK
Inspection characteristic master
|
MKMNR |
| QCVM | MKMNR | QCVM | VERSIONMK |
QPMK
Inspection characteristic master
|
VERSION |
| QCVM | MKMNR | QCVM | MANDANT |
QPMK
Inspection characteristic master
|
MANDT |
| QCVM | MKMNR | QCVM | ZAEHLER |
QPMK
Inspection characteristic master
|
ZAEHLER |
| 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 |
| QCVM | VORLNR | QCVM | VERSION |
QCVK
Certificate profile header
|
VERSION |