SAP ABAP Table MPOS (Maintenance item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IPRM (Package) Application Development R/3 Preventive Maintenance

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MPOS	Table Relationship Diagram
Short Description	Maintenance item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WAPOS	☑	WAPOS	POSNU	CHAR	16	0	Maintenance item
3	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
4	WSTRA	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
5	WPPOS	☐	WPPOS	WPPOS	NUMC	4	0	Item in the maintenance plan
6	PSTXT	☐	POSTXT	TEXT40	CHAR	40	0	Item Short Text
7	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
8	OBKNR	☐	OBJKNR	OBJKN	INT4	10	0	Object list number	*
9	ERKNZ	☐	ERKNZ	FLAG	CHAR	1	0	Creation indicator
10	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERSDT	☐	EDATUM	DATUM	DATS	8	0	Date of creation
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
16	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
17	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
18	STATUS	☐	MPSTAT	FLAG	CHAR	1	0	Maintenance Item Status
19	LTKNZ	☐	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
20	WPGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
21	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
22	GEWRK	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
23	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
24	LANGU	☐	MPLANGU	SPRAS	LANG	1	0	Language key of the long text	*
25	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
26	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
27	LAUFN	☐	LAUFN	AUFNR	CHAR	12	0	Order number	AUFK
28	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
29	ANLZU	☐	ANLZU	ANLZU	CHAR	1	0	Syst.Condition	*
30	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
31	INACT	☐	INACT	FLAG	CHAR	1	0	Indicator that maintenance item is inactive
32	ILART	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	T353I
33	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
34	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
35	IND_ABRVO	☐	IND_ABRVO	CHAR01	CHAR	1	0	Indicator showing settlement rule maintained
36	PSPEL	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
37	STD_NETZ	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
38	STD_AVO	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
39	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
40	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
41	MITYP	☐	MITYP	CHAR2	CHAR	2	0	Maintenance item category	T399P
42	BSTNR	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
43	BSTPO	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	*
44	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
45	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
46	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
47	SAKTO	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
48	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	*
49	APFKT	☐	APFKT	AFAKT	DEC	3	0	Execution factor for whole task list
50	SCRRENTY	☐	SCREENTY	CHAR4	CHAR	4	0	SCREEN TYPE: for order-order category (see domain)
51	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
52	SERMAT	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
53	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
54	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
55	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
56	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
57	TASK_DETERMINE	☐	TASK_DETERMINE	CHAR1	CHAR	1	0	Automatic task determination in the notification
58	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
59	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	*
60	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
61	.INCLUDE	☐				0	0
62	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
63	PHYNR	☐	QPHYSPRNR	QPHYSPRNR	CHAR	12	0	Physical Sample Number	*
64	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	*
65	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
66	TSTMP_BW	☐	TSTMP_BW_EXT	RKE_TSTMP	DEC	16	0	Time Stamp for BI Delta Extraction
67	NO_AUFRELKZ	☐	NO_AUFRELKZ	XFELD	CHAR	1	0	Do Not Release Immediately
68	.INCLU--AP	☐				0	0	Cu specific APPEND for maintenance item
69	DESNUM	☐	/CUM/DESNUM	/CUM/DESNUM	CHAR	12	0	CU: Design Number	*
70	.INCLU--AP	☐				0	0	Append Structure 1 for MPOS Table
71	CYCLESEQIND	☐	CYCLESETSEQ	NUMC2	NUMC	2	0	Cycle Set Sequence
72	ADPSP	☐	ADDCOMPARE_CORE	ADDCOMPARE_CORE	CHAR	40	0	Reference Element PM/PS	*
73	IND_MPOS_API	☐	IND_MPOS_API	IND_API	CHAR	2	0	Maintenance Item Was Created/Changed by API

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MPOS	AUART	T003O	AUART	REF	C	CN
2	MPOS	BAUTL	MARA	MATNR	REF	C	CN
3	MPOS	EQUNR	EQUI	EQUNR	REF	C	CN
4	MPOS	GEWRK	CRID	OBJID	REF	C	CN
5	MPOS	GSBER	TGSB	GSBER
6	MPOS	ILART	T353I	ILART	REF	C	CN
7	MPOS	ILOAN	ILOA	ILOAN	REF	C	CN
8	MPOS	IWERK	T399I	IWERK	REF	C	CN
9	MPOS	LAUFN	AUFK	AUFNR	REF	C	CN
10	MPOS	MANDT	T000	MANDT	KEY	1	CN
11	MPOS	MITYP	T399P	MITYP
12	MPOS	OBJNR	ONR00	OBJNR	REF	C	1
13	MPOS	PLNTY	TCA01	PLNTY	REF	C	CN
14	MPOS	PRIOK	T356	PRIOK	REF	C	CN
15	MPOS	QMART	TQ80	QMART
16	MPOS	QMNUM	QMEL	QMNUM
17	MPOS	SERMAT	MARA	MATNR
18	MPOS	WAERS	TCURC	WAERS
19	MPOS	WARPL	MPLA	WARPL	REF	C	CN
20	MPOS	WPGRP	T024I	INGRP	REF	C	CN
21	MPOS	WSTRA	T351	STRAT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in