R_TimeSheetDraft

DDL: R_TIMESHEETDRAFT Type: view_entity BASIC Package: ODATA_HCM_CATS_REPORTING
37 Fields 1 Data Sources

TimeSheet Draft Query View

R_TimeSheetDraft is a Basic CDS View that provides data about "TimeSheet Draft Query View" in SAP S/4HANA. It reads from 1 data source (catsdbext_d) and exposes 37 fields with key field TimeSheetRecordUUID. Part of development package ODATA_HCM_CATS_REPORTING.

Data Sources (1)

SourceAliasJoin Type
catsdbext_d TimeSheet from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label TimeSheet Draft Query View view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix TIM view
AbapCatalog.extensibility.quota.maximumFields 350 view
AbapCatalog.extensibility.quota.maximumBytes 35000 view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetRecordUUID timesheetrecorduuid GUID
TimeSheetRecord timesheetrecord Counter
WorkAssignmentExternalID workassignmentexternalid WFA Ext. ID
Country2DigitISOCode country2digitisocode Country/Region
WorkAssignment workassignment WorkForce Assgmt ID
TimeSheetDate timesheetdate Date
RecordedHours recordedhours Hours
HoursUnitOfMeasure hoursunitofmeasure Unit of Measure
TimeSheetRecordLongText timesheetrecordlongtext Timesheet Long Text
ProjectUUID projectuuid Project UUID
WBSElementInternalID wbselementinternalid WBS Internal ID
ActivityType activitytype Activity Type
WorkItem workitem Work Item ID
BillingControlCategory billingcontrolcategory Billing Category
BillableControl billablecontrol Billable Control
TimeSheetStatus timesheetstatus Process status
TimeSheetRejectionReason timesheetrejectionreason Rejection reas.
TimeSheetPredecessorRecord timesheetpredecessorrecord Ref. counter
TimeSheetAccountingDocument timesheetaccountingdocument Document no.
WorkflowTaskInternalID workflowtaskinternalid Work Item ID
CreatedByUser createdbyuser User Name
LastChangedByUser lastchangedbyuser User Name
TimeSheetApprovedByUser timesheetapprovedbyuser Approved by
TimeSheetApprovedDate timesheetapproveddate Approval date
TimeSheetCreationDate timesheetcreationdate Created on
TimeSheetEntryTime timesheetentrytime Time
TimeSheetLastChangedDate timesheetlastchangeddate Last Change
TimeSheetLastChangedTime timesheetlastchangedtime Time
LastChangeDateTime lastchangedatetime Timestamp
TimeSheetLastChangeDateTime timesheetlastchangedatetime Changed On
TimeSheetOperation timesheetoperation
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_TimeSheetDraft.
-- 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_TimeSheetDraft AS
SELECT
  TimeSheetRecordUUID,
  TimeSheetRecord,
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  WorkAssignment,
  TimeSheetDate,
  RecordedHours,
  HoursUnitOfMeasure,
  TimeSheetRecordLongText,
  ProjectUUID,
  WBSElementInternalID,
  ActivityType,
  WorkItem,
  BillingControlCategory,
  BillableControl,
  TimeSheetStatus,
  TimeSheetRejectionReason,
  TimeSheetPredecessorRecord,
  TimeSheetAccountingDocument,
  WorkflowTaskInternalID,
  CreatedByUser,
  LastChangedByUser,
  TimeSheetApprovedByUser,
  TimeSheetApprovedDate,
  TimeSheetCreationDate,
  TimeSheetEntryTime,
  TimeSheetLastChangedDate,
  TimeSheetLastChangedTime,
  LastChangeDateTime,
  TimeSheetLastChangeDateTime,
  TimeSheetOperation,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM catsdbext_d AS TimeSheet
;

Learn More