P_MstrProjHierWithStstclKeyFig

DDL: P_MSTRPROJHIERWITHSTSTCLKEYFIG SQL: PHIERLISTSKF Type: view COMPOSITE
30 Fields 1 Data Sources 2 Associations

P_MstrProjHierWithStstclKeyFig is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_MstrProjHierarchy) and exposes 30 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjHierarchy Hierarchy from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea association[1..1] to I_StatisticalKeyFigure as _StstclKeyFig on $projection.StatisticalKeyFigure = _StstclKeyFig.StatisticalKeyFigure and $projection.ControllingArea = _StstclKeyFig.ControllingArea

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PHIERLISTSKF view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID P_MstrProjHierarchy MasterProjectUUID NodeID
MasterProject P_MstrProjHierarchy MasterProject Project ID
MasterProjectName P_MstrProjHierarchy MasterProjectName
MasterProjectOrganization P_MstrProjHierarchy MasterProjectOrganization
MasterProjectIsConfidential P_MstrProjHierarchy MasterProjectIsConfidential
MasterProjectType P_MstrProjHierarchy MasterProjectType
Currency P_MstrProjHierarchy Currency Valuation Crcy
Project P_MstrProjHierarchy Project WBS Element
ProjectDescription P_MstrProjHierarchy ProjectDescription Project Name
BusinessArea P_MstrProjHierarchy BusinessArea Business Area
CompanyCode P_MstrProjHierarchy CompanyCode Receiver Company Code
ControllingArea P_MstrProjHierarchy ControllingArea Controlling Area
ControllingObject P_MstrProjHierarchy ControllingObject Object number
ControllingObjectExternalID P_MstrProjHierarchy ControllingObjectExternalID WBS Element
ControllingObjectType P_MstrProjHierarchy ControllingObjectType Object Type
SalesDocument P_MstrProjHierarchy SalesDocument SD Document
SalesDocumentItem P_MstrProjHierarchy SalesDocumentItem Sales Document Item
ObjectName P_MstrProjHierarchy ObjectName Object name
MstrProjAnchorObjectInternalID P_MstrProjHierarchy MstrProjAnchorObjectInternalID Object number
ExternalObjectIdentifier P_MstrProjHierarchy ExternalObjectIdentifier Project def.
ControllingObjectCurrency P_MstrProjHierarchy ControllingObjectCurrency CO Object Currency
WBSElementObject P_MstrProjHierarchy WBSElementObject Object number
WBSElement P_MstrProjHierarchy WBSElement WBS Internal ID
StatisticalKeyFigure MstrProjSKF StatisticalKeyFigure Statistical Key Figure
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
_MstrProjType _MstrProjType
_MstrProjFinPlan _MstrProjFinPlan
_MstrProjPerdKPI _MstrProjPerdKPI
_StstclKeyFig _StstclKeyFig

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_MstrProjHierWithStstclKeyFig.
-- 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: PHIERLISTSKF

CREATE VIEW P_MstrProjHierWithStstclKeyFig AS
SELECT
  Hierarchy.MasterProjectUUID AS MasterProjectUUID,
  Hierarchy.MasterProject AS MasterProject,
  Hierarchy.MasterProjectName AS MasterProjectName,
  Hierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  Hierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  Hierarchy.MasterProjectType AS MasterProjectType,
  Hierarchy.Currency AS Currency,
  Hierarchy.Project AS Project,
  Hierarchy.ProjectDescription AS ProjectDescription,
  Hierarchy.BusinessArea AS BusinessArea,
  Hierarchy.CompanyCode AS CompanyCode,
  Hierarchy.ControllingArea AS ControllingArea,
  Hierarchy.ControllingObject AS ControllingObject,
  Hierarchy.ControllingObjectExternalID AS ControllingObjectExternalID,
  Hierarchy.ControllingObjectType AS ControllingObjectType,
  Hierarchy.SalesDocument AS SalesDocument,
  Hierarchy.SalesDocumentItem AS SalesDocumentItem,
  Hierarchy.ObjectName AS ObjectName,
  Hierarchy.MstrProjAnchorObjectInternalID AS MstrProjAnchorObjectInternalID,
  Hierarchy.ExternalObjectIdentifier AS ExternalObjectIdentifier,
  Hierarchy.ControllingObjectCurrency AS ControllingObjectCurrency,
  Hierarchy.WBSElementObject AS WBSElementObject,
  Hierarchy.WBSElement AS WBSElement,
  MstrProjSKF.StatisticalKeyFigure AS StatisticalKeyFigure
FROM P_MstrProjHierarchy AS Hierarchy
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea association[1..1] to I_StatisticalKeyFigure as _StstclKeyFig on StatisticalKeyFigure = _StstclKeyFig.StatisticalKeyFigure AND ControllingArea = _StstclKeyFig.ControllingArea  -- association [1..1]
;

Learn More