1. Home
  2. Resources
  3. SAP Tables
  4. IFLOH - FunctLocation (View) With Hierarchy Level, TPLNR From ILOA

SAP Table IFLOH

FunctLocation (View) With Hierarchy Level, TPLNR From ILOA

IFLOH (FunctLocation (View) With Hierarchy Level, TPLNR From ILOA) 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 IFLOH to other SAP tables.

IFLOH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
SPRAS Language Key SPRAS LANG 1 0
PLTXT Description of functional location PLTXT CHAR 40 0
KZLTX Indicator: Long text exists ILOM_KZLTX CHAR 1 0
X Yes
NULL No
KZMLA Primary language indicator for text segment KZMLA CHAR 1 0
PLTXU Description of functional location in capital letters ILOM_PLTXU CHAR 40 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
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
ABCKZI Data origin for ABC indicator field INH_ABCKZI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin for sort field INH_EQFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK T001W CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Location of maintenance object PMLOC T499S CHAR 10 0
STORTI Data origin for location field INH_STORTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin for room number field INH_MSGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER T357 CHAR 3 0
BEBERI Data origin for plant section field INH_BEBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID CRID NUMC 8 0
PPSIDI Data origin for PP work center field INH_PPSIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
GSBER Business Area GSBER TGSB CHAR 4 0
GSBERI Data origin for business area field INH_GSBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOKRSI Data origin for controlling area field INH_KOKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOSTLI Data origin for cost center field INH_KOSTLI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PROIDI Data origin for WBS element field INH_PROIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS T001 CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLNRI Data origin for asset main no./sub-no. fields INH_ANLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN AUFK CHAR 12 0
DAUFNI Data origin of standing order number field INH_DAUFNI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
AUFNR Settlement order ILOM_ORDST AUFK CHAR 12 0
AUFNRI Data origin for settlement order field INH_AUFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
TPLNRI Data origin for functional location field INH_TPLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VKORG Sales Organization VKORG TVKO CHAR 4 0
VKORGI Data origin for sales organization field INH_VKORGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
VTWEGI Data origin of distribution channel field INH_VTWEGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SPART Division SPART TVTA CHAR 2 0
SPARTI Data origin for division field INH_SPARTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
HILEV Hierarchy Level; Above: < 0; Below: > 0 IMRC_HILEV INT4 10 0

