C_FunctionalLocation

DDL: C_FUNCTIONALLOCATION SQL: CFUNCTLLOCATION Type: view CONSUMPTION
45 Fields 1 Data Sources

Functional Location

C_FunctionalLocation is a Consumption CDS View that provides data about "Functional Location" in SAP S/4HANA. It reads from 1 data source (I_FunctionalLocation) and exposes 45 fields with key field FunctionalLocation.

Data Sources (1)

SourceAliasJoin Type
I_FunctionalLocation I_FunctionalLocation from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (10)

NameValueLevelField
ObjectModel.representativeKey FunctionalLocation view
EndUserText.label Functional Location view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CFUNCTLLOCATION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation Object ID
FunctionalLocationLabelName
FuncnlLocPrimaryLabelName _PrimaryLabel FunctionalLocationLabelName Functional Loc.
FunctionalLocationName
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
FunctionalLocationCategoryDesc
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
TechnicalObjectType TechnicalObjectType Text object
TechnicalObjectTypeDesc
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
AuthorizationGroup AuthorizationGroup AuthorizGroup
MaintenanceWorkCenter
MaintenancePlant _LocationAccountAssignment MaintenancePlant Plant
PlantSection _LocationAccountAssignment PlantSection Plant Section
AssetLocation _LocationAccountAssignment AssetLocation Location
AssetRoom _LocationAccountAssignment AssetRoom Room
MaintObjectFreeDefinedAttrib _LocationAccountAssignment MaintObjectFreeDefinedAttrib Sort Field
ABCIndicator _LocationAccountAssignment ABCIndicator ABC Indicator
BusinessArea _LocationAccountAssignment BusinessArea Business Area
ControllingArea _LocationAccountAssignment ControllingArea Controlling Area
CostCenter _LocationAccountAssignment CostCenter Cost Center
CompanyCode _LocationAccountAssignment CompanyCode Receiver Company Code
Division _LocationAccountAssignment Division Internal Division ID
MainWorkCenter _WorkCenter WorkCenter Work Center
MainWorkCenterPlant _WorkCenter Plant Valuation Area
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
CatalogProfile CatalogProfile Catalog Profile
SalesOrganization _LocationAccountAssignment SalesOrganization Sales Organization
DistributionChannel _LocationAccountAssignment DistributionChannel RefDistCh-Cust/Mat.
SalesOffice _LocationAccountAssignment SalesOffice Sales Office
OrganizationDivision _LocationAccountAssignment OrganizationDivision Org. Division
SalesGroup _LocationAccountAssignment SalesGroup Sales Group
MaintObjectInternalID MaintObjectInternalID Object number
_Status _Status
_FunctionalLocationCategory _FunctionalLocationCategory
_FunctionalLocationText _FunctionalLocationText
_TechnicalObjectType _TechnicalObjectType
_WorkCenter _WorkCenter

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FunctionalLocation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFUNCTLLOCATION
-- Parameters: P_Language : sylangu

CREATE VIEW C_FunctionalLocation AS
SELECT
  FunctionalLocation,
  cast( _FunctionalLocationLabel.FunctionalLocationLabelName as ilom_strno ) AS FunctionalLocationLabelName,
  _PrimaryLabel.FunctionalLocationLabelName AS FuncnlLocPrimaryLabelName,
  _FunctionalLocationText[1: Language = $parameters.P_Language ].FunctionalLocationName AS FunctionalLocationName,
  FunctionalLocationCategory,
  _FunctionalLocationCategory._Text[1: Language = $parameters.P_Language ].FunctionalLocationCategoryDesc AS FunctionalLocationCategoryDesc,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  TechnicalObjectType,
  _TechnicalObjectType._Text[1: Language = $parameters.P_Language ].TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  AuthorizationGroup,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS MaintenanceWorkCenter,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.BusinessArea AS BusinessArea,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.Division AS Division,
  _WorkCenter.WorkCenter AS MainWorkCenter,
  _WorkCenter.Plant AS MainWorkCenterPlant,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  CatalogProfile,
  _LocationAccountAssignment.SalesOrganization AS SalesOrganization,
  _LocationAccountAssignment.DistributionChannel AS DistributionChannel,
  _LocationAccountAssignment.SalesOffice AS SalesOffice,
  _LocationAccountAssignment.OrganizationDivision AS OrganizationDivision,
  _LocationAccountAssignment.SalesGroup AS SalesGroup,
  MaintObjectInternalID
FROM I_FunctionalLocation
;

Learn More