I_TimeSheetTP

DDL: I_TIMESHEETTP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources

Time Sheet - TP

I_TimeSheetTP is a Transactional CDS View that provides data about "Time Sheet - TP" in SAP S/4HANA. It reads from 1 data source (R_TimeSheetTP) and exposes 26 fields with key field TimeSheetRecordUUID.

Data Sources (1)

SourceAliasJoin Type
R_TimeSheetTP R_TimeSheetTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Time Sheet - TP view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name TimeSheet view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

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
WBSElementInternalID WBSElementInternalID WBS Internal ID
ActivityType ActivityType Activity Type
WorkItem WorkItem Work Item ID
BillingControlCategory BillingControlCategory Billing Category
TimeSheetStatus TimeSheetStatus Process status
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
LastChangeDateTime LastChangeDateTime Timestamp
TimeSheetLastChangedDate TimeSheetLastChangedDate Last Change
TimeSheetLastChangedTime TimeSheetLastChangedTime Time

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 I_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 I_TimeSheetTP AS
SELECT
  TimeSheetRecordUUID,
  TimeSheetRecord,
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  WorkAssignment,
  TimeSheetDate,
  RecordedHours,
  HoursUnitOfMeasure,
  TimeSheetRecordLongText,
  WBSElementInternalID,
  ActivityType,
  WorkItem,
  BillingControlCategory,
  TimeSheetStatus,
  TimeSheetPredecessorRecord,
  TimeSheetAccountingDocument,
  WorkflowTaskInternalID,
  CreatedByUser,
  LastChangedByUser,
  TimeSheetApprovedByUser,
  TimeSheetApprovedDate,
  TimeSheetCreationDate,
  TimeSheetEntryTime,
  LastChangeDateTime,
  TimeSheetLastChangedDate,
  TimeSheetLastChangedTime
FROM R_TimeSheetTP
;

Learn More