SAP Table QCVK
Certificate profile header
QCVK (Certificate profile header) 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 QCVK to other SAP tables.
QCVK 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 |
CHAR
|
12 | 0 | ||||||||
|
VERSION
Version Number of Certificate Profile
|
QCVERSION |
CHAR
|
6 | 0 | ||||||||
|
SORTFELD
Search Field
|
QSORTFELD |
CHAR
|
40 | 0 | ||||||||
|
GUELTIGAB
Field Not Used Field Reserved for SAP
|
Q_UNUSEDDT |
DATS
|
8 | 0 | ||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||
|
OBTYP
Object Category
|
J_OBTYP | TJ03 |
CHAR
|
3 | 0 | |||||||
|
STSMA
Status Profile
|
J_STSMA | TJ20 |
CHAR
|
8 | 0 | |||||||
|
ERSTELLER
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||
|
ERSTELDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||
|
AENDERER
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||
|
AENDERDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||
|
TDFORM
Form Name
|
QCTDFORM |
CHAR
|
16 | 0 | ||||||||
|
KZGUTLOSE
Indicator: Only Lots Whose Usage Decision is OK
|
QKZGUTLOSE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MINQKZ
Minimum Quality Score for Good Quality
|
QKZMIN |
DEC
|
3 | 0 | ||||||||
|
KZLASTLOT
Indicator: Last Lot for Batch
|
QKZLASTLOT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZLIEFSCH
Indicator: Delivery Note in Inspection Lot
|
QKZLIEFSCH |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
HERKUNFT
Inspection Lot Origin
|
QHERK | TQ31 |
CHAR
|
2 | 0 | |||||||
|
ART
Inspection Type
|
QPART | TQ30 |
CHAR
|
8 | 0 | |||||||
|
KONSISTENT
Indicator: Certificate Profile is Consistent
|
QKZKONSIST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KURZTEXT
Short Text
|
QKURZTEXT |
CHAR
|
40 | 0 | ||||||||
|
LTEXTKZ
Long Text Exists
|
QKZLTX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WITHTRANSF
Stock Transfers from Batch Where-Used List
|
QCTRANSFER |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
QDI_NOPDF
Indicator: Do Not Send PDF Document
|
QC_QDI_NOPDF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ALSTF
Expansion Level of Batch Where-Used List
|
QCALSTF |
NUMC
|
2 | 0 | ||||||||
|
ADBFORM
PDF-Based Forms: Form Name
|
QC_PDF_FORMNAME |
CHAR
|
30 | 0 | ||||||||
|
QKZ_USEADB
Use Adobe Form
|
QC_QKZ_USEADB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CHAR_FIELD_CONF
Configuration of Characteristics Field
|
QC_CHAR_FIELD_CONF | TQ68 |
CHAR
|
3 | 0 | |||||||
QCVK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QCVK | ART | QCVK | MANDANT |
TQ30
Inspection types
|
MANDT |
| QCVK | ART | QCVK | ART |
TQ30
Inspection types
|
ART |
| QCVK | CHAR_FIELD_CONF | QCVK | MANDANT |
TQ68
Definition of Configuration of Characteristics Field
|
MANDT |
| QCVK | CHAR_FIELD_CONF | QCVK | CHAR_FIELD_CONF |
TQ68
Definition of Configuration of Characteristics Field
|
CHAR_FIELD_CONF |
| QCVK | CTYP | QCVK | MANDANT |
TQ05
QM certificate categories for procurement
|
MANDT |
| QCVK | CTYP | QCVK | CTYP |
TQ05
QM certificate categories for procurement
|
ZGTYP |
| QCVK | HERKUNFT | QCVK | HERKUNFT |
TQ31
Inspection Lot Origins
|
HERKUNFT |
| QCVK | MANDANT | QCVK | MANDANT |
T000
Clients
|
MANDT |
| QCVK | OBJNR | QCVK | MANDANT |
ONR00
General Object Number
|
MANDT |
| QCVK | OBJNR | QCVK | OBJNR |
ONR00
General Object Number
|
OBJNR |
| QCVK | OBTYP | QCVK | OBTYP |
TJ03
Object types
|
OBTYP |
| QCVK | STSMA | QCVK | MANDANT |
TJ20
Status profiles
|
MANDT |
| QCVK | STSMA | QCVK | STSMA |
TJ20
Status profiles
|
STSMA |