I_FunctionalLocationData

Functional Location Data | view: IFUNCTLOCATTR | ATTR | Extraction: Full only | Component: Functional Locations
Tables used: JSTO, JEST, IFLOS, IFLOT, EAML_D_LFE_DATA, ILOA, PRPS, CRHD
Column Name Description
FunctionalLocation Functional Location
Column Name Description
Column Name Description
📏 Unit of Measurement for Linear Data (LinearDataUnitOfMeasure):
LinearDataLength null
Column Name Description
OperationStartDate Start-up Date of the Technical Object
CreationDate Date on which the object was created
LastChangeDate Date on which the object was last changed
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
AssetRoom Room CHAR8
FuncnlLocPrimaryLabelName Functional Location Label ILOM_STRNO
FunctionalLocationLabelVersion Version of functional location label NUMC3
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
MainWorkCenter Main work center for maintenance tasks ARBPL
WorkCenter Work Center ARBPL
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FuncnlLocIsMarkedForDeletion Object is deleted CHAR1
LinearDataStartPoint Start Point EAML_POINT
LinearDataEndPoint End Point EAML_POINT
Master Data Relations | to Other Relations ↓ Join Conditions
ABC Indicator for Technical Object
  • ABC Indicator for Technical Object
  • Client
  • I_FUNCTIONALLOCATIONDATA.ABCINDICATOR == T370C.ABCKZ
  • I_FUNCTIONALLOCATIONDATA.MANDT == T370C.MANDT
Address Number
  • Address Number
  • ?
  • ?
  • Client
  • I_FUNCTIONALLOCATIONDATA.ADDRESSID == ADRC.ADDRNUMBER
  • I_FUNCTIONALLOCATIONDATA.[column in domain "AD_NATION"] == ADRC.NATION
  • I_FUNCTIONALLOCATIONDATA.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_FUNCTIONALLOCATIONDATA.MANDT == ADRC.CLIENT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANT == T499S.WERKS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T499S.MANDT
  • I_FUNCTIONALLOCATIONDATA.ASSETLOCATION == T499S.STAND
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • I_FUNCTIONALLOCATIONDATA.AUTHORIZATIONGROUP == T370B.BEGRU
  • I_FUNCTIONALLOCATIONDATA.MANDT == T370B.MANDT
Company Code
  • Company Code
  • Client
  • I_FUNCTIONALLOCATIONDATA.COMPANYCODE == T001.BUKRS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T001.MANDT
Construction type material of the object
  • Construction type material of the object
  • Client
  • I_FUNCTIONALLOCATIONDATA.CONSTRUCTIONMATERIAL == MARA.MATNR
  • I_FUNCTIONALLOCATIONDATA.MANDT == MARA.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_FUNCTIONALLOCATIONDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_FUNCTIONALLOCATIONDATA.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • I_FUNCTIONALLOCATIONDATA.CONTROLLINGAREA == CSKS.KOKRS
  • I_FUNCTIONALLOCATIONDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_FUNCTIONALLOCATIONDATA.COSTCENTER == CSKS.KOSTL
  • I_FUNCTIONALLOCATIONDATA.MANDT == CSKS.MANDT
Functional location category
  • Functional location category
  • Client
  • I_FUNCTIONALLOCATIONDATA.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP
  • I_FUNCTIONALLOCATIONDATA.MANDT == T370F.MANDT
Labeling system for functional locations
  • Labeling system for functional locations
  • Client
  • I_FUNCTIONALLOCATIONDATA.FUNCTIONALLOCLABELINGSYST == IFLOALT.ALKEY
  • I_FUNCTIONALLOCATIONDATA.MANDT == IFLOALT.MANDT
Maintenance Plant
  • Maintenance Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANT == T001W.WERKS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T001W.MANDT
Object ID of the Work Center
  • ?
  • Object ID of the Work Center
  • Client
  • I_FUNCTIONALLOCATIONDATA.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_FUNCTIONALLOCATIONDATA.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_FUNCTIONALLOCATIONDATA.MANDT == CRID.MANDT
Plant associated with main work center
  • Plant associated with main work center
  • Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.MAINWORKCENTERPLANT == T001W.WERKS
  • I_FUNCTIONALLOCATIONDATA.WORKCENTERPLANT == T001W.WERKS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T001W.MANDT
Plant Section
  • Plant Section
  • Maintenance Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.PLANTSECTION == T357.BEBER
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANT == T357.WERKS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T357.MANDT
Settlement order
  • Settlement order
  • Client
  • I_FUNCTIONALLOCATIONDATA.SETTLEMENTORDER == AUFK.AUFNR
  • I_FUNCTIONALLOCATIONDATA.MANDT == AUFK.MANDT
Superior functional location
  • Superior functional location
  • Client
  • I_FUNCTIONALLOCATIONDATA.SUPERIORFUNCTIONALLOCATION == IFLOT.TPLNR
  • I_FUNCTIONALLOCATIONDATA.MANDT == IFLOT.MANDT
Type of Technical Object
  • Type of Technical Object
  • Client
  • I_FUNCTIONALLOCATIONDATA.TECHNICALOBJECTTYPE == T370K.EQART
  • I_FUNCTIONALLOCATIONDATA.MANDT == T370K.MANDT
Object ID of PP work center
  • Object types of the CIM resource
  • Object ID of PP work center
  • Client
  • I_FUNCTIONALLOCATIONDATA.WORKCENTERTYPECODE == CRID.OBJTY
  • I_FUNCTIONALLOCATIONDATA.WORKCENTERINTERNALID == CRID.OBJID
  • I_FUNCTIONALLOCATIONDATA.MANDT == CRID.MANDT
Plant
  • Plant associated with main work center
  • Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.MAINWORKCENTERPLANT == T001W.WERKS
  • I_FUNCTIONALLOCATIONDATA.WORKCENTERPLANT == T001W.WERKS
  • I_FUNCTIONALLOCATIONDATA.MANDT == T001W.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANNERGROUP == T024I.INGRP
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANNINGPLANT == T024I.IWERK
  • I_FUNCTIONALLOCATIONDATA.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Maintenance Planning Plant
  • Client
  • I_FUNCTIONALLOCATIONDATA.MAINTENANCEPLANNINGPLANT == T399I.IWERK
  • I_FUNCTIONALLOCATIONDATA.MANDT == T399I.MANDT