TQ80

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.

-- Notification Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ80 (
    MANDT,             -- Client [mandt]
    QMART,             -- Notifictn Type [qmart]
    QMTYP,             -- Notif. Category [qmtyp]
    RBNR,              -- Catalog Profile [rbnr]
    HERKZ,             -- Notif. Origin [herkz]
    BEZZT,             -- Reference Time [bezzt]
    QMNUK,             -- Number range [qmnuk]
    AUART,             -- Order Type [aufart]
    HSCRTP,            -- Screen Type Hdr [hscrtp]
    OSCRTP,            -- ScrnType Object [oscrtp]
    PSCRTP,            -- ScrnTypePartner [pscrtp]
    PARGR,             -- PartnDet.Proc. [pargr]
    STSMA,             -- Status Profile [j_stsma]
    SMSTSMA,           -- Status Profile [j_stsma]
    ARTPR,             -- PriorityType [artpr]
    SDAUART,           -- Sales Doc. Type [auart]
    COAUART,           -- Order Type [aufart]
    PARVW_KUND,        -- Customer [parvw_kund]
    PARVW_AP,          -- Contact Person [parvw_ap]
    PARVW_INT,         -- Impl. Dept [parvw_int]
    PARVW_LIEF,        -- Supplier [parvw_lief]
    PARVW_HER,         -- Manufacturer [parvw_her]
    PARVW_VERA,        -- Person Respons. [parvw_vera]
    PARVW_AUTO,        -- Author Function [parvw_auto]
    PARVW_QMSM,        -- Task Processor [qmsm_parvw]
    KLAKT,             -- Class. Active [klakt]
    INFO_WIND,         -- Object info [i_infowind]
    SERWI,             -- Serv profile [i_serwi]
    ESCAL,             -- Response [i_escal]
    FEKAT,             -- Defect types [fekat]
    URKAT,             -- Catalog type [urkat]
    MAKAT,             -- Catalog type [makat]
    MFKAT,             -- Catalog type [mfkat]
    OTKAT,             -- Object Parts [otkat]
    SAKAT,             -- Catalog type [sakat]
    STAFO,             -- Update Group [stafo]
    QMWAERS,           -- Currency [qmwaers]
    QMWERT,            -- Avg.Nonconform. [qmwert]
    FBS_CREATE,        -- Function Module [qfbsqm01]
    FBS_DYNNR,         -- Initial Screen [qfbsdynnr]
    TDFORMAT,          -- Format key [qtdformat]
    KZEILE,            -- Line by line [kzeile]
    USERSCR1,          -- Cust. Scrn Area [qmusrscr]
    USERSCR2,          -- Cust. SA Item [qmusrscr1]
    USERSCR3,          -- Cust. SA Cause [qmusrscr2]
    USERSCR4,          -- Cust. SA Task [qmusrscr3]
    USERSCR5,          -- Cust. SA Acty [qmusrscr4]
    QMLTXT01,          -- Log line [qmltxt01]
    QMLTXT02,          -- No text change [qmltxt02]
    AUART2,            -- Order Type [aufart]
    EARLY_NUM,         -- Early No. Assg. [early_num]
    AUTOM_CONT,        -- AutoContractDet [autom_cont]
    MATKZ,             -- MaterialNotifs [qnmatkz]
    KUKZ,              -- Cust. notifs. [qnkukz]
    MATKUKZ,           -- Mat./custNotifs [qnmatkukz]
    LIKZ,              -- Supplier Notif. [qnlikz]
    MATLIKZ,           -- Notif. Mat/Supp [qnmatlikz]
    MATCHKZ,           -- Notif.Mat/Batch [qnmatchkz]
    MATCHKUKZ,         -- NotifMat/Bat/Cu [qnmatchkukz]
    MATCHLIKZ,         -- NotifMat/Ba/Sup [qnmatchlikz]
    FEGRPKZ,           -- NotifDefectType [qnfegrpkz]
    FECODKZ,           -- NotifDefectType [qnfecodkz]
    FOGRPKZ,           -- Notif.Def.Loc. [qnfogrpkz]
    FOCODKZ,           -- Notif.Def.Loc. [qnfocodkz]
    MOD,               -- Display Mode [qnmod]
    ICON1,             -- Icon 1 [qnicon1]
    ICON2,             -- Icon 2 [qnicon2]
    VERS,              -- Variant [qnvers]
    ZEITRAUM,          -- Number of Days [qnzeit]
    TDOBJECT,          -- Text object [tdobject]
    TDNAME,            -- Text Name [tdobname]
    TDID,              -- Text ID [tdid]
    CMCHECK_SM,        -- Credit limit check [cmcheck_sm]
    CMGRA,             -- Credit group order [cmgra]
    PARVW_PAGE,        -- Funct. Paging [parvw_page]
    CUA_FBS,           -- FMod - CUA [q_cua_fbs]
    ROLE_VERA,         -- Notif.Processor [qstrole]
    PERMIT,            -- Approval [qpermit]
    PARVW_GEH,         -- Approved by [parvw_geh]
    ROLE_GEH,          -- Approver [qstrole2]
    ROLE_QMSM,         -- Task Processor [qstrole3]
    PROCESS,           -- Process [qmprocess]
    REQMAINTAPP_USE,   -- Request Maint. App [eam_ntf_create_type_active]
    PMACTIONREQUIRED,  -- Action Req [pmactionreq]
    FAILURE_EFFECT,    -- Failure Effect Catlg [failure_effect_catalog]
    PRIMARY KEY (MANDT, QMART)
);