QMAT

Transparent Table Application Table
35 Fields 3 CDS Views

Inspection type - material parameters

QMAT is an SAP database table in S/4HANA. Inspection type - material parameters. It contains 35 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProductInspTypeSetting view from BASIC Settings for Inspection Type in Product
PPH_DDL_PRUEFBEST view from
PPH_MRP_Pruefbest view from

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY art QPART Inspection Type
KEY matnr MATNR Material
KEY werks WERKS_D Plant
ppl QPPL Insp with TList
spezueber QSPEZUEBER Insp. with spec.
conf QCONF Configuration
tls QCHARG Batch determtn
app QAPP_D Auto.assignment
mer QMERK Inspect Charcs
insmk QINSMK Post to insp. stk
ave QAUTO_VE Auto UD
stichprver QSTPRVER Smpl. Procedure
dynregel QDYNREGEL Dyn. Mod. Rule
sproz QSPROZ Inspection %
hpz QHPZ 100% Inspection
dyn QDYN Skips Allowed
mpb QMPB Manual Sample
mst QMST Manl Samp. Calc
ein QEINZ Serial Numbers
mpdau QMPDAU Avg. insp. dur.
chg Q1WELOS Lot Creation
qkzverf QKZVERF Q-Score Proc.
qpmat QAUSSCHUSS Allowed Scrap %
kzprfkost QKZPRFKOST Indiv. QM Order
aufnr_co QAUFNR_CO QM Order
aktiv QMATAKTIV InspType-Matl
apa QAPA PreferredInsTyp
afr QAFR Insp. for HU
mma Q_UNUSED01 Dummy
feh Q_UNUSED01 Dummy
prfrq QPRFRQ Dummy
nkmpr QNKMPR dummy
ms_flag Q_MS_FLG Multiple Specs
chg_orig_17 QLOT_CONTROL_ORIGIN_17 Insp. Lot Summary

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.

-- Inspection type - material parameters
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QMAT (
    MANDT,        -- Client [MANDT]
    ART,          -- Inspection Type [QPART]
    MATNR,        -- Material [MATNR]
    WERKS,        -- Plant [WERKS_D]
    PPL,          -- Insp with TList [QPPL]
    SPEZUEBER,    -- Insp. with spec. [QSPEZUEBER]
    CONF,         -- Configuration [QCONF]
    TLS,          -- Batch determtn [QCHARG]
    APP,          -- Auto.assignment [QAPP_D]
    MER,          -- Inspect Charcs [QMERK]
    INSMK,        -- Post to insp. stk [QINSMK]
    AVE,          -- Auto UD [QAUTO_VE]
    STICHPRVER,   -- Smpl. Procedure [QSTPRVER]
    DYNREGEL,     -- Dyn. Mod. Rule [QDYNREGEL]
    SPROZ,        -- Inspection % [QSPROZ]
    HPZ,          -- 100% Inspection [QHPZ]
    DYN,          -- Skips Allowed [QDYN]
    MPB,          -- Manual Sample [QMPB]
    MST,          -- Manl Samp. Calc [QMST]
    EIN,          -- Serial Numbers [QEINZ]
    MPDAU,        -- Avg. insp. dur. [QMPDAU]
    CHG,          -- Lot Creation [Q1WELOS]
    QKZVERF,      -- Q-Score Proc. [QKZVERF]
    QPMAT,        -- Allowed Scrap % [QAUSSCHUSS]
    KZPRFKOST,    -- Indiv. QM Order [QKZPRFKOST]
    AUFNR_CO,     -- QM Order [QAUFNR_CO]
    AKTIV,        -- InspType-Matl [QMATAKTIV]
    APA,          -- PreferredInsTyp [QAPA]
    AFR,          -- Insp. for HU [QAFR]
    MMA,          -- Dummy [Q_UNUSED01]
    FEH,          -- Dummy [Q_UNUSED01]
    PRFRQ,        -- Dummy [QPRFRQ]
    NKMPR,        -- dummy [QNKMPR]
    MS_FLAG,      -- Multiple Specs [Q_MS_FLG]
    CHG_ORIG_17,  -- Insp. Lot Summary [QLOT_CONTROL_ORIGIN_17]
    PRIMARY KEY (MANDT, ART, MATNR, WERKS)
);

Learn More