A_TimeSheet_C1276

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 A_TimeSheet_C1276.
-- 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 A_TimeSheet_C1276 AS
SELECT
  TimeSheetUUID,
  WorkAssignmentExternalID,
  Country2DigitISOCode,
  TimeSheetDate,
  RecordedHours,
  HoursUnitOfMeasure,
  TimeSheetTaskUUID,
  _TimeSheetTask.TimeSheetTaskName AS TimeSheetTaskName,
  _TimeSheetTask._CustomerBP.Customer AS Customer,
  _TimeSheetTask._CustomerBP._Customer.CustomerName AS CustomerName,
  TimeSheetProcessingStatus,
  _TimeSheetProcessingStatus._TimeSheetProcgStatusText.TimeSheetProcessingStatusText : localized AS TimeSheetProcessingStatusTextlocalized,
  TimeSheetLongText,
  TimeSheetWrkLocCode,
  _TimeSheetWrkLoc._TimeSheetWrkLocText.TimeSheetWrkLocCodeName : localized AS TimeSheetWrkLocCodeNamelocalized,
  TimeSheetRejectionReason,
  _TimeSheetRejectionReason._TimeSheetRejectionReasonText.TimeSheetRejectionReasonText : localized AS TimeSheetRejectionReasonTextlocalized,
  TimeSheetOvertimeCategory
FROM R_TimeSheetTP_2
LEFT OUTER JOIN A_AllowedTimeSheetTask_C1276 AS _Task ON TimeSheetTaskUUID = _Task.TimeSheetTaskUUID  -- association [1..1]
LEFT OUTER JOIN A_TimeSheetWorkLocation AS _WorkLocation ON TimeSheetWrkLocCode = _WorkLocation.TimeSheetWrkLocCode AND _WorkLocation.TimeSheetWrkLocEndDate <= '99991231'  -- association [0..1]
LEFT OUTER JOIN A_TimeSheetOvertimeCategory AS _OverTimeCat ON TimeSheetOvertimeCategory = _OverTimeCat.TimeSheetOvertimeCategory  -- association [0..1]
;