SAP table IFLO (Generated Table for View)

SAP table IFLO has 3 primary key fields being MANDT,TPLNR,SPRAS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TPLNR Functional Location CHAR 30 0 TPLNR
SPRAS Language Key LANG 1 0 T002 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
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
ILOAN Location and account assignment for technical object CHAR 12 0 ILOAN
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
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
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

IFLO foreign key relationships

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