SAP IFLOTH FunctLocation (table) with hierarchy level Table data and field list

IFLOTH 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 "FunctLocation (table) with hierarchy level" 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_IFLOTH TYPE IFLOTH.

The IFLOTH table consists of various fields, each holding specific information or linking keys about FunctLocation (table) with hierarchy level data available in SAP. These include MANDT (Client), TPLNR (Functional Location), MLANG (Primary language for object texts), TPLKZ (Functional location structure indicator)... 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. .

IFLOTH 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 IFLOTH 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 IFLOTH 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
TPLNR	Functional Location	TPLNR	CHAR	30	Assigned to domain	TPLNR	TPLNR	IFL	IFLM
MLANG	Primary language for object texts	MLANG	LANG	1	T002	ISOLA	SPRAS
TPLKZ	Functional location structure indicator	TPLKZ	CHAR	5	T370S		TPLKZ	ISR
FLTYP	Functional location category	FLTYP	CHAR	1	T370F		FLTYP	IFT
TPLMA	Superior functional location	TPLMA	CHAR	30	IFLOT	TPLNR	TPLNR		IFLM
ERDAT	Date on which the object was created	ICRDT	DATS	8			DATUM
ERNAM	Name of User Who Created the Object	ICRNA	CHAR	12			USNAM
AEDAT	Date on which the object was last changed	IUPDT	DATS	8			DATUM
AENAM	Name of the user who last changed the object	IUPNA	CHAR	12			USNAM
DATAB	Start-up Date of the Technical Object	ILOM_DATAB	DATS	8			DATUM
BEGRU	Technical object authorization group	IAUTG	CHAR	4	T370B		IAUTG
TRPNR	Reference functional location	TRPNR	CHAR	30	IRLOT		TRPNR	IRL	IRLM
PSTAE	SAP Development reserve: Format CHAR, length 4	RESERVE_CHAR_004	CHAR	4			CHAR4
STNAM	SAP Development Reserve: Format CHAR, Length 12	RESERVE_CHAR_012	CHAR	12			CHAR12
LVORM	SAP Development Reserve: Format CHAR, Length 1	RESERVE_CHAR_001	CHAR	1			CHAR1
SUBMT	Construction type material of the object	SUBMT	CHAR	18	MARA	MATN1	MATNR	MAT
SUBMTI	Data origin for construction type field	INH_SUBMTI	CHAR	1			INHER
MAPAR	Manufacturer part number	MAPAR	CHAR	30			MAPAR
MAPARI	SAP Development Reserve: Format CHAR, Length 1	RESERVE_CHAR_001	CHAR	1			CHAR1
IEQUI	Installation of equipment allowed at the functional location	IEQUI	CHAR	1			X
IEQUII	Data origin for equip. inst. allowed field	INH_IEQUII	CHAR	1			INHER
EINZL	Single equipment installation at functional location	EINZL	CHAR	1			XFELD
EINZLI	Data origin for authorization group field	INH_BEGRUI	CHAR	1			INHER
IWERK	Maintenance Planning Plant	IWERK	CHAR	4	T399I		WERKS	IWK
IWERKI	Data origin for planning plant field	INH_IWERKI	CHAR	1			INHER
INGRP	Planner Group for Customer Service and Plant Maintenance	INGRP	CHAR	3	T024I		INGRP	IHG
INGRPI	Data origin for maintenance planner group field	INH_INGRPI	CHAR	1			INHER
PM_OBJTY	Object Type of CIM Resources for Work Center	PM_OBJTY	CHAR	2			CR_OBJTY
LGWID	Object ID of the Work Center	LGWID	NUMC	8	CRID		CR_OBJID
LGWIDI	Data Origin for the Field 'Work Center'	INH_LGWIDI	CHAR	1			INHER
RBNR	Catalog Profile	RBNR	CHAR	9	T352B		RBNR
RBNR_I	Data origin for maintenance catalog field	INH_RBNR_I	CHAR	1			INHER
ILOAN	Location and account assignment for technical object	ILOAN	CHAR	12	ILOA		ILOAN
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
POSNR	Position in superior technical object	ILOM_POSNR	CHAR	4			CHAR4
ISTYP	Object category for Industry Solutions (IS)	ILOM_ISTYP	CHAR	1			ILOM_ISTYP
PREMS	Premise	ILOM_PREMS	CHAR	10			CHAR10
EQART	Type of Technical Object	EQART	CHAR	10	T370K		EQART
INVNR	Inventory number	INVNR	CHAR	25			INVNR_ANLA
GROES	Size/dimension	GROSS	CHAR	18			GROES
BRGEW	Gross Weight	BRGEW	QUAN	13(3)			MENG13
GEWEI	Weight Unit	GEWEI	UNIT	3	T006	CUNIT	MEINS
ANSWT	Acquisition Value	ANSWT	CURR	13(2)			WERT
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
ANSDT	Acquisition date	ANDTI	DATS	8			DATUM
HERST	Manufacturer of asset	HERST	CHAR	30			TEXT30
HERLD	Country of manufacture	HERLD	CHAR	3	T005		LAND1
BAUJJ	Year of construction	BAUJJ	CHAR	4		GJAHR	CJAHR
BAUMM	Month of construction	BAUMM	CHAR	2			BAUMM
TYPBZ	Manufacturer model number	TYPBZ	CHAR	20			TYPBZ
EMATN	Material Number Corresponding to Manufacturer Part Number	EMATN	CHAR	18	Assigned to domain	MATN1	MATNR	HTN
SERGE	Manufacturer serial number	SERGE	CHAR	30			CHAR30
HANDLE	SAP Development Reserve: Integration of Date Segment (Key)	ITOBTMP_TSEGGUID	CHAR	22			SYSUUID_22
TSEGTP	SAP Development Reserve: Integration Date Segment (Tempate)	ITOBTMP_TSEGTEMPLA	CHAR	10	Assigned to domain	TMPLA	TSEGTEMPLA
.INCLU--AP				0
FLLB_DUTY	Logbook Duty	DIACL_DUTY	CHAR	1			XFLAG
FLLB_HIDE	Hide Logbook Display	DIACL_HIDE	CHAR	1			XFLAG
.INCLU--AP				0
IFLOT_SRTYPE	Shift Report Type for Object	ILOM_SR_SRTYPE	CHAR	10
IFLOT_SNTYPE	Notification Type for Shift Note for Object	ILOM_SN_SNTYPE	CHAR	2	TQ80		QMART
HILEV	Hierarchy Level; Above: < 0; Below: > 0	IMRC_HILEV	INT4	10			INT4

Key field

Non-key field

< IFLOT - Functional Location (Table) IFLOTX - Functional Location: Short Texts >

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

As IFLOTH 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 IFLOTH as there is no data to select.

How to access SAP table IFLOTH

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

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