I_PPM_TASK

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.

-- Task data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PPM_TASK (
    PROJECTUUID,
    TASKUUID,
    _AUTHGROUP,
    _AUTHROLE,
    _AUTHSUBST,
    _AUTHUSER,
    _CREATEDBYUSER,
    _I_PROJECT,
    _LASTCHANGEDBYUSER,
    _PRIORITY,
    _PROCESSINGSTATUS,
    _PROJOBJ,
    _SEVERITY,
    _TEXT,
    ACTUALFINISHDATE,
    ACTUALFINISHDATETIME,
    ACTUALSTARTDATE,
    ACTUALSTARTDATETIME,
    ACTUALWORKEXTERNALQUANTITYUNIT,
    COSTREVENUERATECODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DURATIONUNIT,
    EARLIESTFINISHDATE,
    EARLIESTFINISHDATETIME,
    EARLIESTSTARTDATE,
    EARLIESTSTARTDATETIME,
    ENTPROJISMULTISLSORDITMSENBLD,
    EXTERNALID,
    FACTORYCALENDAR,
    FINISHCONSTRAINTDATE,
    FINISHCONSTRAINTDATETIME,
    FINISHCONSTRAINTTYPE,
    FORECASTEDFINISHDATE,
    FORECASTEDFINISHDATETIME,
    FORECASTEDSTARTDATE,
    FORECASTEDSTARTDATETIME,
    ISMIRROREDTASK,
    ISPROJECTMILESTONE,
    ISSUMMARYTASK,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LATESTFINISHDATE,
    LATESTFINISHDATETIME,
    LATESTSTARTDATE,
    LATESTSTARTDATETIME,
    MANUALCOSTRATE,
    MANUALCOSTRATECURRENCY,
    MANUALREVENUERATE,
    MANUALREVENUERATECURRENCY,
    MILESTONEAPPROVALSTATUS,
    OBJECTTYPE,
    PERCENTAGEOFCOMPLETION,
    PLANNEDWORKQUANTITY,
    PLANNEDWORKQUANTITYUNIT,
    PRIORITYCODE,
    PROJECTELEMENTDURATION,
    PROJECTINTERNALID,
    PROJECTVERSIONNUMBER,
    RELEASEDATETIME,
    REMAININGWORKEXTQUANTITYUNIT,
    REMAININGWORKQUANTITYINSECONDS,
    SORTINGNUMBER,
    STARTCONSTRAINTDATE,
    STARTCONSTRAINTDATETIME,
    STARTCONSTRAINTTYPE,
    TASKNAME,
    TASKPROCESSINGSTATUS,
    TASKTEMPLATEUUID,
    TASKTYPE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (PROJECTUUID, TASKUUID)
);