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