I_PubSecBdgtConsumableAnalysis

Public Sector Budget Consumable Analysis | view: IPSBDGTCNSMBL | Extraction: Not supported | Component: Information system
Tables used: ACDOCP, T001, TKA02, FMFINCODE, FMFUNDTYPE, SKB1, GMGR, GMGRANTNONE, GMGRTYPE, PROJ, T001, FCOMC_CATEGORY, PRPS, PSM_D_GLACCTX, FINSC_FISC_DATE, FINSC_PERIOD, PSM_D_AVC_PRF_AS
Column Name Description
Ledger FK Ledger
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 Global Currency
PubSecBudgetAccount Budget Account
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
BusinessArea FK Business Area
Segment FK Segment for Segmental Reporting
GLAccount FK G/L Account
Customer FK Customer Number
ProfitCenter FK Profit Center
GrantID FK Grant
SponsoredClass FK Sponsored Class
SponsoredProgram FK Sponsored Program
GteeMBudgetValidityNumber FK Budget Validity Number
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account 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
Budget Availability Control Profile for Public Sector Mgmt
  • Client
  • Budget Availability Control Profile for Public Sector Mgmt
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == FINSC_AVC_PROF.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
Business Area
  • Client
  • Business Area
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == TGSB.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == T001.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECBDGTCONSUMABLEANALYSIS.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • I_PUBSECBDGTCONSUMABLEANALYSIS.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == CSKS.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTCONSUMABLEANALYSIS.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • I_PUBSECBDGTCONSUMABLEANALYSIS.CUSTOMER == KNA1.KUNNR
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == KNA1.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECBDGTCONSUMABLEANALYSIS.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == FM01.MANDT
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_PUBSECBDGTCONSUMABLEANALYSIS.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == FMFINCODE.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.FUND == FMFINCODE.FINCODE
G/L Account
  • Client
  • G/L Account
  • ?
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == SKA1.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.GLACCOUNT == SKA1.SAKNR
  • I_PUBSECBDGTCONSUMABLEANALYSIS.[column in domain "KTOPL"] == SKA1.KTOPL
Grant
  • Client
  • Grant
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == GMGR.CLIENT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.GRANTID == GMGR.GRANT_NBR
Budget Validity Number
  • Budget Validity Number
  • Client
  • ?
  • ?
  • Grant
  • I_PUBSECBDGTCONSUMABLEANALYSIS.GTEEMBUDGETVALIDITYNUMBER == GMBDGTVALIDITY.BDGT_VLDTY_NBR
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == GMBDGTVALIDITY.CLIENT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.[column in domain "GM_BDGT_STATUS"] == GMBDGTVALIDITY.RELEASE_STATUS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.[column in domain "GM_BDGT_PHASE"] == GMBDGTVALIDITY.BDGT_PHASE
  • I_PUBSECBDGTCONSUMABLEANALYSIS.GRANTID == GMBDGTVALIDITY.GRANT_NBR
Ledger
  • Client
  • Ledger
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • I_PUBSECBDGTCONSUMABLEANALYSIS.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == CEPC.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTCONSUMABLEANALYSIS.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.SEGMENT == FAGL_SEGM.SEGMENT
Sponsored Class
  • Client
  • Sponsored Class
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == GMSPCLASS.CLIENT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS
Sponsored Program
  • Client
  • Sponsored Program
  • I_PUBSECBDGTCONSUMABLEANALYSIS.MANDT == GMSPPROGRAM.CLIENT
  • I_PUBSECBDGTCONSUMABLEANALYSIS.SPONSOREDPROGRAM == GMSPPROGRAM.SPONSORED_PROG