IFLOT SAP (Functional Location (Table)) Table details

Dictionary Type: Table
Description: Functional Location (Table)




ABAP Code to SELECT data from IFLOT
Related tables to IFLOT
Access table IFLOT




Table field list including key, data, relationships and ABAP select examples

IFLOT is a standard SAP Table which is used to store Functional Location (Table) data and is available within R/3 SAP systems depending on the version and release level.

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

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = IFLOTX


SAP IFLOT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
TPLNRFunctional Location TPLNRCHAR30TPLNRTPLNRIFLIFLM
MLANGPrimary language for object texts MLANGLANG1T002ISOLASPRAS
TPLKZFunctional location structure indicator TPLKZCHAR5T370STPLKZISR
FLTYPFunctional location category FLTYPCHAR1T370FFLTYPIFT
TPLMASuperior functional location TPLMACHAR30IFLOTTPLNRTPLNRIFLM
ERDATDate on which the object was created ICRDTDATS8DATUM
ERNAMName of User Who Created the Object ICRNACHAR12USNAM
AEDATDate on which the object was last changed IUPDTDATS8DATUM
AENAMName of the user who last changed the object IUPNACHAR12USNAM
DATABStart-up Date of the Technical Object ILOM_DATABDATS8DATUM
BEGRUTechnical object authorization group IAUTGCHAR4T370BIAUTG
TRPNRReference functional location TRPNRCHAR30IRLOTTRPNRIRLIRLM
PSTAESAP Development reserve: Format CHAR, length 4 RESERVE_CHAR_004CHAR4CHAR4
STNAMSAP Development Reserve: Format CHAR, Length 12 RESERVE_CHAR_012CHAR12CHAR12
LVORMSAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001CHAR1CHAR1
SUBMTConstruction type material of the object SUBMTCHAR18MARAMATN1MATNRMAT
SUBMTIData origin for construction type field INH_SUBMTICHAR1INHER
MAPARManufacturer part number MAPARCHAR30MAPAR
MAPARISAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001CHAR1CHAR1
IEQUIInstallation of equipment allowed at the functional location IEQUICHAR1X
IEQUIIData origin for equip. inst. allowed field INH_IEQUIICHAR1INHER
EINZLSingle equipment installation at functional location EINZLCHAR1XFELD
EINZLIData origin for authorization group field INH_BEGRUICHAR1INHER
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
IWERKIData origin for planning plant field INH_IWERKICHAR1INHER
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
INGRPIData origin for maintenance planner group field INH_INGRPICHAR1INHER
PM_OBJTYObject Type of CIM Resources for Work Center PM_OBJTYCHAR2CR_OBJTY
LGWIDObject ID of the Work Center LGWIDNUMC8CRIDCR_OBJID
LGWIDIData Origin for the Field 'Work Center' INH_LGWIDICHAR1INHER
RBNRCatalog Profile RBNRCHAR9T352BRBNR
RBNR_IData origin for maintenance catalog field INH_RBNR_ICHAR1INHER
ILOANLocation and account assignment for technical object ILOANCHAR12ILOAILOAN
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
POSNRPosition in superior technical object ILOM_POSNRCHAR4CHAR4
ISTYPObject category for Industry Solutions (IS) ILOM_ISTYPCHAR1ILOM_ISTYP
PREMSPremise ILOM_PREMSCHAR10CHAR10
EQARTType of Technical Object EQARTCHAR10T370KEQART
INVNRInventory number INVNRCHAR25INVNR_ANLA
GROESSize/dimension GROSSCHAR18GROES
BRGEWGross Weight BRGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
ANSWTAcquisition Value ANSWTCURR13(2) WERT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ANSDTAcquisition date ANDTIDATS8DATUM
HERSTManufacturer of asset HERSTCHAR30TEXT30
HERLDCountry of manufacture HERLDCHAR3T005LAND1
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
BAUMMMonth of construction BAUMMCHAR2BAUMM
TYPBZManufacturer model number TYPBZCHAR20TYPBZ
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18Assigned to domainMATN1MATNRHTN
SERGEManufacturer serial number SERGECHAR30CHAR30
HANDLESAP Development Reserve: Integration of Date Segment (Key) ITOBTMP_TSEGGUIDCHAR22SYSUUID_22
TSEGTPSAP Development Reserve: Integration Date Segment (Tempate) ITOBTMP_TSEGTEMPLACHAR10Assigned to domainTMPLATSEGTEMPLA
.INCLU--AP 0
FLLB_DUTYLogbook Duty DIACL_DUTYCHAR1XFLAG
FLLB_HIDEHide Logbook Display DIACL_HIDECHAR1XFLAG
.INCLU--AP 0
IFLOT_SRTYPEShift Report Type for Object ILOM_SR_SRTYPECHAR10Assigned to domain
IFLOT_SNTYPENotification Type for Shift Note for Object ILOM_SN_SNTYPECHAR2TQ80QMART

Key field Non-key field



How do I retrieve data from SAP table IFLOT using ABAP code

The following ABAP code Example will allow you to do a basic selection on IFLOT to SELECT all data from the table
DATA: WA_IFLOT TYPE IFLOT.

SELECT SINGLE *
FROM IFLOT
INTO CORRESPONDING FIELDS OF WA_IFLOT
WHERE...

How to access SAP table IFLOT

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!