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 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
KZMETHODE | Output Inspection Method | QKZMETHODE | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
KZESEL | Level for Result Selection | QKZESEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
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 |
Possible values
|
||||||||||||||
KZOFFSPTX | Additional Text When Result Is Outside Specifications | QKZOFFSPTX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
KZOBL | Indicator: Characteristic Required | QKZMKOBL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VMSORTNR | Sort Number in List of Materials for Certificate Profile | QCSORTNR | NUMC | 4 | 0 | |||||||||||||||
COLUMNSORT | Display by Columns | QCCOLSORT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
COLUMNS | Number of Columns | QCCOLUMNS | NUMC | 2 | 0 | |||||||||||||||
UNITNRSORT | Sort by Term for Inspected Unit | QCUNITSORT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
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 |