I_PUBSECCTRLOBJBUDGETCUBE

CDS View
89 Fields 2 CDS Views

Budget Control Object Items Cube

I_PUBSECCTRLOBJBUDGETCUBE is a CDS View in S/4HANA. Budget Control Object Items Cube. It contains 89 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PubSecCtrlObjBudget view from CONSUMPTION Budget Control Object Items Analysis
I_PubSecBdgtConsumableAnalysis view from COMPOSITE Public Sector Budget Consumable Analysis

Fields (89)

KeyField CDS FieldsUsed in Views
KEY AvailabilityControlProfile AvailabilityControlProfile 2
KEY BusinessArea BusinessArea 2
KEY CompanyCode CompanyCode 2
KEY ControllingArea ControllingArea 2
KEY CostCenter CostCenter 2
KEY CtrlObjForBdgtValidityNmbr CtrlObjForBdgtValidityNmbr 2
KEY CtrlObjForBudgetAccount CtrlObjForBudgetAccount 2
KEY CtrlObjForBudgetPeriod CtrlObjForBudgetPeriod 2
KEY CtrlObjForCostCenter CtrlObjForCostCenter 2
KEY CtrlObjForFunctionalArea CtrlObjForFunctionalArea 2
KEY CtrlObjForFund CtrlObjForFund 2
KEY CtrlObjForGrant CtrlObjForGrant 1
KEY CtrlObjForSponsoredClass CtrlObjForSponsoredClass 2
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 2
KEY CtrlObjForWBSElement CtrlObjForWBSElement 2
KEY Customer Customer 2
KEY FinancialManagementArea FinancialManagementArea 2
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 1
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem 1
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 1
KEY FiscalYear FiscalYear 2
KEY FunctionalArea FunctionalArea 2
KEY Fund Fund 2
KEY GLAccount GLAccount 2
KEY GlobalCurrency GlobalCurrency 2
KEY GrantID GrantID 2
KEY GteeMBudgetValidityNumber GteeMBudgetValidityNumber 2
KEY ProfitCenter ProfitCenter 2
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 2
KEY PubSecBudgetAccount PubSecBudgetAccount 2
KEY Segment Segment 2
KEY SponsoredClass SponsoredClass 2
KEY SponsoredProgram SponsoredProgram 2
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 1
_CtrlObjBdgtAccount _CtrlObjBdgtAccount 1
_CtrlObjBdgtPeriod _CtrlObjBdgtPeriod 1
_CtrlObjCostCenter _CtrlObjCostCenter 1
_CtrlObjFuncArea _CtrlObjFuncArea 1
_CtrlObjFund _CtrlObjFund 1
_CtrlObjGrant _CtrlObjGrant 1
_CtrlObjSpnsrdClass _CtrlObjSpnsrdClass 1
_CtrlObjSpnsrdProg _CtrlObjSpnsrdProg 1
_CtrlObjWBSElement _CtrlObjWBSElement 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_Customer _Customer 1
_FinancialManagementArea _FinancialManagementArea 2
_FiscalYear _FiscalYear 1
_Fund _Fund 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_GlobalCurrency _GlobalCurrency 1
_Grant _Grant 1
_ProfitCenter _ProfitCenter 1
_PubSecAvailyCtrlProfile _PubSecAvailyCtrlProfile 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
_PubSecBudgetAccount _PubSecBudgetAccount 1
_PubSecBudgetAccountHier _PubSecBudgetAccountHier 1
_PubSecBudgetPeriodHier _PubSecBudgetPeriodHier 1
_PubSecCostCenterHier _PubSecCostCenterHier 1
_PubSecFunctionalAreaHier _PubSecFunctionalAreaHier 1
_PubSecFundHier _PubSecFundHier 1
_PubSecGrantHier _PubSecGrantHier 1
_PubSecSpnsrdClassHier _PubSecSpnsrdClassHier 1
_PubSecSpnsrdProgHier _PubSecSpnsrdProgHier 1
_PubSecWBSElementHier _PubSecWBSElementHier 1
_Segment _Segment 1
_SponsoredClass _SponsoredClass 1
_SponsoredProgram _SponsoredProgram 1
BudgetDocument BudgetDocument 1
BudgetingType BudgetingType 1
BudgetPeriod BudgetPeriod 1
BudgetProcess BudgetProcess 1
FundType FundType 1
GrantHierarchy GrantHierarchy 2
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 2
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 2
HierarchyIDForCostCenter HierarchyIDForCostCenter 2
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 2
HierarchyIDForFund HierarchyIDForFund 2
HierarchyIDForWBSElement HierarchyIDForWBSElement 2
Ledger Ledger 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
SponsoredClassHierarchy SponsoredClassHierarchy 2
SponsoredProgramHierarchy SponsoredProgramHierarchy 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Budget Control Object Items Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECCTRLOBJBUDGETCUBE (
    AVAILABILITYCONTROLPROFILE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CTRLOBJFORBDGTVALIDITYNMBR,
    CTRLOBJFORBUDGETACCOUNT,
    CTRLOBJFORBUDGETPERIOD,
    CTRLOBJFORCOSTCENTER,
    CTRLOBJFORFUNCTIONALAREA,
    CTRLOBJFORFUND,
    CTRLOBJFORGRANT,
    CTRLOBJFORSPONSOREDCLASS,
    CTRLOBJFORSPONSOREDPROGRAM,
    CTRLOBJFORWBSELEMENT,
    CUSTOMER,
    FINANCIALMANAGEMENTAREA,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    SEGMENT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CTRLOBJBDGTACCOUNT,
    _CTRLOBJBDGTPERIOD,
    _CTRLOBJCOSTCENTER,
    _CTRLOBJFUNCAREA,
    _CTRLOBJFUND,
    _CTRLOBJGRANT,
    _CTRLOBJSPNSRDCLASS,
    _CTRLOBJSPNSRDPROG,
    _CTRLOBJWBSELEMENT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUND,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _PROFITCENTER,
    _PUBSECAVAILYCTRLPROFILE,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTHIER,
    _PUBSECBUDGETPERIODHIER,
    _PUBSECCOSTCENTERHIER,
    _PUBSECFUNCTIONALAREAHIER,
    _PUBSECFUNDHIER,
    _PUBSECGRANTHIER,
    _PUBSECSPNSRDCLASSHIER,
    _PUBSECSPNSRDPROGHIER,
    _PUBSECWBSELEMENTHIER,
    _SEGMENT,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    BUDGETDOCUMENT,
    BUDGETINGTYPE,
    BUDGETPERIOD,
    BUDGETPROCESS,
    FUNDTYPE,
    GRANTHIERARCHY,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORWBSELEMENT,
    LEDGER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    SPONSOREDCLASSHIERARCHY,
    SPONSOREDPROGRAMHIERARCHY,
    PRIMARY KEY (AVAILABILITYCONTROLPROFILE, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, CTRLOBJFORBDGTVALIDITYNMBR, CTRLOBJFORBUDGETACCOUNT, CTRLOBJFORBUDGETPERIOD, CTRLOBJFORCOSTCENTER, CTRLOBJFORFUNCTIONALAREA, CTRLOBJFORFUND, CTRLOBJFORGRANT, CTRLOBJFORSPONSOREDCLASS, CTRLOBJFORSPONSOREDPROGRAM, CTRLOBJFORWBSELEMENT, CUSTOMER, FINANCIALMANAGEMENTAREA, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, FUNCTIONALAREA, FUND, GLACCOUNT, GLOBALCURRENCY, GRANTID, GTEEMBUDGETVALIDITYNUMBER, PROFITCENTER, PUBSECBDGTACCTREVNEXPNCODE, PUBSECBUDGETACCOUNT, SEGMENT, SPONSOREDCLASS, SPONSOREDPROGRAM)
);

Learn More