P_FuncnlAreaGlobAcctgHier

DDL: P_FUNCNLAREAGLOBACCTGHIER Type: view BASIC Package: ODATA_PSM_S4C_FM_WHRUSED_FAREA
21 Fields 1 Data Sources

WUFAREA Global Accounting Hierarchy

P_FuncnlAreaGlobAcctgHier is a Basic CDS View that provides data about "WUFAREA Global Accounting Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_FuncnlAreaGlobAcctgHier) and exposes 21 fields with key fields FuncnlAreaWhereUsedObjType, FunctionalArea, FunctionalAreaHierarchy, HierarchyNode, ValidityEndDate. Part of development package ODATA_PSM_S4C_FM_WHRUSED_FAREA.

Data Sources (1)

SourceAliasJoin Type
I_FuncnlAreaGlobAcctgHier I_FuncnlAreaGlobAcctgHier from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUFNAREAGAH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WUFAREA Global Accounting Hierarchy view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #BASIC view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY FuncnlAreaWhereUsedObjType
KEY FunctionalArea FunctionalArea Sendr Fctl Area
KEY FunctionalAreaHierarchy FunctionalAreaHierarchy Hierarchy ID
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate ValidityEndDate ValidTo
ParentNode ParentNode Parent Node
HierarchyVersion HierarchyVersion Version
ValidityStartDate ValidityStartDate Validity Start Date
ControllingArea ControllingArea Controlling Area
HierarchyNodeSequence HierarchyNodeSequence Sequence Number
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
NodeType NodeType Object Type
HierarchyNodeVal HierarchyNodeVal Value
AllocationSetId AllocationSetId Group ID
LastChangedByUser LastChangedByUser User Name
HierarchyNodeText
FunctionalAreaHierarchyName
_Text _Text
_FunctionalArea _FunctionalArea
_ControllingArea _ControllingArea
_Hierarchy _Hierarchy

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_FuncnlAreaGlobAcctgHier.
-- 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 P_FuncnlAreaGlobAcctgHier AS
SELECT
  cast( '4GAC' as psm_s4c_fm_fnarea_wu_objtypevh ) AS FuncnlAreaWhereUsedObjType,
  FunctionalArea,
  FunctionalAreaHierarchy,
  HierarchyNode,
  ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  ValidityStartDate,
  ControllingArea,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType,
  HierarchyNodeVal,
  AllocationSetId,
  LastChangedByUser,
  _Text[ Language = $session.system_language ].HierarchyNodeText AS HierarchyNodeText,
  _Hierarchy._Text[ Language = $session.system_language ].FunctionalAreaHierarchyName AS FunctionalAreaHierarchyName
FROM I_FuncnlAreaGlobAcctgHier
;

Learn More