C_FunctionalLocation

Functional Location | view: CFUNCTLLOCATION | Extraction: Not supported | Component: Functional Locations

Tables used: T370F_T, IFLOS, IFLOT, T370F, IFLOTX, ILOA, T370K, T370K_T, CRHD, ITOBCUST, IFLOUSR

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (13)
🔗 Relations (23)

Column Name	Description
FunctionalLocation	Functional Location

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Date on which the object was created
LastChangeDate	Date on which the object was last changed

Column Name	Description
WorkCenterTypeCode	Object Type of CIM Resources for Work Center	Show values

Column Name	Description	Domain name
FunctionalLocationLabelName	Functional Location Label	ILOM_STRNO
FuncnlLocPrimaryLabelName	Functional Location Label	ILOM_STRNO
FunctionalLocationName	Description of functional location	TEXT40
FunctionalLocationCategoryDesc	Description of functional location category	TEXT30
TechnicalObjectTypeDesc	Text for Object Type	TEXT20
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
MaintenanceWorkCenter	Work Center	ARBPL
AssetRoom	Room	CHAR8
MaintObjectFreeDefinedAttrib	Sort Field	CHAR30
MainWorkCenter	Work Center	ARBPL

Master Data Relations \| to Other Relations ↓	Join Conditions
ABC Indicator for Technical Object ABC Indicator for Technical Object Client	`C_FUNCTIONALLOCATION.ABCINDICATOR == T370C.ABCKZ` `C_FUNCTIONALLOCATION.MANDT == T370C.MANDT`
Location of maintenance object Location of maintenance object Maintenance Plant Client	`C_FUNCTIONALLOCATION.ASSETLOCATION == T499S.STAND` `C_FUNCTIONALLOCATION.MAINTENANCEPLANT == T499S.WERKS` `C_FUNCTIONALLOCATION.MANDT == T499S.MANDT`
Technical Object Authorization Group Technical Object Authorization Group Client	`C_FUNCTIONALLOCATION.AUTHORIZATIONGROUP == T370B.BEGRU` `C_FUNCTIONALLOCATION.MANDT == T370B.MANDT`
Business Area Business Area Client	`C_FUNCTIONALLOCATION.BUSINESSAREA == TGSB.GSBER` `C_FUNCTIONALLOCATION.MANDT == TGSB.MANDT`
Catalog Profile Catalog Profile Client	`C_FUNCTIONALLOCATION.CATALOGPROFILE == T352B.RBNR` `C_FUNCTIONALLOCATION.MANDT == T352B.MANDT`
Company Code Company Code Client	`C_FUNCTIONALLOCATION.COMPANYCODE == T001.BUKRS` `C_FUNCTIONALLOCATION.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_FUNCTIONALLOCATION.CONTROLLINGAREA == TKA01.KOKRS` `C_FUNCTIONALLOCATION.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`C_FUNCTIONALLOCATION.[column in domain "DATBI"] == CSKS.DATBI` `C_FUNCTIONALLOCATION.CONTROLLINGAREA == CSKS.KOKRS` `C_FUNCTIONALLOCATION.COSTCENTER == CSKS.KOSTL` `C_FUNCTIONALLOCATION.MANDT == CSKS.MANDT`
Distribution channel Sales Organization Distribution Channel Client	`C_FUNCTIONALLOCATION.SALESORGANIZATION == TVKOV.VKORG` `C_FUNCTIONALLOCATION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_FUNCTIONALLOCATION.MANDT == TVKOV.MANDT`
Division Sales Organization Division Division Distribution Channel Client	`C_FUNCTIONALLOCATION.SALESORGANIZATION == TVTA.VKORG` `C_FUNCTIONALLOCATION.DIVISION == TVTA.SPART` `C_FUNCTIONALLOCATION.ORGANIZATIONDIVISION == TVTA.SPART` `C_FUNCTIONALLOCATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_FUNCTIONALLOCATION.MANDT == TVTA.MANDT`
Functional location category Functional location category Client	`C_FUNCTIONALLOCATION.FUNCTIONALLOCATIONCATEGORY == T370F.FLTYP` `C_FUNCTIONALLOCATION.MANDT == T370F.MANDT`
Maintenance Plant Maintenance Plant Client	`C_FUNCTIONALLOCATION.MAINTENANCEPLANT == T001W.WERKS` `C_FUNCTIONALLOCATION.MANDT == T001W.MANDT`
Plant Client Plant	`C_FUNCTIONALLOCATION.MANDT == T001W.MANDT` `C_FUNCTIONALLOCATION.MAINWORKCENTERPLANT == T001W.WERKS`
Division Sales Organization Division Division Distribution Channel Client	`C_FUNCTIONALLOCATION.SALESORGANIZATION == TVTA.VKORG` `C_FUNCTIONALLOCATION.DIVISION == TVTA.SPART` `C_FUNCTIONALLOCATION.ORGANIZATIONDIVISION == TVTA.SPART` `C_FUNCTIONALLOCATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_FUNCTIONALLOCATION.MANDT == TVTA.MANDT`
Plant Section Maintenance Plant Plant Section Client	`C_FUNCTIONALLOCATION.MAINTENANCEPLANT == T357.WERKS` `C_FUNCTIONALLOCATION.PLANTSECTION == T357.BEBER` `C_FUNCTIONALLOCATION.MANDT == T357.MANDT`
Sales group Sales office Sales group Client	`C_FUNCTIONALLOCATION.SALESOFFICE == TVBVK.VKBUR` `C_FUNCTIONALLOCATION.SALESGROUP == TVBVK.VKGRP` `C_FUNCTIONALLOCATION.MANDT == TVBVK.MANDT`
Sales organization Sales Organization Client	`C_FUNCTIONALLOCATION.SALESORGANIZATION == TVKO.VKORG` `C_FUNCTIONALLOCATION.MANDT == TVKO.MANDT`
Type of Technical Object Type of Technical Object Client	`C_FUNCTIONALLOCATION.TECHNICALOBJECTTYPE == T370K.EQART` `C_FUNCTIONALLOCATION.MANDT == T370K.MANDT`
Object ID of the Work Center Object ID of the Work Center Client Object Type of CIM Resources for Work Center	`C_FUNCTIONALLOCATION.WORKCENTERINTERNALID == CRID.OBJID` `C_FUNCTIONALLOCATION.MANDT == CRID.MANDT` `C_FUNCTIONALLOCATION.WORKCENTERTYPECODE == CRID.OBJTY`

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	`C_FUNCTIONALLOCATION.MAINTENANCEPLANNERGROUP == T024I.INGRP` `C_FUNCTIONALLOCATION.MAINTENANCEPLANNINGPLANT == T024I.IWERK` `C_FUNCTIONALLOCATION.MANDT == T024I.MANDT`
Maintenance Planning Plant Maintenance Planning Plant Client	`C_FUNCTIONALLOCATION.MAINTENANCEPLANNINGPLANT == T399I.IWERK` `C_FUNCTIONALLOCATION.MANDT == T399I.MANDT`
Sales office Sales office Sales Organization Division Division Distribution Channel Client	`C_FUNCTIONALLOCATION.SALESOFFICE == TVKBZ.VKBUR` `C_FUNCTIONALLOCATION.SALESORGANIZATION == TVKBZ.VKORG` `C_FUNCTIONALLOCATION.DIVISION == TVKBZ.SPART` `C_FUNCTIONALLOCATION.ORGANIZATIONDIVISION == TVKBZ.SPART` `C_FUNCTIONALLOCATION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `C_FUNCTIONALLOCATION.MANDT == TVKBZ.MANDT`