TPMUS SAP (PM/SM - User default values) Table details

Dictionary Type: Table
Description: PM/SM - User default values




ABAP Code to SELECT data from TPMUS
Related tables to TPMUS
Access table TPMUS




Table field list including key, data, relationships and ABAP select examples

TPMUS is a standard SAP Table which is used to store PM/SM - User default values data and is available within R/3 SAP systems depending on the version and release level.

The TPMUS table consists of various fields, each holding specific information or linking keys about PM/SM - User default values data available in SAP. These include UNAME (User Name), IWERK (Maintenance Planning Plant), AUART (Order Type), INGRP (Planner Group for Customer Service and Plant Maintenance).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TPMUS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
UNAMEUser Name SYUNAMECHAR12SYCHAR12
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
OKSTARCost Element KSTARCHAR10CSKAALPHAKSTARKAT
OEKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
OEKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
OMATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
OWEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
OABLADUnloading Point ABLADCHAR25TEXT25
OMGVRGOperation Quantity MGVRGQUAN13(3) MENG13
OMEINHUnit of Measure for Activity/Operation VORMEUNIT3T006CUNITMEINS
MKSTARCost Element KSTARCHAR10CSKAALPHAKSTARKAT
MEKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
MEKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
MMATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MWEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
MABLADUnloading Point ABLADCHAR25TEXT25
PM_OBJTYObject Type of CIM Resources for Work Center PM_OBJTYCHAR2CR_OBJTY
GEWRKObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
TPLNRFunctional Location TPLNRCHAR30IFLOTTPLNRTPLNRIFLIFLM
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
BAUTLAssembly BAUTLCHAR18MARAMATN1MATNRMAT
SERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
SCREENTYScenario or Subscreen Category SCRTPCHAR4TQBTSCRTP
SEL_OPRInclude task list with operation selection SEL_OPRCHAR1FLAG
WCENTERInclude task list with work center selection WCENTERCHAR1FLAG
NEW_NUMInclude task list with renumbering NEW_NUMCHAR1FLAG
ONE_OPRInclude task list only once completely ONE_OPRCHAR1FLAG
SEQUENCSorted inclusion of operations in the order SEQUENCCHAR1FLAG
BUIAPM: Customizing setting for function 'Set in process' BUIACHAR1BUIA
BUIPSet in process - Suppress dialog box BUIPCHAR1BUIP
ABRVPM: Maintain user setting for settlement rule ABRVCHAR1ABRV
PRWINDisplay Dialog Box from List Editing when Printing PRWINCHAR1KREUZ
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
VKGRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
QQMARTNotification Type QMARTCHAR2TQ80QMARTQMR
QSCREENTYScenario or Subscreen Category SCRTPCHAR4TQBTSCRTP
QMATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
QSERIALNRSerial Number GERNRCHAR18GERNRGERNRSER
QMAWERKPlant for Material QMAWERKSCHAR4T001WWERKSWRK
QQKUNUMAccount Number of Customer QKUNUMCHAR10KNA1ALPHAKUNNRKUN
QLIFNUMVendor Account Number LIFNUMCHAR10LFA1ALPHALIFNRLIF
QQLIFNRNumber of Manufacturer QLIFNRCHAR10LFA1ALPHALIFNRLIF
QEKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
QBKGRPPurchasing Group BKGRPCHAR3T024EKGRPEKG
QARBPLObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
INDSTATUSBActivate Status Bar in Text Control INDSTATUSBCHAR1KREUZ
INDTOOLBActivate Application Toolbar in Text Control INDTOOLBCHAR1KREUZ
ABDUSuppress dialog when completing order ABDUCHAR1KREUZ
LTHE_ONLong text editing (OCX) shown on order header LTHE_ONCHAR1KREUZ
ADDT_ONAdditional data on dates for order shown ADDT_ONCHAR1KREUZ
PMAD_ONAddresses were shown in order PMAD_ONCHAR1KREUZ
PROFILConfirmation Profile CMFU_PROFILCHAR8CMFU_PROFILTCMFUL_P
ACTIONBOXAction Box Display QNQMACTIONBOXCHAR1QKZ
QGMARTNotification Type QMARTCHAR2TQ80QMARTQMR
QCMARTNotification Type QMARTCHAR2TQ80QMARTQMR
AUSWIRKKey for a Scenario QSCENARIOCHAR4Assigned to domainQSCENARIO
PSP_NRWBS Element PS_POSNRNUMC8PRPSABPSPPS_POSNR
OPPONENTPartner Type PS_OPPONENTCHAR2OPPONENT
TL_DEFAULTIntegrate Task List: Standard Settings TL_SEL_DEFAULTCHAR1FLAG
PRTWOSAVEPrint Notification Shop Papers Without Saving QNPRINTWOSAVECHAR1QKZ

Key field Non-key field



How do I retrieve data from SAP table TPMUS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TPMUS to SELECT all data from the table
DATA: WA_TPMUS TYPE TPMUS.

SELECT SINGLE *
FROM TPMUS
INTO CORRESPONDING FIELDS OF WA_TPMUS
WHERE...

How to access SAP table TPMUS

Within an ECC or HANA version of SAP you can also view further information about TPMUS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!