P_PROJECTFINBUDGETSMMRY

Project Financial Budget Summary | view: PPROJFBUDGETSMRY | Extraction: Not supported | Component: VDM views for Costs
Tables used: ACDOCA, ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, AUFK, FINSC_LEDGER, T000, FINSC_SEM_TAG, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ProjectUUID Entity Guid
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):
AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
ActlCmtmtCumltvAmtInGlobCrcy Amount in Global Currency
PredictedAmtInGlobalCurrency Amount in Global Currency
LowerPredictionAmtInGlobCrcy Amount in Global Currency
UpperPredictionAmtInGlobCrcy Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
ActlCostInProjCrcy Amount in Object Currency
CmtmtCostInProjCrcy Amount in CO Object Currency
AssgdValForBudgetInProjCrcy Amount in Object Currency
Column Name Description
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
CurrentDate null
PostingDate Posting Date
CreationDate Creation Date
PredictedCostCreationDate null
Column Name Description
ProcessingStatus Object Processing Status Show values
AvailabilityControlIsActive Availability control indicator(AVC) Show values
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
ProjectProcessingStatus Object Processing Status Show values
Column Name Description Domain name
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Name TEXT40
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ControllingArea Controlling Area CACCD
PlanningCategory Plan Category FCOM_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
PredictedCostPostingDate null
IsSettled null
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Company Code
  • Client
  • Company Code
  • P_PROJECTFINBUDGETSMMRY.MANDT == T001.MANDT
  • P_PROJECTFINBUDGETSMMRY.COMPANYCODE == T001.BUKRS
CO Object Currency
  • CO Object Currency
  • Client
  • P_PROJECTFINBUDGETSMMRY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • P_PROJECTFINBUDGETSMMRY.MANDT == TCURC.MANDT
Functional Area
  • Functional Area
  • Client
  • P_PROJECTFINBUDGETSMMRY.FUNCTIONALAREA == TFKB.FKBER
  • P_PROJECTFINBUDGETSMMRY.MANDT == TFKB.MANDT
Global Currency
  • Client
  • Global Currency
  • P_PROJECTFINBUDGETSMMRY.MANDT == TCURC.MANDT
  • P_PROJECTFINBUDGETSMMRY.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Profit Center
  • Controlling Area
  • Client
  • Profit Center
  • ?
  • P_PROJECTFINBUDGETSMMRY.CONTROLLINGAREA == CEPC.KOKRS
  • P_PROJECTFINBUDGETSMMRY.MANDT == CEPC.MANDT
  • P_PROJECTFINBUDGETSMMRY.PROFITCENTER == CEPC.PRCTR
  • P_PROJECTFINBUDGETSMMRY.[column in domain "DATBI"] == CEPC.DATBI
Project Category
  • Client
  • Project Category
Project Internal ID
  • Client
  • Project Internal ID
  • P_PROJECTFINBUDGETSMMRY.MANDT == PROJ.MANDT
  • P_PROJECTFINBUDGETSMMRY.PROJECTINTERNALID == PROJ.PSPNR
Profile ID for project structure
  • Client
  • Project Profile
  • P_PROJECTFINBUDGETSMMRY.MANDT == TCJ41.MANDT
  • P_PROJECTFINBUDGETSMMRY.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • Client
  • ?
  • Responsible Cost Center
  • ?
  • P_PROJECTFINBUDGETSMMRY.MANDT == CSKS.MANDT
  • P_PROJECTFINBUDGETSMMRY.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PROJECTFINBUDGETSMMRY.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PROJECTFINBUDGETSMMRY.[column in domain "DATBI"] == CSKS.DATBI
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client