QPRS

Transparent Table Application Table
39 Fields 2 CDS Views

Master Record for Material Samples

QPRS is an SAP database table in S/4HANA. Master Record for Material Samples. It contains 39 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MaterialSample view from EXTENSION Material Sample Extension
I_MaterialSample view from BASIC Material Sample

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY phynr qphysprnr Sample
objnr j_objnr Object number
stsma qstsma_prs Status Profile
prart qprart Sample Type
prtyp qprtyp Sample Category
pn_nr qpznr Drawing Number
xmanu qprb_man Manually
gbtyp qgebindet Sample Contr
menge qphysprum Sample Quantity
meinh qphysprme Sample UoM
plos2 qlot_late Inspection Lot
matnr matnr Material
werks werks_d Plant
revlv revlv Revision Level
charg charg_d Batch
ktext qtext_prs Short Text
qauth qmatauth QM Matl Auth.
pnver qprziehver Drawing Proc.
pnvev qversnprzv Version
pnpos qzaehlprzv Item
gebeh qgebeh Lot Container
tpbis qprobnrbis ToPartSampleNo
lgort lgort_d Location
abort qaufbewort Sample Location
abdau qaufbdauer Duration/Days
abdat qaufbdatum Store Until
abinf qaufbinfo Info Text
aenna qprs_aen Changed By
aendt qprs_aendt Date
aenzt qprs_aenzt Time
venum venum Internal HU no.
vepos vepos HU item
entort qprsentort Drawing Locatn
infeort qprsinfeort Drawing Locatn
entdatum qprsentdatum Date of Drawing
entzeit qprsentzeit Time of Drawing
bearbeiter qprsbearbeiter Sample Processor
labor qlabor Work Center

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.

-- Master Record for Material Samples
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPRS (
    MANDT,       -- Client [mandt]
    PHYNR,       -- Sample [qphysprnr]
    OBJNR,       -- Object number [j_objnr]
    STSMA,       -- Status Profile [qstsma_prs]
    PRART,       -- Sample Type [qprart]
    PRTYP,       -- Sample Category [qprtyp]
    PN_NR,       -- Drawing Number [qpznr]
    XMANU,       -- Manually [qprb_man]
    GBTYP,       -- Sample Contr [qgebindet]
    MENGE,       -- Sample Quantity [qphysprum]
    MEINH,       -- Sample UoM [qphysprme]
    PLOS2,       -- Inspection Lot [qlot_late]
    MATNR,       -- Material [matnr]
    WERKS,       -- Plant [werks_d]
    REVLV,       -- Revision Level [revlv]
    CHARG,       -- Batch [charg_d]
    KTEXT,       -- Short Text [qtext_prs]
    QAUTH,       -- QM Matl Auth. [qmatauth]
    PNVER,       -- Drawing Proc. [qprziehver]
    PNVEV,       -- Version [qversnprzv]
    PNPOS,       -- Item [qzaehlprzv]
    GEBEH,       -- Lot Container [qgebeh]
    TPBIS,       -- ToPartSampleNo [qprobnrbis]
    LGORT,       -- Location [lgort_d]
    ABORT,       -- Sample Location [qaufbewort]
    ABDAU,       -- Duration/Days [qaufbdauer]
    ABDAT,       -- Store Until [qaufbdatum]
    ABINF,       -- Info Text [qaufbinfo]
    AENNA,       -- Changed By [qprs_aen]
    AENDT,       -- Date [qprs_aendt]
    AENZT,       -- Time [qprs_aenzt]
    VENUM,       -- Internal HU no. [venum]
    VEPOS,       -- HU item [vepos]
    ENTORT,      -- Drawing Locatn [qprsentort]
    INFEORT,     -- Drawing Locatn [qprsinfeort]
    ENTDATUM,    -- Date of Drawing [qprsentdatum]
    ENTZEIT,     -- Time of Drawing [qprsentzeit]
    BEARBEITER,  -- Sample Processor [qprsbearbeiter]
    LABOR,       -- Work Center [qlabor]
    PRIMARY KEY (MANDT, PHYNR)
);

Learn More