I_PUBSECBDGTLINEITEMCUBE

CDS View
58 Fields 4 CDS Views

Budget Line Items - Cube

I_PUBSECBDGTLINEITEMCUBE is a CDS View in S/4HANA. Budget Line Items - Cube. It contains 58 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_PubSecBdgtAnalysis view from CONSUMPTION Budget Analysis Analytical List Page
I_PubSecCtrlObjBudgetCube view from COMPOSITE Budget Control Object Items Cube
I_RIBBudgetItemCube view_entity from COMPOSITE RIB control object budget items - Cube
P_PubSecBdgtCostSharingItems view from COMPOSITE

Fields (58)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 2
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem 2
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 2
KEY FiscalYear FiscalYear 4
KEY Ledger Ledger 4
_BudgetingType _BudgetingType 1
_BudgetPeriod _BudgetPeriod 1
_BudgetProcess _BudgetProcess 1
_CompanyCode _CompanyCode 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_CurrentCostCenter _CurrentCostCenter 1
_FinancialManagementArea _FinancialManagementArea 1
_FiscalYear _FiscalYear 1
_FunctionalArea _FunctionalArea 1
_Fund _Fund 1
_FundType _FundType 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_GlobalCurrency _GlobalCurrency 1
_Ledger _Ledger 1
_PlanningCategory _PlanningCategory 2
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 1
_ReferenceDocumentType _ReferenceDocumentType 1
_WBSElementBasicData _WBSElementBasicData 1
_WBSElementExternalID _WBSElementExternalID 1
AmountInGlobalCurrency AmountInGlobalCurrency 3
BudgetDocWorkFlowStatus BudgetDocWorkFlowStatus 2
BudgetingType BudgetingType 4
BudgetPeriod BudgetPeriod 3
BudgetProcess BudgetProcess 3
BusinessArea BusinessArea 1
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 2
CostCenter CostCenter 3
Customer Customer 1
FinancialManagementArea FinancialManagementArea 3
FunctionalArea FunctionalArea 3
Fund Fund 3
FundType FundType 2
GLAccount GLAccount 3
GlobalCurrency GlobalCurrency 3
GrantID GrantID 2
GteeMBudgetValidityNumber GteeMBudgetValidityNumber 2
PlanningCategory PlanningCategory 2
ProfitCenter ProfitCenter 2
PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 2
PubSecBudgetAccount PubSecBudgetAccount 2
PubSecExpnBdgtAmtInGlobalCrcy PubSecExpnBdgtAmtInGlobalCrcy,RIBExpnBdgtAmtInGCrcy 2
PubSecRevnBdgtAmtInGlobalCrcy PubSecRevnBdgtAmtInGlobalCrcy,RIBRevnBdgtAmtInGCrcy 2
ReferenceDocument ReferenceDocument 3
ReferenceDocumentContext ReferenceDocumentContext 3
ReferenceDocumentType ReferenceDocumentType 3
Segment Segment 2
SponsoredClass SponsoredClass 1
SponsoredProgram SponsoredProgram 1
WBSElementExternalID WBSElementExternalID 3
WBSElementInternalID WBSElementInternalID 3

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 Line Items - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PUBSECBDGTLINEITEMCUBE (
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    _BUDGETINGTYPE,
    _BUDGETPERIOD,
    _BUDGETPROCESS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENTCOSTCENTER,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _FUND,
    _FUNDTYPE,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _LEDGER,
    _PLANNINGCATEGORY,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _REFERENCEDOCUMENTTYPE,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    AMOUNTINGLOBALCURRENCY,
    BUDGETDOCWORKFLOWSTATUS,
    BUDGETINGTYPE,
    BUDGETPERIOD,
    BUDGETPROCESS,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    FINANCIALMANAGEMENTAREA,
    FUNCTIONALAREA,
    FUND,
    FUNDTYPE,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    PLANNINGCATEGORY,
    PROFITCENTER,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    PUBSECEXPNBDGTAMTINGLOBALCRCY,
    PUBSECREVNBDGTAMTINGLOBALCRCY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    SEGMENT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER)
);

Learn More