P_SpnsrdPgmGlobAcctgHier

DDL: P_SPNSRDPGMGLOBACCTGHIER Type: view BASIC
17 Fields 1 Data Sources 2 Associations

WUSPDPGM Global Accounting Hierarchy

P_SpnsrdPgmGlobAcctgHier is a Basic CDS View that provides data about "WUSPDPGM Global Accounting Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_SponsoredProgHierarchyNode) and exposes 17 fields with key fields SpnsrdPgmWhereUsedObjType, SponsoredProgram, SponsoredProgramHierarchy, HierarchyNode, ValidityEndDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SponsoredProgHierarchyNode I_SponsoredProgHierarchyNode from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SponsoredProgramCore _SponsoredProgram $projection.SponsoredProgram = _SponsoredProgram.SponsoredProgram
[1..1] I_SponsoredProgramHierarchy _Hierarchy $projection.SponsoredProgramHierarchy = _Hierarchy.SponsoredProgramHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUSPNSRPGMGAH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WUSPDPGM Global Accounting Hierarchy view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SpnsrdPgmWhereUsedObjType
KEY SponsoredProgram SponsoredProgram Sponsored Program
KEY SponsoredProgramHierarchy SponsoredProgramHierarchy
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate ValidityEndDate ValidTo
ParentNode ParentNode Parent Node
HierarchyVersion HierarchyVersion Version
ValidityStartDate ValidityStartDate Validity Start Date
HierarchyNodeSequence HierarchyNodeSequence Sequence Number
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
NodeType NodeType Object Type
LastChangedByUser _SponsoredProgram LastChangedByUser User Name
HierarchyNodeText
SponsoredProgramHierarchyName
_SponsoredProgram _SponsoredProgram
_Hierarchy _Hierarchy
_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_SpnsrdPgmGlobAcctgHier.
-- 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_SpnsrdPgmGlobAcctgHier AS
SELECT
  cast( '2GAC' as psm_s4c_gm_spdpgm_wu_objtypevh ) AS SpnsrdPgmWhereUsedObjType,
  SponsoredProgram,
  SponsoredProgramHierarchy,
  HierarchyNode,
  ValidityEndDate,
  ParentNode,
  HierarchyVersion,
  ValidityStartDate,
  HierarchyNodeSequence,
  HierarchyNodeLevel,
  NodeType,
  _SponsoredProgram.LastChangedByUser AS LastChangedByUser,
  _Text[ Language = $session.system_language ].HierarchyNodeText AS HierarchyNodeText,
  _Hierarchy._Text[ Language = $session.system_language ].SponsoredProgramHierarchyName AS SponsoredProgramHierarchyName
FROM I_SponsoredProgHierarchyNode
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [1..1]
LEFT OUTER JOIN I_SponsoredProgramHierarchy AS _Hierarchy ON SponsoredProgramHierarchy = _Hierarchy.SponsoredProgramHierarchy AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [1..1]
;

Learn More