P_ProjectFinBdgtSummary

Project Financial Budget Summary | view: PPROJFBDGTSMRY | Extraction: Not supported | Component: VDM views for Costs
Tables used: AFIH, AFKO, 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, T000, FINSC_SEM_TAG, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Project Project Number (External) Edited
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 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
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
ProjectUUID Entity Guid /S4PPM/GUID
ProjectDescription Project Name TEXT40
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
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
  • Budget Availability Control: Profile
  • Client
Company code
  • Client
  • Company Code
  • P_PROJECTFINBDGTSUMMARY.MANDT == T001.MANDT
  • P_PROJECTFINBDGTSUMMARY.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling Area
  • Client
  • P_PROJECTFINBDGTSUMMARY.CONTROLLINGAREA == TKA01.KOKRS
  • P_PROJECTFINBDGTSUMMARY.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • P_PROJECTFINBDGTSUMMARY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • P_PROJECTFINBDGTSUMMARY.MANDT == TCURC.MANDT
Global Currency
  • Global Currency
  • Client
  • P_PROJECTFINBDGTSUMMARY.GLOBALCURRENCY == TCURC.WAERS
  • P_PROJECTFINBDGTSUMMARY.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • P_PROJECTFINBDGTSUMMARY.MANDT == CEPC.MANDT
  • P_PROJECTFINBDGTSUMMARY.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJECTFINBDGTSUMMARY.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJECTFINBDGTSUMMARY.PROFITCENTER == CEPC.PRCTR
Project Category
  • Client
  • Project Category
Profile ID for project structure
  • Client
  • Project Profile
  • P_PROJECTFINBDGTSUMMARY.MANDT == TCJ41.MANDT
  • P_PROJECTFINBDGTSUMMARY.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Client
  • Project Type
  • P_PROJECTFINBDGTSUMMARY.MANDT == TCJ1.MANDT
  • P_PROJECTFINBDGTSUMMARY.PROJECTTYPE == TCJ1.PRART
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • ?
  • P_PROJECTFINBDGTSUMMARY.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PROJECTFINBDGTSUMMARY.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PROJECTFINBDGTSUMMARY.MANDT == CSKS.MANDT
  • P_PROJECTFINBDGTSUMMARY.[column in domain "DATBI"] == CSKS.DATBI
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client