I_PubSecBdgtCnsmpnAnalysis

Public Sector Budget Consumption Analysis | view: IPSBDGTCNSMPN | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, ACDOCA, ACDOCP, T004, T001, TKA02, FMFINCODE, FMFUNDTYPE, SKA1, SKB1, GMGR, GMGRANTNONE, GMGRTYPE, PROJ, PSM_D_BDGTCNSTY, T001, FCOMC_CATEGORY, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, PSM_D_AVC_PRF_AS
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FinancialManagementArea FK Financial Management Area
ControllingArea FK Controlling Area
FiscalYear Fiscal Year
CtrlObjForFund Control Object for a Fund
CtrlObjForFunctionalArea Control Object for a Functional Area
CtrlObjForBudgetPeriod Control Object for a Budget Period
CtrlObjForCostCenter Control Object for a Cost Center
CtrlObjForWBSElement Control Object for a WBS Element
CtrlObjForBudgetAccount Control Object for a Budget Account
CtrlObjForGrant Control Object for a Grant
CtrlObjForSponsoredClass Control Object for a Sponsored Class
CtrlObjForSponsoredProgram Control Object for a Sponsored Program
CtrlObjForBdgtValidityNmbr Control Object for a Budget Validity Number
GlobalCurrency FK Global Currency
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
AvailabilityControlProfile FK Budget Availability Control Profile for Public Sector Mgmt
Fund FK Fund
CostCenter FK Cost Center
FinancialAccountType Account Type Show values
BusinessArea FK Business Area
Segment FK Segment for Segmental Reporting
GLAccount FK G/L Account
Supplier FK Supplier
Customer FK Customer Number
AccountingDocumentType FK Journal Entry Type
ProfitCenter FK Profit Center
GrantID Grant
SponsoredClass Sponsored Class
SponsoredProgram Sponsored Program
GteeMBudgetValidityNumber Budget Validity Number
Column Name Description
💲 Global Currency (GlobalCurrency):
BdgtConsumableAmtInGlobalCrcy Consumable Amount in Global Currency
BdgtConsumedAmtInGlobalCrcy Consumed Amount in Global Currency
BdgtAvailableAmtInGlobalCrcy Available Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
HierarchyIDForFund Hierarchy ID for Fund DHRYID
HierarchyIDForFunctionalArea Hierarchy ID for Functional Area DHRYID
HierarchyIDForBudgetPeriod Hierarchy ID for Budget Period DHRYID
HierarchyIDForCostCenter Hierarchy ID for Cost Center DHRYID
HierarchyIDForWBSElement Hierarchy ID for WBS Element DHRYID
HierarchyIDForBudgetAccount Hierarchy ID for Budget Account Element DHRYID
GrantHierarchy Grant Hierarchy DHRYID
SponsoredClassHierarchy Sponsored Class Hierarchy DHRYID
SponsoredProgramHierarchy Sponsored Program Hierarchy DHRYID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == T003.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Budget Availability Control Profile for Public Sector Mgmt
  • Client
  • Budget Availability Control Profile for Public Sector Mgmt
Business Area
  • Business Area
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.BUSINESSAREA == TGSB.GSBER
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.COMPANYCODE == T001.BUKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.COSTCENTER == CSKS.KOSTL
  • I_PUBSECBDGTCNSMPNANALYSIS.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTCNSMPNANALYSIS.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == CSKS.MANDT
Customer Number
  • Client
  • Customer Number
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == KNA1.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.CUSTOMER == KNA1.KUNNR
Financial Management Area
  • Client
  • Financial Management Area
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == FM01.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Fund
  • Client
  • Financial Management Area
  • Fund
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == FMFINCODE.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.GLACCOUNT == SKB1.SAKNR
  • I_PUBSECBDGTCNSMPNANALYSIS.COMPANYCODE == SKB1.BUKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == TCURC.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECBDGTCNSMPNANALYSIS.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTCNSMPNANALYSIS.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PUBSECBDGTCNSMPNANALYSIS.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == FAGL_SEGM.MANDT
Supplier
  • Client
  • Supplier
  • I_PUBSECBDGTCNSMPNANALYSIS.MANDT == LFA1.MANDT
  • I_PUBSECBDGTCNSMPNANALYSIS.SUPPLIER == LFA1.LIFNR