TIMESHEET

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.

-- Timesheet Records Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TIMESHEET (
    MANDT,                          -- Client [mandt]
    TIMESHEETUUID,                  -- tims_uuid
    WORKASSIGNMENTEXTERNALID,       -- tims_wfd_assgmt_ext_id
    COUNTRY2DIGITISOCODE,           -- tims_country
    WORKFORCEPERSONID,              -- tims_worker_id
    WORKFORCEPERSONEXTERNALID,      -- tims_wfperson_id_external
    BUSINESSPARTNER,                -- tims_person
    WORKASSIGNMENT,                 -- tims_workforce_assgmt
    TIMESHEETDATE,                  -- tims_timesheetdate
    RECORDEDHOURS,                  -- tims_rec_hours
    HOURSUNITOFMEASURE,             -- tims_hrs_uom
    TIMESHEETSTARTTIME,             -- tims_start_time
    TIMESHEETENDTIME,               -- tims_end_time
    TIMESHEETLONGTEXT,              -- tims_longtext
    TIMESHEETTASKUUID,              -- tims_task_uuid
    SENDERCOSTCENTER,               -- tims_skostl
    RECEIVERCOSTCENTER,             -- tims_rkostl
    PROJECTUUID,                    -- tims_project_uuid
    PROJECTELEMENTUUID,             -- tims_projelmnt_uuid
    ACTIVITYTYPE,                   -- tims_activity_type
    ENTPROJELMNTWORKITEMUUID,       -- tims_projelmntwrkitm_uuid
    BILLABLECONTROL,                -- tims_billable_control
    TIMESHEETWRKLOCCODE,            -- tims_work_location
    TIMESHEETOVERTIMECATEGORY,      -- tims_overtime_category
    PURCHASEORDER,                  -- tims_po
    PURCHASEORDERITEM,              -- tims_po_item
    SENDERPUBSECFUND,               -- tims_sfund
    SENDINGPUBSECFUNCTIONALAREA,    -- tims_sfunarea
    SENDERPUBSECGRANT,              -- tims_sgrant
    SENDERPUBSECBUDGETPERIOD,       -- tims_sbudget_period
    RECEIVERPUBSECFUND,             -- tims_rfund
    RECEIVERPUBSECFUNCNLAREA,       -- tims_rfunarea
    RECEIVERPUBSECGRANT,            -- tims_rgrant
    RECEIVERPUBSECBUDGETPERIOD,     -- tims_rbudget_period
    SERVICEDOCUMENTTYPE,            -- tims_srv_doc_type
    SERVICEDOCUMENT,                -- tims_srv_doc
    SERVICEDOCUMENTITEM,            -- tims_srv_doc_item
    TIMESHEETTASKTYPE,              -- tims_tasktype
    TIMESHEETTASKLEVEL,             -- tims_tasklevel
    TIMESHEETTASKCOMPONENT,         -- tims_taskcomponent
    STATISTICALKEYFIGURE,           -- tims_statkeyfig
    TIMESHEETPROCESSINGSTATUS,      -- tims_status
    TIMESHEETREJECTIONREASON,       -- tims_rejreason
    WORKFLOWTASKINTERNALID,         -- tims_wftaskintid
    TIMESHEETACCOUNTINGDOCUMENT,    -- tims_acc_document
    TIMESHEETISCHANGEDAFTERAPPRVL,  -- tims_chngd_aftr_apprvl
    TIMESHEETLASTUPDATEDSOURCE,     -- tims_last_upd_src
    CREATEDBYUSER,                  -- tims_created_by
    LASTCHANGEDBYUSER,              -- tims_lastchanged_by
    CREATIONDATETIME,               -- tims_created_on
    LASTCHANGEDATETIME,             -- tims_lastchanged_on
    TIMESHEETLASTCHANGEDATETIME,    -- tims_lastchanged_on
    PRIMARY KEY (MANDT, TIMESHEETUUID)
);