P_AllocationFunctionalAreaVH

DDL: P_ALLOCATIONFUNCTIONALAREAVH SQL: PALLOFUNCAREAVH Type: view CONSUMPTION Package: ODATA_MANAGE_ALLOCATION
24 Fields 1 Data Sources

Allocation Functional Area - Value Help

P_AllocationFunctionalAreaVH is a Consumption CDS View that provides data about "Allocation Functional Area - Value Help" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtFunctionalArea) and exposes 24 fields with key field FunctionalArea. Part of development package ODATA_MANAGE_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea I_FundsMgmtFunctionalArea from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PALLOFUNCAREAVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName
FunctionalAreaAuthznGrp FunctionalAreaAuthznGrp Authorization Group
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ExpirationDate ExpirationDate Expiratn Date
FunctionalAreaSubdivisionID FunctionalAreaSubdivisionID Farea Subdivision ID
FunctionalArea1Subdivision FunctionalArea1Subdivision FN Substring 1
FunctionalArea2Subdivision FunctionalArea2Subdivision FN Substring 2
FunctionalArea3Subdivision FunctionalArea3Subdivision FN Substring 3
_CreatedByUser _CreatedByUser
_FuncArea1Subdivision _FuncArea1Subdivision
_FuncArea2Subdivision _FuncArea2Subdivision
_FuncArea3Subdivision _FuncArea3Subdivision
_FunctionalArea _FunctionalArea
_FunctionalAreaSubdivisionID _FunctionalAreaSubdivisionID
_LastChangedByUser _LastChangedByUser
_Text _Text

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 P_AllocationFunctionalAreaVH.
-- 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: PALLOFUNCAREAVH

CREATE VIEW P_AllocationFunctionalAreaVH AS
SELECT
  FunctionalArea,
  _Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  FunctionalAreaAuthznGrp,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  ValidityStartDate,
  ValidityEndDate,
  ExpirationDate,
  FunctionalAreaSubdivisionID,
  FunctionalArea1Subdivision,
  FunctionalArea2Subdivision,
  FunctionalArea3Subdivision
FROM I_FundsMgmtFunctionalArea
;

Learn More