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 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||
MINQKZ | Minimum Quality Score for Good Quality | QKZMIN | DEC | 3 | 0 | |||||||
KZLASTLOT | Indicator: Last Lot for Batch | QKZLASTLOT | CHAR | 1 | 0 |
Possible values
|
||||||
KZLIEFSCH | Indicator: Delivery Note in Inspection Lot | QKZLIEFSCH | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
KURZTEXT | Short Text | QKURZTEXT | CHAR | 40 | 0 | |||||||
LTEXTKZ | Long Text Exists | QKZLTX | CHAR | 1 | 0 |
Possible values
|
||||||
WITHTRANSF | Stock Transfers from Batch Where-Used List | QCTRANSFER | CHAR | 1 | 0 |
Possible values
|
||||||
QDI_NOPDF | Indicator: Do Not Send PDF Document | QC_QDI_NOPDF | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
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 |