QPMK

Transparent Table Application Table
71 Fields 3 CDS Views

Inspection characteristic master

QPMK is an SAP database table in S/4HANA. Inspection characteristic master. It contains 71 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_InspSpecificationVersion view from EXTENSION Inspection Specification Version Ext.
I_InspSpecificationVersion view from BASIC Version of Master Insp Characteristic
P_InspSpecQuantityCtrl view from BASIC

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY zaehler QZAEHLER Plant
KEY mkmnr QMERKNR Master IC
KEY version QVERSNRMK Version
werks WERKS_D Plant
gueltigab DATUV Valid From
sortfeld QSORTFELD Search Field
charact_id1 QCHARACT_ID1 Charact. ID
loekz QLOESCHKZ Status
lsper QVERW Record Used
konsistent QVOLLST Copy model/ref.
autor QERSTELLER Created By
dates QDATUMERST Created On
aeaut QAENDERER Changed By
datae QDATUMAEND Changed On
changeddatetime TZNTSTMPS Time Stamp
steuerkz QMKCONTROL CharCntrl ind.
merkgew QMERKGEW Weighting
prfql QPRQUALIF Inspctr qualif.
dummy10 QTXT10 Info Field 1
dummy20 QTXT20 Info Field 2
dummy40 QTXT40 Info Field 3
qauth QMASTAUTH Auth. Group
toleranzsl QTOLERANZ Tolerance Key
stellen QSTELLEN Decimal Places
masseinhsw QMASSEH Unit of Meas.
sollwert QSOLLWERTE Target Value
sollwni QNINITIAL Not Initial
toleranzob QTOLOB Upper Limit
tolobni QNINITIAL Not Initial
toleranzun QTOLUN Lower Limit
tolunni QNINITIAL Not Initial
klasanzahl QKLASSZAHL No. of Classes
klasbreite QKLASSBR Class Width
klasbrni QNINITIAL Not Initial
klasmitte QKLASSMIT Class Midpoint
klasmini QNINITIAL Not Initial
grenzeob1 QGRENZOB1 1st Upper Limit
grenzob1ni QNINITIAL Not Initial
grenzeun1 QGRENZUN1 1st Lower Limit
grenzun1ni QNINITIAL Not Initial
grenzeob2 QGRENZOB2 2nd Upper Limit
grenzob2ni QNINITIAL Not Initial
grenzeun2 QGRENZUN2 2nd Lower Limit
grenzun2ni QNINITIAL Not Initial
plausioben QPLAUSIOB UpPlaus. Limit
plausiobni QNINITIAL Not Initial
plausiunte QPLAUSIUN LoPlaus. Limit
plausiunni QNINITIAL Not Initial
tolerweiob QTOLWOB UpperSpecLmtChg
tolwobni QNINITIAL Not Initial
tolerweiun QTOLWUN LowerSpecLmtChg
tolwunni QNINITIAL Not Initial
tolerwab QTOLWAB TolChg Val From
tolerwbis QTOLWBIS Change Valid To
codegr9u QCODEGRPU LoLim defect
code9u QCODEU DefCodeLowSpecL
codevr9u QVERSNR Version
codegr9o QCODEGRPO UpLim defect
code9o QCODEO DefCodeUpperSpL
codevr9o QVERSNR Version
atinn ATINN Internal char.
eeantverf QEANTVERF Fraction Calc.
codegrqual QCODEGRPQL DefCodeGrp Rej.
codequal QCODEQL Defect Code: Gen
inpproc QINPPROC Input Processng
spec_det_rule QASDR_SPEC_DET_RULE Spec. Det. Rule
spec_det_active QASDR_SDR_ACTIVE Active
parameter1 QASDR_SDR_PARAMETER Parameters
parameter2 QASDR_SDR_PARAMETER Parameters
dummy_qpmk_incl_eew_ps DUMMY Dummy function in length 1

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 characteristic master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPMK (
    MANDT,                   -- Client [MANDT]
    ZAEHLER,                 -- Plant [QZAEHLER]
    MKMNR,                   -- Master IC [QMERKNR]
    VERSION,                 -- Version [QVERSNRMK]
    WERKS,                   -- Plant [WERKS_D]
    GUELTIGAB,               -- Valid From [DATUV]
    SORTFELD,                -- Search Field [QSORTFELD]
    CHARACT_ID1,             -- Charact. ID [QCHARACT_ID1]
    LOEKZ,                   -- Status [QLOESCHKZ]
    LSPER,                   -- Record Used [QVERW]
    KONSISTENT,              -- Copy model/ref. [QVOLLST]
    AUTOR,                   -- Created By [QERSTELLER]
    DATES,                   -- Created On [QDATUMERST]
    AEAUT,                   -- Changed By [QAENDERER]
    DATAE,                   -- Changed On [QDATUMAEND]
    CHANGEDDATETIME,         -- Time Stamp [TZNTSTMPS]
    STEUERKZ,                -- CharCntrl ind. [QMKCONTROL]
    MERKGEW,                 -- Weighting [QMERKGEW]
    PRFQL,                   -- Inspctr qualif. [QPRQUALIF]
    DUMMY10,                 -- Info Field 1 [QTXT10]
    DUMMY20,                 -- Info Field 2 [QTXT20]
    DUMMY40,                 -- Info Field 3 [QTXT40]
    QAUTH,                   -- Auth. Group [QMASTAUTH]
    TOLERANZSL,              -- Tolerance Key [QTOLERANZ]
    STELLEN,                 -- Decimal Places [QSTELLEN]
    MASSEINHSW,              -- Unit of Meas. [QMASSEH]
    SOLLWERT,                -- Target Value [QSOLLWERTE]
    SOLLWNI,                 -- Not Initial [QNINITIAL]
    TOLERANZOB,              -- Upper Limit [QTOLOB]
    TOLOBNI,                 -- Not Initial [QNINITIAL]
    TOLERANZUN,              -- Lower Limit [QTOLUN]
    TOLUNNI,                 -- Not Initial [QNINITIAL]
    KLASANZAHL,              -- No. of Classes [QKLASSZAHL]
    KLASBREITE,              -- Class Width [QKLASSBR]
    KLASBRNI,                -- Not Initial [QNINITIAL]
    KLASMITTE,               -- Class Midpoint [QKLASSMIT]
    KLASMINI,                -- Not Initial [QNINITIAL]
    GRENZEOB1,               -- 1st Upper Limit [QGRENZOB1]
    GRENZOB1NI,              -- Not Initial [QNINITIAL]
    GRENZEUN1,               -- 1st Lower Limit [QGRENZUN1]
    GRENZUN1NI,              -- Not Initial [QNINITIAL]
    GRENZEOB2,               -- 2nd Upper Limit [QGRENZOB2]
    GRENZOB2NI,              -- Not Initial [QNINITIAL]
    GRENZEUN2,               -- 2nd Lower Limit [QGRENZUN2]
    GRENZUN2NI,              -- Not Initial [QNINITIAL]
    PLAUSIOBEN,              -- UpPlaus. Limit [QPLAUSIOB]
    PLAUSIOBNI,              -- Not Initial [QNINITIAL]
    PLAUSIUNTE,              -- LoPlaus. Limit [QPLAUSIUN]
    PLAUSIUNNI,              -- Not Initial [QNINITIAL]
    TOLERWEIOB,              -- UpperSpecLmtChg [QTOLWOB]
    TOLWOBNI,                -- Not Initial [QNINITIAL]
    TOLERWEIUN,              -- LowerSpecLmtChg [QTOLWUN]
    TOLWUNNI,                -- Not Initial [QNINITIAL]
    TOLERWAB,                -- TolChg Val From [QTOLWAB]
    TOLERWBIS,               -- Change Valid To [QTOLWBIS]
    CODEGR9U,                -- LoLim defect [QCODEGRPU]
    CODE9U,                  -- DefCodeLowSpecL [QCODEU]
    CODEVR9U,                -- Version [QVERSNR]
    CODEGR9O,                -- UpLim defect [QCODEGRPO]
    CODE9O,                  -- DefCodeUpperSpL [QCODEO]
    CODEVR9O,                -- Version [QVERSNR]
    ATINN,                   -- Internal char. [ATINN]
    EEANTVERF,               -- Fraction Calc. [QEANTVERF]
    CODEGRQUAL,              -- DefCodeGrp Rej. [QCODEGRPQL]
    CODEQUAL,                -- Defect Code: Gen [QCODEQL]
    INPPROC,                 -- Input Processng [QINPPROC]
    SPEC_DET_RULE,           -- Spec. Det. Rule [QASDR_SPEC_DET_RULE]
    SPEC_DET_ACTIVE,         -- Active [QASDR_SDR_ACTIVE]
    PARAMETER1,              -- Parameters [QASDR_SDR_PARAMETER]
    PARAMETER2,              -- Parameters [QASDR_SDR_PARAMETER]
    DUMMY_QPMK_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, ZAEHLER, MKMNR, VERSION)
);

Learn More