1. Home
  2. Resources
  3. SAP Tables
  4. IFLO - Generated Table for View

SAP Table IFLO

Generated Table for View

IFLO (Generated Table for View) 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 IFLO to other SAP tables.

IFLO table fields

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

IFLO foreign key relationships

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