I_ProjectPortfolio

DDL: I_PROJECTPORTFOLIO Type: view_entity BASIC
15 Fields 2 Data Sources 3 Associations

Project Portfolio

I_ProjectPortfolio (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Project Portfolio · R&D Engineering

I_ProjectPortfolio is a Basic CDS View (Dimension) that provides data about "Project Portfolio" in SAP S/4HANA. It reads from 2 data sources (I_ProjectPortfolioBasic, I_EPPMGlobalSwitchSetting) and exposes 15 fields with key field ProjectPortfolioUUID. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Portfolio Management
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the relevant master data and status for the selected Project Portfolio(s)? What are the key objects associated with the Project Portfolio? It is not intended for use in SAP S/4HANA cloud.

Structure
Measures and Attributes Some important attributes are ProjectPortfolioUUID , including other entity related information such as ExternalID, Description, PortfolioType, etc.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-PFM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_ProjectPortfolioBasic Portfolio from
I_EPPMGlobalSwitchSetting Settings inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ProjectPortfolioText _PortfolioText $projection.ProjectPortfolioUUID = _PortfolioText.ProjectPortfolioTextUUID
[1..1] I_ProjectPortfolioPlanningText _ProjectPortfolioText $projection.ProjectPortfolioUUID = _ProjectPortfolioText.ProjPortfolioPlanningTextUUID
[1..1] E_ProjectPortfolio _Extension $projection.ProjectPortfolioUUID = _Extension.ProjectPortfolioUUID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
EndUserText.label Project Portfolio view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ProjectPortfolio view
ObjectModel.representativeKey ProjectPortfolioUUID view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProjectPortfolioUUID I_ProjectPortfolioBasic ProjectPortfolioUUID Guid for application objects
ProjectPortfolioExternalID I_ProjectPortfolioBasic ProjectPortfolioExternalID WEBGUI External ID
ParentObjectUUID I_ProjectPortfolioBasic ParentObjectUUID Guid for application objects
ProjectPortfolioMasterLanguage I_ProjectPortfolioBasic ProjectPortfolioMasterLanguage Text Language
PrjPortfolioDefaultLanguage I_ProjectPortfolioBasic PrjPortfolioDefaultLanguage Language Key
LastChangedByUser I_ProjectPortfolioBasic LastChangedByUser Changed by user
LastChangeDateTime I_ProjectPortfolioBasic LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ProjectPortfolioType I_ProjectPortfolioBasic ProjectPortfolioType Portfolio Type
ProjectPortfolioReleaseStatus I_ProjectPortfolioBasic ProjectPortfolioReleaseStatus Release Status
PrjPrtfloIsClsfctnHierarchy I_ProjectPortfolioBasic PrjPrtfloIsClsfctnHierarchy Classification Hierarchy
ProjPrtfloHierarchyIsMandatory I_ProjectPortfolioBasic ProjPrtfloHierarchyIsMandatory Mandatory
CreatedByUser I_ProjectPortfolioBasic CreatedByUser Name of Person Who Created Object
ProjectPortfolioCreatedOnDate I_ProjectPortfolioBasic ProjectPortfolioCreatedOnDate Date When the Object Was Created
_PortfolioText _PortfolioText
_ProjectPortfolioText _ProjectPortfolioText

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 I_ProjectPortfolio.
-- 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 I_ProjectPortfolio AS
SELECT
  Portfolio.ProjectPortfolioUUID AS ProjectPortfolioUUID,
  Portfolio.ProjectPortfolioExternalID AS ProjectPortfolioExternalID,
  Portfolio.ParentObjectUUID AS ParentObjectUUID,
  Portfolio.ProjectPortfolioMasterLanguage AS ProjectPortfolioMasterLanguage,
  Portfolio.PrjPortfolioDefaultLanguage AS PrjPortfolioDefaultLanguage,
  Portfolio.LastChangedByUser AS LastChangedByUser,
  Portfolio.LastChangeDateTime AS LastChangeDateTime,
  Portfolio.ProjectPortfolioType AS ProjectPortfolioType,
  Portfolio.ProjectPortfolioReleaseStatus AS ProjectPortfolioReleaseStatus,
  Portfolio.PrjPrtfloIsClsfctnHierarchy AS PrjPrtfloIsClsfctnHierarchy,
  Portfolio.ProjPrtfloHierarchyIsMandatory AS ProjPrtfloHierarchyIsMandatory,
  Portfolio.CreatedByUser AS CreatedByUser,
  Portfolio.ProjectPortfolioCreatedOnDate AS ProjectPortfolioCreatedOnDate
FROM I_ProjectPortfolioBasic AS Portfolio
INNER JOIN I_EPPMGlobalSwitchSetting AS Settings ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectPortfolioText AS _PortfolioText ON ProjectPortfolioUUID = _PortfolioText.ProjectPortfolioTextUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjectPortfolioPlanningText AS _ProjectPortfolioText ON ProjectPortfolioUUID = _ProjectPortfolioText.ProjPortfolioPlanningTextUUID  -- association [1..1]
LEFT OUTER JOIN E_ProjectPortfolio AS _Extension ON ProjectPortfolioUUID = _Extension.ProjectPortfolioUUID  -- association [1..1]
;

Learn More