P_PROJECTSWTHOUTRECENTPOSTING

CDS View
15 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProjectsWthoutRecentPosting view from CONSUMPTION Projects Without Recent Postings

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY MonthInFirstInterval MonthInFirstInterval 1
KEY MonthInSecondInterval MonthInSecondInterval 1
KEY MonthInThirdInterval MonthInThirdInterval 1
KEY ProfitCenter ProfitCenter 1
KEY Project Project 1
BusinessPartnerFullName BusinessPartnerFullName 1
BusinessPartnerUUID BusinessPartnerUUID 1
ControllingArea ControllingArea 1
CurrentDate CurrentDate 1
ProjectDescription ProjectDescription 1
ProjectInternalID ProjectInternalID 1
ProjectsMaxCreationDate ProjectsMaxCreationDate 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_PROJECTSWTHOUTRECENTPOSTING (
    COMPANYCODE,
    MONTHINFIRSTINTERVAL,
    MONTHINSECONDINTERVAL,
    MONTHINTHIRDINTERVAL,
    PROFITCENTER,
    PROJECT,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERUUID,
    CONTROLLINGAREA,
    CURRENTDATE,
    PROJECTDESCRIPTION,
    PROJECTINTERNALID,
    PROJECTSMAXCREATIONDATE,
    PROJECTTYPE,
    PROJECTUUID,
    PRIMARY KEY (COMPANYCODE, MONTHINFIRSTINTERVAL, MONTHINSECONDINTERVAL, MONTHINTHIRDINTERVAL, PROFITCENTER, PROJECT)
);

Learn More