I_ProjectBudgetItemsCube

Column Name Description
ProjectObjectNode FK Object number
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
AccountingDocument Journal Entry
CompanyCode Company Code
LedgerGLLineItem Ledger Journal Entry Item
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
BudgetInGlobalCrcy Amount in Global Currency
BdgtCtrldBdgtCostInGlobCrcy Amount in Global Currency
BdgtCtrldActlAmtInGlobCrcy Amount in Global Currency
BdgtCtrldCmtmtCostInGlobCrcy Amount in Global Currency
💲 Global Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
ActlCostInProjCrcy Amount in Global Currency
BudgetInProjCrcy Amount in Global Currency
ActualAmountInFreeDfndCrcy1 Amount in Global Currency
CmtmtCostInFreeDefinedCrcy2 Amount in Global Currency
ActualAmountInFreeDfndCrcy3 Amount in Global Currency
CmtmtCostInFreeDefinedCrcy4 Amount in Global Currency
BdgtCtrldBdgtCostInProjCrcy Amount in Global Currency
BdgtCtrldActlAmtInProjCrcy Amount in Global Currency
BdgtCtrldCmtmtCostInProjCrcy Amount in Global Currency
ActualAmountInObjectCurrency Amount in Global Currency
CmtmtCostInObjCrcy Amount in Global Currency
BaselineAmtInObjectCrcy Amount in Global Currency
ActualAmountInFreeDfndCrcy7 Amount in Global Currency
CmtmtCostInFreeDefinedCrcy7 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy7 Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
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
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
IsCommitment Indicator: Is Commitment Show values
IsSettled PS Cost Consider Settlements Show values
Column Name Description Domain name
PlanningCategory Plan Category FCOM_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ProjectCategory null
ProfitCenter Profit Center PRCTR
Project Project FIS_PROJECT
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
ProjectDescription Project Name TEXT40
WBSElement WBS Element FIS_WBS
WBSDescription WBS Element Name TEXT40
BusinessPartnerFullName Full Name of Person TEXT80
BusinessPartnerUUID null
BudgetPlanningCategory Plan Category FCOM_CATEGORY
UserDescription User Description
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PartnerWBSElement Partner WBS Element FIS_WBS
ProjectUUID Entity Guid /S4PPM/GUID
TaskUUID Entity Guid /S4PPM/GUID
AvailabilityControlProfileName Budget Availability Control: Profile Name TEXT30
SemanticTagName Name of Semantic Tag of Hierarchy Node FINS_SEM_TAG_NAME
SemanticTagIsBudgetRelevant null
ProjectIsBudgetRelevant null
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Business Area
  • Client
  • Business Area
  • I_PROJECTBUDGETITEMSCUBE.MANDT == TGSB.MANDT
  • I_PROJECTBUDGETITEMSCUBE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PROJECTBUDGETITEMSCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_PROJECTBUDGETITEMSCUBE.MANDT == T004.MANDT
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTBUDGETITEMSCUBE.MANDT == TKA01.MANDT
  • I_PROJECTBUDGETITEMSCUBE.CONTROLLINGAREA == TKA01.KOKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PROJECTBUDGETITEMSCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_PROJECTBUDGETITEMSCUBE.MANDT == T009.MANDT
G/L Account
  • ?
  • G/L Account
  • Client
  • I_PROJECTBUDGETITEMSCUBE.[column in domain "BUKRS"] == SKB1.BUKRS
  • I_PROJECTBUDGETITEMSCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PROJECTBUDGETITEMSCUBE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PROJECTBUDGETITEMSCUBE.MANDT == TCURC.MANDT
  • I_PROJECTBUDGETITEMSCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTBUDGETITEMSCUBE.MANDT == TCJ41.MANDT
  • I_PROJECTBUDGETITEMSCUBE.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Project Type
  • Client
  • I_PROJECTBUDGETITEMSCUBE.PROJECTTYPE == TCJ1.PRART
  • I_PROJECTBUDGETITEMSCUBE.MANDT == TCJ1.MANDT
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • ?
  • I_PROJECTBUDGETITEMSCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTBUDGETITEMSCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_PROJECTBUDGETITEMSCUBE.MANDT == CSKS.MANDT
  • I_PROJECTBUDGETITEMSCUBE.[column in domain "DATBI"] == CSKS.DATBI
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • I_PROJECTBUDGETITEMSCUBE.MANDT == CEPC.MANDT
  • I_PROJECTBUDGETITEMSCUBE.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTBUDGETITEMSCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTBUDGETITEMSCUBE.WBSELEMENTPROFITCENTER == CEPC.PRCTR