I_ProjectBudgetItems

Project Budget Items | view: IPROJBDGTITEM | TRAN | Extraction: Full only | Component: VDM views for Costs
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, FINSC_AVC_PROF, FINSC_AVC_PROFT, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, FINSC_FAGL2SEMTA, HRRP_NODE, FINSC_LEDGER, AUFK, FCOMC_CATEGORY, T000, FINSC_SEM_TAG, FINSC_HRRP2SEMTA, FINSC_AVC_SEMTAG, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode 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
BudgetInGlobalCrcy Amount in Global Currency
BdgtCtrldBdgtCostInGlobCrcy Amount in Global Currency
BdgtCtrldActlAmtInGlobCrcy Amount in Global Currency
BdgtCtrldCmtmtCostInGlobCrcy Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Global Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
ActlCostInProjCrcy Amount in Global Currency
CmtmtCostInProjCrcy Amount in Global Currency
BudgetInProjCrcy Amount in Global Currency
PlndCostAmtInProjCrcy Amount in Object 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
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
CurrentDate 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
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
IsCommitment Indicator: Is Commitment Show values
Column Name Description Domain name
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
BudgetProcess Budget Process Type BUDGET_PROCESS
Project Project FIS_PROJECT
ProjectDescription Project Name TEXT40
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
ProfitCenter Profit Center PRCTR
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ProjectCategory null
ProjectUUID Entity Guid /S4PPM/GUID
WBSElement WBS Element FIS_WBS
WBSDescription WBS Element Name TEXT40
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
PlanningCategory Plan Category FCOM_CATEGORY
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
IsSettled null
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
BudgetPlanningCategory Plan Category FCOM_CATEGORY
JointVentureWBSElementExtID Work Breakdown Structure Element (WBS Element) PS_POSID
TaskUUID Entity Guid /S4PPM/GUID
AvailabilityControlProfileName Budget Availability Control: Profile Name TEXT30
SemanticTagIsBudgetRelevant null
ObjectIsBudgeted null
ProjectIsBudgetRelevant null
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Business Area
  • Client
  • Business Area
  • I_PROJECTBUDGETITEMS.MANDT == TGSB.MANDT
  • I_PROJECTBUDGETITEMS.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PROJECTBUDGETITEMS.MANDT == T004.MANDT
  • I_PROJECTBUDGETITEMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code Currency
  • Client
  • Company Code Currency
  • I_PROJECTBUDGETITEMS.MANDT == TCURC.MANDT
  • I_PROJECTBUDGETITEMS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTBUDGETITEMS.MANDT == TKA01.MANDT
  • I_PROJECTBUDGETITEMS.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • ?
  • Cost Center
  • I_PROJECTBUDGETITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROJECTBUDGETITEMS.MANDT == CSKS.MANDT
  • I_PROJECTBUDGETITEMS.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTBUDGETITEMS.COSTCENTER == CSKS.KOSTL
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PROJECTBUDGETITEMS.FISCALYEARVARIANT == T009.PERIV
  • I_PROJECTBUDGETITEMS.MANDT == T009.MANDT
Functional Currency
  • Functional Currency
  • Client
  • I_PROJECTBUDGETITEMS.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_PROJECTBUDGETITEMS.MANDT == TCURC.MANDT
G/L Account
  • Client
  • G/L Account
  • ?
  • I_PROJECTBUDGETITEMS.MANDT == SKB1.MANDT
  • I_PROJECTBUDGETITEMS.GLACCOUNT == SKB1.SAKNR
  • I_PROJECTBUDGETITEMS.[column in domain "BUKRS"] == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • I_PROJECTBUDGETITEMS.GLOBALCURRENCY == TCURC.WAERS
  • I_PROJECTBUDGETITEMS.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Partner Order
  • Partner Order
  • Client
  • I_PROJECTBUDGETITEMS.PARTNERORDER == AUFK.AUFNR
  • I_PROJECTBUDGETITEMS.MANDT == AUFK.MANDT
Project Internal ID
  • Project Internal ID
  • Client
  • I_PROJECTBUDGETITEMS.PROJECTINTERNALID == PROJ.PSPNR
  • I_PROJECTBUDGETITEMS.MANDT == PROJ.MANDT
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTBUDGETITEMS.MANDT == TCJ41.MANDT
  • I_PROJECTBUDGETITEMS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Client
  • Project Type
  • I_PROJECTBUDGETITEMS.MANDT == TCJ1.MANDT
  • I_PROJECTBUDGETITEMS.PROJECTTYPE == TCJ1.PRART
Responsible cost center
  • ?
  • Client
  • ?
  • Responsible Cost Center
  • I_PROJECTBUDGETITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROJECTBUDGETITEMS.MANDT == CSKS.MANDT
  • I_PROJECTBUDGETITEMS.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTBUDGETITEMS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Logical System I_PROJECTBUDGETITEMS.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PROJECTBUDGETITEMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • I_PROJECTBUDGETITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PROJECTBUDGETITEMS.MANDT == TCURC.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_PROJECTBUDGETITEMS.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTBUDGETITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTBUDGETITEMS.MANDT == CEPC.MANDT
  • I_PROJECTBUDGETITEMS.WBSELEMENTPROFITCENTER == CEPC.PRCTR