SAP Table TPMUS
PM/SM - User default values
TPMUS (PM/SM - User default values) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TPMUS to other SAP tables.
TPMUS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| UNAME | User Name | SYUNAME | CHAR | 12 | 0 | |||||||||||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||||||
| AUART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||||||
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||||||||||
| QMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||
| OKSTAR | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||||||
| OEKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||
| OEKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||||||
| OMATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||
| OWEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | 0 | |||||||||||
| OABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||
| OMGVRG | Operation Quantity | MGVRG | QUAN | 13 | 3 | |||||||||||
| OMEINH | Unit of Measure for Activity/Operation | VORME | T006 | UNIT | 3 | 0 | ||||||||||
| MKSTAR | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||||||
| MEKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||
| MEKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||||||
| MMATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||
| MWEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | 0 | |||||||||||
| MABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||
| GEWRK | Object ID of the Work Center | LGWID | CRID | NUMC | 8 | 0 | ||||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||||||
| BAUTL | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||||||||||
| SERIALNR | Serial Number | GERNR | CHAR | 18 | 0 | |||||||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | TQBT | CHAR | 4 | 0 | ||||||||||
| SEL_OPR | Include task list with operation selection | SEL_OPR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| WCENTER | Include task list with work center selection | WCENTER | CHAR | 1 | 0 |
Possible values
|
||||||||||
| NEW_NUM | Include task list with renumbering | NEW_NUM | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ONE_OPR | Include task list only once completely | ONE_OPR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| SEQUENC | Sorted inclusion of operations in the order | SEQUENC | CHAR | 1 | 0 |
Possible values
|
||||||||||
| BUIA | PM: Customizing setting for function 'Set in process' | BUIA | CHAR | 1 | 0 |
Possible values
|
||||||||||
| BUIP | Set in process - Suppress dialog box | BUIP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ABRV | PM: Maintain user setting for settlement rule | ABRV | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRWIN | Display Dialog Box from List Editing when Printing | PRWIN | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||||||
| VKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||
| QQMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||
| QSCREENTY | Scenario or Subscreen Category | SCRTP | TQBT | CHAR | 4 | 0 | ||||||||||
| QMATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
| QSERIALNR | Serial Number | GERNR | CHAR | 18 | 0 | |||||||||||
| QMAWERK | Plant for Material | QMAWERKS | T001W | CHAR | 4 | 0 | ||||||||||
| QQKUNUM | Account Number of Customer | QKUNUM | KNA1 | CHAR | 10 | 0 | ||||||||||
| QLIFNUM | Vendor Account Number | LIFNUM | LFA1 | CHAR | 10 | 0 | ||||||||||
| QQLIFNR | Number of Manufacturer | QLIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||
| QEKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||
| QBKGRP | Purchasing Group | BKGRP | T024 | CHAR | 3 | 0 | ||||||||||
| QARBPL | Object ID of the Work Center | LGWID | CRID | NUMC | 8 | 0 | ||||||||||
| INDSTATUSB | Activate Status Bar in Text Control | INDSTATUSB | CHAR | 1 | 0 |
Possible values
|
||||||||||
| INDTOOLB | Activate Application Toolbar in Text Control | INDTOOLB | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ABDU | Suppress dialog when completing order | ABDU | CHAR | 1 | 0 |
Possible values
|
||||||||||
| LTHE_ON | Long text editing (OCX) shown on order header | LTHE_ON | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ADDT_ON | Additional data on dates for order shown | ADDT_ON | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PMAD_ON | Addresses were shown in order | PMAD_ON | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PROFIL | Confirmation Profile | CMFU_PROFIL | CHAR | 8 | 0 | |||||||||||
| ACTIONBOX | Action Box Display | QNQMACTIONBOX | CHAR | 1 | 0 |
Possible values
|
||||||||||
| QGMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||
| QCMART | Notification Type | QMART | TQ80 | CHAR | 2 | 0 | ||||||||||
| AUSWIRK | Key for a Scenario | QSCENARIO | CHAR | 4 | 0 | |||||||||||
| PSP_NR | WBS Element | PS_POSNR | PRPS | NUMC | 8 | 0 | ||||||||||
| OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | 0 |
Possible values
|
||||||||||
| TL_DEFAULT | Integrate Task List: Standard Settings | TL_SEL_DEFAULT | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRTWOSAVE | Print Notification Shop Papers Without Saving | QNPRINTWOSAVE | CHAR | 1 | 0 |
Possible values
|
||||||||||
TPMUS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TPMUS | AUART | TPMUS | MANDT | T003O | Order Types | CLIENT |
| TPMUS | AUART | TPMUS | AUART | T003O | Order Types | AUART |
| TPMUS | BAUTL | TPMUS | MANDT | MARA | General Material Data | MANDT |
| TPMUS | BAUTL | TPMUS | BAUTL | MARA | General Material Data | MATNR |
| TPMUS | EQUNR | TPMUS | MANDT | EQUI | Equipment master data | MANDT |
| TPMUS | EQUNR | TPMUS | EQUNR | EQUI | Equipment master data | EQUNR |
| TPMUS | GEWRK | TPMUS | MANDT | CRID | CIM Resource - Entities | MANDT |
| TPMUS | GEWRK | TPMUS | PM_OBJTY | CRID | CIM Resource - Entities | OBJTY |
| TPMUS | GEWRK | TPMUS | GEWRK | CRID | CIM Resource - Entities | OBJID |
| TPMUS | GSBER | TPMUS | MANDT | TGSB | Business Areas | MANDT |
| TPMUS | GSBER | TPMUS | GSBER | TGSB | Business Areas | GSBER |
| TPMUS | INGRP | TPMUS | MANDT | T024I | Maintenance planner groups | MANDT |
| TPMUS | INGRP | TPMUS | IWERK | T024I | Maintenance planner groups | IWERK |
| TPMUS | INGRP | TPMUS | INGRP | T024I | Maintenance planner groups | INGRP |
| TPMUS | IWERK | TPMUS | MANDT | T399I | Planning plant parameters | MANDT |
| TPMUS | IWERK | TPMUS | IWERK | T399I | Planning plant parameters | IWERK |
| TPMUS | MANDT | TPMUS | MANDT | T000 | Clients | MANDT |
| TPMUS | MEKGRP | TPMUS | MEKGRP | T024 | Purchasing Groups | EKGRP |
| TPMUS | MEKGRP | TPMUS | MANDT | T024 | Purchasing Groups | MANDT |
| TPMUS | MEKORG | TPMUS | MEKORG | T024E | Purchasing Organizations | EKORG |
| TPMUS | MEKORG | TPMUS | MANDT | T024E | Purchasing Organizations | MANDT |
| TPMUS | MKSTAR | TPMUS | MKSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| TPMUS | MKSTAR | TPMUS | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| TPMUS | MKSTAR | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| TPMUS | MMATKL | TPMUS | MANDT | T023 | Material Groups | MANDT |
| TPMUS | MMATKL | TPMUS | MMATKL | T023 | Material Groups | MATKL |
| TPMUS | OEKGRP | TPMUS | MANDT | T024 | Purchasing Groups | MANDT |
| TPMUS | OEKGRP | TPMUS | OEKGRP | T024 | Purchasing Groups | EKGRP |
| TPMUS | OEKORG | TPMUS | MANDT | T024E | Purchasing Organizations | MANDT |
| TPMUS | OEKORG | TPMUS | OEKORG | T024E | Purchasing Organizations | EKORG |
| TPMUS | OKSTAR | TPMUS | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| TPMUS | OKSTAR | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| TPMUS | OKSTAR | TPMUS | OKSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| TPMUS | OMATKL | TPMUS | MANDT | T023 | Material Groups | MANDT |
| TPMUS | OMATKL | TPMUS | OMATKL | T023 | Material Groups | MATKL |
| TPMUS | OMEINH | TPMUS | MANDT | T006 | Units of Measurement | MANDT |
| TPMUS | OMEINH | TPMUS | OMEINH | T006 | Units of Measurement | MSEHI |
| TPMUS | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| TPMUS | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| TPMUS | PRCTR | TPMUS | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| TPMUS | PRCTR | TPMUS | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| TPMUS | PSP_NR | TPMUS | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| TPMUS | PSP_NR | TPMUS | PSP_NR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| TPMUS | QARBPL | TPMUS | MANDT | CRID | CIM Resource - Entities | MANDT |
| TPMUS | QARBPL | TPMUS | PM_OBJTY | CRID | CIM Resource - Entities | OBJTY |
| TPMUS | QARBPL | TPMUS | QARBPL | CRID | CIM Resource - Entities | OBJID |
| TPMUS | QBKGRP | TPMUS | MANDT | T024 | Purchasing Groups | MANDT |
| TPMUS | QBKGRP | TPMUS | QBKGRP | T024 | Purchasing Groups | EKGRP |
| TPMUS | QCMART | TPMUS | MANDT | TQ80 | Notification Types | MANDT |
| TPMUS | QCMART | TPMUS | QCMART | TQ80 | Notification Types | QMART |
| TPMUS | QEKORG | TPMUS | MANDT | T024E | Purchasing Organizations | MANDT |
| TPMUS | QEKORG | TPMUS | QEKORG | T024E | Purchasing Organizations | EKORG |
| TPMUS | QGMART | TPMUS | MANDT | TQ80 | Notification Types | MANDT |
| TPMUS | QGMART | TPMUS | QGMART | TQ80 | Notification Types | QMART |
| TPMUS | QLIFNUM | TPMUS | QLIFNUM | LFA1 | Vendor Master (General Section) | LIFNR |
| TPMUS | QLIFNUM | TPMUS | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| TPMUS | QMART | TPMUS | MANDT | TQ80 | Notification Types | MANDT |
| TPMUS | QMART | TPMUS | QMART | TQ80 | Notification Types | QMART |
| TPMUS | QMATNR | TPMUS | MANDT | MARA | General Material Data | MANDT |
| TPMUS | QMATNR | TPMUS | QMATNR | MARA | General Material Data | MATNR |
| TPMUS | QMAWERK | TPMUS | QMAWERK | T001W | Plants/Branches | WERKS |
| TPMUS | QMAWERK | TPMUS | MANDT | T001W | Plants/Branches | MANDT |
| TPMUS | QQKUNUM | TPMUS | MANDT | KNA1 | General Data in Customer Master | MANDT |
| TPMUS | QQKUNUM | TPMUS | QQKUNUM | KNA1 | General Data in Customer Master | KUNNR |
| TPMUS | QQLIFNR | TPMUS | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| TPMUS | QQLIFNR | TPMUS | QQLIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| TPMUS | QQMART | TPMUS | MANDT | TQ80 | Notification Types | MANDT |
| TPMUS | QQMART | TPMUS | QQMART | TQ80 | Notification Types | QMART |
| TPMUS | QSCREENTY | TPMUS | QSCREENTY | TQBT | Screen type table for subscreen | SCREENTY |
| TPMUS | SCREENTY | TPMUS | SCREENTY | TQBT | Screen type table for subscreen | SCREENTY |
| TPMUS | SPART | TPMUS | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| TPMUS | SPART | TPMUS | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| TPMUS | TPLNR | TPMUS | MANDT | IFLOT | Functional Location (Table) | MANDT |
| TPMUS | TPLNR | TPMUS | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| TPMUS | VKBUR | TPMUS | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
| TPMUS | VKBUR | TPMUS | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
| TPMUS | VKGRP | TPMUS | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
| TPMUS | VKGRP | TPMUS | VKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
| TPMUS | VKORG | TPMUS | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TPMUS | VKORG | TPMUS | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TPMUS | VTWEG | TPMUS | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TPMUS | VTWEG | TPMUS | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
