P_PUBSECBDGTCNSMPNANALYSIS

CDS View
42 Fields 2 CDS Views

P_PUBSECBDGTCNSMPNANALYSIS is a CDS View in S/4HANA. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PubSecBdgtCnsmpnAnalysis view from COMPOSITE Public Sector Budget Consumption Analysis
I_PubSecGrantBdgtCnsmpn view from COMPOSITE Grant Budget Consumption Analysis

Fields (42)

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 CtrlObjForGrant CtrlObjForGrant 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
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PUBSECBDGTCNSMPNANALYSIS (
    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,
    SEGMENT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUPPLIER,
    GRANTHIERARCHY,
    HIERARCHYIDFORBUDGETACCOUNT,
    HIERARCHYIDFORBUDGETPERIOD,
    HIERARCHYIDFORCOSTCENTER,
    HIERARCHYIDFORFUNCTIONALAREA,
    HIERARCHYIDFORFUND,
    HIERARCHYIDFORWBSELEMENT,
    SPONSOREDCLASSHIERARCHY,
    SPONSOREDPROGRAMHIERARCHY,
    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, SEGMENT, SPONSOREDCLASS, SPONSOREDPROGRAM, SUPPLIER)
);

Learn More