I_MstrProjFinancialPlan

Commercial Project Financial Plan | view: IMSTRPROJFINPLN | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Column Name Description
MasterProjectUUID NodeID
MasterProjectItemUUID NodeID
FinancialPlanUUID NodeID
FinancialPlanVersUUID NodeID
Column Name Description
Column Name Description
Column Name Description
FinancialPlanStartDate Start Date
FinancialPlanEndDate End Date
Column Name Description
FinancialPlanHierType Plan Hierarchy Structure Show values
FinancialPlanArchiveStatus Archiving Status Show values
FinPlanVersTransfDelSts Plan Version: Status of Deletion of Transfer Data Show values
Column Name Description Domain name
MasterProject Commercial Project ID /CPD/MP_ID
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
MasterProjectItem Item Key (Master Project) /CPD/MP_ITM_OKEY
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
FinancialPlanID External ID for Financial Plan
FinPlanCrtedByUser Created By XUBNAME
FinPlanCrtedDateTime Created On DEC15
FinPlanLastChgdByUser Changed By XUBNAME
FinPlanLastChgdDateTime Commercial Project Last Changed On DEC15
FinancialPlanStatus Status ID /CPD/PFP_STATUS_ID
FinancialPlanFcstStatus Forecast Status ID /CPD/PFP_FORECAST_ST_ID
FinancialPlanFcstPeriod Forecast Period
FinancialPlanThldPercent PoC Threshold Value (%) /CPD/PFP_THRESHOLD_VALUE
FinPlanReviewYearPerd Review Year Period /CPD/FISCAL_YEAR_PERIOD
FinancialPlanVersion Plan Version ID /CPD/PFP_VERSION_ID
FinPlanVersDesc Version Description /CPD/PFP_VERSION_DESC
FinPlnVersionType Version Type ID /CPD/PFP_VER_TYPE_ID
FinPlanVersStatus Status ID /CPD/PFP_STATUS_ID
FinPlanVersTransferLogID Application Log: External ID BALNREXT
FinPlnVersUpwardTransfLgID Application Log: External ID BALNREXT
FinPlanVersFcstPerd Forecast Period
FinPlanVersPlnFcstPerd Forecast Period
FinPlanVersPlnFcstYear Forecast Year
FinPlanVersCrtedByUser Created By XUBNAME
FinPlanVersCrtedDateTime Created On DEC15
FinPlanVersLastChgdByUser Changed By XUBNAME
FinPlanVersLastChgdDteTime Commercial Project Last Changed On DEC15
Master Data Relations Join Conditions
Plan Currency
  • Plan Currency
  • Client
  • I_MSTRPROJFINANCIALPLAN.FINANCIALPLANCURRENCY == TCURC.WAERS
  • I_MSTRPROJFINANCIALPLAN.MANDT == TCURC.MANDT
Plan Type ID
  • Client
  • Plan Type ID