I_PROJECTCOSTLINEITEMS

CDS View
46 Fields 8 CDS Views

Project Cost Line Items

I_PROJECTCOSTLINEITEMS is a CDS View in S/4HANA. Project Cost Line Items. It contains 46 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_ProjectCostLineItemsByPeriod view from COMPOSITE Project Cost Line Items by Period
I_ProjectCostLineItemsCube view from COMPOSITE Project Cost Line Items Cube
P_BudgetPostingsByCurrentYear view from COMPOSITE Get Projects which has budget postings for current year
P_ProjCostSpclPerdTmeRnge view from COMPOSITE Project Cost Line Items Cube
P_ProjCostsWithCalcdMnth view from CONSUMPTION Project Costs With Calculated Months
P_PROJCSTLINEITEMS view_entity from COMPOSITE Project Cost Line Item
P_ProjectCostsInGlobalCurrency view from CONSUMPTION Project Costs in Global Currency
P_ProjectPredictSummryMain view from CONSUMPTION Project Prediction Summary Main

Fields (46)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ActualPlanJournalEntryItem ActualPlanJournalEntryItem 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 OriginalFiscalYear FiscalYear,OriginalFiscalYear 2
KEY ProjectObjectNode ProjectObjectNode 1
KEY SourceLedger SourceLedger 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AmountInObjectCurrency AmountInObjectCurrency 1
BusinessArea BusinessArea 2
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
ControllingObjectCurrency ControllingObjectCurrency 1
FinancialPlanningEntryItem FinancialPlanningEntryItem 1
FiscalPeriod FiscalPeriod 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 2
FunctionalArea FunctionalArea 2
GLAccount GLAccount 1
NextFiscalYearPeriod FiscalYearPeriod,NextFiscalYearPeriod 2
OrderID OrderID 1
OriginalFiscalPeriod FiscalPeriod,OriginalFiscalPeriod 2
PartnerAccountAssignmentType PartnerAccountAssignmentType 1
PlanningCategory PlanningCategory 2
Plant Plant 2
PostingDate PostingDate 1
ProfitCenter ProfitCenter 1
Project Project 2
ProjectCategory ProjectCategory 1
ProjectDescription ProjectDescription 1
ProjectInternalID ProjectInternalID 2
ProjectObject ProjectObject 1
ProjectProfileCode ProjectProfileCode 1
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 1
ProjectType ProjectType 3
ProjectUUID ProjectUUID 1
ResponsibleCostCenter ResponsibleCostCenter 1
SemanticTag SemanticTag 2
WBSDescription WBSDescription 1
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 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 Cost Line Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTCOSTLINEITEMS (
    ACCOUNTINGDOCUMENT,
    ACTUALPLANJOURNALENTRYITEM,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    ORIGINALFISCALYEAR,
    PROJECTOBJECTNODE,
    SOURCELEDGER,
    ACCOUNTINGDOCCREATEDBYUSER,
    AMOUNTINOBJECTCURRENCY,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCURRENCY,
    FINANCIALPLANNINGENTRYITEM,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    NEXTFISCALYEARPERIOD,
    ORDERID,
    ORIGINALFISCALPERIOD,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PLANNINGCATEGORY,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    PROJECT,
    PROJECTCATEGORY,
    PROJECTDESCRIPTION,
    PROJECTINTERNALID,
    PROJECTOBJECT,
    PROJECTPROFILECODE,
    PROJECTSUMMARYTASKUUID,
    PROJECTTYPE,
    PROJECTUUID,
    RESPONSIBLECOSTCENTER,
    SEMANTICTAG,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WBSELEMENTPROFITCENTER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACTUALPLANJOURNALENTRYITEM, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, ORIGINALFISCALYEAR, PROJECTOBJECTNODE, SOURCELEDGER)
);

Learn More