TPMUS

Transparent Table Application Table
113 Fields 1 CDS Views

PM/SM - User default values

TPMUS is an SAP database table in S/4HANA. PM/SM - User default values. It contains 113 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EAMUserDefaultValues view from BASIC User Default Values

Fields (113)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uname SYUNAME User Name
iwerk IWERK Planning Plant
auart AUFART Order Type
ingrp INGRP Planner Group
qmart QMART Notifictn Type
okstar KSTAR Cost Element
oekorg EKORG Purchasing Org.
oekgrp EKGRP Purch. Group
omatkl MATKL Material Group
owempf WEMPF Recipient
oablad ABLAD Unloading Point
omgvrg MGVRG Operation Qty
omeinh VORME Act/op UoM
mkstar KSTAR Cost Element
mekorg EKORG Purchasing Org.
mekgrp EKGRP Purch. Group
mmatkl MATKL Material Group
mwempf WEMPF Recipient
mablad ABLAD Unloading Point
pm_objty PM_OBJTY Object Type
gewrk LGWID Work Center
gsber GSBER Business Area
tplnr TPLNR Functional loc.
equnr EQUNR Equipment
bautl BAUTL Assembly
serialnr GERNR Serial Number
matnr MATNR Material
prctr PRCTR Profit Center
screenty SCRTP Scenario
sel_opr SEL_OPR OperSelection
wcenter WCENTER WrkCntrSelect
new_num NEW_NUM Renumber
one_opr ONE_OPR Incl.once.comp.
sequenc SEQUENC Oper. sorting
buia BUIA Set in process
buip BUIP Suppress dialog
abrv ABRV SETR Default
prwin PRWIN Disp. PrtDlgBox
vkbur VKBUR Sales Office
vkgrp VKGRP Sales Group
spart SPART Division
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
qqmart QMART Notifictn Type
qscreenty SCRTP Scenario
qmatnr MATNR Material
qserialnr GERNR Serial Number
qmawerk QMAWERKS Plant for Mat.
qqkunum QKUNUM Customer
qlifnum LIFNUM Supplier
qqlifnr QLIFNR Manufacturer
qekorg EKORG Purchasing Org.
qbkgrp BKGRP Purch. Group
qarbpl LGWID Work Center
indstatusb INDSTATUSB Status bar
indtoolb INDTOOLB Toolbar
abdu ABDU No dial.compltn
lthe_on LTHE_ON Long text on
addt_on ADDT_ON Dates on
pmad_on PMAD_ON Address shown
profil CMFU_PROFIL Profile
actionbox QNQMACTIONBOX Action Box: Table
qgmart QMART Notifictn Type
qcmart QMART Notifictn Type
auswirk QSCENARIO Scenario
psp_nr PS_POSNR WBS Element
opponent PS_OPPONENT Partner Type
tl_default TL_SEL_DEFAULT Standard
prtwosave QNPRINTWOSAVE Print w/o Save
eams_dlfl EAMS_NOTIF_CHANGE_DLFL Deletion Flag
eams_reset_dlfl EAMS_NOTIF_CHANGE_DLFL_RESET Reset Deletion Flag
eams_teco EAMS_NOTIF_CHANGE_TECO Complete (Tech.)
eams_reset_teco EAMS_NOTIF_CHANGE_TECO_RESET Cancel Tech. Compl.
eams_close EAMS_NOTIF_CHANGE_CLOSE Complete (Business)
eams_do_not_exec EAMS_NOTIF_CHANGE_DO_NOT_EXEC Do Not Execute
eams_teco_conf EAMS_NOTIF_CHANGE_TECO_CONF Conf.: Tech. Compl.
eams_no_sf_rel EAMS_NO_SF_REL Hide SF Relationship
eams_auart_uc PM_AUFART Order type
eam_default_storage_location EAM_UPREF_STORAGE_LOCATION Storage Location
warpl WARPL MaintenancePlan
wptxt WPTXT MaintPlanText
fcode FCODE Function code
mplanref_inactive EAM_MPLANREF_INACTIVE Inact. M. Plan
mplanref_init_dt_and_cntr EAM_MPLANREF_INIT_DT_AND_CNTR Start Date & Counter
mplanref_copy_header EAM_MPLANREF_COPY_HEADER Additional Data
mplanref_copy_sched_param EAM_MPLANREF_COPY_SCHED_PARAM Sched. Params
mplanref_copy_maint_items EAM_MPLANREF_COPY_MAINT_ITEMS Maint. Items
mplanref_copy_object_list EAM_MPLANREF_COPY_OBJECT_LIST Object Lists
mplanref_copy_cust_fields EAM_MPLANREF_COPY_CUST_FIELDS Customer Fields
mplanref_copy_clfn EAM_MPLANREF_COPY_CLFN Classification
mplanref_copy_compl EAM_MPLANREF_COPY_COMPL Compliance
vspos VERSCHPLUS Late Completion
vsneg VERSCHNEG EarlyCompletion
topos TOLERPLUS Tolerance (+)
toneg TOLERNEG Tolerance (-)
fabkl FABKL Factory Calend.
horiz HORIZONT Call horizon
horiz_qualifier EAM_CC_CALLHORIZON_QUALIFIER Calculation Type
abrho ABRHO SchedPeriod
hunit HUNIT SchedIntUnit
call_confirm CALL_CONFIRM Compl.Requirmnt
zeit TIME_KNZ Indicator for selection of time-based maintenance
stich TIME_KNZ Indicator for selection of time-based maintenance
kalender TIME_KNZ Indicator for selection of time-based maintenance
or_knz ANDOR Operation type
and_knz ANDOR Operation type
sfakt SFAKT CycModifFactor
recipient_location_code RECIPIENT_LOCATION_CODE Recipient Loc.
rwempf WEMPF Recipient
rablad ABLAD Unloading Point
ream_default_storage_location EAM_UPREF_STORAGE_LOCATION Storage Location
rqmawerk QMAWERKS Plant for Mat.

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]
    SEL_OPR,                        -- OperSelection [SEL_OPR]
    WCENTER,                        -- WrkCntrSelect [WCENTER]
    NEW_NUM,                        -- Renumber [NEW_NUM]
    ONE_OPR,                        -- Incl.once.comp. [ONE_OPR]
    SEQUENC,                        -- Oper. sorting [SEQUENC]
    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]
    WARPL,                          -- MaintenancePlan [WARPL]
    WPTXT,                          -- MaintPlanText [WPTXT]
    FCODE,                          -- Function code [FCODE]
    MPLANREF_INACTIVE,              -- Inact. M. Plan [EAM_MPLANREF_INACTIVE]
    MPLANREF_INIT_DT_AND_CNTR,      -- Start Date & Counter [EAM_MPLANREF_INIT_DT_AND_CNTR]
    MPLANREF_COPY_HEADER,           -- Additional Data [EAM_MPLANREF_COPY_HEADER]
    MPLANREF_COPY_SCHED_PARAM,      -- Sched. Params [EAM_MPLANREF_COPY_SCHED_PARAM]
    MPLANREF_COPY_MAINT_ITEMS,      -- Maint. Items [EAM_MPLANREF_COPY_MAINT_ITEMS]
    MPLANREF_COPY_OBJECT_LIST,      -- Object Lists [EAM_MPLANREF_COPY_OBJECT_LIST]
    MPLANREF_COPY_CUST_FIELDS,      -- Customer Fields [EAM_MPLANREF_COPY_CUST_FIELDS]
    MPLANREF_COPY_CLFN,             -- Classification [EAM_MPLANREF_COPY_CLFN]
    MPLANREF_COPY_COMPL,            -- Compliance [EAM_MPLANREF_COPY_COMPL]
    VSPOS,                          -- Late Completion [VERSCHPLUS]
    VSNEG,                          -- EarlyCompletion [VERSCHNEG]
    TOPOS,                          -- Tolerance (+) [TOLERPLUS]
    TONEG,                          -- Tolerance (-) [TOLERNEG]
    FABKL,                          -- Factory Calend. [FABKL]
    HORIZ,                          -- Call horizon [HORIZONT]
    HORIZ_QUALIFIER,                -- Calculation Type [EAM_CC_CALLHORIZON_QUALIFIER]
    ABRHO,                          -- SchedPeriod [ABRHO]
    HUNIT,                          -- SchedIntUnit [HUNIT]
    CALL_CONFIRM,                   -- Compl.Requirmnt [CALL_CONFIRM]
    ZEIT,                           -- Indicator for selection of time-based maintenance [TIME_KNZ]
    STICH,                          -- Indicator for selection of time-based maintenance [TIME_KNZ]
    KALENDER,                       -- Indicator for selection of time-based maintenance [TIME_KNZ]
    OR_KNZ,                         -- Operation type [ANDOR]
    AND_KNZ,                        -- Operation type [ANDOR]
    SFAKT,                          -- CycModifFactor [SFAKT]
    RECIPIENT_LOCATION_CODE,        -- Recipient Loc. [RECIPIENT_LOCATION_CODE]
    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)
);

Learn More