I_PROJECTBUDGETITEMS

CDS View
39 Fields 3 CDS Views

Project Budget Items

I_PROJECTBUDGETITEMS is a CDS View in S/4HANA. Project Budget Items. It contains 39 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProjectBdgtItemsByPostgPerd view from COMPOSITE Project Budget Items by Posting Period
I_ProjectBudgetItemsCube view from COMPOSITE Project Budget Items Cube View
P_BudgetPostingsByFiscalYear view from COMPOSITE

Fields (39)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 2
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 1
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AmountInFunctionalCurrency AmountInFunctionalCurrency 1
AvailabilityControlIsActive AvailabilityControlIsActive 1
AvailabilityControlProfile AvailabilityControlProfile 1
AvailyCtrlTimeRangeType AvailyCtrlTimeRangeType 1
BudgetCurrencyRole BudgetCurrencyRole 1
BudgetProcess BudgetProcess 1
BusinessArea BusinessArea 2
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 2
FunctionalCurrency FunctionalCurrency 1
GLAccount GLAccount 1
PartnerWBSElement PartnerWBSElement 1
PlanningCategory PlanningCategory 1
PostingDate PostingDate 1
ProfitCenter ProfitCenter 1
Project Project 1
ProjectCategory ProjectCategory 1
ProjectDescription ProjectDescription 1
ProjectExternalID ProjectExternalID 1
ProjectInternalID ProjectInternalID 1
ProjectProfileCode ProjectProfileCode 1
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 1
ProjectType ProjectType 1
ResponsibleCostCenter ResponsibleCostCenter 1
SemanticTag SemanticTag 1
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementProfitCenter WBSElementProfitCenter 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.

-- Project Budget Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTBUDGETITEMS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    ACCOUNTINGDOCCREATEDBYUSER,
    AMOUNTINFUNCTIONALCURRENCY,
    AVAILABILITYCONTROLISACTIVE,
    AVAILABILITYCONTROLPROFILE,
    AVAILYCTRLTIMERANGETYPE,
    BUDGETCURRENCYROLE,
    BUDGETPROCESS,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    GLACCOUNT,
    PARTNERWBSELEMENT,
    PLANNINGCATEGORY,
    POSTINGDATE,
    PROFITCENTER,
    PROJECT,
    PROJECTCATEGORY,
    PROJECTDESCRIPTION,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTPROFILECODE,
    PROJECTSUMMARYTASKUUID,
    PROJECTTYPE,
    RESPONSIBLECOSTCENTER,
    SEMANTICTAG,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTPROFITCENTER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More