IFLOT is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Functional Location (Table) data. There are total 59 fields in the table. The IFLOT table can be found in the Application Development R/3 Location Management (ILOM) package and is part of the Functional Locations (PM-EQM-FL) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
IFLOT Table Fields
The following is the list of fields that are available in SAP IFLOT table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| TPLNR | Functional Location | TPLNR | TPLNR | CHAR | 30 | |
| MLANG | Primary language for object texts | MLANG | SPRAS | T002 | LANG | 1 |
| TPLKZ | Functional Location Structure Indicator | TPLKZ | TPLKZ | T370S | CHAR | 5 |
| FLTYP | Functional location category | FLTYP | FLTYP | T370F | CHAR | 1 |
| TPLMA | Superior functional location | TPLMA | TPLNR | IFLOT | CHAR | 30 |
| ERDAT | Date on which the object was created | ICRDT | DATUM | DATS | 8 | |
| ERNAM | Name of User Who Created the Object | ICRNA | USNAM | CHAR | 12 | |
| AEDAT | Date on which the object was last changed | IUPDT | DATUM | DATS | 8 | |
| AENAM | Name of the user who last changed the object | IUPNA | USNAM | CHAR | 12 | |
| DATAB | Start-up Date of the Technical Object | ILOM_DATAB | DATUM | DATS | 8 | |
| BEGRU | Technical object authorization group | IAUTG | IAUTG | T370B | CHAR | 4 |
| TRPNR | Reference functional location | TRPNR | TRPNR | IRLOT | CHAR | 30 |
| PSTAE | SAP Development reserve: Format CHAR, length 4 | RESERVE_CHAR_004 | CHAR4 | CHAR | 4 | |
| STNAM | SAP Development Reserve: Format CHAR, Length 12 | RESERVE_CHAR_012 | CHAR12 | CHAR | 12 | |
| LVORM | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | |
| SUBMT | Construction type material of the object | SUBMT | MATNR | MARA | CHAR | 40 |
| SUBMTI | Data origin for construction type field | INH_SUBMTI | INHER | CHAR | 1 | |
| MAPAR | Manufacturer part number | MAPAR | MAPAR | CHAR | 30 | |
| MAPARI | SAP Development Reserve: Format CHAR, Length 1 | RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | |
| IEQUI | Installation of equipment allowed at the functional location | IEQUI | X | CHAR | 1 | |
| IEQUII | Data origin for equip. inst. allowed field | INH_IEQUII | INHER | CHAR | 1 | |
| EINZL | Single equipment installation at functional location | EINZL | XFELD | CHAR | 1 | |
| EINZLI | Data origin for authorization group field | INH_BEGRUI | INHER | CHAR | 1 | |
| IWERK | Maintenance Planning Plant | IWERK | WERKS | T399I | CHAR | 4 |
| IWERKI | Data origin for planning plant field | INH_IWERKI | INHER | CHAR | 1 | |
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | INGRP | T024I | CHAR | 3 |
| INGRPI | Data origin for maintenance planner group field | INH_INGRPI | INHER | CHAR | 1 | |
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CR_OBJTY | CHAR | 2 | |
| LGWID | Object ID of the Work Center | LGWID | CR_OBJID | CRID | NUMC | 8 |
| LGWIDI | Data Origin for the Field ‘Work Center’ | INH_LGWIDI | INHER | CHAR | 1 | |
| RBNR | Catalog Profile | RBNR | RBNR | T352B | CHAR | 9 |
| RBNR_I | Data origin for maintenance catalog field | INH_RBNR_I | INHER | CHAR | 1 | |
| ILOAN | Location and account assignment for technical object | ILOAN | ILOAN | ILOA | CHAR | 12 |
| OBJNR | Object number | J_OBJNR | J_OBJNR | ONR00 | CHAR | 22 |
| POSNR | Position in superior technical object | ILOM_POSNR | CHAR4 | CHAR | 4 | |
| ISTYP | Object category for Industry Solutions (IS) | ILOM_ISTYP | ILOM_ISTYP | CHAR | 1 | |
| PREMS | Premise | ILOM_PREMS | CHAR10 | CHAR | 10 | |
| EQART | Type of Technical Object | EQART | EQART | T370K | CHAR | 10 |
| INVNR | Inventory number | INVNR | INVNR_ANLA | CHAR | 25 | |
| GROES | Size/dimension | GROSS | GROES | CHAR | 18 | |
| BRGEW | Gross weight | BRGEW | MENG13 | QUAN | 13 | |
| GEWEI | Weight Unit | GEWEI | MEINS | T006 | UNIT | 3 |
| ANSWT | Acquisition Value | ANSWT | WERT | CURR | 13 | |
| WAERS | Currency Key | WAERS | WAERS | TCURC | CUKY | 5 |
| ANSDT | Acquisition date | ANDTI | DATUM | DATS | 8 | |
| HERST | Manufacturer of Asset | HERST | TEXT30 | CHAR | 30 | |
| HERLD | Country of manufacture | HERLD | LAND1 | T005 | CHAR | 3 |
| BAUJJ | Year of construction | BAUJJ | CJAHR | CHAR | 4 | |
| BAUMM | Month of construction | BAUMM | BAUMM | CHAR | 2 | |
| TYPBZ | Manufacturer model number | TYPBZ | TYPBZ | CHAR | 20 | |
| EMATN | Material number corresponding to manufacturer part number | EMATN | MATNR | * | CHAR | 40 |
| SERGE | Manufacturer serial number | SERGE | CHAR30 | CHAR | 30 | |
| HANDLE | SAP Development Reserve: Integration of Date Segment (Key) | ITOBTMP_TSEGGUID | SYSUUID_22 | CHAR | 22 | |
| TSEGTP | SAP Development Reserve: Integration Date Segment (Tempate) | ITOBTMP_TSEGTEMPLA | TSEGTEMPLA | * | CHAR | 10 |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS | DEC | 15 | |
| FLLB_DUTY | Logbook Duty | DIACL_DUTY | XFLAG | CHAR | 1 | |
| FLLB_HIDE | Hide Logbook Display | DIACL_HIDE | XFLAG | CHAR | 1 | |
| IFLOT_SNTYPE | Notification Type for Shift Note for Object | ILOM_SN_SNTYPE | QMART | TQ80 | CHAR | 2 |
Availability
The SAP HANA table IFLOT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for IFLOT table
We’re updating the content all the time, so check back regularly.
