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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IWO1 (Package) Appl. Development R/3 Plant Maintenance Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TPMUS	Table Relationship Diagram
Short Description	PM/SM - User default values

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	UNAME	☑	SYUNAME	SYCHAR12	CHAR	12	0	User Name
3	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
4	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
5	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
6	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
7	OKSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
8	OEKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	OEKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
10	OMATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
11	OWEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
12	OABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
13	OMGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
14	OMEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
15	MKSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
16	MEKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
17	MEKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
18	MMATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
19	MWEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
20	MABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
21	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
22	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
25	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
26	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
27	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
28	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
29	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
30	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
31	.INCLUDE	☐				0	0	PM: Transfer Structure TL Transfer in PM Order
32	SEL_OPR	☐	SEL_OPR	FLAG	CHAR	1	0	Include task list with operation selection
33	WCENTER	☐	WCENTER	FLAG	CHAR	1	0	Include task list with work center selection
34	NEW_NUM	☐	NEW_NUM	FLAG	CHAR	1	0	Include task list with renumbering
35	ONE_OPR	☐	ONE_OPR	FLAG	CHAR	1	0	Include task list only once completely
36	SEQUENC	☐	SEQUENC	FLAG	CHAR	1	0	Sorted inclusion of operations in the order
37	BUIA	☐	BUIA	BUIA	CHAR	1	0	PM: Customizing setting for function 'Set in process'
38	BUIP	☐	BUIP	BUIP	CHAR	1	0	Set in process - Suppress dialog box
39	ABRV	☐	ABRV	ABRV	CHAR	1	0	PM: Maintain user setting for settlement rule
40	PRWIN	☐	PRWIN	KREUZ	CHAR	1	0	Display Dialog Box from List Editing when Printing
41	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
42	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
43	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
44	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
45	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
46	QQMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
47	QSCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	TQBT
48	QMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
49	QSERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
50	QMAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
51	QQKUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
52	QLIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
53	QQLIFNR	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
54	QEKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
55	QBKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
56	QARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
57	INDSTATUSB	☐	INDSTATUSB	KREUZ	CHAR	1	0	Activate Status Bar in Text Control
58	INDTOOLB	☐	INDTOOLB	KREUZ	CHAR	1	0	Activate Application Toolbar in Text Control
59	ABDU	☐	ABDU	KREUZ	CHAR	1	0	Suppress dialog when completing order
60	LTHE_ON	☐	LTHE_ON	KREUZ	CHAR	1	0	Long text editing (OCX) shown on order header
61	ADDT_ON	☐	ADDT_ON	KREUZ	CHAR	1	0	Additional data on dates for order shown
62	PMAD_ON	☐	PMAD_ON	KREUZ	CHAR	1	0	Addresses were shown in order
63	PROFIL	☐	CMFU_PROFIL	CMFU_PROFIL	CHAR	8	0	Confirmation Profile
64	ACTIONBOX	☐	QNQMACTIONBOX	QKZ	CHAR	1	0	Action Box Display
65	QGMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
66	QCMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
67	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	*
68	PSP_NR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
69	OPPONENT	☐	PS_OPPONENT	OPPONENT	CHAR	2	0	Partner Type
70	TL_DEFAULT	☐	TL_SEL_DEFAULT	FLAG	CHAR	1	0	Integrate Task List: Standard Settings
71	PRTWOSAVE	☐	QNPRINTWOSAVE	QKZ	CHAR	1	0	Print Notification Shop Papers Without Saving

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TPMUS	AUART	T003O	AUART
2	TPMUS	BAUTL	MARA	MATNR
3	TPMUS	EQUNR	EQUI	EQUNR
4	TPMUS	GEWRK	CRID	OBJID
5	TPMUS	GSBER	TGSB	GSBER
6	TPMUS	INGRP	T024I	INGRP
7	TPMUS	IWERK	T399I	IWERK
8	TPMUS	MANDT	T000	MANDT
9	TPMUS	MEKGRP	T024	EKGRP		C	CN
10	TPMUS	MEKORG	T024E	EKORG		C	CN
11	TPMUS	MKSTAR	CSKA	KSTAR
12	TPMUS	MMATKL	T023	MATKL		C	CN
13	TPMUS	OEKGRP	T024	EKGRP		C	CN
14	TPMUS	OEKORG	T024E	EKORG		C	CN
15	TPMUS	OKSTAR	CSKA	KSTAR
16	TPMUS	OMATKL	T023	MATKL		C	CN
17	TPMUS	OMEINH	T006	MSEHI
18	TPMUS	PRCTR	CEPC	PRCTR
19	TPMUS	PSP_NR	PRPS	PSPNR
20	TPMUS	QARBPL	CRID	OBJID
21	TPMUS	QBKGRP	T024	EKGRP
22	TPMUS	QCMART	TQ80	QMART
23	TPMUS	QEKORG	T024E	EKORG
24	TPMUS	QGMART	TQ80	QMART
25	TPMUS	QLIFNUM	LFA1	LIFNR
26	TPMUS	QMART	TQ80	QMART
27	TPMUS	QMATNR	MARA	MATNR
28	TPMUS	QMAWERK	T001W	WERKS
29	TPMUS	QQKUNUM	KNA1	KUNNR
30	TPMUS	QQLIFNR	LFA1	LIFNR
31	TPMUS	QQMART	TQ80	QMART
32	TPMUS	QSCREENTY	TQBT	SCREENTY
33	TPMUS	SCREENTY	TQBT	SCREENTY
34	TPMUS	SPART	TSPA	SPART
35	TPMUS	TPLNR	IFLOT	TPLNR
36	TPMUS	VKBUR	TVBUR	VKBUR
37	TPMUS	VKGRP	TVKGR	VKGRP
38	TPMUS	VKORG	TVKO	VKORG
39	TPMUS	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in