I_PUBSECBDGTCNSMPNANALYSISCUBE

CDS View
60 Fields 2 CDS Views

Public Sector Budget Consumption Analysis Cube

I_PUBSECBDGTCNSMPNANALYSISCUBE is a CDS View in S/4HANA. Public Sector Budget Consumption Analysis Cube. It contains 60 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PubSecBdgtCnsmpnAnalysis view from CONSUMPTION Public Sector Budget Consumption Analysis
C_PubSecGrantBdgtCnsmpn view from CONSUMPTION Grant Budget Overview

Fields (60)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentType AccountingDocumentType 2
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 CtrlObjForSponsoredClass CtrlObjForSponsoredClass 2
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 2
KEY CtrlObjForWBSElement CtrlObjForWBSElement 2
KEY Customer Customer 2
KEY FinancialAccountType FinancialAccountType 2
KEY FinancialManagementArea FinancialManagementArea 2
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 Ledger Ledger 2
KEY ProfitCenter ProfitCenter 2
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 2
KEY Segment Segment 2
KEY SponsoredClass SponsoredClass 2
KEY SponsoredProgram SponsoredProgram 2
KEY Supplier Supplier 2
_AccountingDocumentType _AccountingDocumentType 2
_BusinessArea _BusinessArea 2
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_CurrentCostCenter _CurrentCostCenter 2
_CurrentProfitCenter _CurrentProfitCenter 2
_Customer _Customer 2
_FinancialAccountType _FinancialAccountType 2
_FinancialManagementArea _FinancialManagementArea 2
_FunctionalArea _FunctionalArea 2
_Fund _Fund 2
_GLAccountInCompanyCode _GLAccountInCompanyCode 2
_Grant _Grant 2
_ProfitCenter _ProfitCenter 2
_PubSecAvailyCtrlProfile _PubSecAvailyCtrlProfile 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 2
_Segment _Segment 2
_Supplier _Supplier 2
GrantHierarchy GrantHierarchy 2
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 2
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 2
HierarchyIDForCostCenter HierarchyIDForCostCenter 2
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 2
HierarchyIDForFund HierarchyIDForFund 2
HierarchyIDForWBSElement HierarchyIDForWBSElement 2
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.

-- Public Sector Budget Consumption Analysis Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECBDGTCNSMPNANALYSISCUBE (
    ACCOUNTINGDOCUMENTTYPE,
    AVAILABILITYCONTROLPROFILE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CTRLOBJFORBDGTVALIDITYNMBR,
    CTRLOBJFORBUDGETACCOUNT,
    CTRLOBJFORBUDGETPERIOD,
    CTRLOBJFORCOSTCENTER,
    CTRLOBJFORFUNCTIONALAREA,
    CTRLOBJFORFUND,
    CTRLOBJFORSPONSOREDCLASS,
    CTRLOBJFORSPONSOREDPROGRAM,
    CTRLOBJFORWBSELEMENT,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FISCALYEAR,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    LEDGER,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    SEGMENT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUPPLIER,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FUNCTIONALAREA,
    _FUND,
    _GLACCOUNTINCOMPANYCODE,
    _GRANT,
    _PROFITCENTER,
    _PUBSECAVAILYCTRLPROFILE,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _SEGMENT,
    _SUPPLIER,
    GRANTHIERARCHY,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORWBSELEMENT,
    SPONSOREDCLASSHIERARCHY,
    SPONSOREDPROGRAMHIERARCHY,
    PRIMARY KEY (ACCOUNTINGDOCUMENTTYPE, AVAILABILITYCONTROLPROFILE, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, CTRLOBJFORBDGTVALIDITYNMBR, CTRLOBJFORBUDGETACCOUNT, CTRLOBJFORBUDGETPERIOD, CTRLOBJFORCOSTCENTER, CTRLOBJFORFUNCTIONALAREA, CTRLOBJFORFUND, CTRLOBJFORSPONSOREDCLASS, CTRLOBJFORSPONSOREDPROGRAM, CTRLOBJFORWBSELEMENT, CUSTOMER, FINANCIALACCOUNTTYPE, FINANCIALMANAGEMENTAREA, FISCALYEAR, FUNCTIONALAREA, FUND, GLACCOUNT, GLOBALCURRENCY, GRANTID, GTEEMBUDGETVALIDITYNUMBER, LEDGER, PROFITCENTER, PUBSECBDGTACCTREVNEXPNCODE, SEGMENT, SPONSOREDCLASS, SPONSOREDPROGRAM, SUPPLIER)
);

Learn More