I_PUBSECBDGTLINEITEMCUBE

CDS View
115 Fields 6 CDS Views

Budget Line Items - Cube

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PubSecBdgtAnalysis view from CONSUMPTION Budget Analysis Analytical List Page
C_PubSecBdgtLineItemQry1 view from CONSUMPTION Budget Line Items Query
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 Grants Budget Cost Sharing Items
P_PubSecBdgtLineItems view_entity from COMPOSITE Budget Line Items

Fields (115)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 6
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 3
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem 3
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 3
KEY FiscalYear FiscalYear 6
KEY Ledger Ledger 6
KEY PlanningCategory PlanningCategory 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
AccountAssignmentType AccountAssignmentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInGlobalCurrency AmountInGlobalCurrency 5
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
BillToParty BillToParty 1
BudgetAccountHierarchy BudgetAccountHierarchy 2
BudgetDocument BudgetDocument 2
BudgetDocWorkFlowStatus BudgetDocWorkFlowStatus 4
BudgetingType BudgetingType 6
BudgetPeriod BudgetPeriod 5
BudgetProcess BudgetProcess 5
BusinessArea BusinessArea 2
BusinessTransactionType BusinessTransactionType 2
ChartOfAccounts ChartOfAccounts 3
CompanyCodeCurrency CompanyCodeCurrency 2
ControllingArea ControllingArea 4
ControllingObjectCurrency ControllingObjectCurrency 1
CostCenter CostCenter 5
CostCenterHierarchy CostCenterHierarchy 1
CostCtrActivityType CostCtrActivityType 1
CostSourceUnit CostSourceUnit 1
Customer Customer 1
CustomerGroup CustomerGroup 2
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
FinancialManagementArea FinancialManagementArea 5
FinancialTransactionType FinancialTransactionType 1
FiscalPeriod FiscalPeriod 2
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 2
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy 1
FunctionalArea FunctionalArea 5
FunctionalAreaHierarchy FunctionalAreaHierarchy 2
Fund Fund 5
FundHierarchy FundHierarchy 2
FundType FundType 4
GLAccount GLAccount 5
GlobalCurrency GlobalCurrency 5
GranteeMgmtFundType GranteeMgmtFundType 2
GranteeMgmtSponsor GranteeMgmtSponsor 2
GrantHierarchy GrantHierarchy 2
GrantID GrantID 4
GteeMBudgetValidityNumber GteeMBudgetValidityNumber 4
LedgerFiscalYear LedgerFiscalYear 2
OrderID OrderID 1
PartnerBusinessArea PartnerBusinessArea 2
PartnerCompanyCode PartnerCompanyCode 2
PartnerCostCenter PartnerCostCenter 2
PartnerCostCtrActivityType PartnerCostCtrActivityType 1
PartnerFunctionalArea PartnerFunctionalArea 2
PartnerProfitCenter PartnerProfitCenter 2
PartnerProjectExternalID PartnerProjectExternalID 1
PartnerProjectInternalID PartnerProjectInternalID 1
PartnerSegment PartnerSegment 2
PartnerWBSElementExternalID PartnerWBSElementExternalID 2
PartnerWBSElementInternalID PartnerWBSElementInternalID 1
Plant Plant 1
PostingDate PostingDate 2
Product Product 1
ProfitCenter ProfitCenter 4
ProjectExternalID ProjectExternalID 1
ProjectInternalID ProjectInternalID 1
PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 4
PubSecBudgetAccount PubSecBudgetAccount 4
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 1
PubSecBudgetIsRelevant PubSecBudgetIsRelevant 1
PubSecExpnBdgtAmtInCoCodeCrcy PubSecExpnBdgtAmtInCoCodeCrcy 2
PubSecExpnBdgtAmtInGlobalCrcy PubSecExpnBdgtAmtInGlobalCrcy,RIBExpnBdgtAmtInGCrcy 4
PubSecExpnBdgtAmtInTransCrcy PubSecExpnBdgtAmtInTransCrcy 2
PubSecIsConsumableBudget PubSecIsConsumableBudget 2
PubSecRevnBdgtAmtInCoCodeCrcy PubSecRevnBdgtAmtInCoCodeCrcy 2
PubSecRevnBdgtAmtInGlobalCrcy PubSecRevnBdgtAmtInGlobalCrcy,RIBRevnBdgtAmtInGCrcy 4
PubSecRevnBdgtAmtInTransCrcy PubSecRevnBdgtAmtInTransCrcy 2
ReferenceDocument ReferenceDocument 5
ReferenceDocumentContext ReferenceDocumentContext 4
ReferenceDocumentType ReferenceDocumentType 5
SalesDistrict SalesDistrict 1
Segment Segment 4
ShipToParty ShipToParty 1
SoldProduct SoldProduct 1
SponsoredClass SponsoredClass 3
SponsoredProgram SponsoredProgram 3
TransactionCurrency TransactionCurrency 2
ValuationQuantity ValuationQuantity 1
WBSElementExternalID WBSElementExternalID 5
WBSElementInternalID WBSElementInternalID 4

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,
    PLANNINGCATEGORY,
    _BUDGETINGTYPE,
    _BUDGETPERIOD,
    _BUDGETPROCESS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CURRENTCOSTCENTER,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _FUND,
    _FUNDTYPE,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _LEDGER,
    _PLANNINGCATEGORY,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _REFERENCEDOCUMENTTYPE,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    ACCOUNTASSIGNMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BILLTOPARTY,
    BUDGETACCOUNTHIERARCHY,
    BUDGETDOCUMENT,
    BUDGETDOCWORKFLOWSTATUS,
    BUDGETINGTYPE,
    BUDGETPERIOD,
    BUDGETPROCESS,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCURRENCY,
    COSTCENTER,
    COSTCENTERHIERARCHY,
    COSTCTRACTIVITYTYPE,
    COSTSOURCEUNIT,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    FINANCIALMANAGEMENTAREA,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINGLOBALCRCY,
    FUNCTIONALAREA,
    FUNCTIONALAREAHIERARCHY,
    FUND,
    FUNDHIERARCHY,
    FUNDTYPE,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTEEMGMTFUNDTYPE,
    GRANTEEMGMTSPONSOR,
    GRANTHIERARCHY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    LEDGERFISCALYEAR,
    ORDERID,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANYCODE,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERFUNCTIONALAREA,
    PARTNERPROFITCENTER,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PARTNERSEGMENT,
    PARTNERWBSELEMENTEXTERNALID,
    PARTNERWBSELEMENTINTERNALID,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETISRELEVANT,
    PUBSECEXPNBDGTAMTINCOCODECRCY,
    PUBSECEXPNBDGTAMTINGLOBALCRCY,
    PUBSECEXPNBDGTAMTINTRANSCRCY,
    PUBSECISCONSUMABLEBUDGET,
    PUBSECREVNBDGTAMTINCOCODECRCY,
    PUBSECREVNBDGTAMTINGLOBALCRCY,
    PUBSECREVNBDGTAMTINTRANSCRCY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    SALESDISTRICT,
    SEGMENT,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    TRANSACTIONCURRENCY,
    VALUATIONQUANTITY,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, PLANNINGCATEGORY)
);

Learn More