QCVK

Transparent Table Application Table
30 Fields 1 CDS Views

Certificate profile header

QCVK is an SAP database table in S/4HANA. Certificate profile header. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyCertificateProfile view from BASIC Quality Certificate Profile

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandant MANDT Client
KEY ctyp QZGTYP CertificateType
KEY vorlnr QVORLNR Cert. Profile
KEY version QCVERSION Version No.
sortfeld QSORTFELD Search Field
gueltigab Q_UNUSEDDT Empty
objnr J_OBJNR Object number
obtyp J_OBTYP Object Type
stsma J_STSMA Status Profile
ersteller ERNAM Created By
ersteldat ERDAT Created On
aenderer AENAM Changed By
aenderdat AEDAT Changed On
tdform QCTDFORM SAPscript Form
kzgutlose QKZGUTLOSE AccptdLots Only
minqkz QKZMIN Min. Q-Score
kzlastlot QKZLASTLOT Last lot
kzliefsch QKZLIEFSCH DlvryNoteInLot
herkunft QHERK Insp. Lot Orig.
art QPART Inspection Type
konsistent QKZKONSIST Consistent
kurztext QKURZTEXT Short Text
ltextkz QKZLTX Long text
withtransf QCTRANSFER Stock Transfers
qdi_nopdf QC_QDI_NOPDF No PDF
alstf QCALSTF Explosion Level
adbform QC_PDF_FORMNAME PDF-Based Form
qkz_useadb QC_QKZ_USEADB PDF-Based Form
char_field_conf QC_CHAR_FIELD_CONF CharacFldConfig
changeddatetime TZNTSTMPS Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Certificate profile header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCVK (
    MANDANT,          -- Client [MANDT]
    CTYP,             -- CertificateType [QZGTYP]
    VORLNR,           -- Cert. Profile [QVORLNR]
    VERSION,          -- Version No. [QCVERSION]
    SORTFELD,         -- Search Field [QSORTFELD]
    GUELTIGAB,        -- Empty [Q_UNUSEDDT]
    OBJNR,            -- Object number [J_OBJNR]
    OBTYP,            -- Object Type [J_OBTYP]
    STSMA,            -- Status Profile [J_STSMA]
    ERSTELLER,        -- Created By [ERNAM]
    ERSTELDAT,        -- Created On [ERDAT]
    AENDERER,         -- Changed By [AENAM]
    AENDERDAT,        -- Changed On [AEDAT]
    TDFORM,           -- SAPscript Form [QCTDFORM]
    KZGUTLOSE,        -- AccptdLots Only [QKZGUTLOSE]
    MINQKZ,           -- Min. Q-Score [QKZMIN]
    KZLASTLOT,        -- Last lot [QKZLASTLOT]
    KZLIEFSCH,        -- DlvryNoteInLot [QKZLIEFSCH]
    HERKUNFT,         -- Insp. Lot Orig. [QHERK]
    ART,              -- Inspection Type [QPART]
    KONSISTENT,       -- Consistent [QKZKONSIST]
    KURZTEXT,         -- Short Text [QKURZTEXT]
    LTEXTKZ,          -- Long text [QKZLTX]
    WITHTRANSF,       -- Stock Transfers [QCTRANSFER]
    QDI_NOPDF,        -- No PDF [QC_QDI_NOPDF]
    ALSTF,            -- Explosion Level [QCALSTF]
    ADBFORM,          -- PDF-Based Form [QC_PDF_FORMNAME]
    QKZ_USEADB,       -- PDF-Based Form [QC_QKZ_USEADB]
    CHAR_FIELD_CONF,  -- CharacFldConfig [QC_CHAR_FIELD_CONF]
    CHANGEDDATETIME,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDANT, CTYP, VORLNR, VERSION)
);

Learn More