I_PPM_ProjectCostForecastData

Project Cost Forecast: ML Training Input | view: IPROCSTFRCDTA | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt
Tables used: SCAL_TT_DATE, CGPL_HIERARCHY, CGPL_HIERARCHY, SCAL_TT_MONTH, SCAL_TT_YEAR, ACDOCA, ACDOCP, FINSC_AVC_PROF, USR21, T001, TKA02, TKA01, /S4PPM/HIERARCHY, /S4PPM/TASK, PRPS, AUFK, FINSC_LEDGER, DPR_PART, DPR_PART_ROLE, /S4PPM/PROJECT, /S4PPM/TASK, DPR_BUPA_LINK, PROJ, T000, FINSC_SEM_TAG, PRPS, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ProjectInternalID Project (internal)
Column Name Description
ActualCostAmount Actual Amount in Global Currency
Column Name Description
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
PlannedStartByErlstPlannedCost Planned Start
PlannedEndByLtstPlannedCost Planned Finish
ActualStartByErlstActualCost Actual Start
ActualEndByLtstActualCost Actual Finish
Column Name Description
ProjectProcessingStatus Object Processing Status Show values
Column Name Description Domain name
TargetProjectID null
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSDescription WBS Element Name TEXT40
Project Project definition PS_PSPID
PlannedDuration Number of Days in Year or Month INT4
PlannedCostStartYearMonth Year Month NUM6
PlannedCostEndYearMonth Year Month NUM6
PlannedCostErlstToLtstDurn Number of Days in Year or Month INT4
ActualCostStartYearMonth Year Month NUM6
ActualCostEndYearMonth Year Month NUM6
ActualCostErlstToLtstDurn Number of Days in Year or Month INT4
NumberOfWBSElements 4 Byte Signed Integer INT4
TeamMemberCount 4 Byte Signed Integer INT4
TeamMemberRoleStaffingCount 4 Byte Signed Integer INT4
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == T001.MANDT
  • I_PPM_PROJECTCOSTFORECASTDATA.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling Area
  • Client
  • I_PPM_PROJECTCOSTFORECASTDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == TKA01.MANDT
Cost center
  • ?
  • Client
  • ?
  • Cost center to which costs are actually posted
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == CSKS.MANDT
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PPM_PROJECTCOSTFORECASTDATA.COSTCENTER == CSKS.KOSTL
Costing sheet
  • Costing Sheet
  • ?
  • Client
  • ?
  • I_PPM_PROJECTCOSTFORECASTDATA.COSTINGSHEET == T683.KALSM
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "KVEWE"] == T683.KVEWE
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == T683.MANDT
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "KAPPL"] == T683.KAPPL
Factory calendar I_PPM_PROJECTCOSTFORECASTDATA.FACTORYCALENDAR == TFACD.IDENT
Functional Area
  • Functional Area
  • Client
  • I_PPM_PROJECTCOSTFORECASTDATA.FUNCTIONALAREA == TFKB.FKBER
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == TFKB.MANDT
Investment Measure Profile
  • Investment Measure Profile
  • Client
  • I_PPM_PROJECTCOSTFORECASTDATA.INVESTMENTPROFILE == TAPRF.IVPRO
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == TAPRF.MANDT
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • I_PPM_PROJECTCOSTFORECASTDATA.PROFITCENTER == CEPC.PRCTR
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "DATBI"] == CEPC.DATBI
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == CEPC.MANDT
Responsible cost center
  • ?
  • Client
  • ?
  • Responsible Cost Center
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "DATBI"] == CSKS.DATBI
  • I_PPM_PROJECTCOSTFORECASTDATA.MANDT == CSKS.MANDT
  • I_PPM_PROJECTCOSTFORECASTDATA.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PPM_PROJECTCOSTFORECASTDATA.RESPONSIBLECOSTCENTER == CSKS.KOSTL