A_PrjPrtfloBucketFinancialPlan

DDL: A_PRJPRTFLOBUCKETFINANCIALPLAN Type: view_entity CONSUMPTION
21 Fields 1 Data Sources 1 Associations 1 OData Services

Proj Portfolio Bucket Financial Planning

A_PrjPrtfloBucketFinancialPlan is a Consumption CDS View that provides data about "Proj Portfolio Bucket Financial Planning" in SAP S/4HANA. It reads from 1 data source (R_PrjPrtfloBcktFinPlanTP) and exposes 21 fields with key fields PrjPrtfloBcktFinPlnType, FiscalYear, FiscalPeriod, PrjPrtfloBcktFinPlanUUID, PrjPrtfloBcktFinPlnCatUUID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECTPORTFOLIO).

Data Sources (1)

SourceAliasJoin Type
R_PrjPrtfloBcktFinPlanTP R_PrjPrtfloBcktFinPlanTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PrjPrtfloBcktFinancialGroup _Extension $projection.PrjPrtfloBcktFinPlanUUID = _Extension.PrjPrtfloBcktFinPlnGroupUUID

Annotations (10)

NameValueLevelField
EndUserText.label Proj Portfolio Bucket Financial 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 PrjPrtfloBucketFinancialPlan_Type view
OData.entitySet.name PrjPrtfloBucketFinancialPlan view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTPORTFOLIO API_PROJECTPORTFOLIO V4 C2 C1

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PrjPrtfloBcktFinPlnType PrjPrtfloBcktFinPlnType
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY PrjPrtfloBcktFinPlanUUID PrjPrtfloBcktFinPlanUUID
KEY PrjPrtfloBcktFinPlnCatUUID PrjPrtfloBcktFinPlnCatUUID
PrjPrtfloBcktFinPlnPeriodDate PrjPrtfloBcktFinPlnPeriodDate
PrjPrtfloFinPlnPeriodIsInitial PrjPrtfloFinPlnPeriodIsInitial
PrjPrtfloBcktFinPlnCategoryId PrjPrtfloBcktFinPlnCategoryId
PrjPrtfloBcktFinPlnCatIsActive PrjPrtfloBcktFinPlnCatIsActive
PrjPrtfloBcktFinPlnCatIsOrigl PrjPrtfloBcktFinPlnCatIsOrigl
ProjectPortfolioBucketUUID ProjectPortfolioBucketUUID
PrjPrtfloBcktFinPlnGroupId PrjPrtfloBcktFinPlnGroupId
PrjPrtfloBcktFinPlnGrpSponsor PrjPrtfloBcktFinPlnGrpSponsor
PrjPrtfloBcktFinPlnGrpIsActive PrjPrtfloBcktFinPlnGrpIsActive
PrjPrtfloBcktFinPlnGrpIsOrigl PrjPrtfloBcktFinPlnGrpIsOrigl
PrjPrtfloBcktFinPlnChgdDteTme PrjPrtfloBcktFinPlnChgdDteTme
PrjPrtfloBcktFinPlnChangedBy PrjPrtfloBcktFinPlnChangedBy
PrjPrtfloBcktFinPlnAmount PrjPrtfloBcktFinPlnAmount
PrjPrtfloBcktFinPlnCurrency PrjPrtfloBcktFinPlnCurrency
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_PrjPrtfloBucketFinancialPlan.
-- 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_PrjPrtfloBucketFinancialPlan AS
SELECT
  PrjPrtfloBcktFinPlnType,
  FiscalYear,
  FiscalPeriod,
  PrjPrtfloBcktFinPlanUUID,
  PrjPrtfloBcktFinPlnCatUUID,
  PrjPrtfloBcktFinPlnPeriodDate,
  PrjPrtfloFinPlnPeriodIsInitial,
  PrjPrtfloBcktFinPlnCategoryId,
  PrjPrtfloBcktFinPlnCatIsActive,
  PrjPrtfloBcktFinPlnCatIsOrigl,
  ProjectPortfolioBucketUUID,
  PrjPrtfloBcktFinPlnGroupId,
  PrjPrtfloBcktFinPlnGrpSponsor,
  PrjPrtfloBcktFinPlnGrpIsActive,
  PrjPrtfloBcktFinPlnGrpIsOrigl,
  PrjPrtfloBcktFinPlnChgdDteTme,
  PrjPrtfloBcktFinPlnChangedBy,
  PrjPrtfloBcktFinPlnAmount,
  PrjPrtfloBcktFinPlnCurrency,
  ProjectPortfolioUUID
FROM R_PrjPrtfloBcktFinPlanTP
LEFT OUTER JOIN E_PrjPrtfloBcktFinancialGroup AS _Extension ON PrjPrtfloBcktFinPlanUUID = _Extension.PrjPrtfloBcktFinPlnGroupUUID  -- association [1..1]
;

Learn More