SAP ABAP Table MPLA (Maintenance plan)

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	MPLA	Table Relationship Diagram
Short Description	Maintenance plan

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	WARPL	☑	WARPL	WARPL	CHAR	12	0	Maintenance Plan
3	ERKNZ	☐	ERKNZ	FLAG	CHAR	1	0	Creation indicator
4	AEKNZ	☐	AEKNZ	FLAG	CHAR	1	0	Change indicator
5	ERSDT	☐	EDATUM	DATUM	DATS	8	0	Date of creation
6	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	WPTXT	☐	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
10	STRAT	☐	STRAT	WSTRA	CHAR	6	0	Maintenance strategy	T351
11	ABRHO	☐	ABRHO	ANZTA	NUMC	3	0	Scheduling Period
12	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
13	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
14	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	*
15	LTKNZ	☐	MPLTX	XFELD	CHAR	1	0	Long Text Indicator
16	LVORM	☐	ABSTOP	XFELD	CHAR	1	0	Indicator: maintenance plan locked against calls
17	ANZPS	☐	ANZMPOS	WPPOS	NUMC	4	0	Number of maintenance items in the maintenance plan
18	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
19	LANGU	☐	MPLANGU	SPRAS	LANG	1	0	Language key of the long text	*
20	VSPOS	☐	VERSCHPLUS	NUM3	NUMC	3	0	Shift Factor for Late Completion
21	VSNEG	☐	VERSCHNEG	NUM3	NUMC	3	0	Shift Factor for Early Completion
22	TOPOS	☐	TOLERPLUS	NUM3	NUMC	3	0	Tolerance for Late Completion (%)
23	TONEG	☐	TOLERNEG	NUM3	NUMC	3	0	Tolerance for Early Completion (%)
24	SFAKT	☐	SFAKT	SFAKT	DEC	3	2	Cycle modification factor
25	STICH	☐	TERMKNZ	TERMKNZ	CHAR	1	0	Scheduling indicator
26	TGOON	☐	TGON	NUM3	NUMC	3	0	Scheduling to reoccur when lead float reached
27	HORIZ	☐	HORIZONT	NUM3	NUMC	3	0	Call horizon for maintenance plan calls
28	HORIZ_DAYS	☐	HORIZONT	NUM3	NUMC	3	0	Call horizon for maintenance plan calls
29	HORIZ_QUALIFIER	☐	EAM_CC_CALLHORIZON_QUALIFIER	EAM_CC_CALLHORIZON_QUALIFIER	CHAR	1	0	Calculation Type of Call Horizon
30	ANDOR	☐	ANDOR	RADIO	CHAR	1	0	Indicator for OR or AND link
31	KNAUT	☐	KNZABR	FLAG	CHAR	1	0	Reserved
32	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
33	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
34	MPTYP	☐	MPTYP	MPTYP	CHAR	2	0	Maintenance plan category	T399W
35	HUNIT	☐	HUNIT	MEINS	UNIT	3	0	Unit in scheduling interval	*
36	STADT	☐	STADT	DATUM	DATS	8	0	Start date
37	SZAEH	☐	SZAEHC	WZYKL	CHAR	22	0	Start counter reading
38	CALL_CONFIRM	☐	CALL_CONFIRM	CHAR1	CHAR	1	0	Only Create New Call Object After Completing Predecessor
39	PLAN_SORT	☐	PLAN_SORT	CHAR20	CHAR	20	0	Sort field for maintenance plans	T399G
40	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
41	PUFFP	☐	PUFF_VORL	NUM3	NUMC	3	0	Lead Float in Days
42	PUFFN	☐	PUFF_NACHL	NUM3	NUMC	3	0	Follow-up float in days
43	.INCLU--AP	☐				0	0	Append Structure 1 for MPLA Table
44	START_DATE	☐	DATE_START	DATUM	DATS	8	0	Start Date for Scheduling
45	START_TIME	☐	TIME_START	TIME	TIMS	6	0	Start Time for Scheduling
46	CALL_UPDATE_IND	☐	IND_CALL_UPDATE	XFELD	CHAR	1	0	Indicator for Adapting Basic Dates of Call Object
47	IND_MPLA_API	☐	IND_MPLA_API	IND_API	CHAR	2	0	Maintenance Plan Was Created/Changed by API
48	MCP_SF	☐	MCP_SF	MCP_SF	CHAR	1	0	Shift Factor for Multiple Counter Plan

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MPLA	BEGRU	T370B	BEGRU	REF	C	CN
2	MPLA	FABKL	TFACD	IDENT	REF	C	CN
3	MPLA	MANDT	T000	MANDT	KEY	1	CN
4	MPLA	MPTYP	T399W	MPTYP	KEY	1	CN
5	MPLA	PLAN_SORT	T399G	PLAN_SORT	KEY	1	CN
6	MPLA	STRAT	T351	STRAT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in