A_FunctionalLocation

DDL: A_FUNCTIONALLOCATION Type: view_entity COMPOSITE Package: IEQM
84 Fields 1 Data Sources 2 OData Services

Functional Location

A_FunctionalLocation is a Composite CDS View that provides data about "Functional Location" in SAP S/4HANA. It reads from 1 data source (R_FunctionalLocationTP) and exposes 84 fields with key field FunctionalLocation. It is exposed through 2 OData services (API_FUNCTIONALLOCATION, ASQL_F6973). Part of development package IEQM.

Data Sources (1)

SourceAliasJoin Type
R_FunctionalLocationTP R_FunctionalLocationTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Location view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

OData Services (2)

ServiceBindingVersionContractRelease
API_FUNCTIONALLOCATION API_FUNCTIONALLOCATION V2 C2 C1
ASQL_F6973 ASQL_F6973 C2 NOT_RELEASED

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation Object ID
FunctionalLocationOID FunctionalLocationOID FuncLoc Instce ID
FunctionalLocationLabelName FunctionalLocationLabelName Functional Loc.
FunctionalLocationName FunctionalLocationName Functional Loc.
FuncLocationStructure FuncLocationStructure
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
SuperiorFunctionalLocation SuperiorFunctionalLocation Object ID
SuperiorFuncnlLocLabelName SuperiorFuncnlLocLabelName Functional Loc.
FuncnlLocPosInSuperiorTechObj FuncnlLocPosInSuperiorTechObj
TechnicalObjectType TechnicalObjectType Text object
AuthorizationGroup AuthorizationGroup AuthorizGroup
GrossWeight GrossWeight Total Weight
GrossWeightUnit GrossWeightUnit
OperationStartDate OperationStartDate
InventoryNumber InventoryNumber
AcquisitionValue AcquisitionValue
Currency Currency Valuation Crcy
AcquisitionDate AcquisitionDate Date Entered
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
ManufacturerCountry ManufacturerCountry Mnf. Cntry/Regn
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ConstructionMonth ConstructionMonth
ConstructionYear ConstructionYear
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
MaintenancePlant MaintenancePlant Plant
AssetLocation AssetLocation Location
AssetRoom AssetRoom Room
PlantSection PlantSection Plant Section
WorkCenter WorkCenter Work Center
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterPlant WorkCenterPlant Plant
ABCIndicator ABCIndicator ABC Indicator
MaintObjectFreeDefinedAttrib MaintObjectFreeDefinedAttrib Sort Field
AddressID AddressID Ship-to address
FormOfAddress FormOfAddress Title Key
BusinessPartnerName1 BusinessPartnerName1 Name
BusinessPartnerName2 BusinessPartnerName2 Name 2
CityName CityName Name
HouseNumber HouseNumber House Number
HouseNumberSupplementText HouseNumberSupplementText Supplement
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
PostalCode PostalCode Postal Code
StreetName StreetName Text
Region Region Venue Region
Country Country Venue: Ctry/Reg
PhoneNumber PhoneNumber Telephone no.
FaxNumber FaxNumber Fax Number
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
WBSElementExternalID WBSElementExternalID WBS Element External ID
SettlementOrder SettlementOrder SettlementOrder
ConstructionMaterial ConstructionMaterial ConstType
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
CatalogProfile CatalogProfile Catalog Profile
EquipmentInstallationIsAllowed EquipmentInstallationIsAllowed
OnePieceOfEquipmentIsAllowed OnePieceOfEquipmentIsAllowed
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SalesOffice SalesOffice Sales Office
OrganizationDivision OrganizationDivision Org. Division
SalesGroup SalesGroup Sales Group
FunctionalLocationHasEquipment FunctionalLocationHasEquipment
FuncnlLocHasSubOrdinateFuncLoc FuncnlLocHasSubOrdinateFuncLoc
LastChangeDateTime LastChangeDateTime Timestamp
FuncnlLocIsMarkedForDeletion FuncnlLocIsMarkedForDeletion
FuncnlLocIsDeleted FuncnlLocIsDeleted
FunctionalLocationIsActive FunctionalLocationIsActive
FunctionalLocationIsCreated FunctionalLocationIsCreated
FuncnlLocIsDeactivated FuncnlLocIsDeactivated
FunctionalLocationEndOfUseDate FunctionalLocationEndOfUseDate
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name

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 A_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.

CREATE VIEW A_FunctionalLocation AS
SELECT
  FunctionalLocation,
  FunctionalLocationOID,
  FunctionalLocationLabelName,
  FunctionalLocationName,
  FuncLocationStructure,
  FunctionalLocationCategory,
  SuperiorFunctionalLocation,
  SuperiorFuncnlLocLabelName,
  FuncnlLocPosInSuperiorTechObj,
  TechnicalObjectType,
  AuthorizationGroup,
  GrossWeight,
  GrossWeightUnit,
  OperationStartDate,
  InventoryNumber,
  AcquisitionValue,
  Currency,
  AcquisitionDate,
  AssetManufacturerName,
  ManufacturerPartNmbr,
  ManufacturerCountry,
  ManufacturerPartTypeName,
  ConstructionMonth,
  ConstructionYear,
  ManufacturerSerialNumber,
  MaintenancePlant,
  AssetLocation,
  AssetRoom,
  PlantSection,
  WorkCenter,
  WorkCenterInternalID,
  WorkCenterPlant,
  ABCIndicator,
  MaintObjectFreeDefinedAttrib,
  AddressID,
  FormOfAddress,
  BusinessPartnerName1,
  BusinessPartnerName2,
  CityName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  PostalCode,
  StreetName,
  Region,
  Country,
  PhoneNumber,
  FaxNumber,
  CompanyCode,
  BusinessArea,
  MasterFixedAsset,
  FixedAsset,
  CostCenter,
  ControllingArea,
  WBSElementExternalID,
  SettlementOrder,
  ConstructionMaterial,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MainWorkCenterPlant,
  MainWorkCenter,
  MainWorkCenterInternalID,
  CatalogProfile,
  EquipmentInstallationIsAllowed,
  OnePieceOfEquipmentIsAllowed,
  SalesOrganization,
  DistributionChannel,
  SalesOffice,
  OrganizationDivision,
  SalesGroup,
  FunctionalLocationHasEquipment,
  FuncnlLocHasSubOrdinateFuncLoc,
  LastChangeDateTime,
  FuncnlLocIsMarkedForDeletion,
  FuncnlLocIsDeleted,
  FunctionalLocationIsActive,
  FunctionalLocationIsCreated,
  FuncnlLocIsDeactivated,
  FunctionalLocationEndOfUseDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser
FROM R_FunctionalLocationTP
;

Learn More