A_PrjPrtfloBucketCapacityPlan

DDL: A_PRJPRTFLOBUCKETCAPACITYPLAN Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 Associations 1 OData Services

Proj Portfolio Bucket Capacity Planning

A_PrjPrtfloBucketCapacityPlan is a Consumption CDS View that provides data about "Proj Portfolio Bucket Capacity Planning" in SAP S/4HANA. It reads from 1 data source (R_PrjPrtfloBcktCapPlanTP) and exposes 20 fields with key fields PrjPrtfloBcktCapPlanUUID, PrjPrtfloBcktCapPlnType, FiscalYear, FiscalPeriod, PrjPrtfloBcktCapPlnCatUUID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECTPORTFOLIO).

Data Sources (1)

SourceAliasJoin Type
R_PrjPrtfloBcktCapPlanTP R_PrjPrtfloBcktCapPlanTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PrjPrtfloBucketCapacityGroup _Extension $projection.PrjPrtfloBcktCapPlanUUID = _Extension.PrjPrtfloBcktCapPlnGroupUUID

Annotations (10)

NameValueLevelField
EndUserText.label Proj Portfolio Bucket Capacity Planning view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
OData.entityType.name PrjPrtfloBucketCapacityPlan_Type view
OData.entitySet.name PrjPrtfloBucketCapacityPlan view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTPORTFOLIO API_PROJECTPORTFOLIO V4 C2 C1

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PrjPrtfloBcktCapPlanUUID PrjPrtfloBcktCapPlanUUID
KEY PrjPrtfloBcktCapPlnType PrjPrtfloBcktCapPlnType
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY PrjPrtfloBcktCapPlnCatUUID PrjPrtfloBcktCapPlnCatUUID
PrjPrtfloBcktCapPlnPeriodDate PrjPrtfloBcktCapPlnPeriodDate
PrjPrtfloBcktCapPlnChgdDteTme PrjPrtfloBcktCapPlnChgdDteTme
PrjPrtfloBcktCapPlnAmount PrjPrtfloBcktCapPlnAmount
PrjPrtfloBcktCapPlnUnit PrjPrtfloBcktCapPlnUnit
PrjPrtfloBcktCapPlnChangedBy PrjPrtfloBcktCapPlnChangedBy
PrjPrtfloBcktCapPlnCategoryId PrjPrtfloBcktCapPlnCategoryId
PrjPrtfloBcktCapPlnCatIsActive PrjPrtfloBcktCapPlnCatIsActive
PrjPrtfloBcktCapPlnCatIsOrigl PrjPrtfloBcktCapPlnCatIsOrigl
ProjectPortfolioBucketUUID ProjectPortfolioBucketUUID
PrjPrtfloBcktCapPlnGroupId PrjPrtfloBcktCapPlnGroupId
PrjPrtfloBcktCapPlnGrpSponsor PrjPrtfloBcktCapPlnGrpSponsor
PrjPrtfloBcktCapPlnGrpIsActive PrjPrtfloBcktCapPlnGrpIsActive
PrjPrtfloBcktCapPlnGrpIsOrigl PrjPrtfloBcktCapPlnGrpIsOrigl
ProjectPortfolioUUID ProjectPortfolioUUID
_PortfolioredirectedtoA_ProjectPortfolio

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 A_PrjPrtfloBucketCapacityPlan.
-- 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 A_PrjPrtfloBucketCapacityPlan AS
SELECT
  PrjPrtfloBcktCapPlanUUID,
  PrjPrtfloBcktCapPlnType,
  FiscalYear,
  FiscalPeriod,
  PrjPrtfloBcktCapPlnCatUUID,
  PrjPrtfloBcktCapPlnPeriodDate,
  PrjPrtfloBcktCapPlnChgdDteTme,
  PrjPrtfloBcktCapPlnAmount,
  PrjPrtfloBcktCapPlnUnit,
  PrjPrtfloBcktCapPlnChangedBy,
  PrjPrtfloBcktCapPlnCategoryId,
  PrjPrtfloBcktCapPlnCatIsActive,
  PrjPrtfloBcktCapPlnCatIsOrigl,
  ProjectPortfolioBucketUUID,
  PrjPrtfloBcktCapPlnGroupId,
  PrjPrtfloBcktCapPlnGrpSponsor,
  PrjPrtfloBcktCapPlnGrpIsActive,
  PrjPrtfloBcktCapPlnGrpIsOrigl,
  ProjectPortfolioUUID
FROM R_PrjPrtfloBcktCapPlanTP
LEFT OUTER JOIN E_PrjPrtfloBucketCapacityGroup AS _Extension ON PrjPrtfloBcktCapPlanUUID = _Extension.PrjPrtfloBcktCapPlnGroupUUID  -- association [1..1]
;

Learn More