P_PROJECTCOSTLINEITEMS

CDS View

P_PROJECTCOSTLINEITEMS is a CDS View in S/4HANA. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProjectCostLineItems view from COMPOSITE Project Cost Line Items
P_PPM_ProjectCostLineItem view from COMPOSITE
P_ProjFinSmmryLnItems view inner COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ActualPlanJournalEntryItem ActualPlanJournalEntryItem 1
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 1
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY Project Project 2
KEY SourceLedger SourceLedger 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInObjectCurrency AmountInObjectCurrency 1
ControllingObjectCurrency ControllingObjectCurrency 1
CreationDate CreationDate 1
FiscalPeriod FiscalPeriod 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
GLAccountHierarchy GLAccountHierarchy 1
GlobalCurrency GlobalCurrency 1
IsSettled IsSettled 1
PartnerAccountAssignmentType PartnerAccountAssignmentType 1
PlanningCategory PlanningCategory 1
PostingDate PostingDate 1
ProjectInternalID ProjectInternalID 2
ProjectType ProjectType 2
SemanticTag SemanticTag 2
WBSElementInternalID WBSElementInternalID 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_PROJECTCOSTLINEITEMS (
    ACCOUNTINGDOCUMENT,
    ACTUALPLANJOURNALENTRYITEM,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    PROJECT,
    SOURCELEDGER,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    CONTROLLINGOBJECTCURRENCY,
    CREATIONDATE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    GLACCOUNTHIERARCHY,
    GLOBALCURRENCY,
    ISSETTLED,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PLANNINGCATEGORY,
    POSTINGDATE,
    PROJECTINTERNALID,
    PROJECTTYPE,
    SEMANTICTAG,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACTUALPLANJOURNALENTRYITEM, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, PROJECT, SOURCELEDGER)
);