A_PrjPrtfloItemFinancialPlan

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

Proj Portfolio Item Financial Planning

A_PrjPrtfloItemFinancialPlan is a Consumption CDS View that provides data about "Proj Portfolio Item Financial Planning" in SAP S/4HANA. It reads from 1 data source (R_PrjPrtfloItemFinancialPlanTP) and exposes 21 fields with key fields PrjPrtfloItmFinPlnUUID, PrjPrtfloItmFinancialPlanType, FiscalYear, FiscalPeriod, PrjPrtfloItmFinPlnCategoryUUID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECTPORTFOLIO).

Data Sources (1)

SourceAliasJoin Type
R_PrjPrtfloItemFinancialPlanTP R_PrjPrtfloItemFinancialPlanTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PrjPrtfloItemFinancialGroup _Extension $projection.PrjPrtfloItmFinPlnUUID = _Extension.PrjPrtfloItmFinPlanGroupUUID

Annotations (10)

NameValueLevelField
EndUserText.label Proj Portfolio Item 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 PrjPrtfloItemFinancialPlan_Type view
OData.entitySet.name PrjPrtfloItemFinancialPlan view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTPORTFOLIO API_PROJECTPORTFOLIO V4 C2 C1

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PrjPrtfloItmFinPlnUUID PrjPrtfloItmFinPlnUUID
KEY PrjPrtfloItmFinancialPlanType PrjPrtfloItmFinancialPlanType
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY FiscalPeriod FiscalPeriod Tax period
KEY PrjPrtfloItmFinPlnCategoryUUID PrjPrtfloItmFinPlnCategoryUUID
PrjPrtfloItmFinPlanPeriodDate PrjPrtfloItmFinPlanPeriodDate
PrjPrtfloFinPlnPeriodIsInitial PrjPrtfloFinPlnPeriodIsInitial
PrjPrtfloItmFinPlnChgdDateTime PrjPrtfloItmFinPlnChgdDateTime
PrjPrtfloItmFinPlanChangedBy PrjPrtfloItmFinPlanChangedBy
PrjPrtfloItmFinPlanAmount PrjPrtfloItmFinPlanAmount
PrjPrtfloItmFinPlanCurrency PrjPrtfloItmFinPlanCurrency
PrjPrtfloItmFinPlnCategoryId PrjPrtfloItmFinPlnCategoryId
PrjPrtfloItmFinPlnCatIsActive PrjPrtfloItmFinPlnCatIsActive
PrjPrtfloItmFinPlnCatIsOrigl PrjPrtfloItmFinPlnCatIsOrigl
ProjectPortfolioItemUUID ProjectPortfolioItemUUID
PrjPrtfloItmFinPlnGroupId PrjPrtfloItmFinPlnGroupId
PrjPrtfloItmFinPlnGrpSponsor PrjPrtfloItmFinPlnGrpSponsor
PrjPrtfloItmFinPlnGrpIsActive PrjPrtfloItmFinPlnGrpIsActive
PrjPrtfloItmFinPlnGrpIsOrigl PrjPrtfloItmFinPlnGrpIsOrigl
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_PrjPrtfloItemFinancialPlan.
-- 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_PrjPrtfloItemFinancialPlan AS
SELECT
  PrjPrtfloItmFinPlnUUID,
  PrjPrtfloItmFinancialPlanType,
  FiscalYear,
  FiscalPeriod,
  PrjPrtfloItmFinPlnCategoryUUID,
  PrjPrtfloItmFinPlanPeriodDate,
  PrjPrtfloFinPlnPeriodIsInitial,
  PrjPrtfloItmFinPlnChgdDateTime,
  PrjPrtfloItmFinPlanChangedBy,
  PrjPrtfloItmFinPlanAmount,
  PrjPrtfloItmFinPlanCurrency,
  PrjPrtfloItmFinPlnCategoryId,
  PrjPrtfloItmFinPlnCatIsActive,
  PrjPrtfloItmFinPlnCatIsOrigl,
  ProjectPortfolioItemUUID,
  PrjPrtfloItmFinPlnGroupId,
  PrjPrtfloItmFinPlnGrpSponsor,
  PrjPrtfloItmFinPlnGrpIsActive,
  PrjPrtfloItmFinPlnGrpIsOrigl,
  ProjectPortfolioUUID
FROM R_PrjPrtfloItemFinancialPlanTP
LEFT OUTER JOIN E_PrjPrtfloItemFinancialGroup AS _Extension ON PrjPrtfloItmFinPlnUUID = _Extension.PrjPrtfloItmFinPlanGroupUUID  -- association [1..1]
;

Learn More