QPRVK

Transparent Table Application Table
16 Fields 2 CDS Views

Sample-drawing procedure

QPRVK is an SAP database table in S/4HANA. Sample-drawing procedure. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SmplDrwgProcedureVersion view from EXTENSION Sample-drwg. Proc. Vers. for Matl. Extn.
I_SmplDrwgProcedureVersion view from BASIC Sample-drawing Proc. Vers. for Material

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY prziehverf qprziehver Drawing Proc.
KEY version qversnprzv Version
gueltigab datuv Valid From
sortfeld qsortfeld Search Field
qmastauth qmastauth Auth. Group
gebanz qkzgebanz Containers
kzquit qkzquit Confirmation
ersteller qersteller Created By
aenderer qaenderer Changed By
datumerst qdatumerst Created On
zeiterst qzeiterstl Time
datumaend qdatumaend Changed On
zeitaend qzeitaend Time
kznvprzv qkznvwprv Blocking Ind.
kzvprzvpl qkzvprzvpl In task list

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.

-- Sample-drawing procedure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPRVK (
    MANDT,       -- Client [mandt]
    PRZIEHVERF,  -- Drawing Proc. [qprziehver]
    VERSION,     -- Version [qversnprzv]
    GUELTIGAB,   -- Valid From [datuv]
    SORTFELD,    -- Search Field [qsortfeld]
    QMASTAUTH,   -- Auth. Group [qmastauth]
    GEBANZ,      -- Containers [qkzgebanz]
    KZQUIT,      -- Confirmation [qkzquit]
    ERSTELLER,   -- Created By [qersteller]
    AENDERER,    -- Changed By [qaenderer]
    DATUMERST,   -- Created On [qdatumerst]
    ZEITERST,    -- Time [qzeiterstl]
    DATUMAEND,   -- Changed On [qdatumaend]
    ZEITAEND,    -- Time [qzeitaend]
    KZNVPRZV,    -- Blocking Ind. [qkznvwprv]
    KZVPRZVPL,   -- In task list [qkzvprzvpl]
    PRIMARY KEY (MANDT, PRZIEHVERF, VERSION)
);

Learn More