IFLOT_VS

Functional Location (Version Table) | #masterdata | Component: Functional Locations
Column Name Description
MANDT FK Client
VSNMR Number or description of a version
TPLNR Functional Location
Column Name Description
💲 Currency Key (WAERS):
ANSWT Acquisition Value
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
Column Name Description
ERDAT Date on which the object was created
AEDAT Date on which the object was last changed
DATAB Start-up Date of the Technical Object
ANSDT Acquisition date
ENDOFUSE End-of-Use Date of the Technical Object
Column Name Description
SUBMTI Data origin for construction type field Show values
IEQUI Installation of equipment allowed at the functional location Show values
IEQUII Data origin for equip. inst. allowed field Show values
EINZL Single equipment installation at functional location Show values
EINZLI Data origin for authorization group field Show values
IWERKI Data origin for planning plant field Show values
INGRPI Data origin for maintenance planner group field Show values
PM_OBJTY Object Type of CIM Resources for Work Center Show values
LGWIDI Data Origin for the Field 'Work Center' Show values
RBNR_I Data origin for maintenance catalog field Show values
ISTYP Object category for Industry Solutions (IS) Show values
BAUMM Month of construction Show values
FLLB_DUTY Logbook Duty Show values
FLLB_HIDE Hide Logbook Display Show values
Column Name Description Domain name
ERNAM Name of User Who Created the Object USNAM
AENAM Name of the user who last changed the object USNAM
PSTAE SAP Development reserve: Format CHAR, length 4 CHAR4
STNAM SAP Development Reserve: Format CHAR, Length 12 CHAR12
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR1
MAPAR Manufacturer part number MAPAR
MAPARI SAP Development Reserve: Format CHAR, Length 1 CHAR1
POSNR Position in superior technical object CHAR4
PREMS Premise CHAR10
INVNR Inventory number INVNR_ANLA
GROES Size/dimension GROES
HERST Manufacturer of Asset TEXT30
BAUJJ Year of construction CJAHR
TYPBZ Manufacturer model number TYPBZ
EMATN Material number corresponding to manufacturer part number MATNR
SERGE Manufacturer's Serial Number CHAR30
HANDLE SAP Development Reserve: Integration of Date Segment (Key) SYSUUID_22
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) TSEGTEMPLA
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
DUMMY_IFLOT_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
IFLOT_SRTYPE Shift Report Type for Object
Master Data Relations | to Other Relations ↓ Join Conditions
Technical Object Authorization Group
  • IFLOT_VS.MANDT == T370B.MANDT
  • IFLOT_VS.BEGRU == T370B.BEGRU
Type of Technical Object
  • IFLOT_VS.MANDT == T370K.MANDT
  • IFLOT_VS.EQART == T370K.EQART
Functional location category
  • IFLOT_VS.MANDT == T370F.MANDT
  • IFLOT_VS.FLTYP == T370F.FLTYP
Weight Unit
  • IFLOT_VS.MANDT == T006.MANDT
  • IFLOT_VS.GEWEI == T006.MSEHI
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • IFLOT_VS.HERLD == T005.LAND1
  • IFLOT_VS.MANDT == T005.MANDT
Notification Type for Shift Note for Object
  • IFLOT_VS.MANDT == TQ80.MANDT
  • IFLOT_VS.IFLOT_SNTYPE == TQ80.QMART
Location and account assignment for technical object
  • IFLOT_VS.MANDT == ILOA.MANDT
  • IFLOT_VS.ILOAN == ILOA.ILOAN
Object ID of the Work Center
  • Object ID of the Work Center
  • Object Type of CIM Resources for Work Center
  • Client
  • IFLOT_VS.LGWID == CRID.OBJID
  • IFLOT_VS.PM_OBJTY == CRID.OBJTY
  • IFLOT_VS.MANDT == CRID.MANDT
Client IFLOT_VS.MANDT == T000.MANDT
Primary language for object texts IFLOT_VS.MLANG == T002.SPRAS
Catalog Profile
  • IFLOT_VS.MANDT == T352B.MANDT
  • IFLOT_VS.RBNR == T352B.RBNR
Construction type material of the object
  • Construction type material of the object
  • Client
  • IFLOT_VS.SUBMT == MARA.MATNR
  • IFLOT_VS.MANDT == MARA.MANDT
Functional Location Structure Indicator
  • IFLOT_VS.MANDT == T370S.MANDT
  • IFLOT_VS.TPLKZ == T370S.TPLKZ
Superior functional location
  • IFLOT_VS.MANDT == IFLOT.MANDT
  • IFLOT_VS.TPLMA == IFLOT.TPLNR
Reference functional location
  • Reference functional location
  • Client
  • IFLOT_VS.TRPNR == IRLOT.TRPNR
  • IFLOT_VS.MANDT == IRLOT.MANDT
Currency Key
  • IFLOT_VS.MANDT == TCURC.MANDT
  • IFLOT_VS.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • IFLOT_VS.MANDT == T024I.MANDT
  • IFLOT_VS.IWERK == T024I.IWERK
  • IFLOT_VS.INGRP == T024I.INGRP
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • IFLOT_VS.IWERK == T399I.IWERK
  • IFLOT_VS.MANDT == T399I.MANDT