I_TIMESHEETRECORD

CDS View
31 Fields 10 CDS Views

Time Recording Data

I_TIMESHEETRECORD is a CDS View in S/4HANA. Time Recording Data. It contains 31 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_CATSDATAWITHCATEGORY view from COMPOSITE
P_FuncnlAreaTskTmeRec view from COMPOSITE WUFAREA Task Time Recording
P_FundTskTmeRec view from COMPOSITE WUFUND Task Time Recording
P_GrantTskTmeRec view from COMPOSITE WUGRANT Task Time Recording
P_SDMForCatsTable view_entity from BASIC
P_TimeSheetApprovedHours view from COMPOSITE
P_TimeSheetRejectedHours view from COMPOSITE
P_TimeShtEntriesForApprvl view from COMPOSITE
P_TimeShtHrsAnlysForProjects view from COMPOSITE
P_TmeShtApprvrMail view from BASIC Email: Timesheet Approver reminder

Fields (31)

KeyField CDS FieldsUsed in Views
KEY TimeSheetRecord TimeSheetRecord 7
_TimeSheetOvertimeCatText _TimeSheetOvertimeCatText 1
_TimeSheetRecordLongText _TimeSheetRecordLongText 1
_TimeSheetTaskTypeText _TimeSheetTaskTypeText 1
_TimeSheetWrkLoc _TimeSheetWrkLoc 1
AccountingIndicatorCode AccountingIndicatorCode 5
ActivityType ActivityType,EngagementProjectResource 8
ControllingArea ControllingArea 1
HoursUnitOfMeasure HoursUnitOfMeasure 2
InternalOrder InternalOrder 3
PersonWorkAgreement EmploymentInternalID,PersonWorkAgreement 6
PurchaseOrder PurchaseOrder 5
PurchaseOrderItem PurchaseOrderItem 3
ReceiverCostCenter ReceiverCostCenter 3
RecordedHours RecordedHours 2
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
TimeSheetDate CalendarDate,TimeSheetDate 3
TimeSheetHasLongText TimeSheetHasLongText 1
TimeSheetLastChangedDate TimeSheetLastChangedDate 1
TimeSheetNote TimeSheetNote 2
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 1
TimeSheetPredecessorRecord TimeSheetPredecessorRecord 2
TimeSheetStatus Status,TimeSheetStatus 4
TimeSheetTaskType TaskType,TimeSheetTaskType 4
TimeSheetWrkLocCode TimeSheetWrkLocCode 1
UnitOfMeasure UnitOfMeasure 2
WBSElementInternalID WBSElementInternalID 4
WorkflowTaskInternalID WorkflowTaskInternalID 1
WorkItem WorkItem 5

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.

-- Time Recording Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TIMESHEETRECORD (
    TIMESHEETRECORD,
    _TIMESHEETOVERTIMECATTEXT,
    _TIMESHEETRECORDLONGTEXT,
    _TIMESHEETTASKTYPETEXT,
    _TIMESHEETWRKLOC,
    ACCOUNTINGINDICATORCODE,
    ACTIVITYTYPE,
    CONTROLLINGAREA,
    HOURSUNITOFMEASURE,
    INTERNALORDER,
    PERSONWORKAGREEMENT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    RECEIVERCOSTCENTER,
    RECORDEDHOURS,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    TIMESHEETDATE,
    TIMESHEETHASLONGTEXT,
    TIMESHEETLASTCHANGEDDATE,
    TIMESHEETNOTE,
    TIMESHEETOVERTIMECATEGORY,
    TIMESHEETPREDECESSORRECORD,
    TIMESHEETSTATUS,
    TIMESHEETTASKTYPE,
    TIMESHEETWRKLOCCODE,
    UNITOFMEASURE,
    WBSELEMENTINTERNALID,
    WORKFLOWTASKINTERNALID,
    WORKITEM,
    PRIMARY KEY (TIMESHEETRECORD)
);

Learn More