SAP table QCVME (Certificate profile charac. level: Extended information)

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

QCVME foreign key relationships

Table Field Check Table Check Field
0 QCVME KZHERKTEXT TQ64 Origin of characteristic short text for certificates MANDANT
1 QCVME KZHERKVG TQ63 Origin of insp. specs for certificates (function modules) MANDANT
0 QCVME KZHERKWERT TQ61 Result value origin for certificates MANDANT
0 QCVME KZHERKWERT TQ61 Result value origin for certificates KZHERKWERT
1 QCVME KZSTRSKIP TQ62 Output strategy for skip characteristics MANDANT
1 QCVME KZSTRSKIP TQ62 Output strategy for skip characteristics KZSTRSKIP
0 QCVME MANDANT T000 Clients MANDT
1 QCVME MKMNR QPMK Inspection characteristic master MANDT
1 QCVME MKMNR QPMK Inspection characteristic master ZAEHLER
1 QCVME MKMNR QPMK Inspection characteristic master VERSION
0 QCVME TQ61_FBNAM TFDIR Function Module FUNCNAME
1 QCVME TQ62_FBNAM TFDIR Function Module FUNCNAME
0 QCVME TQ63_FBNAM TFDIR Function Module FUNCNAME
1 QCVME TQ64_FBNAM TFDIR Function Module FUNCNAME
0 QCVME VORLNR QCVK Certificate profile header MANDANT
0 QCVME VORLNR QCVK Certificate profile header CTYP
0 QCVME VORLNR QCVK Certificate profile header VORLNR
0 QCVME VORLNR QCVK Certificate profile header VERSION