C_PubSecBdgtAnalysis

Budget Analysis Analytical List Page | view: CPSMBDGTANLYS | Extraction: Not supported | Component: Information system
Tables used: PRTE, ACDOCP, SKAT, BDGT_D_SUBCATEG, BDGT_D_SUBCATEGT, FMBUDGETPD, FMBUDGETPDT, BUDGET_D_PROCESS, BUDGET_D_PROCT, T001, TKA02, CSKS, CSKS, CSKT, TFKB, TFKBT, FMFINCODE, FMFINT, SKB1, GMGR, GMGRANTNONE, GMGRTEXTS, GMGRTYPE, PROJ, T001, FCOMC_CATEGORY, PRPS, PRPS, PSM_D_GLACCTX, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context
ReferenceDocumentType Reference Document Type
FundName Fund Name TEXT20
BudgetPeriodName Budget Period Name NAME
FunctionalAreaName Name of the Functional Area
GrantName Short Description of the Grant
BudgetProcessText Budget Process Description
BudgetingTypeText Budget Type Description
CompanyCodeName Name of Company Code or Company
CostCenterName Cost Center Name
WBSDescription WBS Element Name
GLAccountName Budget Account Name PSM_TEXT20
FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund CHAR04
GrantLfcycStatusForAuthzn Lifecycle Status J_ISTAT
FundAuthznGrp Fund Authorization Group CHAR10
BudgetPeriodAuthznGrp Budget Period Authorization Group CHAR10
Master Data Relations Join Conditions
Budget Type (Subcategory)
  • Client
  • Budget Type (Subcategory)
Budget Period
  • Client
  • Budget Period
  • C_PUBSECBDGTANALYSIS.MANDT == FMBUDGETPD.MANDT
  • C_PUBSECBDGTANALYSIS.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Client
  • Budget Process Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PUBSECBDGTANALYSIS.MANDT == T004.MANDT
  • C_PUBSECBDGTANALYSIS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_PUBSECBDGTANALYSIS.COMPANYCODE == T001.BUKRS
  • C_PUBSECBDGTANALYSIS.MANDT == T001.MANDT
Cost Center
  • ?
  • Client
  • ?
  • Cost Center
  • C_PUBSECBDGTANALYSIS.[column in domain "DATBI"] == CSKS.DATBI
  • C_PUBSECBDGTANALYSIS.MANDT == CSKS.MANDT
  • C_PUBSECBDGTANALYSIS.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PUBSECBDGTANALYSIS.COSTCENTER == CSKS.KOSTL
Financial Management Area
  • Client
  • Financial Management Area
  • C_PUBSECBDGTANALYSIS.MANDT == FM01.MANDT
  • C_PUBSECBDGTANALYSIS.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Functional Area
  • Client
  • Functional Area
  • C_PUBSECBDGTANALYSIS.MANDT == TFKB.MANDT
  • C_PUBSECBDGTANALYSIS.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Financial Management Area
  • Fund
  • C_PUBSECBDGTANALYSIS.MANDT == FMFINCODE.MANDT
  • C_PUBSECBDGTANALYSIS.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_PUBSECBDGTANALYSIS.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Client
  • Chart of Accounts
  • C_PUBSECBDGTANALYSIS.GLACCOUNT == SKA1.SAKNR
  • C_PUBSECBDGTANALYSIS.MANDT == SKA1.MANDT
  • C_PUBSECBDGTANALYSIS.CHARTOFACCOUNTS == SKA1.KTOPL
Grants Management: Authorization Groups
  • Grants Management: Authorization Groups
  • ?
  • Client
  • C_PUBSECBDGTANALYSIS.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
  • C_PUBSECBDGTANALYSIS.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
  • C_PUBSECBDGTANALYSIS.MANDT == GMAUTHGRP.CLIENT
Grant
  • Client
  • Grant
  • C_PUBSECBDGTANALYSIS.MANDT == GMGR.CLIENT
  • C_PUBSECBDGTANALYSIS.GRANTID == GMGR.GRANT_NBR
Lifecycle Status C_PUBSECBDGTANALYSIS.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Ledger
  • Client
  • Ledger
Plan Category
  • Plan Category
  • Client
Budget Account
  • ?
  • Client
  • Budget Account
  • C_PUBSECBDGTANALYSIS.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PUBSECBDGTANALYSIS.MANDT == SKA1.MANDT
  • C_PUBSECBDGTANALYSIS.PUBSECBUDGETACCOUNT == SKA1.SAKNR
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • C_PUBSECBDGTANALYSIS.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • C_PUBSECBDGTANALYSIS.MANDT == T001.MANDT