C_MyInboxTimeShtApprvl

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_MyInboxTimeShtApprvl.
-- 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.
-- SQL view name: CTMESHTAPPRVL
-- Parameters: P_WorkflowTaskInternalID : sww_wiid

CREATE VIEW C_MyInboxTimeShtApprvl AS
SELECT
  Cats.TimeSheetRecord AS TimeSheetRecord,
  Cats.PersonWorkAgreement AS PersonWorkAgreement,
  _PersonWorkAgreement._WorkforcePerson.PersonExternalID AS PersonExternalID,
  concat( '#Employee-displayFactSheet?EmployeeExtID=', _PersonWorkAgreement._WorkforcePerson.PersonExternalID ) AS WebsiteURL,
  _PersonWorkAgreement._WorkforcePerson.PersonFullName AS PersonFullName,
  _PersonWorkAgreement.AuthorizationGroup AS AuthorizationGroup,
  Cats.TimeSheetDate AS TimeSheetDate,
  Cats.EngagementProject AS EngagementProject,
  case Cats.EngagementProjectCategory when 'C' then concat( '#CustomerProject-displayFactSheet?CustomerProject=', Cats.EngagementProject) when 'I' then concat( '#InternalProject-displayFactSheet?InternalProject=', Cats.EngagementProject) end as EngmntProjURL AS EngagementProjectendasEngmntProjURL,
  Cats.EngagementProjectName AS EngagementProjectName,
  Cats.Customer AS Customer,
  _CustomerVH.CustomerName AS CustomerName,
  Cats.PurchaseOrder AS PurchaseOrder,
  Cats.WorkPackage AS WorkPackage,
  Cats.WorkPackageName AS WorkPackageName,
  Cats.WorkItem AS WorkItem,
  _WorkItem.WorkItemName AS WorkItemName,
  Cats.ActivityType AS ActivityType,
  _CostCenterActivityTypeText.CostCtrActivityTypeName AS EngagementProjResourceText,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  _BillingControlCategoryText.BillingControlCategoryText AS BillingControlCategoryText,
  _TimeSheetTaskTypeText.TimeSheetTaskTypeText AS TimeSheetTaskTypeText,
  Cats.WBSElementInternalID AS WBSElementInternalID,
  Cats.WBSDescription AS WBSDescription,
  Cats.WBSElementExternalID AS WBSElementExternalID,
  _CostCenterText.CostCenterName AS CostCenterName,
  Cats.ReceiverCostCenter AS ReceiverCostCenter,
  Cats.InternalOrder AS InternalOrder,
  Cats.TimeSheetNote AS TimeSheetNote,
  Cats.TimeSheetLongText AS TimeSheetLongText,
  Cats.TimeSheetPredecessorRecord AS TimeSheetPredecessorRecord,
  _TimeSheetPredecessorRecord.RecordedHours AS PreviousRecordedHours,
  _TimeSheetPredecessorRecord.TimeSheetNote AS PrevTimeSheetNote,
  Cats.TimeSheetWrkLocCode AS TimeSheetWrkLocCode,
  Cats.TimeSheetWrkLocCodeName AS TimeSheetWrkLocCodeName,
  Cats.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  Cats.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  cast(Cats.PlndEffortQty as abap.dec( 15, 2 )) AS PlndEffortQty,
  Cats.RecordedHours AS RecordedHours,
  Cats.TotalApprovedHours AS TotalApprovedHours,
  Cats.TotalRejectedHours AS TotalRejectedHours,
  Cats.TimeSheetLastChangedDate AS TimeSheetLastChangedDate
FROM I_TimeShtEntriesForApprvl
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON Cats.PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkItem ON Cats.WorkItem = _WorkItem.WorkItem AND Cats.WorkPackage = _WorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON Cats.ControllingArea = _CostCenterActivityTypeText.ControllingArea AND Cats.ActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND _CostCenterActivityTypeText.ValidityEndDate >= $session.system_date AND _CostCenterActivityTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON Cats.BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetRecord AS _TimeSheetPredecessorRecord ON Cats.TimeSheetPredecessorRecord = _TimeSheetPredecessorRecord.TimeSheetRecord  -- association [1..1]
LEFT OUTER JOIN I_Customer_VH AS _CustomerVH ON _CustomerVH.Customer = Cats.Customer  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON Cats.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND Cats.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetTaskTypeText AS _TimeSheetTaskTypeText ON Cats.TimeSheetTaskType = _TimeSheetTaskTypeText.TimeSheetTaskType AND _TimeSheetTaskTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_TimeSheetRecord AS _TimeSheetRecordExtention ON TimeSheetRecord = _TimeSheetRecordExtention.TimeSheetRecord  -- association [0..1]
LEFT OUTER JOIN I_EntProjElmntBlockFunc AS _WPFunctionValue ON Cats.WBSElementInternalID = _WPFunctionValue.WBSElementInternalID AND Cats.EntProjElementFunctionID = _WPFunctionValue.EntProjElementFunctionID  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON Cats.ReceiverCostCenter = _CostCenterText.CostCenter AND Cats.ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.Language = $session.system_language AND Cats.TimeSheetLastChangedDate <= _CostCenterText.ValidityEndDate AND Cats.TimeSheetLastChangedDate >= _CostCenterText.ValidityStartDate  -- association [0..1]
;