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]
    MAINTNOTIFTYPEHASACTVPHSEMODEL,  -- eam_ntf_phase_model_active
    PRIMARY KEY (MANDT, QMART)
);