IFLOT table in SAP ERP or S/4HANA stores Functional Location (Table) data. There are total 59 fields in IFLOT table. The Functional Location (Table) table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of IFLOT table. It is in Application Development R/3 Location Management (ILOM) ABAP package and is part of the Functional Locations (PM-EQM-FL) module.
SAP IFLOT Table Fields
Following is the list of fields that are available in SAP IFLOT table. The primary key fields of Functional Location (Table) table in SAP are MANDT (Client), TPLNR (Functional Location).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| TPLNR | Functional Location | TPLNR | CHAR(30) | |
| MLANG | Primary language for object texts | MLANG | T002 | LANG(1) |
| TPLKZ | Functional Location Structure Indicator | TPLKZ | T370S | CHAR(5) |
| FLTYP | Functional location category | FLTYP | T370F | CHAR(1) |
| TPLMA | Superior functional location | TPLMA | IFLOT | CHAR(30) |
| ERDAT | Date on which the object was created | ICRDT | DATS(8) | |
| ERNAM | Name of User Who Created the Object | ICRNA | CHAR(12) | |
| AEDAT | Date on which the object was last changed | IUPDT | DATS(8) | |
| AENAM | Name of the user who last changed the object | IUPNA | CHAR(12) | |
| DATAB | Start-up Date of the Technical Object | ILOM_DATAB | DATS(8) | |
| BEGRU | Technical object authorization group | IAUTG | T370B | CHAR(4) |
| TRPNR | Reference functional location | TRPNR | IRLOT | CHAR(30) |
| PSTAE | SAP Development reserve: Format CHAR, length 4 | RESERVE_CHAR_004 | CHAR(4) | |
| STNAM | SAP Development Reserve: Format CHAR, Length 12 | RESERVE_CHAR_012 | CHAR(12) | |
| LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR(1) | |
| SUBMT | Construction type material of the object | SUBMT | MARA | CHAR(40) |
| SUBMTI | Data origin for construction type field | INH_SUBMTI | CHAR(1) | |
| MAPAR | Manufacturer part number | MAPAR | CHAR(30) | |
| MAPARI | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR(1) | |
| IEQUI | Installation of equipment allowed at the functional location | IEQUI | CHAR(1) | |
| IEQUII | Data origin for equip. inst. allowed field | INH_IEQUII | CHAR(1) | |
| EINZL | Single equipment installation at functional location | EINZL | CHAR(1) | |
| EINZLI | Data origin for authorization group field | INH_BEGRUI | CHAR(1) | |
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR(4) |
| IWERKI | Data origin for planning plant field | INH_IWERKI | CHAR(1) | |
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR(3) |
| INGRPI | Data origin for maintenance planner group field | INH_INGRPI | CHAR(1) | |
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR(2) | |
| LGWID | Object ID of the Work Center | LGWID | CRID | NUMC(8) |
| LGWIDI | Data Origin for the Field ‘Work Center’ | INH_LGWIDI | CHAR(1) | |
| RBNR | Catalog Profile | RBNR | T352B | CHAR(9) |
| RBNR_I | Data origin for maintenance catalog field | INH_RBNR_I | CHAR(1) | |
| ILOAN | Location and account assignment for technical object | ILOAN | ILOA | CHAR(12) |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR(22) |
| POSNR | Position in superior technical object | ILOM_POSNR | CHAR(4) | |
| ISTYP | Object category for Industry Solutions (IS) | ILOM_ISTYP | CHAR(1) | |
| PREMS | Premise | ILOM_PREMS | CHAR(10) | |
| EQART | Type of Technical Object | EQART | T370K | CHAR(10) |
| INVNR | Inventory number | INVNR | CHAR(25) | |
| GROES | Size/dimension | GROSS | CHAR(18) | |
| BRGEW | Gross weight | BRGEW | QUAN(13) | |
| GEWEI | Weight Unit | GEWEI | T006 | UNIT(3) |
| ANSWT | Acquisition Value | ANSWT | CURR(13) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY(5) |
| ANSDT | Acquisition date | ANDTI | DATS(8) | |
| HERST | Manufacturer of Asset | HERST | CHAR(30) | |
| HERLD | Country of manufacture | HERLD | T005 | CHAR(3) |
| BAUJJ | Year of construction | BAUJJ | CHAR(4) | |
| BAUMM | Month of construction | BAUMM | CHAR(2) | |
| TYPBZ | Manufacturer model number | TYPBZ | CHAR(20) | |
| EMATN | Material number corresponding to manufacturer part number | EMATN | * | CHAR(40) |
| SERGE | Manufacturer serial number | SERGE | CHAR(30) | |
| HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | ITOBTMP_TSEGGUID | CHAR(22) | |
| TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | ITOBTMP_TSEGTEMPLA | * | CHAR(10) |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC(15) | |
| FLLB_DUTY | Logbook Duty | DIACL_DUTY | CHAR(1) | |
| FLLB_HIDE | Hide Logbook Display | DIACL_HIDE | CHAR(1) | |
| IFLOT_SNTYPE | Notification Type for Shift Note for Object | ILOM_SN_SNTYPE | TQ80 | CHAR(2) |
