C_ProjectFinancialSummary

Monitor Projects | view: CPROJFINSMMRY | Extraction: Not supported | Component: VDM views for Costs
Tables used: CGPL_HIERARCHY, ACDOCA, ACDOCP, FINSC_AVC_PROF, USR21, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, AUFK, FINSC_LEDGER, DPR_BUPA_LINK, DPR_ENTITY_LINK, FCOMC_CATEGORY, TCJ4T, T000, FINSC_SEM_TAG, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ProjectInternalID FK Project Internal ID
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
ActlCmtmtCumltvAmtInGlobCrcy Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
ActlPlnDiffAmtInGlobalCrcy null
BudgetInGlobalCrcy Amount in Global Currency
AccmltdAvailBdgtInGlobalCrcy null
PredictedAmtInGlobalCurrency Amount in Global Currency
LowerPredictionAmtInGlobCrcy Amount in Global Currency
UpperPredictionAmtInGlobCrcy Amount in Global Currency
ActualCostForCostComponent1 null
ActualCostForCostComponent2 null
ActualCostForCostComponent3 null
ActualCostForCostComponent4 null
ActualCost null
PlanCostForCostComponent1 null
PlanCostForCostComponent2 null
PlanCostForCostComponent3 null
PlanCostForCostComponent4 null
PlannedCost null
💲 CO Object Currency (ControllingObjectCurrency):
ActlCostInProjCrcy Amount in Object Currency
CmtmtCostInProjCrcy Amount in CO Object Currency
PlndCostAmtInProjCrcy Amount in Object Currency
ActlPlnDiffAmtInProjectCrcy null
BudgetInProjCrcy Amount in Object Currency
💲 Global Currency (ProjectCurrency):
AssgdValForBudgetInProjCrcy Amount in Global Currency
AvailableBudgetInProjectCrcy null
Column Name Description
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
PostingDate Posting Date
CreationDate Creation Date
PredictedCostCreationDate null
Column Name Description
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
AvailabilityControlIsActive Availability control indicator(AVC) Show values
ProjectProcessingStatus Object Processing Status Show values
Column Name Description Domain name
ProjectUUID Entity Guid /S4PPM/GUID
Project Project Number (External) Edited
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ControllingArea Controlling Area
ProjectDescription Project Name TEXT40
PlanningCategory Plan Category FCOM_CATEGORY
ProjectCategory Project Category DPR_PROJECT_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node
StatusIsActive null
ProjectProfileCodeText Text for Profile TEXT40
BusinessPartner Business Partner Number
BusinessPartnerUUID null
BusinessPartnerFullName Full Name of Person TEXT80
AvailyCtrlTimeRangeType Budget Availability Control: Time Range
AvailyCtrlTimeRangeTypeDesc Short Text for Fixed Values DDTEXT
BudgetConsumption null
PredictedCostPostingDate null
ProjectFinPostingIsAvailable null
ActualCostComponentName1 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
ActualCostComponentName2 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
ActualCostComponentName3 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
ActualCostComponentName4 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
PlanCostComponentName1 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
PlanCostComponentName2 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
PlanCostComponentName3 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
PlanCostComponentName4 Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
CostComponentName Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Company Code
  • Client
  • Company Code
  • C_PROJECTFINANCIALSUMMARY.MANDT == T001.MANDT
  • C_PROJECTFINANCIALSUMMARY.COMPANYCODE == T001.BUKRS
CO Object Currency
  • Client
  • CO Object Currency
  • C_PROJECTFINANCIALSUMMARY.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALSUMMARY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • C_PROJECTFINANCIALSUMMARY.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALSUMMARY.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • C_PROJECTFINANCIALSUMMARY.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTFINANCIALSUMMARY.MANDT == CEPC.MANDT
  • C_PROJECTFINANCIALSUMMARY.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTFINANCIALSUMMARY.CONTROLLINGAREA == CEPC.KOKRS
Project Internal ID
  • Project Internal ID
  • Client
  • C_PROJECTFINANCIALSUMMARY.PROJECTINTERNALID == PROJ.PSPNR
  • C_PROJECTFINANCIALSUMMARY.MANDT == PROJ.MANDT
Profile ID for project structure
  • Client
  • Project Profile
  • C_PROJECTFINANCIALSUMMARY.MANDT == TCJ41.MANDT
  • C_PROJECTFINANCIALSUMMARY.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Client
  • Project Type
  • C_PROJECTFINANCIALSUMMARY.MANDT == TCJ1.MANDT
  • C_PROJECTFINANCIALSUMMARY.PROJECTTYPE == TCJ1.PRART
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • ?
  • C_PROJECTFINANCIALSUMMARY.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJECTFINANCIALSUMMARY.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJECTFINANCIALSUMMARY.MANDT == CSKS.MANDT
  • C_PROJECTFINANCIALSUMMARY.[column in domain "KOKRS"] == CSKS.KOKRS
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting