SAP table QCVK (Certificate profile header)
SAP table QCVK has 4 primary key fields being MANDANT,CTYP,VORLNR,VERSION.
| 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 |
|
QVORLNR
|
|
| VERSION |
Version Number of Certificate Profile |
CHAR |
6 |
0 |
|
QCVERSION
|
|
| SORTFELD |
Search Field |
CHAR |
40 |
0 |
|
QSORTFELD
|
|
| GUELTIGAB |
Field Not Used Field Reserved for SAP |
DATS |
8 |
0 |
|
Q_UNUSEDDT
|
|
| OBJNR |
Object number |
CHAR |
22 |
0 |
ONR00
|
J_OBJNR
|
|
| OBTYP |
Object Type |
CHAR |
3 |
0 |
TJ03
|
J_OBTYP
|
|
| STSMA |
Status Profile |
CHAR |
8 |
0 |
TJ20
|
J_STSMA
|
|
| ERSTELLER |
Name of Person Responsible for Creating the Object |
CHAR |
12 |
0 |
|
ERNAM
|
|
| ERSTELDAT |
Date on which the record was created |
DATS |
8 |
0 |
|
ERDAT
|
|
| AENDERER |
Name of Person Who Changed Object |
CHAR |
12 |
0 |
|
AENAM
|
|
| AENDERDAT |
Last Changed On |
DATS |
8 |
0 |
|
AEDAT
|
|
| TDFORM |
SAPscript Form Name |
CHAR |
16 |
0 |
|
QCTDFORM
|
|
| KZGUTLOSE |
Only Inspection Lots Whose Usage Decision Is OK |
CHAR |
1 |
0 |
|
QKZGUTLOSE
|
|
| MINQKZ |
Minimum Quality Score for Good Quality |
DEC |
3 |
0 |
|
QKZMIN
|
|
| KZLASTLOT |
Indicator: Last Lot for Batch |
CHAR |
1 |
0 |
|
QKZLASTLOT
|
|
| KZLIEFSCH |
Delivery Note Is Contained in Inspection Lot |
CHAR |
1 |
0 |
|
QKZLIEFSCH
|
|
| HERKUNFT |
Inspection Lot Origin |
CHAR |
2 |
0 |
TQ31
|
QHERK
|
|
| ART |
Inspection Type |
CHAR |
8 |
0 |
TQ30
|
QPART
|
|
| KONSISTENT |
Indicator: Certificate Profile is Consistent |
CHAR |
1 |
0 |
|
QKZKONSIST
|
|
| KURZTEXT |
Short Text |
CHAR |
40 |
0 |
|
QKURZTEXT
|
|
| LTEXTKZ |
Long Text Exists |
CHAR |
1 |
0 |
|
QKZLTX
|
|
| WITHTRANSF |
Stock Transfers from Batch Where-Used List |
CHAR |
1 |
0 |
|
QCTRANSFER
|
| 1 |
Transfer Postings and Stock Transport Orders |
| X |
Transfer Postings |
|
| QDI_NOPDF |
Do Not Send PDF Document |
CHAR |
1 |
0 |
|
QC_QDI_NOPDF
|
|
| ALSTF |
Expansion Level of Batch Where-Used List |
NUMC |
2 |
0 |
|
QCALSTF
|
|
| ADBFORM |
PDF-Based Forms: Form Name |
CHAR |
30 |
0 |
|
QC_PDF_FORMNAME
|
|
| QKZ_USEADB |
Use PDF-Based Form |
CHAR |
1 |
0 |
|
QC_QKZ_USEADB
|
|
| CHAR_FIELD_CONF |
Configuration of Characteristics Field |
CHAR |
3 |
0 |
TQ68
|
QC_CHAR_FIELD_CONF
|
|
| CHANGEDDATETIME |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
DEC |
15 |
0 |
|
TZNTSTMPS
|
|
QCVK foreign key relationships
| Table |
Field |
Check Table |
|
Check Field |
| 0 QCVK |
ART |
TQ30 |
Inspection types |
MANDT |
| 0 QCVK |
ART |
TQ30 |
Inspection types |
ART |
| 1 QCVK |
CHAR_FIELD_CONF |
TQ68 |
Definition of Configuration of Characteristics Field |
MANDT |
| 0 QCVK |
HERKUNFT |
TQ31 |
Inspection Lot Origins |
HERKUNFT |
| 1 QCVK |
MANDANT |
T000 |
Clients |
MANDT |
| 0 QCVK |
OBJNR |
ONR00 |
General Object Number |
MANDT |
| 1 QCVK |
OBTYP |
TJ03 |
Object types |
OBTYP |
| 0 QCVK |
STSMA |
TJ20 |
Status profiles |
MANDT |
| 0 QCVK |
STSMA |
TJ20 |
Status profiles |
STSMA |