QCVM
Certificate profile characteristic level
QCVM is an SAP database table in S/4HANA. Certificate profile characteristic level. It contains 31 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_QltyCertPrflCharacteristic | view | from | BASIC | Certificate Profile Characteristic |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandant | mandt | Client | |||
| KEY | ctyp | qzgtyp | CertificateType | |||
| KEY | vorlnr | qvorlnr | Cert. Profile | |||
| KEY | version | qcversion | Version No. | |||
| KEY | blocknr | qblocknr | Char.block no. | |||
| KEY | merkmalnr | qmknr | Character. no. | |||
| sortnr | qsortnr | Number | ||||
| text_elem | qctextelem | Text Element | ||||
| kategorie | qccharcat | Charc Category | ||||
| zaehler | werks_d | Plant | ||||
| mkmnr | qmerknr | Master IC | ||||
| versionmk | qversnrmk | Version | ||||
| cmerkmalid | atinn | Internal char. | ||||
| kzherkwert | qkzherkwt | Result Origin | ||||
| kzherktext | qkzherktxt | Text Origin | ||||
| kzausgfmt | qkzausgfmt | Output Format | ||||
| kzmethode | qkzmethode | Method Text | ||||
| kzesel | qkzesel | Result Level | ||||
| kzherkvg | qkzherkvg | Spec. Origin | ||||
| kzstrskip | qkzstrskip | Skip Strategy | ||||
| masseinhsw | qmasseh | Unit of Meas. | ||||
| ausglen | qlaenge | Output Length | ||||
| stellen | qstellen | Decimal Places | ||||
| kzexpds | qkzexpds | Exponent | ||||
| kzoffsptx | qkzoffsptx | Add.text not OK | ||||
| kzobl | qkzmkobl | Required | ||||
| vmsortnr | qcsortnr | Sort no. mat. | ||||
| columnsort | qccolsort | By Columns | ||||
| columns | qccolumns | No. of Columns | ||||
| unitnrsort | qcunitsort | Sort by Term for Inspected Unit | ||||
| charact_id1 | qcharact_id1 | Charact. ID |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Certificate profile characteristic level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCVM (
MANDANT, -- Client [mandt]
CTYP, -- CertificateType [qzgtyp]
VORLNR, -- Cert. Profile [qvorlnr]
VERSION, -- Version No. [qcversion]
BLOCKNR, -- Char.block no. [qblocknr]
MERKMALNR, -- Character. no. [qmknr]
SORTNR, -- Number [qsortnr]
TEXT_ELEM, -- Text Element [qctextelem]
KATEGORIE, -- Charc Category [qccharcat]
ZAEHLER, -- Plant [werks_d]
MKMNR, -- Master IC [qmerknr]
VERSIONMK, -- Version [qversnrmk]
CMERKMALID, -- Internal char. [atinn]
KZHERKWERT, -- Result Origin [qkzherkwt]
KZHERKTEXT, -- Text Origin [qkzherktxt]
KZAUSGFMT, -- Output Format [qkzausgfmt]
KZMETHODE, -- Method Text [qkzmethode]
KZESEL, -- Result Level [qkzesel]
KZHERKVG, -- Spec. Origin [qkzherkvg]
KZSTRSKIP, -- Skip Strategy [qkzstrskip]
MASSEINHSW, -- Unit of Meas. [qmasseh]
AUSGLEN, -- Output Length [qlaenge]
STELLEN, -- Decimal Places [qstellen]
KZEXPDS, -- Exponent [qkzexpds]
KZOFFSPTX, -- Add.text not OK [qkzoffsptx]
KZOBL, -- Required [qkzmkobl]
VMSORTNR, -- Sort no. mat. [qcsortnr]
COLUMNSORT, -- By Columns [qccolsort]
COLUMNS, -- No. of Columns [qccolumns]
UNITNRSORT, -- Sort by Term for Inspected Unit [qcunitsort]
CHARACT_ID1, -- Charact. ID [qcharact_id1]
PRIMARY KEY (MANDANT, CTYP, VORLNR, VERSION, BLOCKNR, MERKMALNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA