SAP MPLAN_ILOA ILOA for Maintenance Plan Table data and field list

MPLAN_ILOA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "ILOA for Maintenance Plan" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MPLAN_ILOA TYPE MPLAN_ILOA.

The MPLAN_ILOA table consists of various fields, each holding specific information or linking keys about ILOA for Maintenance Plan data available in SAP. These include MANDT (Client), ILOAN (Location and account assignment for technical object), TPLNR (Functional Location), ABCKZ (ABC indicator for technical object)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MPLAN_ILOA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP MPLAN_ILOA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MPLAN_ILOA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
WAPOS	Maintenance item	WAPOS	CHAR	16		ALPHA	POSNU	MPS	MPOSL
MANDT	Client	MANDT	CLNT	3	T000		MANDT
ILOAN	Location and account assignment for technical object	ILOAN	CHAR	12	Assigned to domain		ILOAN
TPLNR	Functional Location	TPLNR	CHAR	30	IFLOT	TPLNR	TPLNR	IFL	IFLM
ABCKZ	ABC indicator for technical object	ABCKZ	CHAR	1	T370C		ABCKZ
ABCKZI	Data origin for ABC indicator field	INH_ABCKZI	CHAR	1			INHER
EQFNR	Sort field	EQFNR	CHAR	30			CHAR30
EQFNRI	Data origin for sort field	INH_EQFNRI	CHAR	1			INHER
SWERK	Maintenance plant	SWERK	CHAR	4	T001W		WERKS	SWK
SWERKI	Data origin for maintenance plant field	INH_SWERKI	CHAR	1			INHER
STORT	Location of maintenance object	PMLOC	CHAR	10	T499S		AP_STAND
STORTI	Data origin for location field	INH_STORTI	CHAR	1			INHER
MSGRP	Room	RAUMNR	CHAR	8			CHAR8
MSGRPI	Data origin for room number field	INH_MSGRPI	CHAR	1			INHER
BEBER	Plant section	BEBER	CHAR	3	T357		BEBER	BBE
BEBERI	Data origin for plant section field	INH_BEBERI	CHAR	1			INHER
CR_OBJTY	Object types of the CIM resource	CR_OBJTY	CHAR	2			CR_OBJTY
PPSID	Object ID of PP work center	PPSID	NUMC	8	CRID		CR_OBJID
PPSIDI	Data origin for PP work center field	INH_PPSIDI	CHAR	1			INHER
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
GSBERI	Data origin for business area field	INH_GSBERI	CHAR	1			INHER
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
KOKRSI	Data origin for controlling area field	INH_KOKRSI	CHAR	1			INHER
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
KOSTLI	Data origin for cost center field	INH_KOSTLI	CHAR	1			INHER
PROID	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
PROIDI	Data origin for WBS element field	INH_PROIDI	CHAR	1			INHER
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
BUKRSI	Data origin for company code field	INH_BUKRSI	CHAR	1			INHER
ANLNR	Main Asset Number	ANLN1	CHAR	12	ANLH	ALPHA	ANLN1	AN1
ANLNRI	Data origin for asset main no./sub-no. fields	INH_ANLNRI	CHAR	1			INHER
ANLUN	Asset Subnumber	ANLN2	CHAR	4	ANLA	ALPHA	ANLN2	AN2
ANLUNI	Data origin indicator	INHER	CHAR	1			INHER
DAUFN	Standing order number	DAUFN	CHAR	12	AUFK	ALPHA	AUFNR		ORDP
DAUFNI	Data origin of standing order number field	INH_DAUFNI	CHAR	1			INHER
AUFNR	Settlement order	ILOM_ORDST	CHAR	12	AUFK	ALPHA	AUFNR		ORDE
AUFNRI	Data origin for settlement order field	INH_AUFNRI	CHAR	1			INHER
TPLNRI	Data origin for functional location field	INH_TPLNRI	CHAR	1			INHER
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VKORGI	Data origin for sales organization field	INH_VKORGI	CHAR	1			INHER
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVKOV		VTWEG	VTW	C_VTWEG
VTWEGI	Data origin of distribution channel field	INH_VTWEGI	CHAR	1			INHER
SPART	Division	SPART	CHAR	2	TVTA		SPART	SPA	C_SPART
SPARTI	Data origin for division field	INH_SPARTI	CHAR	1			INHER
ADRNR	Address number	AD_ADDRNUM	CHAR	10	ADRC	ALPHA	AD_ADDRNUM	ADR
ADRNRI	Data origin for address field	INH_ADRNRI	CHAR	1			INHER
OWNER	Object reference indicator	ILOM_OWNER	CHAR	1			ILOM_OWNER
VKBUR	Sales Office	VKBUR	CHAR	4	TVKBZ		VKBUR	VKB
VKGRP	Sales Group	VKGRP	CHAR	3	TVBVK		VKGRP	VKG

Key field

Non-key field

< MPLAN_HEADER_LIST_PARAMS - Parameter(s) for List Selection MPLAN_ITEM_LIST_OPTIONS - Selection Options for Maintenance Plan List >

How do I retrieve data from SAP structure MPLAN_ILOA using ABAP code?

As MPLAN_ILOA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MPLAN_ILOA as there is no data to select.

How to access SAP table MPLAN_ILOA

Within an ECC or HANA version of SAP you can also view further information about MPLAN_ILOA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).