P_PROJECTCOSTSTODATE

CDS View
17 Fields 1 CDS Views

P_PROJECTCOSTSTODATE is a CDS View in S/4HANA. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProjectCostsToDate view from CONSUMPTION Project Costs to Date

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY PlanningCategory PlanningCategory 1
KEY PostingDate PostingDate 1
KEY ProfitCenter ProfitCenter 1
KEY Project Project 1
ActualAmountInGlobalCurrency ActualAmountInGlobalCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
BusinessPartner BusinessPartner 1
BusinessPartnerFullName BusinessPartnerFullName 1
BusinessPartnerUUID BusinessPartnerUUID 1
CalendarMonthName CalendarMonthName 1
ControllingArea ControllingArea 1
GlobalCurrency GlobalCurrency 1
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency 1
ProjectInternalID ProjectInternalID 1
ProjectType ProjectType 1
ProjectUUID ProjectUUID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PROJECTCOSTSTODATE (
    COMPANYCODE,
    PLANNINGCATEGORY,
    POSTINGDATE,
    PROFITCENTER,
    PROJECT,
    ACTUALAMOUNTINGLOBALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERUUID,
    CALENDARMONTHNAME,
    CONTROLLINGAREA,
    GLOBALCURRENCY,
    PLANAMOUNTINGLOBALCURRENCY,
    PROJECTINTERNALID,
    PROJECTTYPE,
    PROJECTUUID,
    PRIMARY KEY (COMPANYCODE, PLANNINGCATEGORY, POSTINGDATE, PROFITCENTER, PROJECT)
);

Learn More