QCVV

Transparent Table Application Table
13 Fields 1 CDS Views

Certificate Profile: List of Preliminary Products

QCVV is an SAP database table in S/4HANA. Certificate Profile: List of Preliminary Products. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QltyCertPrflMaterial view from BASIC Quality Certificate Profile Material

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandant mandt Client
KEY ctyp qzgtyp CertificateType
KEY vorlnr qvorlnr Cert. Profile
KEY version qcversion Version No.
KEY vmkateg qcvmatkat Data origin cat
KEY matnr matnr Material
KEY counter qcvvcount Sequential Number for Material in a Certificate Profile
blocknr qblocknr Char.block no.
vmsortnr qcsortnr Sort no. mat.
herkunft qherk Insp. Lot Orig.
art qpart Inspection Type
kzgutlose qkzgutlose AccptdLots Only
minqkz qkzmin Min. Q-Score

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: List of Preliminary Products
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QCVV (
    MANDANT,    -- Client [mandt]
    CTYP,       -- CertificateType [qzgtyp]
    VORLNR,     -- Cert. Profile [qvorlnr]
    VERSION,    -- Version No. [qcversion]
    VMKATEG,    -- Data origin cat [qcvmatkat]
    MATNR,      -- Material [matnr]
    COUNTER,    -- Sequential Number for Material in a Certificate Profile [qcvvcount]
    BLOCKNR,    -- Char.block no. [qblocknr]
    VMSORTNR,   -- Sort no. mat. [qcsortnr]
    HERKUNFT,   -- Insp. Lot Orig. [qherk]
    ART,        -- Inspection Type [qpart]
    KZGUTLOSE,  -- AccptdLots Only [qkzgutlose]
    MINQKZ,     -- Min. Q-Score [qkzmin]
    PRIMARY KEY (MANDANT, CTYP, VORLNR, VERSION, VMKATEG, MATNR, COUNTER)
);

Learn More