C_TimeSheetTaskListSidePanel

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 C_TimeSheetTaskListSidePanel.
-- 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 C_TimeSheetTaskListSidePanel AS
SELECT
  Task.TimeSheetTaskUUID AS TimeSheetTaskUUID,
  Calendar.CalendarYear AS CalendarYear,
  Calendar.CalendarMonth AS CalendarMonth,
  Calendar._CalendarMonth._Text[1: Language = $session.system_language ].CalendarMonthName AS CalendarMonthName,
  Task.TimeSheetTask AS TimeSheetTask,
  Task._TaskDisplayText.TimeSheetTaskNameForDisplayTxt AS TimeSheetTaskNameForDisplayTxt,
  Task.TimeSheetTaskName AS TimeSheetTaskName,
  Task._TaskDisplayText.TimeSheetTaskTypeText AS TimeSheetTaskTypeText,
  Task.WorkforcePersonExternalID AS WorkforcePersonExternalID,
  Task.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  Task.Country2DigitISOCode AS Country2DigitISOCode,
  Task.TimeSheetTaskAccountingCat AS TimeSheetTaskAccountingCat,
  Task._AccountingCat._Text[1: Language = $session.system_language ].TimeSheetTaskAccountingCatName AS TimeSheetTaskAccountingCatName,
  Task.TimeSheetTaskStartDate AS TimeSheetTaskStartDate,
  Task.TimeSheetTaskEndDate AS TimeSheetTaskEndDate,
  Task.TimeSheetTaskSourceType AS TimeSheetTaskSourceType,
  Task._TaskSourceType.TimeSheetTaskSourceTypeText AS TimeSheetTaskSourceTypeText,
  Task.ProjectDemandUUID AS ProjectDemandUUID,
  Task.ProjDmndRsceAssgmtUUID AS ProjDmndRsceAssgmtUUID,
  Task.ProjectUUID AS ProjectUUID,
  cast( Task._Project.Project as vdm_tims_project_id preserving type ) AS Project,
  cast( Task._Project.ProjectDescription as vdm_tims_project_name preserving type ) AS ProjectDescription,
  Task.ProjectElementUUID AS ProjectElementUUID,
  cast( Task._ProjectElement.ProjectElement as vdm_tims_work_package_id preserving type ) AS ProjectElement,
  cast( Task._ProjectElement.ProjectElementDescription as vdm_tims_work_package_name preserving type ) AS ProjectElementDescription,
  cast( Task._TimeRecgBlockFunction.EntProjTimeRecgIsBlkd as vdm_tims_blocked_fg preserving type ) AS EntProjTimeRecgIsBlkd,
  Task.EntProjElmntWorkItemUUID AS EntProjElmntWorkItemUUID,
  cast( Task._ProjectElementWorkItem.EntProjElmntWorkItem as vdm_tims_work_item_id preserving type ) AS EntProjElmntWorkItem,
  cast( Task._ProjectElementWorkItem.EntProjElmntWorkItemName as vdm_tims_work_item_name preserving type ) AS EntProjElmntWorkItemName,
  Task.CustomerUUID AS CustomerUUID,
  cast( Task._CustomerBP._BusinessPartner.BusinessPartner as vdm_tims_customer_id preserving type ) AS Customer,
  cast( Task._CustomerBP._BusinessPartner.BusinessPartnerFullName as vdm_tims_customer_name preserving type ) AS CustomerName,
  Task.ActivityType AS ActivityType,
  cast( Task._CostCenterActType._Text[1: Language = $session.system_language ].CostCtrActivityTypeName as vdm_tims_activity_type_name preserving type ) AS CostCtrActivityTypeName,
  Task.BillableControl AS BillableControl,
  cast( Task._BillableCat.BillingControlCategoryText as vdm_tims_bill_control_cat_txt preserving type ) AS BillingControlCategoryText,
  Task.RecentlyChangedDateTime AS RecentlyChangedDateTime,
  RecordedHours.RecordedHoursFltp AS RecordedHours,
  PlannedHours.PlannedHoursFltp AS ProjDmndRsceAssgmtDistrQty,
  PlannedHours.PlannedHoursUnit AS ProjDmndRsceAssgmtDistrQtyUnit,
  Task.TimeSheetTaskIsFavorite AS TimeSheetTaskIsFavorite,
  Task.TimeSheetTaskIsHidden AS TimeSheetTaskIsHidden,
  Task._CostCenterActType AS _CostCenterActType,
  Task._BillableCat AS _BillableCat,
  Task._CustomerBP AS _CustomerBP,
  Task._Project AS _Project,
  Task._ProjectElement AS _ProjectElement,
  Task._ProjectElementWorkItem AS _ProjectElementWorkItem,
  Task._WorkAssignment AS _WorkAssignment,
  Task._TimeRecgBlockFunction AS _TimeRecgBlockFunction
FROM P_TimeSheetTaskYearMonth AS Calendar
INNER JOIN R_TimeSheetTaskTP AS Task ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TimeSheetTaskRscDistr AS PlannedHours ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TimeSheetTaskRecHoursSum AS RecordedHours ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillableControlCategoryText ON _BillableControlCategoryText.BillingControlCategory = 'BILLABLE'  -- association [0..*]
LEFT OUTER JOIN P_TimesheetRecentlyUsedTask AS _TimeRecording ON Task.TimeSheetTaskUUID = _TimeRecording.TimeSheetTaskUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUser ON Task.BusinessPartner = _BusinessUser.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_TimeSheetWorkAssignment AS _TimeSheetWorkAssignment ON _TimeSheetWorkAssignment.WorkAssignmentExternalID = WorkAssignmentExternalID AND _TimeSheetWorkAssignment.Country2DigitISOCode = Country2DigitISOCode  -- association [1..1]
;