SAP Table IFLOT
Functional Location (Table)
IFLOT (Functional Location (Table)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link IFLOT to other SAP tables.
IFLOT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
TPLNR
Functional Location
|
TPLNR |
CHAR
|
30 | 0 | ||||||||||||
|
MLANG
Primary language for object texts
|
MLANG | T002 |
LANG
|
1 | 0 | |||||||||||
|
TPLKZ
Functional location structure indicator
|
TPLKZ | T370S |
CHAR
|
5 | 0 | |||||||||||
|
FLTYP
Functional location category
|
FLTYP | T370F |
CHAR
|
1 | 0 | |||||||||||
|
TPLMA
Superior functional location
|
TPLMA | IFLOT |
CHAR
|
30 | 0 | |||||||||||
|
ERDAT
Date on which the object was created
|
ICRDT |
DATS
|
8 | 0 | ||||||||||||
|
ERNAM
Name of User Who Created the Object
|
ICRNA |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Date on which the object was last changed
|
IUPDT |
DATS
|
8 | 0 | ||||||||||||
|
AENAM
Name of the user who last changed the object
|
IUPNA |
CHAR
|
12 | 0 | ||||||||||||
|
DATAB
Start-up Date of the Technical Object
|
ILOM_DATAB |
DATS
|
8 | 0 | ||||||||||||
|
BEGRU
Technical object authorization group
|
IAUTG | T370B |
CHAR
|
4 | 0 | |||||||||||
|
TRPNR
Reference functional location
|
TRPNR | IRLOT |
CHAR
|
30 | 0 | |||||||||||
|
PSTAE
SAP Development reserve: Format CHAR, length 4
|
RESERVE_CHAR_004 |
CHAR
|
4 | 0 | ||||||||||||
|
STNAM
SAP Development Reserve: Format CHAR, Length 12
|
RESERVE_CHAR_012 |
CHAR
|
12 | 0 | ||||||||||||
|
LVORM
SAP Development Reserve: Format CHAR, Length 1
|
RESERVE_CHAR_001 |
CHAR
|
1 | 0 | ||||||||||||
|
SUBMT
Construction type material of the object
|
SUBMT | MARA |
CHAR
|
18 | 0 | |||||||||||
|
SUBMTI
Data origin for construction type field
|
INH_SUBMTI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MAPAR
Manufacturer part number
|
MAPAR |
CHAR
|
30 | 0 | ||||||||||||
|
MAPARI
SAP Development Reserve: Format CHAR, Length 1
|
RESERVE_CHAR_001 |
CHAR
|
1 | 0 | ||||||||||||
|
IEQUI
Installation of equipment allowed at the functional location
|
IEQUI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IEQUII
Data origin for equip. inst. allowed field
|
INH_IEQUII |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
EINZL
Single equipment installation at functional location
|
EINZL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
EINZLI
Data origin for authorization group field
|
INH_BEGRUI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T399I |
CHAR
|
4 | 0 | |||||||||||
|
IWERKI
Data origin for planning plant field
|
INH_IWERKI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
INGRP
Planner Group for Customer Service and Plant Maintenance
|
INGRP | T024I |
CHAR
|
3 | 0 | |||||||||||
|
INGRPI
Data origin for maintenance planner group field
|
INH_INGRPI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PM_OBJTY
Object Type of CIM Resources for Work Center
|
PM_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
LGWID
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
LGWIDI
Data Origin for the Field 'Work Center'
|
INH_LGWIDI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
RBNR
Catalog Profile
|
RBNR | T352B |
CHAR
|
9 | 0 | |||||||||||
|
RBNR_I
Data origin for maintenance catalog field
|
INH_RBNR_I |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ILOAN
Location and account assignment for technical object
|
ILOAN | ILOA |
CHAR
|
12 | 0 | |||||||||||
|
OBJNR
Object number
|
J_OBJNR | ONR00 |
CHAR
|
22 | 0 | |||||||||||
|
POSNR
Position in superior technical object
|
ILOM_POSNR |
CHAR
|
4 | 0 | ||||||||||||
|
ISTYP
Object category for Industry Solutions (IS)
|
ILOM_ISTYP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PREMS
Premise
|
ILOM_PREMS |
CHAR
|
10 | 0 | ||||||||||||
|
EQART
Type of Technical Object
|
EQART | T370K |
CHAR
|
10 | 0 | |||||||||||
|
INVNR
Inventory number
|
INVNR |
CHAR
|
25 | 0 | ||||||||||||
|
GROES
Size/dimension
|
GROSS |
CHAR
|
18 | 0 | ||||||||||||
|
BRGEW
Gross Weight
|
BRGEW |
QUAN
|
13 | 3 | ||||||||||||
|
GEWEI
Weight Unit
|
GEWEI | T006 |
UNIT
|
3 | 0 | |||||||||||
|
ANSWT
Acquisition Value
|
ANSWT |
CURR
|
13 | 2 | ||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
ANSDT
Acquisition date
|
ANDTI |
DATS
|
8 | 0 | ||||||||||||
|
HERST
Manufacturer of asset
|
HERST |
CHAR
|
30 | 0 | ||||||||||||
|
HERLD
Country of manufacture
|
HERLD | T005 |
CHAR
|
3 | 0 | |||||||||||
|
BAUJJ
Year of construction
|
BAUJJ |
CHAR
|
4 | 0 | ||||||||||||
|
BAUMM
Month of construction
|
BAUMM |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
TYPBZ
Manufacturer model number
|
TYPBZ |
CHAR
|
20 | 0 | ||||||||||||
|
EMATN
Material Number Corresponding to Manufacturer Part Number
|
EMATN |
CHAR
|
18 | 0 | ||||||||||||
|
SERGE
Manufacturer serial number
|
SERGE |
CHAR
|
30 | 0 | ||||||||||||
|
HANDLE
SAP Development Reserve: Integration of Date Segment (Key)
|
ITOBTMP_TSEGGUID |
CHAR
|
22 | 0 | ||||||||||||
|
TSEGTP
SAP Development Reserve: Integration Date Segment (Tempate)
|
ITOBTMP_TSEGTEMPLA |
CHAR
|
10 | 0 | ||||||||||||
|
FLLB_DUTY
Logbook Duty
|
DIACL_DUTY |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FLLB_HIDE
Hide Logbook Display
|
DIACL_HIDE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IFLOT_SRTYPE
Shift Report Type for Object
|
ILOM_SR_SRTYPE |
CHAR
|
10 | 0 | ||||||||||||
|
IFLOT_SNTYPE
Notification Type for Shift Note for Object
|
ILOM_SN_SNTYPE | TQ80 |
CHAR
|
2 | 0 | |||||||||||
IFLOT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| IFLOT | BEGRU | IFLOT | MANDT |
T370B
Technical object authorization group
|
MANDT |
| IFLOT | BEGRU | IFLOT | BEGRU |
T370B
Technical object authorization group
|
BEGRU |
| IFLOT | EQART | SY | MANDT |
T370K
Type of technical object
|
MANDT |
| IFLOT | EQART | IFLOT | EQART |
T370K
Type of technical object
|
EQART |
| IFLOT | FLTYP | IFLOT | FLTYP |
T370F
Functional Location Category
|
FLTYP |
| IFLOT | FLTYP | IFLOT | MANDT |
T370F
Functional Location Category
|
MANDT |
| IFLOT | GEWEI | SY | MANDT |
T006
Units of Measurement
|
MANDT |
| IFLOT | GEWEI | IFLOT | GEWEI |
T006
Units of Measurement
|
MSEHI |
| IFLOT | HERLD | IFLOT | HERLD |
T005
Countries
|
LAND1 |
| IFLOT | HERLD | SY | MANDT |
T005
Countries
|
MANDT |
| IFLOT | IFLOT_SNTYPE | SYST | MANDT |
TQ80
Notification Types
|
MANDT |
| IFLOT | IFLOT_SNTYPE | IFLOT | IFLOT_SNTYPE |
TQ80
Notification Types
|
QMART |
| IFLOT | ILOAN | IFLOT | ILOAN |
ILOA
PM Object Location and Account Assignment
|
ILOAN |
| IFLOT | ILOAN | IFLOT | MANDT |
ILOA
PM Object Location and Account Assignment
|
MANDT |
| IFLOT | INGRP | IFLOT | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| IFLOT | INGRP | IFLOT | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| IFLOT | INGRP | IFLOT | INGRP |
T024I
Maintenance planner groups
|
INGRP |
| IFLOT | IWERK | IFLOT | MANDT |
T399I
Planning plant parameters
|
MANDT |
| IFLOT | IWERK | IFLOT | IWERK |
T399I
Planning plant parameters
|
IWERK |
| IFLOT | LGWID | IFLOT | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| IFLOT | LGWID | IFLOT | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| IFLOT | LGWID | IFLOT | LGWID |
CRID
CIM Resource - Entities
|
OBJID |
| IFLOT | MANDT | IFLOT | MANDT |
T000
Clients
|
MANDT |
| IFLOT | MLANG | IFLOT | MLANG |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| IFLOT | OBJNR | IFLOT | MANDT |
ONR00
General Object Number
|
MANDT |
| IFLOT | OBJNR | IFLOT | OBJNR |
ONR00
General Object Number
|
OBJNR |
| IFLOT | RBNR | IFLOT | MANDT |
T352B
Technical report
|
MANDT |
| IFLOT | RBNR | IFLOT | RBNR |
T352B
Technical report
|
RBNR |
| IFLOT | SUBMT | IFLOT | MANDT |
MARA
General Material Data
|
MANDT |
| IFLOT | SUBMT | IFLOT | SUBMT |
MARA
General Material Data
|
MATNR |
| IFLOT | TPLKZ | IFLOT | MANDT |
T370S
Functional Location Structure Indicators
|
MANDT |
| IFLOT | TPLKZ | IFLOT | TPLKZ |
T370S
Functional Location Structure Indicators
|
TPLKZ |
| IFLOT | TPLMA | IFLOT | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| IFLOT | TPLMA | IFLOT | TPLMA |
IFLOT
Functional Location (Table)
|
TPLNR |
| IFLOT | TRPNR | IFLOT | MANDT |
IRLOT
Reference Functional Location (Table)
|
MANDT |
| IFLOT | TRPNR | IFLOT | TRPNR |
IRLOT
Reference Functional Location (Table)
|
TRPNR |
| IFLOT | WAERS | SY | MANDT |
TCURC
Currency Codes
|
MANDT |
| IFLOT | WAERS | IFLOT | WAERS |
TCURC
Currency Codes
|
WAERS |