QPRN

Transparent Table Application Table
28 Fields 2 CDS Views

Sample Drawing of Material Samples

QPRN is an SAP database table in S/4HANA. Sample Drawing of Material Samples. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MaterialSampleDrawing view from EXTENSION Material Sample Drawing Extension
I_MaterialSampleDrawing view from BASIC Material Sample Drawing

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pn_nr QPZNR Drawing Number
plos QLOT_LATE Inspection Lot
matnr MATNR Material
werks WERKS_D Plant
revlv REVLV Revision Level
charg CHARG_D Batch
cvp_xblck CVP_XBLCK Purpose Completed
kunnr QKUNWE Customer
lifnr ELIFN Supplier
hrstl QLIFNR Manufacturer
mblnr MBLNR Material Doc.
zeile MBLPO Mat. Doc.Item
mjahr MJAHR Mat. Doc. Year
aufnr AUFNR Order
verid VERID Prod. Version
sa_aufnr SA_AUFNR RS header
anlna QPRS_ANL Created By
anldt QPRS_ANLDT Date
anlzt QPRS_ANLZT Time
qmatauth QMATAUTH QM Matl Auth.
kzquit QKZQUIT Confirmation
sig_il_sdr SIG_IL_SDR DigSig SmplDraw
frgna QPRS_FRG Released By
frgdt QPRS_FRGDT Date
frgzt QPRS_FRGZT Time
pztxt QPZ_TEXT Comments
qmnum QMNUM Notification

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 of Material Samples
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPRN (
    MANDT,       -- Client [MANDT]
    PN_NR,       -- Drawing Number [QPZNR]
    PLOS,        -- Inspection Lot [QLOT_LATE]
    MATNR,       -- Material [MATNR]
    WERKS,       -- Plant [WERKS_D]
    REVLV,       -- Revision Level [REVLV]
    CHARG,       -- Batch [CHARG_D]
    CVP_XBLCK,   -- Purpose Completed [CVP_XBLCK]
    KUNNR,       -- Customer [QKUNWE]
    LIFNR,       -- Supplier [ELIFN]
    HRSTL,       -- Manufacturer [QLIFNR]
    MBLNR,       -- Material Doc. [MBLNR]
    ZEILE,       -- Mat. Doc.Item [MBLPO]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    AUFNR,       -- Order [AUFNR]
    VERID,       -- Prod. Version [VERID]
    SA_AUFNR,    -- RS header [SA_AUFNR]
    ANLNA,       -- Created By [QPRS_ANL]
    ANLDT,       -- Date [QPRS_ANLDT]
    ANLZT,       -- Time [QPRS_ANLZT]
    QMATAUTH,    -- QM Matl Auth. [QMATAUTH]
    KZQUIT,      -- Confirmation [QKZQUIT]
    SIG_IL_SDR,  -- DigSig SmplDraw [SIG_IL_SDR]
    FRGNA,       -- Released By [QPRS_FRG]
    FRGDT,       -- Date [QPRS_FRGDT]
    FRGZT,       -- Time [QPRS_FRGZT]
    PZTXT,       -- Comments [QPZ_TEXT]
    QMNUM,       -- Notification [QMNUM]
    PRIMARY KEY (MANDT, PN_NR)
);

Learn More