C_ProjectPortfolioBucketDP

DDL: C_PROJECTPORTFOLIOBUCKETDP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources 5 Associations

Project Portfolio Bucket

C_ProjectPortfolioBucketDP is a Consumption CDS View that provides data about "Project Portfolio Bucket" in SAP S/4HANA. It reads from 1 data source (I_ProjectPortfolioBucket) and exposes 23 fields with key field ProjectPortfolioBucketUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectPortfolioBucket I_ProjectPortfolioBucket from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_ProjectPortfolioBucket _Extension $projection.ProjectPortfolioBucketUUID = _Extension.ProjectPortfolioBucketUUID
[1..*] C_ProjectPortfolioItemDP _PortfolioItem
[1..*] C_ProjectPortfolioInitiativeDP _PortfolioInitiative
[1..*] C_ProjPrtfloBcktFinPlanningDP _FinancialPlan
[1..*] C_ProjPrtfloBcktCapPlanningDP _CapacityPlan

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Portfolio Bucket view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ProjectPortfolioBucket view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey ProjectPortfolioBucketUUID view
VDM.viewType #CONSUMPTION view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RPB view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ProjectPortfolioBucketUUID ProjectPortfolioBucketUUID
ProjPortfolioBucketExternalID ProjPortfolioBucketExternalID
ProjectPortfolioUUID ProjectPortfolioUUID
ParentObjectUUID ParentObjectUUID UUID Parent GO
ProjPortfolioBucketDescription ProjPortfolioBucketDescription Portfolio Bucket Description
ProjPrtfloBcktFinCurrency ProjPrtfloBcktFinCurrency
ProjPrtfloBcktFinPlngPerdType ProjPrtfloBcktFinPlngPerdType
ProjPrtfloBucketCapacityUnit ProjPrtfloBucketCapacityUnit
LastChangeDateTime LastChangeDateTime Timestamp
ProjPrtfloBucketReleaseStatus ProjPrtfloBucketReleaseStatus
ProjPrtfloBcktCapPlngStartDate ProjPrtfloBcktCapPlngStartDate
PrjPrtfloBcktCapPlngFinishDate PrjPrtfloBcktCapPlngFinishDate
ProjPrtfloBcktFinPlngStartDate ProjPrtfloBcktFinPlngStartDate
PrjPrtfloBcktFinPlngFinishDate PrjPrtfloBcktFinPlngFinishDate
ProjPrtfloBcktCapPlngPerdType ProjPrtfloBcktCapPlngPerdType
ProjPrtfloBcktTransfStartDate ProjPrtfloBcktTransfStartDate
ProjPrtfloBcktTransfFinishDate ProjPrtfloBcktTransfFinishDate
ProjPrtfloBucketCreatedOnDate ProjPrtfloBucketCreatedOnDate
_Portfolio _Portfolio
_PortfolioItem _PortfolioItem
_PortfolioInitiative _PortfolioInitiative
_FinancialPlan _FinancialPlan
_CapacityPlan _CapacityPlan

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 C_ProjectPortfolioBucketDP.
-- 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 C_ProjectPortfolioBucketDP AS
SELECT
  ProjectPortfolioBucketUUID,
  ProjPortfolioBucketExternalID,
  ProjectPortfolioUUID,
  ParentObjectUUID,
  ProjPortfolioBucketDescription,
  ProjPrtfloBcktFinCurrency,
  ProjPrtfloBcktFinPlngPerdType,
  ProjPrtfloBucketCapacityUnit,
  LastChangeDateTime,
  ProjPrtfloBucketReleaseStatus,
  ProjPrtfloBcktCapPlngStartDate,
  PrjPrtfloBcktCapPlngFinishDate,
  ProjPrtfloBcktFinPlngStartDate,
  PrjPrtfloBcktFinPlngFinishDate,
  ProjPrtfloBcktCapPlngPerdType,
  ProjPrtfloBcktTransfStartDate,
  ProjPrtfloBcktTransfFinishDate,
  ProjPrtfloBucketCreatedOnDate
FROM I_ProjectPortfolioBucket
LEFT OUTER JOIN E_ProjectPortfolioBucket AS _Extension ON ProjectPortfolioBucketUUID = _Extension.ProjectPortfolioBucketUUID  -- association [1..1]
LEFT OUTER JOIN C_ProjectPortfolioItemDP AS _PortfolioItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_ProjectPortfolioInitiativeDP AS _PortfolioInitiative ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_ProjPrtfloBcktFinPlanningDP AS _FinancialPlan ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_ProjPrtfloBcktCapPlanningDP AS _CapacityPlan ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More