1. Home
  2. Resources
  3. SAP Tables
  4. IFLOT - Functional Location (Table)

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
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
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
X Yes
NULL No
IEQUII Data origin for equip. inst. allowed field INH_IEQUII CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EINZL Single equipment installation at functional location EINZL CHAR 1 0
X Yes
NULL No
EINZLI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IWERK Maintenance Planning Plant IWERK T399I CHAR 4 0
IWERKI Data origin for planning plant field INH_IWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
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
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
RBNR Catalog Profile RBNR T352B CHAR 9 0
RBNR_I Data origin for maintenance catalog field INH_RBNR_I CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
D Device location IS-U
C Connection object IS-U
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
00
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
NULL Blank
. Radio button
X Selection
FLLB_HIDE Hide Logbook Display DIACL_HIDE CHAR 1 0
NULL Blank
. Radio button
X Selection
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