TPMUS SAP table for – PM/SM – User default values

Here we would like to draw your attention to TPMUS table in SAP. As we know it is being mainly used with the SAP PM-WOC (Maintenance Processing in PM) component which is coming under PM module (Plant Maintenance). TPMUS is a SAP standard transparent table used for storing PM/SM – User default values related data in SAP. It comes under the package IWO1.

SAP TPMUS table

Table TPMUS technical data

TableTPMUS
Data storingPM/SM – User default values
ModulePM
ComponentPM-WOC
SAP PackageIWO1
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP TPMUS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TPMUS table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • OMATKL
    Its data type is C (Character String) with field length 9
  • OWEMPF
    Its data type is C (Character String) with field length 12
  • OABLAD
    Its data type is C (Character String) with field length 25
  • OMGVRG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OMEINH
    Its data type is C (Character String) with field length 3
  • MKSTAR
    Its data type is C (Character String) with field length 10
  • MEKORG
    Its data type is C (Character String) with field length 4
  • MEKGRP
    Its data type is C (Character String) with field length 3
  • MMATKL
    Its data type is C (Character String) with field length 9
  • MWEMPF
    Its data type is C (Character String) with field length 12
  • UNAME : User Name
    Its a key field. Its data type is C (Character String) with field length 12
  • MABLAD
    Its data type is C (Character String) with field length 25
  • PM_OBJTY : Object Type of CIM Resources for Work Center
    Its data type is C (Character String) with field length 2
  • GEWRK : Object ID of the Work Center
    Its data type is N (Character String with Digits Only) with field length 8
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • TPLNR : Flight Scheduling: Actual Aircraft Registration
    Its data type is C (Character String) with field length 30
  • EQUNR : Equipment Number
    Its data type is C (Character String) with field length 18
  • BAUTL : Assembly
    Its data type is C (Character String) with field length 18
  • SERIALNR : Serial Number
    Its data type is C (Character String) with field length 18
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • IWERK : Maintenance Planning Plant
    Its data type is C (Character String) with field length 4
  • SCREENTY : Scenario or Subscreen Category
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is PMSELTL
  • SEL_OPR
    Its data type is C (Character String) with field length 1
  • WCENTER
    Its data type is C (Character String) with field length 1
  • NEW_NUM
    Its data type is C (Character String) with field length 1
  • ONE_OPR
    Its data type is C (Character String) with field length 1
  • SEQUENC
    Its data type is C (Character String) with field length 1
  • BUIA
    Its data type is C (Character String) with field length 1
  • BUIP
    Its data type is C (Character String) with field length 1
  • ABRV
    Its data type is C (Character String) with field length 1
  • AUART : Order Type
    Its data type is C (Character String) with field length 4
  • PRWIN
    Its data type is C (Character String) with field length 1
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • QQMART
    Its data type is C (Character String) with field length 2
  • QSCREENTY
    Its data type is C (Character String) with field length 4
  • QMATNR
    Its data type is C (Character String) with field length 18
  • QSERIALNR
    Its data type is C (Character String) with field length 18
  • INGRP
    Its data type is C (Character String) with field length 3
  • QMAWERK
    Its data type is C (Character String) with field length 4
  • QQKUNUM
    Its data type is C (Character String) with field length 10
  • QLIFNUM
    Its data type is C (Character String) with field length 10
  • QQLIFNR
    Its data type is C (Character String) with field length 10
  • QEKORG
    Its data type is C (Character String) with field length 4
  • QBKGRP
    Its data type is C (Character String) with field length 3
  • QARBPL
    Its data type is N (Character String with Digits Only) with field length 8
  • INDSTATUSB
    Its data type is C (Character String) with field length 1
  • INDTOOLB
    Its data type is C (Character String) with field length 1
  • ABDU
    Its data type is C (Character String) with field length 1
  • QMART
    Its data type is C (Character String) with field length 2
  • LTHE_ON
    Its data type is C (Character String) with field length 1
  • ADDT_ON
    Its data type is C (Character String) with field length 1
  • PMAD_ON
    Its data type is C (Character String) with field length 1
  • PROFIL : Effectivity profile
    Its data type is C (Character String) with field length 8
  • ACTIONBOX
    Its data type is C (Character String) with field length 1
  • QGMART
    Its data type is C (Character String) with field length 2
  • QCMART
    Its data type is C (Character String) with field length 2
  • AUSWIRK
    Its data type is C (Character String) with field length 4
  • PSP_NR
    Its data type is N (Character String with Digits Only) with field length 8
  • OPPONENT
    Its data type is C (Character String) with field length 2
  • OKSTAR
    Its data type is C (Character String) with field length 10
  • TL_DEFAULT
    Its data type is C (Character String) with field length 1
  • PRTWOSAVE
    Its data type is C (Character String) with field length 1
  • OEKORG
    Its data type is C (Character String) with field length 4
  • OEKGRP
    Its data type is C (Character String) with field length 3