QMSM

Transparent Table Application Table
59 Fields 5 CDS Views

Quality notification - tasks

QMSM is an SAP database table in S/4HANA. Quality notification - tasks. It contains 59 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_NotificationTask view from EXTENSION Notification Task Extension
I_MaintenanceNotificationTask view from BASIC Maintenance Notification Task
I_NotificationTask view from BASIC Notification Task
I_QualityTask view from BASIC Quality Task
P_MfgNotifFollowUpActnHistory view from BASIC

Fields (59)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY qmnum qmnum Notification
KEY manum manum Task
mnkat makat Catalog type
mngrp magrp Code Group
mncod mncod Task Code
mnver qversnr Version
folgeact qmfolact Follow-Up Actn
folactprot qmfoaprot Follow-UpActLog
matxt matxt Task Text
ernam ernam Created By
erdat erdat Created On
aenam aenam Changed By
aedat aedat Changed On
pster pster Planned Start
peter peter Planned End
objnr qmobjnr Object number
indtx indltx Long text
kzmla kzmla Primary lang.
pstur pstur Planned Time
petur petur Planned Time
erlnam qmsmerlnam Completed By
erldat qmsmerldat Completed On
erlzeit qmsmerltim Completion Time
wdvdat qmsmwdvdat Resubmission
fenum felfd Item
urnum urnum Cause
erzeit erzeit Created At
aezeit aezeit Changed At
parvw qmsm_parvw Task Processor
parnr qmsm_parnr Responsible
mmenge qsmmng Quantity
mmgein qmgein Unit of Measure
bautl qmsm_bautl Affected Assy
kzloesch kzloesch Delete
qsmnum qsmnum Sort Number
autkz qautkz Object autom.
handle tsegguid Handle
tsegfl tsegexists TSegment exists
tsegtp tsegtempla Template
tzonso tzonso Notif.Time.Zone
tzonsm tzonsm Task Time Zone
tzonid tzonsmid Time zone orig.
timebasedeffort qtsktimebasedeffort Time Effort
timebasedeffortuom qtsktimebasedeffortuom Unit
kzactionbox qnkzactionbox From action box
funktion qnfunktion Function
abc_templ abc_templ Template
tasktype qtsktype Task Type
defectinternalid qdefectinternalid Internal Defect ID
prdcssrqtaskinternalid prdcssrqtaskinternalid Predecessor Task Internal ID
taskorigin qtaskorigin Task Origin
processor qtskproc Task Processor
changeddatetime tzntstmps Time Stamp
wdvzeit qmsmwdvtim Resubmission Time
probsolvingprocess qprobsolvingprocess Problem-Solving Process
probsolvingprocessstep qprobsolvingprocessstep Problem-Solving Step
prbobsolvproccause qprobsolvingprocesscause Cause
taskiscontrolledbyorigin qtaskcontrolledbyorigin Task Processing Is Controlled by Origin

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.

-- Quality notification - tasks
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QMSM (
    MANDT,                     -- Client [mandt]
    QMNUM,                     -- Notification [qmnum]
    MANUM,                     -- Task [manum]
    MNKAT,                     -- Catalog type [makat]
    MNGRP,                     -- Code Group [magrp]
    MNCOD,                     -- Task Code [mncod]
    MNVER,                     -- Version [qversnr]
    FOLGEACT,                  -- Follow-Up Actn [qmfolact]
    FOLACTPROT,                -- Follow-UpActLog [qmfoaprot]
    MATXT,                     -- Task Text [matxt]
    ERNAM,                     -- Created By [ernam]
    ERDAT,                     -- Created On [erdat]
    AENAM,                     -- Changed By [aenam]
    AEDAT,                     -- Changed On [aedat]
    PSTER,                     -- Planned Start [pster]
    PETER,                     -- Planned End [peter]
    OBJNR,                     -- Object number [qmobjnr]
    INDTX,                     -- Long text [indltx]
    KZMLA,                     -- Primary lang. [kzmla]
    PSTUR,                     -- Planned Time [pstur]
    PETUR,                     -- Planned Time [petur]
    ERLNAM,                    -- Completed By [qmsmerlnam]
    ERLDAT,                    -- Completed On [qmsmerldat]
    ERLZEIT,                   -- Completion Time [qmsmerltim]
    WDVDAT,                    -- Resubmission [qmsmwdvdat]
    FENUM,                     -- Item [felfd]
    URNUM,                     -- Cause [urnum]
    ERZEIT,                    -- Created At [erzeit]
    AEZEIT,                    -- Changed At [aezeit]
    PARVW,                     -- Task Processor [qmsm_parvw]
    PARNR,                     -- Responsible [qmsm_parnr]
    MMENGE,                    -- Quantity [qsmmng]
    MMGEIN,                    -- Unit of Measure [qmgein]
    BAUTL,                     -- Affected Assy [qmsm_bautl]
    KZLOESCH,                  -- Delete [kzloesch]
    QSMNUM,                    -- Sort Number [qsmnum]
    AUTKZ,                     -- Object autom. [qautkz]
    HANDLE,                    -- Handle [tsegguid]
    TSEGFL,                    -- TSegment exists [tsegexists]
    TSEGTP,                    -- Template [tsegtempla]
    TZONSO,                    -- Notif.Time.Zone [tzonso]
    TZONSM,                    -- Task Time Zone [tzonsm]
    TZONID,                    -- Time zone orig. [tzonsmid]
    TIMEBASEDEFFORT,           -- Time Effort [qtsktimebasedeffort]
    TIMEBASEDEFFORTUOM,        -- Unit [qtsktimebasedeffortuom]
    KZACTIONBOX,               -- From action box [qnkzactionbox]
    FUNKTION,                  -- Function [qnfunktion]
    ABC_TEMPL,                 -- Template [abc_templ]
    TASKTYPE,                  -- Task Type [qtsktype]
    DEFECTINTERNALID,          -- Internal Defect ID [qdefectinternalid]
    PRDCSSRQTASKINTERNALID,    -- Predecessor Task Internal ID [prdcssrqtaskinternalid]
    TASKORIGIN,                -- Task Origin [qtaskorigin]
    PROCESSOR,                 -- Task Processor [qtskproc]
    CHANGEDDATETIME,           -- Time Stamp [tzntstmps]
    WDVZEIT,                   -- Resubmission Time [qmsmwdvtim]
    PROBSOLVINGPROCESS,        -- Problem-Solving Process [qprobsolvingprocess]
    PROBSOLVINGPROCESSSTEP,    -- Problem-Solving Step [qprobsolvingprocessstep]
    PRBOBSOLVPROCCAUSE,        -- Cause [qprobsolvingprocesscause]
    TASKISCONTROLLEDBYORIGIN,  -- Task Processing Is Controlled by Origin [qtaskcontrolledbyorigin]
    PRIMARY KEY (MANDT, QMNUM, MANUM)
);

Learn More