SAP table IFLOH (FunctLocation (View) With Hierarchy Level, TPLNR From ILOA)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
SPRAS Language Key LANG 1 0 SPRAS
PLTXT Description of functional location CHAR 40 0 PLTXT
KZLTX Long Text Exists CHAR 1 0 ILOM_KZLTX
KZMLA Primary language indicator for text segment CHAR 1 0 KZMLA
PLTXU Description of functional location in capital letters CHAR 40 0 ILOM_PLTXU
TEXTCHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
MLANG Primary language for object texts LANG 1 0 T002 MLANG
TPLKZ Functional Location Structure Indicator CHAR 5 0 T370S TPLKZ
FLTYP Functional location category CHAR 1 0 T370F FLTYP
TPLMA Superior functional location CHAR 30 0 IFLOT TPLMA
ERDAT Date on which the object was created DATS 8 0 ICRDT
ERNAM Name of User Who Created the Object CHAR 12 0 ICRNA
AEDAT Date on which the object was last changed DATS 8 0 IUPDT
AENAM Name of the user who last changed the object CHAR 12 0 IUPNA
DATAB Start-up Date of the Technical Object DATS 8 0 ILOM_DATAB
BEGRU Technical Object Authorization Group CHAR 4 0 T370B IAUTG
TRPNR Reference functional location CHAR 30 0 IRLOT TRPNR
PSTAE SAP Development reserve: Format CHAR, length 4 CHAR 4 0 RESERVE_CHAR_004
STNAM SAP Development Reserve: Format CHAR, Length 12 CHAR 12 0 RESERVE_CHAR_012
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR 1 0 RESERVE_CHAR_001
SUBMT Construction type material of the object CHAR 40 0 MARA SUBMT
SUBMTI Data origin for construction type field CHAR 1 0 INH_SUBMTI
MAPAR Manufacturer part number CHAR 30 0 MAPAR
MAPARI SAP Development Reserve: Format CHAR, Length 1 CHAR 1 0 RESERVE_CHAR_001
IEQUI Installation of equipment allowed at the functional location CHAR 1 0 IEQUI
IEQUII Data origin for equip. inst. allowed field CHAR 1 0 INH_IEQUII
EINZL Single equipment installation at functional location CHAR 1 0 EINZL
EINZLI Data origin for authorization group field CHAR 1 0 INH_BEGRUI
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
IWERKI Data origin for planning plant field CHAR 1 0 INH_IWERKI
INGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
INGRPI Data origin for maintenance planner group field CHAR 1 0 INH_INGRPI
PM_OBJTY Object Type of CIM Resources for Work Center CHAR 2 0 PM_OBJTY
LGWID Object ID of the Work Center NUMC 8 0 CRID LGWID
LGWIDI Data Origin for the Field 'Work Center' CHAR 1 0 INH_LGWIDI
RBNR Catalog Profile CHAR 9 0 T352B RBNR
RBNR_I Data origin for maintenance catalog field CHAR 1 0 INH_RBNR_I
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
POSNR Position in superior technical object CHAR 4 0 ILOM_POSNR
ISTYP Object category for Industry Solutions (IS) CHAR 1 0 ILOM_ISTYP
C Connection object IS-U
D Device location IS-U
PREMS Premise CHAR 10 0 ILOM_PREMS
EQART Type of Technical Object CHAR 10 0 T370K EQART
INVNR Inventory number CHAR 25 0 INVNR
GROES Size/dimension CHAR 18 0 GROSS
BRGEW Gross weight QUAN 13 3 BRGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
ANSWT Acquisition Value CURR 13 2 ANSWT
WAERS Currency Key CUKY 5 0 TCURC WAERS
ANSDT Acquisition date DATS 8 0 ANDTI
HERST Manufacturer of Asset CHAR 30 0 HERST
HERLD Country/Region of Manufacture CHAR 3 0 T005 HERLD
BAUJJ Year of construction CHAR 4 0 BAUJJ
BAUMM Month of construction CHAR 2 0 BAUMM
00
TYPBZ Manufacturer model number CHAR 20 0 TYPBZ
EMATN Material number corresponding to manufacturer part number CHAR 40 0 * EMATN
SERGE Manufacturer's Serial Number CHAR 30 0 SERGE
HANDLE SAP Development Reserve: Integration of Date Segment (Key) CHAR 22 0 ITOBTMP_TSEGGUID
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) CHAR 10 0 * ITOBTMP_TSEGTEMPLA
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
ENDOFUSE End-of-Use Date of the Technical Object DATS 8 0 ENDOFUSE_DATE
DUMMY_IFLOT_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
FLLB_DUTY Logbook Duty CHAR 1 0 DIACL_DUTY
FLLB_HIDE Hide Logbook Display CHAR 1 0 DIACL_HIDE
IFLOT_SRTYPE Shift Report Type for Object CHAR 10 0 ILOM_SR_SRTYPE
IFLOT_SNTYPE Notification Type for Shift Note for Object CHAR 2 0 TQ80 ILOM_SN_SNTYPE
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
ABCKZ ABC Indicator for Technical Object CHAR 1 0 T370C ABCKZ
ABCKZI Data origin for ABC indicator field CHAR 1 0 INH_ABCKZI
EQFNR Sort Field CHAR 30 0 EQFNR
EQFNRI Data origin for sort field CHAR 1 0 INH_EQFNRI
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
SWERKI Data origin for maintenance plant field CHAR 1 0 INH_SWERKI
STORT Location of maintenance object CHAR 10 0 T499S PMLOC
STORTI Data origin for location field CHAR 1 0 INH_STORTI
MSGRP Room CHAR 8 0 RAUMNR
MSGRPI Data origin for room number field CHAR 1 0 INH_MSGRPI
BEBER Plant Section CHAR 3 0 T357 BEBER
BEBERI Data origin for plant section field CHAR 1 0 INH_BEBERI
CR_OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
PPSID Object ID of PP work center NUMC 8 0 CRID PPSID
PPSIDI Data origin for PP work center field CHAR 1 0 INH_PPSIDI
GSBER Business Area CHAR 4 0 TGSB GSBER
GSBERI Data origin for business area field CHAR 1 0 INH_GSBERI
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOKRSI Data origin for controlling area field CHAR 1 0 INH_KOKRSI
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KOSTLI Data origin for cost center field CHAR 1 0 INH_KOSTLI
PROID Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
PROIDI Data origin for WBS element field CHAR 1 0 INH_PROIDI
BUKRS Company Code CHAR 4 0 T001 BUKRS
BUKRSI Data origin for company code field CHAR 1 0 INH_BUKRSI
ANLNR Main Asset Number CHAR 12 0 ANLH ANLN1
ANLNRI Data origin for asset main no./sub-no. fields CHAR 1 0 INH_ANLNRI
ANLUN Asset Subnumber CHAR 4 0 ANLA ANLN2
ANLUNI Data origin indicator CHAR 1 0 INHER
D Field maintained directly. No data transfer
H Data transfer from superior object
R Data transfer from reference object
DAUFN Standing order number CHAR 12 0 AUFK DAUFN
DAUFNI Data origin of standing order number field CHAR 1 0 INH_DAUFNI
AUFNR Settlement order CHAR 12 0 AUFK ILOM_ORDST
AUFNRI Data origin for settlement order field CHAR 1 0 INH_AUFNRI
TPLNRI Data origin for functional location field CHAR 1 0 INH_TPLNRI
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VKORGI Data origin for sales organization field CHAR 1 0 INH_VKORGI
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
VTWEGI Data origin of distribution channel field CHAR 1 0 INH_VTWEGI
SPART Division CHAR 2 0 TVTA SPART
SPARTI Data origin for division field CHAR 1 0 INH_SPARTI
ADRNR Address Number CHAR 10 0 ADRC AD_ADDRNUM
ADRNRI Data origin for address field CHAR 1 0 INH_ADRNRI
OWNER Object reference indicator CHAR 1 0 ILOM_OWNER
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 CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
HILEV Hierarchy Level; Above: < 0; Below: > 0 INT4 10 0 IMRC_HILEV

IFLOH foreign key relationships

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