I_PUBSECBDGTCONSUMEDANALYSIS

CDS View
42 Fields 1 CDS Views

Public Sector Budget Consumed Analysis

I_PUBSECBDGTCONSUMEDANALYSIS is a CDS View in S/4HANA. Public Sector Budget Consumed Analysis. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PubSecBdgtCnsmpnAnalysis view from COMPOSITE

Fields (42)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentType AccountingDocumentType 1
KEY AvailabilityControlProfile AvailabilityControlProfile 1
KEY BusinessArea BusinessArea 1
KEY CompanyCode CompanyCode 1
KEY ControllingArea ControllingArea 1
KEY CostCenter CostCenter 1
KEY CtrlObjForBdgtValidityNmbr CtrlObjForBdgtValidityNmbr 1
KEY CtrlObjForBudgetAccount CtrlObjForBudgetAccount 1
KEY CtrlObjForBudgetPeriod CtrlObjForBudgetPeriod 1
KEY CtrlObjForCostCenter CtrlObjForCostCenter 1
KEY CtrlObjForFunctionalArea CtrlObjForFunctionalArea 1
KEY CtrlObjForFund CtrlObjForFund 1
KEY CtrlObjForGrant CtrlObjForGrant 1
KEY CtrlObjForSponsoredClass CtrlObjForSponsoredClass 1
KEY CtrlObjForSponsoredProgram CtrlObjForSponsoredProgram 1
KEY CtrlObjForWBSElement CtrlObjForWBSElement 1
KEY Customer Customer 1
KEY FinancialAccountType FinancialAccountType 1
KEY FinancialManagementArea FinancialManagementArea 1
KEY FiscalYear FiscalYear 1
KEY FunctionalArea FunctionalArea 1
KEY Fund Fund 1
KEY GLAccount GLAccount 1
KEY GlobalCurrency GlobalCurrency 1
KEY GrantID GrantID 1
KEY GteeMBudgetValidityNumber GteeMBudgetValidityNumber 1
KEY Ledger Ledger 1
KEY ProfitCenter ProfitCenter 1
KEY PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 1
KEY PubSecBudgetAccount PubSecBudgetAccount 1
KEY Segment Segment 1
KEY SponsoredClass SponsoredClass 1
KEY SponsoredProgram SponsoredProgram 1
KEY Supplier Supplier 1
GrantHierarchy GrantHierarchy 1
HierarchyIDForBudgetAccount HierarchyIDForBudgetAccount 1
HierarchyIDForBudgetPeriod HierarchyIDForBudgetPeriod 1
HierarchyIDForCostCenter HierarchyIDForCostCenter 1
HierarchyIDForFunctionalArea HierarchyIDForFunctionalArea 1
HierarchyIDForFund HierarchyIDForFund 1
HierarchyIDForWBSElement HierarchyIDForWBSElement 1
SponsoredClassHierarchy SponsoredClassHierarchy 1

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 Consumed Analysis
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECBDGTCONSUMEDANALYSIS (
    ACCOUNTINGDOCUMENTTYPE,
    AVAILABILITYCONTROLPROFILE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CTRLOBJFORBDGTVALIDITYNMBR,
    CTRLOBJFORBUDGETACCOUNT,
    CTRLOBJFORBUDGETPERIOD,
    CTRLOBJFORCOSTCENTER,
    CTRLOBJFORFUNCTIONALAREA,
    CTRLOBJFORFUND,
    CTRLOBJFORGRANT,
    CTRLOBJFORSPONSOREDCLASS,
    CTRLOBJFORSPONSOREDPROGRAM,
    CTRLOBJFORWBSELEMENT,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FISCALYEAR,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    LEDGER,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    SEGMENT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUPPLIER,
    GRANTHIERARCHY,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORWBSELEMENT,
    SPONSOREDCLASSHIERARCHY,
    PRIMARY KEY (ACCOUNTINGDOCUMENTTYPE, AVAILABILITYCONTROLPROFILE, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, CTRLOBJFORBDGTVALIDITYNMBR, CTRLOBJFORBUDGETACCOUNT, CTRLOBJFORBUDGETPERIOD, CTRLOBJFORCOSTCENTER, CTRLOBJFORFUNCTIONALAREA, CTRLOBJFORFUND, CTRLOBJFORGRANT, CTRLOBJFORSPONSOREDCLASS, CTRLOBJFORSPONSOREDPROGRAM, CTRLOBJFORWBSELEMENT, CUSTOMER, FINANCIALACCOUNTTYPE, FINANCIALMANAGEMENTAREA, FISCALYEAR, FUNCTIONALAREA, FUND, GLACCOUNT, GLOBALCURRENCY, GRANTID, GTEEMBUDGETVALIDITYNUMBER, LEDGER, PROFITCENTER, PUBSECBDGTACCTREVNEXPNCODE, PUBSECBUDGETACCOUNT, SEGMENT, SPONSOREDCLASS, SPONSOREDPROGRAM, SUPPLIER)
);

Learn More