R_PrjPrtfloItemFinancialPlanTP

DDL: R_PRJPRTFLOITEMFINANCIALPLANTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 2 Associations

Prj Prtflo Fin Planning for Item - TP

R_PrjPrtfloItemFinancialPlanTP is a Transactional CDS View that provides data about "Prj Prtflo Fin Planning for Item - TP" in SAP S/4HANA. It reads from 1 data source (I_PrjPrtfloItemFinPlanData) and exposes 23 fields with key fields PrjPrtfloItmFinPlnUUID, PrjPrtfloItmFinancialPlanType, FiscalYear, FiscalPeriod, PrjPrtfloItmFinPlnCategoryUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrjPrtfloItemFinPlanData I_PrjPrtfloItemFinPlanData from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ProjectPortfolioTP _Portfolio $projection.ProjectPortfolioUUID = _Portfolio.ProjectPortfolioUUID --Extension
[1..1] E_PrjPrtfloItemFinancialGroup _Extension $projection.PrjPrtfloItmFinPlnUUID = _Extension.PrjPrtfloItmFinPlanGroupUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Prj Prtflo Fin Planning for Item - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PrjPrtfloItmFinPlnUUID I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnUUID
KEY PrjPrtfloItmFinancialPlanType I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinancialPlanType
KEY FiscalYear I_PrjPrtfloItemFinPlanData FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_PrjPrtfloItemFinPlanData FiscalPeriod Tax period
KEY PrjPrtfloItmFinPlnCategoryUUID I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnCategoryUUID
PrjPrtfloItmFinPlanPeriodDate I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlanPeriodDate
PrjPrtfloItmFinPlnChgdDateTime I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnChgdDateTime
PrjPrtfloItmFinPlanChangedBy I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlanChangedBy
PrjPrtfloItmFinPlanAmount I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlanAmount
PrjPrtfloItmFinPlanCurrency I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlanCurrency
PrjPrtfloItmFinPlnCategoryId I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnCategoryId
PrjPrtfloItmFinPlnCatParUUID I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnCatParUUID
PrjPrtfloItmFinPlnCatIsActive I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnCatIsActive
PrjPrtfloItmFinPlnCatIsOrigl I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnCatIsOrigl
PrjPrtfloItmFinPlnGroupId I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnGroupId
PrjPrtfloItmFinPlnGrpSponsor I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnGrpSponsor
PrjPrtfloItmFinGrpParUUID I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinGrpParUUID
PrjPrtfloItmFinPlnGrpIsActive I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnGrpIsActive
PrjPrtfloItmFinPlnGrpIsOrigl I_PrjPrtfloItemFinPlanData PrjPrtfloItmFinPlnGrpIsOrigl
ProjectPortfolioUUID I_PrjPrtfloItemFinPlanData ProjectPortfolioUUID
ProjectPortfolioItemUUID I_PrjPrtfloItemFinPlanData ProjectPortfolioItemUUID
_Item _Item
_Portfolio _Portfolio

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 R_PrjPrtfloItemFinancialPlanTP.
-- 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 R_PrjPrtfloItemFinancialPlanTP AS
SELECT
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnUUID AS PrjPrtfloItmFinPlnUUID,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinancialPlanType AS PrjPrtfloItmFinancialPlanType,
  I_PrjPrtfloItemFinPlanData.FiscalYear AS FiscalYear,
  I_PrjPrtfloItemFinPlanData.FiscalPeriod AS FiscalPeriod,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnCategoryUUID AS PrjPrtfloItmFinPlnCategoryUUID,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlanPeriodDate AS PrjPrtfloItmFinPlanPeriodDate,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnChgdDateTime AS PrjPrtfloItmFinPlnChgdDateTime,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlanChangedBy AS PrjPrtfloItmFinPlanChangedBy,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlanAmount AS PrjPrtfloItmFinPlanAmount,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlanCurrency AS PrjPrtfloItmFinPlanCurrency,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnCategoryId AS PrjPrtfloItmFinPlnCategoryId,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnCatParUUID AS PrjPrtfloItmFinPlnCatParUUID,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnCatIsActive AS PrjPrtfloItmFinPlnCatIsActive,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnCatIsOrigl AS PrjPrtfloItmFinPlnCatIsOrigl,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnGroupId AS PrjPrtfloItmFinPlnGroupId,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnGrpSponsor AS PrjPrtfloItmFinPlnGrpSponsor,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinGrpParUUID AS PrjPrtfloItmFinGrpParUUID,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnGrpIsActive AS PrjPrtfloItmFinPlnGrpIsActive,
  I_PrjPrtfloItemFinPlanData.PrjPrtfloItmFinPlnGrpIsOrigl AS PrjPrtfloItmFinPlnGrpIsOrigl,
  I_PrjPrtfloItemFinPlanData.ProjectPortfolioUUID AS ProjectPortfolioUUID,
  I_PrjPrtfloItemFinPlanData.ProjectPortfolioItemUUID AS ProjectPortfolioItemUUID
FROM I_PrjPrtfloItemFinPlanData
LEFT OUTER JOIN R_ProjectPortfolioTP AS _Portfolio ON ProjectPortfolioUUID = _Portfolio.ProjectPortfolioUUID  -- association [1..1]
LEFT OUTER JOIN E_PrjPrtfloItemFinancialGroup AS _Extension ON PrjPrtfloItmFinPlnUUID = _Extension.PrjPrtfloItmFinPlanGroupUUID  -- association [1..1]
;

Learn More