QPMZ

Transparent Table Application Table
36 Fields 3 CDS Views

Assignment table - insp. methods/master insp. characteristic

QPMZ is an SAP database table in S/4HANA. Assignment table - insp. methods/master insp. characteristic. It contains 36 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_AssgmtInspMethInspSpec view from EXTENSION Assgnmt. - Insp. Meth./Insp. Spec. Extn.
I_AssgmtInspMethInspSpec view from BASIC Assgnmt. - Insp. Meth./Insp. Spec.
P_Qm_Mic_Method_Catalog view from BASIC

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY zaehler qzaehler Plant
KEY mkmnr qmerknr Master IC
KEY version qversnrmk Version
KEY werkpm qwerkpmet Plant
KEY pmethode qpmethode Insp. Method
KEY verspm qversnrpm Version
werkmk werks_d Plant
gueltigab datuv Valid From
anonr qpos Item
katab1 qkttab Selected Set
katalgart1 qkatausw Catalog Type
auswmenge1 qcgrausw CodeGrp/SelSet
version1 qversnr Version
auswmgwrk1 qwerkausw Plant
katab2 qkttab Selected Set
katalgart2 qkatausw Catalog Type
auswmenge2 qcgrausw CodeGrp/SelSet
version2 qversnr Version
auswmgwrk2 qwerkausw Plant
katab3 qkttab Selected Set
katalgart3 qkatausw Catalog Type
auswmenge3 qcgrausw CodeGrp/SelSet
version3 qversnr Version
auswmgwrk3 qwerkausw Plant
katab4 qkttab Selected Set
katalgart4 qkatausw Catalog Type
auswmenge4 qcgrausw CodeGrp/SelSet
version4 qversnr Version
auswmgwrk4 qwerkausw Plant
katab5 qkttab Selected Set
katalgart5 qkatausw Catalog Type
auswmenge5 qcgrausw CodeGrp/SelSet
version5 qversnr Version
auswmgwrk5 qwerkausw Plant
geloescht qgel Deleted record

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.

-- Assignment table - insp. methods/master insp. characteristic
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPMZ (
    MANDT,       -- Client [mandt]
    ZAEHLER,     -- Plant [qzaehler]
    MKMNR,       -- Master IC [qmerknr]
    VERSION,     -- Version [qversnrmk]
    WERKPM,      -- Plant [qwerkpmet]
    PMETHODE,    -- Insp. Method [qpmethode]
    VERSPM,      -- Version [qversnrpm]
    WERKMK,      -- Plant [werks_d]
    GUELTIGAB,   -- Valid From [datuv]
    ANONR,       -- Item [qpos]
    KATAB1,      -- Selected Set [qkttab]
    KATALGART1,  -- Catalog Type [qkatausw]
    AUSWMENGE1,  -- CodeGrp/SelSet [qcgrausw]
    VERSION1,    -- Version [qversnr]
    AUSWMGWRK1,  -- Plant [qwerkausw]
    KATAB2,      -- Selected Set [qkttab]
    KATALGART2,  -- Catalog Type [qkatausw]
    AUSWMENGE2,  -- CodeGrp/SelSet [qcgrausw]
    VERSION2,    -- Version [qversnr]
    AUSWMGWRK2,  -- Plant [qwerkausw]
    KATAB3,      -- Selected Set [qkttab]
    KATALGART3,  -- Catalog Type [qkatausw]
    AUSWMENGE3,  -- CodeGrp/SelSet [qcgrausw]
    VERSION3,    -- Version [qversnr]
    AUSWMGWRK3,  -- Plant [qwerkausw]
    KATAB4,      -- Selected Set [qkttab]
    KATALGART4,  -- Catalog Type [qkatausw]
    AUSWMENGE4,  -- CodeGrp/SelSet [qcgrausw]
    VERSION4,    -- Version [qversnr]
    AUSWMGWRK4,  -- Plant [qwerkausw]
    KATAB5,      -- Selected Set [qkttab]
    KATALGART5,  -- Catalog Type [qkatausw]
    AUSWMENGE5,  -- CodeGrp/SelSet [qcgrausw]
    VERSION5,    -- Version [qversnr]
    AUSWMGWRK5,  -- Plant [qwerkausw]
    GELOESCHT,   -- Deleted record [qgel]
    PRIMARY KEY (MANDT, ZAEHLER, MKMNR, VERSION, WERKPM, PMETHODE, VERSPM)
);

Learn More