SAP ABAP Table EAMS_S_SP_MPOS (Maintenance Plan Items)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PM (Application Component) Plant Maintenance
     ⤷ EAMS_MDP_MISC (Package) Miscellaneous for Master Data Provider

Basic Data

Table Category	INTTAB	Structure
Structure	EAMS_S_SP_MPOS	Table Relationship Diagram
Short Description	Maintenance Plan Items

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Business Object Mplan Item - Identification
2	EAMS_WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
3	.INCLUDE	☐				0	0	Maintenance item
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
6	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
7	WSTRA	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
8	WPPOS	☐	WPPOS	WPPOS	NUMC	4	0	Item in the maintenance plan
9	PSTXT	☐	POSTXT	TEXT40	CHAR	40	0	Item Short Text
10	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
11	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	*
12	ERKNZ	☐	ERKNZ	FLAG	CHAR	1	0	Creation indicator
13	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	ERSDT	☐	EDATUM	DATUM	DATS	8	0	Date of creation
16	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
19	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
20	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
21	STATUS	☐	MPSTAT	FLAG	CHAR	1	0	Maintenance Item Status
22	LTKNZ	☐	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
23	WPGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
24	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
25	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
26	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
27	LANGU	☐	MPLANGU	SPRAS	LANG	1	0	Language key of the long text	*
28	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
29	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
30	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
31	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
32	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	*
33	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
34	INACT	☐	INACT	FLAG	CHAR	1	0	Indicator that maintenance item is inactive
35	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	*
36	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
37	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
38	IND_ABRVO	☐	IND_ABRVO	CHAR01	CHAR	1	0	Indicator showing settlement rule maintained
39	PSPEL	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
40	STD_NETZ	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
41	STD_AVO	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
42	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
43	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
44	MITYP	☐	MITYP	CHAR2	CHAR	2	0	Maintenance item category	T399P
45	BSTNR	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
46	BSTPO	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	*
47	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
48	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
49	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
50	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
51	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
52	APFKT	☐	APFKT	AFAKT	DEC	3	0	Execution factor for whole task list
53	SCRRENTY	☐	SCREENTY	CHAR4	CHAR	4	0	SCREEN TYPE: for order-order category (see domain)
54	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
55	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
56	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
57	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
58	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
59	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
60	TASK_DETERMINE	☐	TASK_DETERMINE	CHAR1	CHAR	1	0	Automatic task determination in the notification
61	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
62	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	*
63	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
64	.INCLUDE	☐				0	0
65	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
66	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
67	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
68	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
69	TSTMP_BW	☐	TSTMP_BW_EXT	RKE_TSTMP	DEC	16	0	Time Stamp for BI Delta Extraction
70	NO_AUFRELKZ	☐	NO_AUFRELKZ	XFELD	CHAR	1	0	Do Not Release Immediately
71	.INCLU--AP	☐				0	0	Cu specific APPEND for maintenance item
72	DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number	*
73	.INCLU--AP	☐				0	0	Append Structure 1 for MPOS Table
74	CYCLESEQIND	☐	CYCLESETSEQ	NUMC2	NUMC	2	0	Cycle Set Sequence
75	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
76	IND_MPOS_API	☐	IND_MPOS_API	IND_API	CHAR	2	0	Maintenance Item Was Created/Changed by API
77	WPTXT	☐	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
78	SYS_STATUS_INAC	☐	EAMS_IND_STATUS_INAK	BOOLEAN	CHAR	1	0	Maintenance Plan Inactive
79	WSTRA_TEXT	☐	TXWSTRA	TXT30	CHAR	30	0	Description of maintenance strategy
80	MPTYP	☐	MPTYP	MPTYP	CHAR	2	0	Maintenance plan category	*
81	MPTYP_TEXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
82	.INCLUDE	☐				0	0	Technical Object - Identification
83	EAMS_TEC_OBJ_TYPE	☐	/PLMB/GOS_OBJECT_TYPE	/PLMB/GOS_OBJECT_TYPE	CHAR	10	0	Object Type	*
84	EAMS_TEC_OBJ_NO	☐	EAMS_TEC_OBJ	EAMS_TEC_OBJ	CHAR	40	0	Technical Object
85	EAMS_TEC_OBJ_DES	☐	EAMS_TEC_OBJ_DES	TEXT40	CHAR	40	0	Technical Object Description
86	EAMS_TEC_OBJ_TYPE_DESC	☐	EAMS_TEC_OBJ_TYPE_DESC	/PLMB/GOS_OTYPE_DESC	CHAR	40	0	Description of Technical Object Type
87	EAMS_TL_DISPLAY_ID	☐	EAMS_TL_DISPLAY_ID	EAMS_TL_DISPLAY_ID	CHAR	30	0	Concatenated Task List ID for Display
88	TASKLIST_TEXT	☐	PLANTEXT	TEXT40	CHAR	40	0	Task list description
89	BAUTX	☐	BAUTX	TEXT40	CHAR	40	0	Description of PM Assembly
90	MATERIAL_TEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
91	MAINT_PLAN_PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
92	ORDERTYPE_TEXT	☐	AUARTTEXT	TEXT40	CHAR	40	0	Short Text
93	NTFTYPE_TEXT	☐	QMARTX	TEXT20	CHAR	20	0	Notification Type Texts
94	WERGW	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	*
95	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
96	WORKCENTER_TEXT	☐	KTXT40	TEXT40	CHAR	40	0	Work center description
97	WORKCENTER_PLANT_TEXT	☐	NAME1	TEXT30	CHAR	30	0	Name
98	BST_KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
99	BST_KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
100	SALES_ORD_IT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
101	INNAM	☐	INNAM	TEXT18	CHAR	18	0	Name of the Maintenance Planner Group
102	MAINT_ACTIV_TEXT	☐	ILATX	TXT30	CHAR	30	0	Description of maintenance activity type
103	GTEXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description
104	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	*
105	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
106	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	*
107	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
108	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
109	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	*
110	PP_WORKCENTER	☐	ARBPL	ARBPL	CHAR	8	0	Work center
111	PP_WORKCENTER_TEXT	☐	KTXT40	TEXT40	CHAR	40	0	Work center description
112	ILOA_GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
113	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
114	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
115	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
116	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
117	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
118	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
119	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	*
120	ORDST	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
121	PRIORITY_TEXT	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
122	LOCATION_TEXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
123	PLANT_SECTION_RESPONSIBLE	☐	EAMS_PERS_RESP_PLANT_SECT	CHAR30	CHAR	30	0	Person Responsible for Plant Section
124	PLANT_SECTION_PHONE	☐	TELE	CHAR12	CHAR	12	0	Phone number of person responsible for company area
125	ABCKZ_TEXT	☐	ABCTX	TEXT20	CHAR	20	0	Text for ABC Indicator for Technical Objects
126	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
127	ANLA_TEXT	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
128	COST_CENTER_TEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
129	WBS_TEXT	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
130	MAINT_PLANT_TEXT	☐	NAME1	TEXT30	CHAR	30	0	Name
131	OBJECTLIST_EXISTS	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
132	CYCLESETSEQ	☐	CYCLESETSEQ	NUMC2	NUMC	2	0	Cycle Set Sequence
133	EAMS_OBJ_LIST_EXISTS	☐	EAMS_OBJ_LIST_EXISTS	XFELD	CHAR	1	0	Object List Exists
134	EAMS_TL_AVAILABLE	☐	EAMS_TL_AVAILABLE	XFELD	CHAR	1	0	Task List Available
135	EAML_LFE_IND	☐	EAML_LFE_IND	XFELD	CHAR	1	0	Indicator: Object Belongs to Linear Asset Management
136	START_POINT	☐	EAML_START_POINT	EAML_POINT	CHAR	18	0	Start Point
137	END_POINT	☐	EAML_END_POINT	EAML_POINT	CHAR	18	0	End Point
138	LINEAR_LENGTH	☐	EAML_LINEAR_LENGTH	EAML_POINT	CHAR	18	0	Length
139	LINEAR_UNIT	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	*
140	FIRST_OFFSET_TYPE_CODE	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	*
141	FIRST_OFFSET_VALUE	☐	EAML_OFFSET1_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 1
142	FIRST_OFFSET_UNIT	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	*
143	FIRST_OFFSET_UNIT_ISO	☐	EAML_OFFSET1_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 1 in ISO Code	*
144	FIRST_OFFSET_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
145	SECOND_OFFSET_TYPE_CODE	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	*
146	SECOND_OFFSET_VALUE	☐	EAML_OFFSET2_VALUE	EAML_POINT	CHAR	18	0	Value of Offset 2
147	SECOND_OFFSET_UNIT	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	*
148	SECOND_OFFSET_UNIT_ISO	☐	EAML_OFFSET2_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Offset 2 in ISO Code	*
149	SECOND_OFFSET_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
150	LINEAR_UNIT_ISO	☐	EAML_LINEAR_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit of Measurement for Linear Data in ISO Code	*
151	LINEAR_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
152	MARKER_START_POINT	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
153	MARKER_DISTANCE_START_POINT	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
154	MARKER_END_POINT	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
155	MARKER_DISTANCE_END_POINT	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
156	MARKER_DISTANCE_UNIT	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	*
157	MARKER_DISTANCE_UNIT_ISO	☐	EAML_MARKER_DISTANCE_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	Unit for the Distance from Marker in ISO Code	*
158	MARKER_DISTANCE_UNIT_TXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
159	STICH	☐	TERMKNZ	TERMKNZ	CHAR	1	0	Scheduling indicator
160	BST_DISPLAY_TEXT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
161	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
162	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
163	ILOA_GTEXT	☐	GTEXT	TEXT30	CHAR	30	0	Business area description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EAMS_S_SP_MPOS	BAUTL	MARA	MATNR	REF	C	CN
2	EAMS_S_SP_MPOS	EQUNR	EQUI	EQUNR	REF	C	CN
3	EAMS_S_SP_MPOS	GEWRK	CRID	OBJID	REF	C	CN
4	EAMS_S_SP_MPOS	ILOAN	ILOA	ILOAN	REF	C	CN
5	EAMS_S_SP_MPOS	LAUFN	AUFK	AUFNR	REF	C	CN
6	EAMS_S_SP_MPOS	MANDT	T000	MANDT	KEY	1	CN
7	EAMS_S_SP_MPOS	MITYP	T399P	MITYP
8	EAMS_S_SP_MPOS	OBJNR	ONR00	OBJNR	REF	C	1
9	EAMS_S_SP_MPOS	PLNTY	TCA01	PLNTY	REF	C	CN
10	EAMS_S_SP_MPOS	PRIOK	T356	PRIOK	REF	C	CN
11	EAMS_S_SP_MPOS	QMART	TQ80	QMART
12	EAMS_S_SP_MPOS	QMNUM	QMEL	QMNUM
13	EAMS_S_SP_MPOS	SERMAT	MARA	MATNR
14	EAMS_S_SP_MPOS	WAERS	TCURC	WAERS
15	EAMS_S_SP_MPOS	WPGRP	T024I	INGRP	REF	C	CN
16	EAMS_S_SP_MPOS	WSTRA	T351	STRAT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605