_PROJECT

_PROJECT is an SAP database table in S/4HANA. It contains 47 fields.

Fields (47)

KeyField CDS FieldsUsed in Views
_AuthGroup _AuthGroup 1
_AuthRole _AuthRole 1
_AuthSubst _AuthSubst 1
_AuthUser _AuthUser 1
_EnterpriseProjectType _EnterpriseProjectType 1
_Priority _Priority 1
_ProjectManager _ProjectManager 1
aedat LastChangeDate 1
aenam LastChangedByUser 1
AllocationFrequencyCode AllocationFrequencyCode 1
bprof BudgetProfile 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 3
ControllingArea ControllingArea 1
cpd_updat UpdateTimestamp 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CustomerProject CustomerProject 2
CustomerProjectName CustomerProjectName 2
EnterpriseProjectType EnterpriseProjectType 2
erdat CreationDate 1
ernam CreatedByUser 1
FactoryCalendar FactoryCalendar 1
FunctionalArea FunctionalArea 2
kalid FactoryCalendar 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
logsystem LogicalSystem 1
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive 2
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
Plant Plant 1
ProfitCenter ProfitCenter 1
Project Project,PSPID 15
ProjectCurrency ProjectCurrency 1
ProjectDescription ProjectDescription,ProjectName 36
ProjectExternalID Project,ProjectExternalID 18
ProjectManagerUUID ProjectManagerUUID 2
ProjectName ProjectName 1
ProjectObject ProjectObject,ProjectObjectRootNode,StatusObject 14
ProjectProfileCode ProjectProfileCode 5
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 2
ProjectWithCodingMask Project,ProjectWithCodingMask,pspid_edit 5
ResponsibleCostCenter ResponsibleCostCenter 1
vgsbr BusinessArea 1
WBSElement WBSElement 2
werks Plant 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 _PROJECT (
    _AUTHGROUP,
    _AUTHROLE,
    _AUTHSUBST,
    _AUTHUSER,
    _ENTERPRISEPROJECTTYPE,
    _PRIORITY,
    _PROJECTMANAGER,
    AEDAT,
    AENAM,
    ALLOCATIONFREQUENCYCODE,
    BPROF,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CPD_UPDAT,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMERPROJECT,
    CUSTOMERPROJECTNAME,
    ENTERPRISEPROJECTTYPE,
    ERDAT,
    ERNAM,
    FACTORYCALENDAR,
    FUNCTIONALAREA,
    KALID,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LOGSYSTEM,
    OBJBASEDAUTHORIZATIONISACTIVE,
    PLANNEDENDDATE,
    PLANNEDSTARTDATE,
    PLANT,
    PROFITCENTER,
    PROJECT,
    PROJECTCURRENCY,
    PROJECTDESCRIPTION,
    PROJECTEXTERNALID,
    PROJECTMANAGERUUID,
    PROJECTNAME,
    PROJECTOBJECT,
    PROJECTPROFILECODE,
    PROJECTSUMMARYTASKUUID,
    PROJECTWITHCODINGMASK,
    RESPONSIBLECOSTCENTER,
    VGSBR,
    WBSELEMENT,
    WERKS
);