I_FunctionalLocation

Functional Location | view: IFUNCTLLOCATION | ATTR | Extraction: Not supported | Component: Functional Locations
Tables used: IFLOT
Column Name Description
FunctionalLocation Functional Location
Column Name Description
💲 Currency Key (Currency):
AcquisitionValue Acquisition Value
Column Name Description
📏 Weight Unit (GrossWeightUnit):
GrossWeight Gross weight
Column Name Description
CreationDate Date on which the object was created
LastChangeDate Date on which the object was last changed
AcquisitionDate Acquisition date
OperationStartDate Start-up Date of the Technical Object
Column Name Description
WorkCenterTypeCode Object Type of CIM Resources for Work Center Show values
ConstructionMonth Month of construction Show values
EquipmentInstallationIsAllowed Installation of equipment allowed at the functional location Show values
OnePieceOfEquipmentIsAllowed Single equipment installation at functional location Show values
Column Name Description Domain name
CreatedByUser Name of User Who Created the Object USNAM
LastChangedByUser Name of the user who last changed the object USNAM
AssetManufacturerName Manufacturer of Asset TEXT30
ManufacturerPartTypeName Manufacturer model number TYPBZ
ConstructionYear Year of construction CJAHR
FuncnlLocPosInSuperiorTechObj Position in superior technical object CHAR4
ManufacturerPartNmbr Manufacturer part number MAPAR
ManufacturerSerialNumber Manufacturer's Serial Number CHAR30
InventoryNumber Inventory number INVNR_ANLA
SizeOrDimensionText Size/dimension GROES
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations | to Other Relations ↓ Join Conditions
Technical Object Authorization Group
  • Client
  • Technical Object Authorization Group
  • I_FUNCTIONALLOCATION.MANDT == T370B.MANDT
  • I_FUNCTIONALLOCATION.AUTHORIZATIONGROUP == T370B.BEGRU
Catalog Profile
  • Client
  • Catalog Profile
  • I_FUNCTIONALLOCATION.MANDT == T352B.MANDT
  • I_FUNCTIONALLOCATION.CATALOGPROFILE == T352B.RBNR
Construction type material of the object
  • Client
  • Construction type material of the object
  • I_FUNCTIONALLOCATION.MANDT == MARA.MANDT
  • I_FUNCTIONALLOCATION.CONSTRUCTIONMATERIAL == MARA.MATNR
Currency Key
  • Client
  • Currency Key
  • I_FUNCTIONALLOCATION.MANDT == TCURC.MANDT
  • I_FUNCTIONALLOCATION.CURRENCY == TCURC.WAERS
Functional Location Structure Indicator
  • Client
  • Functional Location Structure Indicator
  • I_FUNCTIONALLOCATION.MANDT == T370S.MANDT
  • I_FUNCTIONALLOCATION.FUNCLOCATIONSTRUCTURE == T370S.TPLKZ
Functional location category
  • Client
  • Functional location category
  • I_FUNCTIONALLOCATION.MANDT == T370F.MANDT
  • I_FUNCTIONALLOCATION.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
Weight Unit
  • Client
  • Weight Unit
  • I_FUNCTIONALLOCATION.MANDT == T006.MANDT
  • I_FUNCTIONALLOCATION.GROSSWEIGHTUNIT == T006.MSEHI
Location and account assignment for technical object
  • Client
  • Location and account assignment for technical object
  • I_FUNCTIONALLOCATION.MANDT == ILOA.MANDT
  • I_FUNCTIONALLOCATION.MAINTOBJECTLOCACCTASSGMTNMBR == ILOA.ILOAN
Country/Region of Manufacture
  • Client
  • Country/Region of Manufacture
  • I_FUNCTIONALLOCATION.MANDT == T005.MANDT
  • I_FUNCTIONALLOCATION.MANUFACTURERCOUNTRY == T005.LAND1
Superior functional location
  • Client
  • Superior functional location
  • I_FUNCTIONALLOCATION.MANDT == IFLOT.MANDT
  • I_FUNCTIONALLOCATION.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_FUNCTIONALLOCATION.TECHNICALOBJECTTYPE == T370K.EQART
  • I_FUNCTIONALLOCATION.MANDT == T370K.MANDT
Object ID of the Work Center
  • Client
  • Object Type of CIM Resources for Work Center
  • Object ID of the Work Center
  • I_FUNCTIONALLOCATION.MANDT == CRID.MANDT
  • I_FUNCTIONALLOCATION.WORKCENTERTYPECODE == CRID.OBJTY
  • I_FUNCTIONALLOCATION.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Client
  • Maintenance Planning Plant
  • Planner Group for Customer Service and Plant Maintenance
  • I_FUNCTIONALLOCATION.MANDT == T024I.MANDT
  • I_FUNCTIONALLOCATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_FUNCTIONALLOCATION.MAINTENANCEPLANNERGROUP == T024I.INGRP
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • I_FUNCTIONALLOCATION.MANDT == T399I.MANDT
  • I_FUNCTIONALLOCATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK