I_ProjectBdgtItemsByPostgPerd

Project Budget Items by Posting Period | view: IPROJBDGTPSTPER | Extraction: Not supported | 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, USR21, 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
LedgerGLLineItem Ledger Journal Entry Item
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
BudgetAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
BudgetAmountInTransactionCrcy Amount in Transaction Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
BudgetInGlobalCrcy Amount in Global Currency
AccmltdAvailBdgtInGlobalCrcy Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
BudgetAmountInFunctionalCrcy Amount in Functional Currency
💲 Global Currency (ControllingObjectCurrency):
ActlCostInProjCrcy Amount in Global Currency
PlndCostAmtInProjCrcy Amount in Object Currency
CmtmtCostInProjCrcy Amount in Global Currency
BudgetInProjCrcy Amount in Global Currency
AmountInObjectCurrency Amount in Object Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
IsSettled PS Cost Consider Settlements Show values
IsCommitment Indicator: Is Commitment Show values
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
Column Name Description Domain name
BudgetProcess Budget Process Type BUDGET_PROCESS
Project Project FIS_PROJECT
ProjectDescription Project Name TEXT40
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
ProfitCenter Profit Center PRCTR
WBSElement WBS Element FIS_WBS
WBSDescription WBS Element Name TEXT40
UserDescription User Description
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
PlanningCategory Plan Category FCOM_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ProjectUUID Entity Guid /S4PPM/GUID
TaskUUID Entity Guid /S4PPM/GUID
SemanticTagIsBudgetRelevant null
ObjectIsBudgeted null
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_PROJECTBDGTITEMSBYPOSTGPERD.BUSINESSAREA == TGSB.GSBER
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PROJECTBDGTITEMSBYPOSTGPERD.CHARTOFACCOUNTS == T004.KTOPL
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == T004.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TCURC.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.COMPANYCODECURRENCY == TCURC.WAERS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TKA01.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.CONTROLLINGAREA == TKA01.KOKRS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == T009.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.FISCALYEARVARIANT == T009.PERIV
Functional Currency
  • Client
  • Functional Currency
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TCURC.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • ?
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == SKB1.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.GLACCOUNT == SKB1.SAKNR
  • I_PROJECTBDGTITEMSBYPOSTGPERD.[column in domain "BUKRS"] == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • I_PROJECTBDGTITEMSBYPOSTGPERD.GLOBALCURRENCY == TCURC.WAERS
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == FINSC_LEDGER.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.LEDGER == FINSC_LEDGER.RLDNR
  • I_PROJECTBDGTITEMSBYPOSTGPERD.SOURCELEDGER == FINSC_LEDGER.RLDNR
Partner Order
  • Partner Order
  • Client
  • I_PROJECTBDGTITEMSBYPOSTGPERD.PARTNERORDER == AUFK.AUFNR
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == AUFK.MANDT
Project Internal ID
  • Project Internal ID
  • Client
  • I_PROJECTBDGTITEMSBYPOSTGPERD.PROJECTINTERNALID == PROJ.PSPNR
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == PROJ.MANDT
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TCJ41.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • Client
  • ?
  • ?
  • Responsible Cost Center
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == CSKS.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROJECTBDGTITEMSBYPOSTGPERD.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTBDGTITEMSBYPOSTGPERD.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == FINSC_LEDGER.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.LEDGER == FINSC_LEDGER.RLDNR
  • I_PROJECTBDGTITEMSBYPOSTGPERD.SOURCELEDGER == FINSC_LEDGER.RLDNR
Source Logical System I_PROJECTBDGTITEMSBYPOSTGPERD.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PROJECTBDGTITEMSBYPOSTGPERD.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == TCURC.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.TRANSACTIONCURRENCY == TCURC.WAERS
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • I_PROJECTBDGTITEMSBYPOSTGPERD.MANDT == CEPC.MANDT
  • I_PROJECTBDGTITEMSBYPOSTGPERD.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTBDGTITEMSBYPOSTGPERD.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTBDGTITEMSBYPOSTGPERD.WBSELEMENTPROFITCENTER == CEPC.PRCTR