IFLOH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IFLOH ABCKZ SY MANDT T370C ABC indicator for technical objects MANDT
IFLOH ABCKZ IFLOH ABCKZ T370C ABC indicator for technical objects ABCKZ
IFLOH ADRNR SY MANDT ADRC Addresses (Business Address Services) CLIENT
IFLOH ADRNR IFLOH ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
IFLOH ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
IFLOH ADRNR * ADRC Addresses (Business Address Services) NATION
IFLOH ANLNR IFLOH ANLNR ANLH Main asset number ANLN1
IFLOH ANLNR SY MANDT ANLH Main asset number MANDT
IFLOH ANLNR IFLOH BUKRS ANLH Main asset number BUKRS
IFLOH ANLUN SY MANDT ANLA Asset Master Record Segment MANDT
IFLOH ANLUN IFLOH BUKRS ANLA Asset Master Record Segment BUKRS
IFLOH ANLUN IFLOH ANLNR ANLA Asset Master Record Segment ANLN1
IFLOH ANLUN IFLOH ANLUN ANLA Asset Master Record Segment ANLN2
IFLOH AUFNR SY MANDT AUFK Order master data MANDT
IFLOH AUFNR IFLOH AUFNR AUFK Order master data AUFNR
IFLOH BEBER SY MANDT T357 Plant Section MANDT
IFLOH BEBER IFLOH SWERK T357 Plant Section WERKS
IFLOH BEBER IFLOH BEBER T357 Plant Section BEBER
IFLOH BEGRU SY MANDT T370B Technical object authorization group MANDT
IFLOH BEGRU IFLOH BEGRU T370B Technical object authorization group BEGRU
IFLOH BUKRS SY MANDT T001 Company Codes MANDT
IFLOH BUKRS IFLOH BUKRS T001 Company Codes BUKRS
IFLOH DAUFN SY MANDT AUFK Order master data MANDT
IFLOH DAUFN IFLOH DAUFN AUFK Order master data AUFNR
IFLOH EQART IFLOH EQART T370K Type of technical object EQART
IFLOH EQART SY MANDT T370K Type of technical object MANDT
IFLOH FLTYP SY MANDT T370F Functional Location Category MANDT
IFLOH FLTYP IFLOH FLTYP T370F Functional Location Category FLTYP
IFLOH GEWEI IFLOH GEWEI T006 Units of Measurement MSEHI
IFLOH GEWEI SY MANDT T006 Units of Measurement MANDT
IFLOH GSBER IFLOH GSBER TGSB Business Areas GSBER
IFLOH GSBER SY MANDT TGSB Business Areas MANDT
IFLOH HERLD SY MANDT T005 Countries MANDT
IFLOH HERLD IFLOH HERLD T005 Countries LAND1
IFLOH IFLOT_SNTYPE SYST MANDT TQ80 Notification Types MANDT
IFLOH IFLOT_SNTYPE IFLOH IFLOT_SNTYPE TQ80 Notification Types QMART
IFLOH ILOAN SY MANDT ILOA PM Object Location and Account Assignment MANDT
IFLOH ILOAN IFLOH ILOAN ILOA PM Object Location and Account Assignment ILOAN
IFLOH INGRP SY MANDT T024I Maintenance planner groups MANDT
IFLOH INGRP IFLOH IWERK T024I Maintenance planner groups IWERK
IFLOH INGRP IFLOH INGRP T024I Maintenance planner groups INGRP
IFLOH IWERK SY MANDT T399I Planning plant parameters MANDT
IFLOH IWERK IFLOH IWERK T399I Planning plant parameters IWERK
IFLOH KOKRS SY MANDT TKA01 Controlling Areas MANDT
IFLOH KOKRS IFLOH KOKRS TKA01 Controlling Areas KOKRS
IFLOH KOSTL SY MANDT CSKS Cost Center Master Data MANDT
IFLOH KOSTL IFLOH KOKRS CSKS Cost Center Master Data KOKRS
IFLOH KOSTL IFLOH KOSTL CSKS Cost Center Master Data KOSTL
IFLOH KOSTL * CSKS Cost Center Master Data DATBI
IFLOH LGWID SY MANDT CRID CIM Resource - Entities MANDT
IFLOH LGWID IFLOH PM_OBJTY CRID CIM Resource - Entities OBJTY
IFLOH LGWID IFLOH LGWID CRID CIM Resource - Entities OBJID
IFLOH MLANG IFLOH MLANG T002 Language Keys (Component BC-I18) SPRAS
IFLOH OBJNR IFLOH OBJNR ONR00 General Object Number OBJNR
IFLOH OBJNR SY MANDT ONR00 General Object Number MANDT
IFLOH PPSID IFLOH PPSID CRID CIM Resource - Entities OBJID
IFLOH PPSID SY MANDT CRID CIM Resource - Entities MANDT
IFLOH PPSID IFLOH CR_OBJTY CRID CIM Resource - Entities OBJTY
IFLOH PROID SY MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
IFLOH PROID IFLOH PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
IFLOH RBNR IFLOH RBNR T352B Technical report RBNR
IFLOH RBNR SY MANDT T352B Technical report MANDT
IFLOH SPART IFLOH SPART TVTA Organizational Unit: Sales Area(s) SPART
IFLOH SPART SY MANDT TVTA Organizational Unit: Sales Area(s) MANDT
IFLOH SPART IFLOH VKORG TVTA Organizational Unit: Sales Area(s) VKORG
IFLOH SPART IFLOH VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
IFLOH STORT SY MANDT T499S Location MANDT
IFLOH STORT IFLOH SWERK T499S Location WERKS
IFLOH STORT IFLOH STORT T499S Location STAND
IFLOH SUBMT SY MANDT MARA General Material Data MANDT
IFLOH SUBMT IFLOH SUBMT MARA General Material Data MATNR
IFLOH SWERK IFLOH SWERK T001W Plants/Branches WERKS
IFLOH SWERK SY MANDT T001W Plants/Branches MANDT
IFLOH TPLKZ SY MANDT T370S Functional Location Structure Indicators MANDT
IFLOH TPLKZ IFLOH TPLKZ T370S Functional Location Structure Indicators TPLKZ
IFLOH TPLMA IFLOH TPLMA IFLOT Functional Location (Table) TPLNR
IFLOH TPLMA SY MANDT IFLOT Functional Location (Table) MANDT
IFLOH TPLNR SY MANDT IFLOT Functional Location (Table) MANDT
IFLOH TPLNR IFLOH TPLNR IFLOT Functional Location (Table) TPLNR
IFLOH TRPNR SY MANDT IRLOT Reference Functional Location (Table) MANDT
IFLOH TRPNR IFLOH TRPNR IRLOT Reference Functional Location (Table) TRPNR
IFLOH VKBUR IFLOH VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
IFLOH VKBUR IFLOH SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
IFLOH VKBUR IFLOH VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
IFLOH VKBUR SY MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
IFLOH VKBUR IFLOH VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
IFLOH VKGRP SY MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
IFLOH VKGRP IFLOH VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
IFLOH VKGRP IFLOH VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
IFLOH VKORG SY MANDT TVKO Organizational Unit: Sales Organizations MANDT
IFLOH VKORG IFLOH VKORG TVKO Organizational Unit: Sales Organizations VKORG
IFLOH VTWEG IFLOH VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
IFLOH VTWEG IFLOH VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
IFLOH VTWEG SY MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
IFLOH WAERS SY MANDT TCURC Currency Codes MANDT
IFLOH WAERS IFLOH WAERS TCURC Currency Codes WAERS