R_TimeSheetTP

DDL: R_TIMESHEETTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 2 Associations

Time Sheet - TP

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

Data Sources (1)

SourceAliasJoin Type
R_TimeSheet TimeSheet from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_WorkAssgmtDetsDEX _WorkAssgmtDets $projection.WorkAssignment = _WorkAssgmtDets.WorkAssignment
[1..1] I_BllbleCtrlBillgCtrlCatAssgmt _BllbleCtrlBillgCtrlCatAssgmt $projection.BillableControl = _BllbleCtrlBillgCtrlCatAssgmt.BillableControl

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Time Sheet - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name TimeSheet view
ObjectModel.representativeKey TimeSheetRecordUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetRecordUUID TimeSheetRecordUUID GUID
TimeSheetRecord TimeSheetRecord Counter
WorkAssignmentExternalID _WorkAssgmtDets WorkAssignmentExternalID WFA Ext. ID
Country2DigitISOCode
WorkAssignment WorkAssignment WorkForce Assgmt ID
TimeSheetDate TimeSheetDate Date
RecordedHours RecordedHours Hours
HoursUnitOfMeasure HoursUnitOfMeasure Unit of Measure
TimeSheetRecordLongText TimeSheetRecordLongText Timesheet Long Text
WBSElementInternalID WBSElementInternalID WBS Internal ID
ActivityType ActivityType Activity Type
WorkItem WorkItem Work Item ID
BillingControlCategory _BllbleCtrlBillgCtrlCatAssgmt 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

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_TimeSheetTP.
-- 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_TimeSheetTP AS
SELECT
  TimeSheetRecordUUID,
  TimeSheetRecord,
  _WorkAssgmtDets.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  cast(_WorkAssgmtDets.CountryOrRegion as intca ) AS Country2DigitISOCode,
  WorkAssignment,
  TimeSheetDate,
  RecordedHours,
  HoursUnitOfMeasure,
  TimeSheetRecordLongText,
  WBSElementInternalID,
  ActivityType,
  WorkItem,
  _BllbleCtrlBillgCtrlCatAssgmt.BillingControlCategory AS BillingControlCategory,
  BillableControl,
  TimeSheetStatus,
  TimeSheetRejectionReason,
  TimeSheetPredecessorRecord,
  TimeSheetAccountingDocument,
  WorkflowTaskInternalID,
  CreatedByUser,
  LastChangedByUser,
  TimeSheetApprovedByUser,
  TimeSheetApprovedDate,
  TimeSheetCreationDate,
  TimeSheetEntryTime,
  TimeSheetLastChangedDate,
  TimeSheetLastChangedTime,
  LastChangeDateTime,
  TimeSheetLastChangeDateTime
FROM R_TimeSheet AS TimeSheet
LEFT OUTER JOIN I_WorkAssgmtDetsDEX AS _WorkAssgmtDets ON WorkAssignment = _WorkAssgmtDets.WorkAssignment  -- association [1..1]
LEFT OUTER JOIN I_BllbleCtrlBillgCtrlCatAssgmt AS _BllbleCtrlBillgCtrlCatAssgmt ON BillableControl = _BllbleCtrlBillgCtrlCatAssgmt.BillableControl  -- association [1..1]
;

Learn More