I_ProjectPortfolioItem

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 I_ProjectPortfolioItem.
-- 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 I_ProjectPortfolioItem AS
SELECT
  Item.ProjectPortfolioItemUUID AS ProjectPortfolioItemUUID,
  Item.ProjectPortfolioItem AS ProjectPortfolioItem,
  Item.ProjectPortfolioMasterLanguage AS ProjectPortfolioMasterLanguage,
  Item.FiscalYearVariant AS FiscalYearVariant,
  Item.PrjPortfolioDefaultLanguage AS PrjPortfolioDefaultLanguage,
  Item.ProjectPortfolioUUID AS ProjectPortfolioUUID,
  Item.ProjPrtfloItemParentObjectUUID AS ProjPrtfloItemParentObjectUUID,
  Item.ProjectPortfolioItemCategory AS ProjectPortfolioItemCategory,
  Item.ProjPortfolioItemSubcategory AS ProjPortfolioItemSubcategory,
  Item.ProjectPortfolioItemStage AS ProjectPortfolioItemStage,
  Item.ProjectPortfolioItemGroup AS ProjectPortfolioItemGroup,
  Item.ProjPrtfloItemTechnologyType AS ProjPrtfloItemTechnologyType,
  Item.ProjPrtfloItmAssessedRiskValue AS ProjPrtfloItmAssessedRiskValue,
  Item.ProjPrtfloItmProbltyTechSuccss AS ProjPrtfloItmProbltyTechSuccss,
  Item.ProjPrtfloItmProbltyCommSuccss AS ProjPrtfloItmProbltyCommSuccss,
  Item.ProjPrtfloItemHeadcountValue AS ProjPrtfloItemHeadcountValue,
  Item.ProjPrtfloItemDevelopmentCost AS ProjPrtfloItemDevelopmentCost,
  Item.ProjectPortfolioItemLaunchCost AS ProjectPortfolioItemLaunchCost,
  Item.ProjPrtfloItmNPVAmount AS ProjPrtfloItmNPVAmount,
  Item.ProjectPortfolioItemCurrency AS ProjectPortfolioItemCurrency,
  Item.ProjectPortfolioItemLocation AS ProjectPortfolioItemLocation,
  Item.ProjectPortfolioItemGeography AS ProjectPortfolioItemGeography,
  Item.LastChangeDateTime AS LastChangeDateTime,
  Item.ProjPrtfloItmFinPeriodType AS ProjPrtfloItmFinPeriodType,
  Item.ProjPortfolioItemCapacityUnit AS ProjPortfolioItemCapacityUnit,
  Item.ProjPrtfloItmFcstdStartDate AS ProjPrtfloItmFcstdStartDate,
  Item.ProjPrtfloItmPlannedStartDate AS ProjPrtfloItmPlannedStartDate,
  Item.ProjPrtfloItemActualStartDate AS ProjPrtfloItemActualStartDate,
  Item.ProjPrtfloItmFcstdFinishDate AS ProjPrtfloItmFcstdFinishDate,
  Item.ProjPrtfloItmPlannedFinishDate AS ProjPrtfloItmPlannedFinishDate,
  Item.ProjPrtfloItemActualFinishDate AS ProjPrtfloItemActualFinishDate,
  Item.ProjPortfolioItemIsEscalated AS ProjPortfolioItemIsEscalated,
  Item.ProjectPortfolioItemType AS ProjectPortfolioItemType,
  Item.ProjPortfolioItemHeaderUUID AS ProjPortfolioItemHeaderUUID,
  Item.ProjPrtfloItmExpdCommlValueAmt AS ProjPrtfloItmExpdCommlValueAmt,
  Item.ProjPortfolioItemPriorityGroup AS ProjPortfolioItemPriorityGroup,
  Item.ProjectPortfolioItemChangedBy AS ProjectPortfolioItemChangedBy,
  Item.ProjPrtfloItemClassification AS ProjPrtfloItemClassification,
  Item.ProjectPortfolioItemStatus AS ProjectPortfolioItemStatus,
  Item.ProjPrtfloItmCapPlngPerdType AS ProjPrtfloItmCapPlngPerdType,
  Item.ProjPortfolioItemDiscountRate AS ProjPortfolioItemDiscountRate,
  Item.ProjPrtfloDcsnPointActiveUUID AS ProjPrtfloDcsnPointActiveUUID,
  Item.ProjPrtfloItmFcstdBdgtTotAmt AS ProjPrtfloItmFcstdBdgtTotAmt,
  Item.ProjPrtfloItmFcstdBdgtAnnAmt AS ProjPrtfloItmFcstdBdgtAnnAmt,
  Item.ProjPrtfloItmFcstdCostTotAmt AS ProjPrtfloItmFcstdCostTotAmt,
  Item.ProjPrtfloItemYTDFcstdCost AS ProjPrtfloItemYTDFcstdCost,
  Item.ProjPortfolioItemTemplateUUID AS ProjPortfolioItemTemplateUUID,
  Item.ProjPortfolioItemRiskPercent AS ProjPortfolioItemRiskPercent,
  Item.ProjectPortfolioItemRiskGroup AS ProjectPortfolioItemRiskGroup,
  Item.ProjectPortfolioItemRiskIcon AS ProjectPortfolioItemRiskIcon,
  Item.ProjPortfolioItemDerivedRisk AS ProjPortfolioItemDerivedRisk,
  Item.ProjPrtfloItemActualHeadNmbrOf AS ProjPrtfloItemActualHeadNmbrOf,
  Item.ProjPortfolioItemPriorityIcon AS ProjPortfolioItemPriorityIcon,
  Item.ProjPortfolioItemPhaseIcon AS ProjPortfolioItemPhaseIcon,
  Item.ProjectPortfolioItemBudgetIcon AS ProjectPortfolioItemBudgetIcon,
  Item.ProjPortfolioItemScheduleIcon AS ProjPortfolioItemScheduleIcon,
  Item.ProjPortfolioItemStaffingIcon AS ProjPortfolioItemStaffingIcon,
  Item.ProjPrtfloItmBudgetTotalAmount AS ProjPrtfloItmBudgetTotalAmount,
  Item.ProjPrtfloItmBdgtAnnualAmount AS ProjPrtfloItmBdgtAnnualAmount,
  Item.ProjPortfolioItemPlannedCost AS ProjPortfolioItemPlannedCost,
  Item.ProjPrtfloItemYTDPlannedCost AS ProjPrtfloItemYTDPlannedCost,
  Item.ProjectPortfolioItemActualCost AS ProjectPortfolioItemActualCost,
  Item.ProjPrtfloItmYTDActualCost AS ProjPrtfloItmYTDActualCost,
  Item.ProjectPortfolioItemIsProposal AS ProjectPortfolioItemIsProposal,
  Item.ProjPortfolioItemStatusGroup AS ProjPortfolioItemStatusGroup,
  Item.ProjPrtfloItemWorkEffortTotal AS ProjPrtfloItemWorkEffortTotal,
  Item.ProjPrtfloItmYTDWorkEffort AS ProjPrtfloItmYTDWorkEffort,
  Item.ProjectPortfolioItemWorkEffort AS ProjectPortfolioItemWorkEffort,
  Item.ProjPrtfloItemYTDPlannedEffort AS ProjPrtfloItemYTDPlannedEffort,
  Item.ProjPrtfloItmRetOnInvmtAmount AS ProjPrtfloItmRetOnInvmtAmount,
  Item.ProjPrtfloItmIntRateOfRetAmt AS ProjPrtfloItmIntRateOfRetAmt,
  Item.ProjPrtfloItemDerivedRiskGroup AS ProjPrtfloItemDerivedRiskGroup,
  Item.ProjPrtfloItemDerivedRiskIcon AS ProjPrtfloItemDerivedRiskIcon,
  Item.ProjPrtfloItmFcstdDuration AS ProjPrtfloItmFcstdDuration,
  Item.ProjPrtfloItemPlannedDuration AS ProjPrtfloItemPlannedDuration,
  Item.ProjPrtfloItemActualDuration AS ProjPrtfloItemActualDuration,
  Item.ProjPrtfloItmStfngStatusGroup AS ProjPrtfloItmStfngStatusGroup,
  Item.ProjPrtfloItmBudgetStatusGroup AS ProjPrtfloItmBudgetStatusGroup,
  Item.ProjPrtfloItmSchedStatusGroup AS ProjPrtfloItmSchedStatusGroup,
  Item.ProjPrtfloItmPlndRevenueAmt AS ProjPrtfloItmPlndRevenueAmt,
  Item.ProjPrtfloItmYTDPlannedRevenue AS ProjPrtfloItmYTDPlannedRevenue,
  Item.ProjPortfolioItemActualRevenue AS ProjPortfolioItemActualRevenue,
  Item.ProjPrtfloItemYTDActualRevenue AS ProjPrtfloItemYTDActualRevenue,
  Item.ProjPrtfloItmNPVPlanAmount AS ProjPrtfloItmNPVPlanAmount,
  Item.ProjPrtfloItmIntRateRetPlanAmt AS ProjPrtfloItmIntRateRetPlanAmt,
  Item.ProjPrtfloItmRetOnInvmtPlanAmt AS ProjPrtfloItmRetOnInvmtPlanAmt,
  Item.ProjPrtfloItemPaybackPlanValue AS ProjPrtfloItemPaybackPlanValue,
  Item.PrjPrtfloItmExpdCommlValPlnAmt AS PrjPrtfloItmExpdCommlValPlnAmt,
  Item._Portfolio AS _Portfolio
FROM I_ProjectPortfolioItemBasic AS Item
INNER JOIN I_EPPMGlobalSwitchSetting AS Settings ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectPortfolioPlanningText AS _ProjectPortfolioItemText ON ProjectPortfolioItemUUID = _ProjectPortfolioItemText.ProjPortfolioPlanningTextUUID  -- association [0..1]
LEFT OUTER JOIN E_ProjectPortfolioItem AS _Extension ON ProjectPortfolioItemUUID = _Extension.ProjectPortfolioItemUUID  -- association [1..1]
LEFT OUTER JOIN E_ProjectPortfolioItemDerived AS _ExtensionDer ON ProjectPortfolioItemUUID = _ExtensionDer.ProjectPortfolioItemUUID  -- association [1..1]
;