SAP table QCVM (Certificate profile characteristic level)

SAP table QCVM has 6 primary key fields being MANDANT,CTYP,VORLNR,VERSION,BLOCKNR,MERKMALNR.

Field Description Data Type Length Decimals Checktable Data Element
MANDANT Client CLNT 3 0 T000 MANDT
CTYP Certificate Type CHAR 4 0 TQ05 QZGTYP
VORLNR Certificate Profile ID CHAR 12 0 QCVK QVORLNR
VERSION Version Number of Certificate Profile CHAR 6 0 QCVERSION
BLOCKNR Number of Characteristic Block NUMC 4 0 QBLOCKNR
MERKMALNR Consecutive Characteristic Number NUMC 4 0 QMKNR
SORTNR Sort Number NUMC 4 0 QSORTNR
TEXT_ELEM Assignment of a Characteristic to a Form Text Element CHAR 4 0 QCTEXTELEM
KATEGORIE Characteristic Category for Certificates CHAR 1 0 QCCHARCAT
ZAEHLER Plant CHAR 4 0 * WERKS_D
MKMNR Master Inspection Characteristic CHAR 8 0 QPMK QMERKNR
VERSIONMK Version Number of Master Inspection Characteristic CHAR 6 0 QVERSNRMK
CMERKMALID Internal characteristic NUMC 10 0 * ATINN
KZHERKWERT Origin of Characteristic Result on Certificate CHAR 2 0 TQ61 QKZHERKWT
KZHERKTEXT Origin of Characteristic Short Text CHAR 2 0 TQ64 QKZHERKTXT
KZAUSGFMT Characteristic Output Format CHAR 2 0 QKZAUSGFMT
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 of Inspection Method Text CHAR 2 0 QKZMETHODE
No
01 Short text
02 Long text
KZESEL Level for Result Selection CHAR 1 0 QKZESEL
1 Summary
2 Mean Value of Sample/Inspection Point
3 Original Value
KZHERKVG Origin of Inspection Specifications CHAR 2 0 TQ63 QKZHERKVG
KZSTRSKIP Output Strategy for Skip Characteristics CHAR 2 0 TQ62 QKZSTRSKIP
MASSEINHSW Unit of Measurement in Which Quantitative Data Is Stored UNIT 3 0 T006 QMASSEH
AUSGLEN Output Length INT1 3 0 QLAENGE
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
KZEXPDS Exponential Notation CHAR 1 0 QKZEXPDS
KZOFFSPTX Additional Text When Result Is Outside Specifications CHAR 1 0 QKZOFFSPTX
No
0 No
1 If Outside of Specification
< If Less Than Lower Limit
> If Greater Than Upper Limit
KZOBL Characteristic Is Required CHAR 1 0 QKZMKOBL
VMSORTNR Sort Number in List of Materials for Certificate Profile NUMC 4 0 QCSORTNR
COLUMNSORT Display by Columns CHAR 1 0 QCCOLSORT
COLUMNS Number of Columns NUMC 2 0 QCCOLUMNS
UNITNRSORT Sort by Term for Inspected Unit CHAR 1 0 QCUNITSORT
CHARACT_ID1 Characteristic Description for Quality Data Exchange CHAR 40 0 QCHARACT_ID1

QCVM foreign key relationships

Table Field Check Table Check Field
0 QCVM KZHERKTEXT TQ64 Origin of characteristic short text for certificates MANDANT
1 QCVM KZHERKVG TQ63 Origin of insp. specs for certificates (function modules) MANDANT
0 QCVM KZHERKWERT TQ61 Result value origin for certificates MANDANT
0 QCVM KZHERKWERT TQ61 Result value origin for certificates KZHERKWERT
1 QCVM KZSTRSKIP TQ62 Output strategy for skip characteristics MANDANT
1 QCVM KZSTRSKIP TQ62 Output strategy for skip characteristics KZSTRSKIP
0 QCVM MANDANT T000 Clients MANDT
1 QCVM MASSEINHSW T006 Units of Measurement MANDT
0 QCVM MKMNR QPMK Inspection characteristic master MANDT
0 QCVM MKMNR QPMK Inspection characteristic master ZAEHLER
0 QCVM MKMNR QPMK Inspection characteristic master VERSION
1 QCVM VORLNR QCVK Certificate profile header MANDANT
1 QCVM VORLNR QCVK Certificate profile header CTYP
1 QCVM VORLNR QCVK Certificate profile header VORLNR
1 QCVM VORLNR QCVK Certificate profile header VERSION