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 Quality Inspection Flag
PPH_MRP_Pruefbest view from Quality Inspection Flag

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