_PROJECTBASICDATA

_PROJECTBASICDATA is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY ProjectExternalID PartnerProjectExternalID,Project,ProjectExternalID 19
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
ProfitCenter ProfitCenter 1
Project OrglChgRptNodeDescription,Project 5
ProjectDescription ProjectDescription 11
ProjectInternalID ProjectInternalID 1
ProjectProfileCode ProjectProfileCode 3

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 _PROJECTBASICDATA (
    PROJECTEXTERNALID,
    COMPANYCODE,
    CONTROLLINGAREA,
    PLANNEDENDDATE,
    PLANNEDSTARTDATE,
    PROFITCENTER,
    PROJECT,
    PROJECTDESCRIPTION,
    PROJECTINTERNALID,
    PROJECTPROFILECODE,
    PRIMARY KEY (PROJECTEXTERNALID)
);