TPMUS

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.

-- PM/SM - User default values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TPMUS (
    MANDT,                          -- Client [mandt]
    UNAME,                          -- User Name [syuname]
    IWERK,                          -- Planning Plant [iwerk]
    AUART,                          -- Order Type [aufart]
    INGRP,                          -- Planner Group [ingrp]
    QMART,                          -- Notifictn Type [qmart]
    OKSTAR,                         -- Cost Element [kstar]
    OEKORG,                         -- Purchasing Org. [ekorg]
    OEKGRP,                         -- Purch. Group [ekgrp]
    OMATKL,                         -- Material Group [matkl]
    OWEMPF,                         -- Recipient [wempf]
    OABLAD,                         -- Unloading Point [ablad]
    OMGVRG,                         -- Operation Qty [mgvrg]
    OMEINH,                         -- Act/op UoM [vorme]
    MKSTAR,                         -- Cost Element [kstar]
    MEKORG,                         -- Purchasing Org. [ekorg]
    MEKGRP,                         -- Purch. Group [ekgrp]
    MMATKL,                         -- Material Group [matkl]
    MWEMPF,                         -- Recipient [wempf]
    MABLAD,                         -- Unloading Point [ablad]
    PM_OBJTY,                       -- Object Type [pm_objty]
    GEWRK,                          -- Work Center [lgwid]
    GSBER,                          -- Business Area [gsber]
    TPLNR,                          -- Functional loc. [tplnr]
    EQUNR,                          -- Equipment [equnr]
    BAUTL,                          -- Assembly [bautl]
    SERIALNR,                       -- Serial Number [gernr]
    MATNR,                          -- Material [matnr]
    PRCTR,                          -- Profit Center [prctr]
    SCREENTY,                       -- Scenario [scrtp]
    BUIA,                           -- Set in process [buia]
    BUIP,                           -- Suppress dialog [buip]
    ABRV,                           -- SETR Default [abrv]
    PRWIN,                          -- Disp. PrtDlgBox [prwin]
    VKBUR,                          -- Sales Office [vkbur]
    VKGRP,                          -- Sales Group [vkgrp]
    SPART,                          -- Division [spart]
    VKORG,                          -- Sales Org. [vkorg]
    VTWEG,                          -- Distr. Channel [vtweg]
    QQMART,                         -- Notifictn Type [qmart]
    QSCREENTY,                      -- Scenario [scrtp]
    QMATNR,                         -- Material [matnr]
    QSERIALNR,                      -- Serial Number [gernr]
    QMAWERK,                        -- Plant for Mat. [qmawerks]
    QQKUNUM,                        -- Customer [qkunum]
    QLIFNUM,                        -- Supplier [lifnum]
    QQLIFNR,                        -- Manufacturer [qlifnr]
    QEKORG,                         -- Purchasing Org. [ekorg]
    QBKGRP,                         -- Purch. Group [bkgrp]
    QARBPL,                         -- Work Center [lgwid]
    INDSTATUSB,                     -- Status bar [indstatusb]
    INDTOOLB,                       -- Toolbar [indtoolb]
    ABDU,                           -- No dial.compltn [abdu]
    LTHE_ON,                        -- Long text on [lthe_on]
    ADDT_ON,                        -- Dates on [addt_on]
    PMAD_ON,                        -- Address shown [pmad_on]
    PROFIL,                         -- Profile [cmfu_profil]
    ACTIONBOX,                      -- Action Box: Table [qnqmactionbox]
    QGMART,                         -- Notifictn Type [qmart]
    QCMART,                         -- Notifictn Type [qmart]
    AUSWIRK,                        -- Scenario [qscenario]
    PSP_NR,                         -- WBS Element [ps_posnr]
    OPPONENT,                       -- Partner Type [ps_opponent]
    TL_DEFAULT,                     -- Standard [tl_sel_default]
    PRTWOSAVE,                      -- Print w/o Save [qnprintwosave]
    EAMS_DLFL,                      -- Deletion Flag [eams_notif_change_dlfl]
    EAMS_RESET_DLFL,                -- Reset Deletion Flag [eams_notif_change_dlfl_reset]
    EAMS_TECO,                      -- Complete (Tech.) [eams_notif_change_teco]
    EAMS_RESET_TECO,                -- Cancel Tech. Compl. [eams_notif_change_teco_reset]
    EAMS_CLOSE,                     -- Complete (Business) [eams_notif_change_close]
    EAMS_DO_NOT_EXEC,               -- Do Not Execute [eams_notif_change_do_not_exec]
    EAMS_TECO_CONF,                 -- Conf.: Tech. Compl. [eams_notif_change_teco_conf]
    EAMS_NO_SF_REL,                 -- Hide SF Relationship [eams_no_sf_rel]
    EAMS_AUART_UC,                  -- Order type [pm_aufart]
    EAM_DEFAULT_STORAGE_LOCATION,   -- Storage Location [eam_upref_storage_location]
    RWEMPF,                         -- Recipient [wempf]
    RABLAD,                         -- Unloading Point [ablad]
    REAM_DEFAULT_STORAGE_LOCATION,  -- Storage Location [eam_upref_storage_location]
    RQMAWERK,                       -- Plant for Mat. [qmawerks]
    PRIMARY KEY (MANDT, UNAME)
);