I_PPM_ProjectCostForecastData

DDL: I_PPM_PROJECTCOSTFORECASTDATA SQL: IPROCSTFRCDTA Type: view COMPOSITE
45 Fields 6 Data Sources

Project Cost Forecast: ML Training Input

I_PPM_ProjectCostForecastData is a Composite CDS View that provides data about "Project Cost Forecast: ML Training Input" in SAP S/4HANA. It reads from 6 data sources and exposes 45 fields with key field ProjectInternalID.

Data Sources (6)

SourceAliasJoin Type
P_ProjectCostSum ProjCost left_outer
I_ProjectCostDates ProjDates left_outer
I_PPM_ProjectSummaryTask ProjSumTask from
I_PPM_ProjTeamMembersCntNoSt TeamMemberCnt left_outer
I_PPM_ProjTeamStaffingCntNoSt TeamStaffingCnt left_outer
I_ProjectToWBSElementCount WBSCount left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPROCSTFRCDTA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Project Cost Forecast: ML Training Input view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID I_PPM_ProjectSummaryTask ProjectInternalID Project Def.
TargetProjectID
WBSElementInternalID I_PPM_ProjectSummaryTask WBSElementInternalID WBS Internal ID
WBSDescription
WBSElementObject
Project
ActualAmountInGlobalCurrency
ActualCostAmount
CompanyCode
ControllingArea
ProfitCenter
ProjectProfileCode
Plant
FunctionalArea
CostCenter
ProjectType
ProjectProcessingStatus I_PPM_ProjectSummaryTask ProjectProcessingStatus
PlannedStartDate
PlannedEndDate
PlanCostStartDate
PlannedStartByErlstPlannedCost
PlanCostStartYearMonth
PlanCostStartYearMonth
PlannedCostStartYearMonth
PlanCostEndDate
PlannedEndByLtstPlannedCost
PlanCostEndYearMonth
PlanCostEndYearMonth
PlanCostEndYearMonth
PlannedCostEndYearMonth
ActualCostStartDate
ActualStartByErlstActualCost
ActualCostStartYearMonth
ActualCostStartYearMonth
ActualCostEndYearMonth
ActualCostEndYearMonth
ActualCostEndDate
ActualEndByLtstActualCost
CostingSheet
ResponsibleCostCenter
FactoryCalendar
InvestmentProfile
NumberOfWBSElements
TeamMemberCount
TeamMemberRoleStaffingCount

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_PPM_ProjectCostForecastData.
-- 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.
-- SQL view name: IPROCSTFRCDTA

CREATE VIEW I_PPM_ProjectCostForecastData AS
SELECT
  ProjSumTask.ProjectInternalID AS ProjectInternalID,
  '1' AS TargetProjectID,
  ProjSumTask.WBSElementInternalID AS WBSElementInternalID,
  ProjSumTask._ProjObjRoot.WBSDescription AS WBSDescription,
  ProjSumTask._ProjObjRoot.WBSElementObject AS WBSElementObject,
  ProjSumTask._ProjObjRoot._Project.Project AS Project,
  cast (ProjCost.ActualAmountInGlobalCurrency as fis_act_ksl) AS ActualCostAmount,
  ProjSumTask._ProjObjRoot.CompanyCode AS CompanyCode,
  ProjSumTask._ProjObjRoot.ControllingArea AS ControllingArea,
  ProjSumTask._ProjObjRoot.ProfitCenter AS ProfitCenter,
  ProjSumTask._I_Project.ProjectProfileCode AS ProjectProfileCode,
  ProjSumTask._ProjObjRoot.Plant AS Plant,
  ProjSumTask._ProjObjRoot.FunctionalArea AS FunctionalArea,
  ProjSumTask._ProjObjRoot.CostCenter AS CostCenter,
  ProjSumTask._ProjObjRoot._ProjectType.ProjectType AS ProjectType,
  ProjSumTask.ProjectProcessingStatus AS ProjectProcessingStatus,
  ProjSumTask._ProjObjRoot._Project.PlannedStartDate AS PlannedStartDate,
  ProjSumTask._ProjObjRoot._Project.PlannedEndDate AS PlannedEndDate,
  cast ((ProjDates.PlannedStartByErlstPlannedCost) as dpr_tv_planstartdate ) AS PlannedStartByErlstPlannedCost,
  cast (ProjDates.PlannedCostStartYearMonth as vdm_yearmonth) AS PlannedCostStartYearMonth,
  cast (ProjDates.PlannedEndByLtstPlannedCost as dpr_tv_planfinishdate ) AS PlannedEndByLtstPlannedCost,
  cast (ProjDates.PlannedCostEndYearMonth as vdm_yearmonth) AS PlannedCostEndYearMonth,
  cast (ProjDates.ActualStartByErlstActualCost as dpr_tv_actual_start) AS ActualStartByErlstActualCost,
  cast (ProjDates.ActualCostStartYearMonth as vdm_yearmonth ) AS ActualCostStartYearMonth,
  cast (ProjDates.ActualCostEndYearMonth as vdm_yearmonth ) AS ActualCostEndYearMonth,
  cast (ProjDates.ActualEndByLtstActualCost as dpr_tv_actual_finish ) AS ActualEndByLtstActualCost,
  ProjSumTask._ProjObjRoot.CostingSheet AS CostingSheet,
  ProjSumTask._ProjObjRoot.ResponsibleCostCenter AS ResponsibleCostCenter,
  ProjSumTask._ProjObjRoot.FactoryCalendar AS FactoryCalendar,
  ProjSumTask._ProjObjRoot.InvestmentProfile AS InvestmentProfile,
  cast( WBSCount.NumberOfWBSElements as int4 ) AS NumberOfWBSElements,
  cast( TeamMemberCnt.TeamMemberCount as int4 ) AS TeamMemberCount,
  cast( TeamStaffingCnt.TeamMemberRoleStaffingCount as int4 ) AS TeamMemberRoleStaffingCount
FROM I_PPM_ProjectSummaryTask AS ProjSumTask
LEFT OUTER JOIN P_ProjectCostSum AS ProjCost ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectCostDates AS ProjDates ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectToWBSElementCount AS WBSCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjTeamMembersCntNoSt AS TeamMemberCnt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_ProjTeamStaffingCntNoSt AS TeamStaffingCnt ON /* join condition not captured in parsed metadata */
;

Learn More