I_PubSecCtrlObjBudgetCube

Budget Control Object Items Cube | view: IPSMS4CCOBJBDANC | TRAN | 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
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Column Name Description
💲 Global Currency (GlobalCurrency):
PubSecExpnBdgtAmtInGlobalCrcy Budget Expense Amount in Global Currency
PubSecRevnBdgtAmtInGlobalCrcy Budget Revenue Amount in Global Currency
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
FiscalYear Fiscal Year GJAHR
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PubSecBudgetAccount Budget Account SAKNR
CtrlObjForFund Control Object for a Fund
HierarchyIDForFund Hierarchy ID for Fund DHRYID
CtrlObjForFunctionalArea Control Object for a Functional Area
HierarchyIDForFunctionalArea Hierarchy ID for Functional Area DHRYID
CtrlObjForBudgetPeriod Control Object for a Budget Period
HierarchyIDForBudgetPeriod Hierarchy ID for Budget Period DHRYID
CtrlObjForCostCenter Control Object for a Cost Center
HierarchyIDForCostCenter Hierarchy ID for Cost Center DHRYID
CtrlObjForWBSElement Control Object for a WBS Element
HierarchyIDForWBSElement Hierarchy ID for WBS Element DHRYID
CtrlObjForBudgetAccount Control Object for a Budget Account
HierarchyIDForBudgetAccount Hierarchy ID for Budget Account Element DHRYID
CtrlObjForGrant Control Object for a Grant
GrantHierarchy Grant Hierarchy DHRYID
CtrlObjForSponsoredClass Control Object for a Sponsored Class
SponsoredClassHierarchy Sponsored Class Hierarchy DHRYID
CtrlObjForSponsoredProgram Control Object for a Sponsored Program
SponsoredProgramHierarchy Sponsored Program Hierarchy DHRYID
CtrlObjForBdgtValidityNmbr Control Object for a Budget Validity Number
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocumentType Reference Document Type AWTYP
BudgetDocument Budget Document Number AWREF
Master Data Relations Join Conditions
Budget Availability Control Profile for Public Sector Mgmt
  • Budget Availability Control Profile for Public Sector Mgmt
  • Client
Budget Type (Subcategory)
  • Client
  • Budget Type (Subcategory)
Budget Period
  • Client
  • Budget Period
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == FMBUDGETPD.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Budget Process Type
  • Client
Business Area
  • Business Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.BUSINESSAREA == TGSB.GSBER
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == T001.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.COSTCENTER == CSKS.KOSTL
  • I_PUBSECCTRLOBJBUDGETCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECCTRLOBJBUDGETCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == CSKS.MANDT
Customer Number
  • Client
  • Customer Number
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == KNA1.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.CUSTOMER == KNA1.KUNNR
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == FM01.MANDT
Functional Area
  • Functional Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == TFKB.MANDT
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_PUBSECCTRLOBJBUDGETCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == FMFINCODE.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.FUND == FMFINCODE.FINCODE
FM Fund Type
  • Financial Management Area
  • Client
  • FM Fund Type
  • I_PUBSECCTRLOBJBUDGETCUBE.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • G/L Account
  • Client
  • ?
  • I_PUBSECCTRLOBJBUDGETCUBE.GLACCOUNT == SKA1.SAKNR
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == SKA1.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.[column in domain "KTOPL"] == SKA1.KTOPL
Grant
  • Grant
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.GRANTID == GMGR.GRANT_NBR
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == GMGR.CLIENT
Budget Validity Number
  • Grant
  • ?
  • ?
  • Client
  • Budget Validity Number
  • I_PUBSECCTRLOBJBUDGETCUBE.GRANTID == GMBDGTVALIDITY.GRANT_NBR
  • I_PUBSECCTRLOBJBUDGETCUBE.[column in domain "GM_BDGT_STATUS"] == GMBDGTVALIDITY.RELEASE_STATUS
  • I_PUBSECCTRLOBJBUDGETCUBE.[column in domain "GM_BDGT_PHASE"] == GMBDGTVALIDITY.BDGT_PHASE
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == GMBDGTVALIDITY.CLIENT
  • I_PUBSECCTRLOBJBUDGETCUBE.GTEEMBUDGETVALIDITYNUMBER == GMBDGTVALIDITY.BDGT_VLDTY_NBR
Ledger
  • Client
  • Ledger
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECCTRLOBJBUDGETCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECCTRLOBJBUDGETCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECCTRLOBJBUDGETCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Sponsored Class
  • Sponsored Class
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == GMSPCLASS.CLIENT
Sponsored Program
  • Sponsored Program
  • Client
  • I_PUBSECCTRLOBJBUDGETCUBE.SPONSOREDPROGRAM == GMSPPROGRAM.SPONSORED_PROG
  • I_PUBSECCTRLOBJBUDGETCUBE.MANDT == GMSPPROGRAM.CLIENT