_PROJECTTASK

_PROJECTTASK is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
ActualWorkQuantityUnit ActualWorkQuantityUnit 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DevProjActualWorkQuantity DevProjActualWorkQuantity 1
DevProjCalculatedFinishDate DevProjCalculatedFinishDate 1
DevProjCalculatedStartDate DevProjCalculatedStartDate 1
DevProjElmntUUID DevProjElmntUUID 1
DevProjFinishConstraintType DevProjFinishConstraintType 1
DevProjGroupingText DevProjGroupingText 1
DevProjSearchFieldText DevProjSearchFieldText 1
DevProjTaskType DevProjType 1
FactoryCalendar FactoryCalendar 1
FinishConstraintDate FinishConstraintDate 1
ForecastedFinishDate ForecastedFinishDate 1
ForecastedStartDate ForecastedStartDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PriorityCode PriorityCode 1
Project Project 1
ProjectDescription ProjectDescription 1
StartConstraintDate StartConstraintDate 1
StartConstraintType StartConstraintType 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 _PROJECTTASK (
    ACTUALWORKQUANTITYUNIT,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DEVPROJACTUALWORKQUANTITY,
    DEVPROJCALCULATEDFINISHDATE,
    DEVPROJCALCULATEDSTARTDATE,
    DEVPROJELMNTUUID,
    DEVPROJFINISHCONSTRAINTTYPE,
    DEVPROJGROUPINGTEXT,
    DEVPROJSEARCHFIELDTEXT,
    DEVPROJTASKTYPE,
    FACTORYCALENDAR,
    FINISHCONSTRAINTDATE,
    FORECASTEDFINISHDATE,
    FORECASTEDSTARTDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRIORITYCODE,
    PROJECT,
    PROJECTDESCRIPTION,
    STARTCONSTRAINTDATE,
    STARTCONSTRAINTTYPE
);