R_TimeSheet

DDL: R_TIMESHEET Type: view_entity BASIC
26 Fields 1 Data Sources 2 Associations

Time Sheet

R_TimeSheet is a Basic CDS View that provides data about "Time Sheet" in SAP S/4HANA. It reads from 1 data source (catsdbext) and exposes 26 fields with key field TimeSheetRecordUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
catsdbext catsdbext from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_TimeSheetSDMStatus _TimeSheetSDMStatus _TimeSheetSDMStatus.MigrationClass = 'CL_SDM_CATSDB_2308'
[1..1] I_TimeSheetRecord _TimeSheetRecord $projection.TimeSheetRecord = _TimeSheetRecord.TimeSheetRecord

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
EndUserText.label Time Sheet view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetRecordUUID catsdbext timesheetrecorduuid GUID
TimeSheetRecord catsdbext timesheetrecord Counter
WorkAssignment _TimeSheetRecord PersonWorkAgreement Personnel No.
TimeSheetDate _TimeSheetRecord TimeSheetDate Date
RecordedHours _TimeSheetRecord RecordedHours Hours
HoursUnitOfMeasure _TimeSheetRecord HoursUnitOfMeasure Unit of Measure
TimeSheetRecordLongText catsdbext timesheetrecordlongtext Timesheet Long Text
WBSElementInternalID _TimeSheetRecord WBSElementInternalID WBS Internal ID
ActivityType _TimeSheetRecord ActivityType Activity Type
WorkItem _TimeSheetRecord WorkItem Work Item ID
BillableControl _TimeSheetRecord AccountingIndicatorCode AcctIndicator
TimeSheetStatus _TimeSheetRecord TimeSheetStatus Process status
TimeSheetRejectionReason _TimeSheetRecord RejectionReason
TimeSheetPredecessorRecord _TimeSheetRecord TimeSheetPredecessorRecord Ref. counter
TimeSheetAccountingDocument _TimeSheetRecord TimeSheetAccountingDocument Document no.
WorkflowTaskInternalID _TimeSheetRecord WorkflowTaskInternalID Work Item ID
CreatedByUser _TimeSheetRecord CreatedByUser User Name
LastChangedByUser _TimeSheetRecord LastChangedByUser User Name
TimeSheetApprovedByUser _TimeSheetRecord TimeSheetApprovedByUser Approved by
TimeSheetApprovedDate _TimeSheetRecord TimeSheetApprovedDate Approval date
TimeSheetCreationDate _TimeSheetRecord TimeSheetCreationDate Created on
TimeSheetEntryTime _TimeSheetRecord TimeSheetEntryTime Time
TimeSheetLastChangedDate _TimeSheetRecord TimeSheetLastChangedDate Last Change
TimeSheetLastChangedTime _TimeSheetRecord TimeSheetLastChangedTime Time
LastChangeDateTime catsdbext lastchangedatetime Timestamp
TimeSheetLastChangeDateTime catsdbext timesheetlastchangedatetime Changed On

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_TimeSheet.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_TimeSheet AS
SELECT
  catsdbext.timesheetrecorduuid AS TimeSheetRecordUUID,
  catsdbext.timesheetrecord AS TimeSheetRecord,
  _TimeSheetRecord.PersonWorkAgreement AS WorkAssignment,
  _TimeSheetRecord.TimeSheetDate AS TimeSheetDate,
  _TimeSheetRecord.RecordedHours AS RecordedHours,
  _TimeSheetRecord.HoursUnitOfMeasure AS HoursUnitOfMeasure,
  catsdbext.timesheetrecordlongtext AS TimeSheetRecordLongText,
  _TimeSheetRecord.WBSElementInternalID AS WBSElementInternalID,
  _TimeSheetRecord.ActivityType AS ActivityType,
  _TimeSheetRecord.WorkItem AS WorkItem,
  _TimeSheetRecord.AccountingIndicatorCode AS BillableControl,
  _TimeSheetRecord.TimeSheetStatus AS TimeSheetStatus,
  _TimeSheetRecord.RejectionReason AS TimeSheetRejectionReason,
  _TimeSheetRecord.TimeSheetPredecessorRecord AS TimeSheetPredecessorRecord,
  _TimeSheetRecord.TimeSheetAccountingDocument AS TimeSheetAccountingDocument,
  _TimeSheetRecord.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _TimeSheetRecord.CreatedByUser AS CreatedByUser,
  _TimeSheetRecord.LastChangedByUser AS LastChangedByUser,
  _TimeSheetRecord.TimeSheetApprovedByUser AS TimeSheetApprovedByUser,
  _TimeSheetRecord.TimeSheetApprovedDate AS TimeSheetApprovedDate,
  _TimeSheetRecord.TimeSheetCreationDate AS TimeSheetCreationDate,
  _TimeSheetRecord.TimeSheetEntryTime AS TimeSheetEntryTime,
  _TimeSheetRecord.TimeSheetLastChangedDate AS TimeSheetLastChangedDate,
  _TimeSheetRecord.TimeSheetLastChangedTime AS TimeSheetLastChangedTime,
  catsdbext.lastchangedatetime AS LastChangeDateTime,
  catsdbext.timesheetlastchangedatetime AS TimeSheetLastChangeDateTime
FROM catsdbext
LEFT OUTER JOIN P_TimeSheetSDMStatus AS _TimeSheetSDMStatus ON _TimeSheetSDMStatus.MigrationClass = 'CL_SDM_CATSDB_2308'  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetRecord AS _TimeSheetRecord ON TimeSheetRecord = _TimeSheetRecord.TimeSheetRecord  -- association [1..1]
;

Learn More