I_SESTimeRecording

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_SESTimeRecording.
-- 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: ISESTMERECG

CREATE VIEW I_SESTimeRecording AS
SELECT
  I_MMTimeRecording.ReferenceDocument AS ReferenceDocument,
  I_MMTimeRecording.IsDeleted AS IsDeleted,
  I_MMTimeRecording.TimeSheetNote AS TimeSheetNote,
  I_MMTimeRecording.PersonnelNumber AS PersonnelNumber,
  I_MMTimeRecording.ServicePerformanceDate AS ServicePerformanceDate,
  I_MMTimeRecording.CostCenter AS CostCenter,
  I_MMTimeRecording.WBSElementInternalID AS WBSElementInternalID,
  I_MMTimeRecording.WBSElementInternalID_2 AS WBSElementInternalID_2,
  I_MMTimeRecording.OrderID AS OrderID,
  I_MMTimeRecording.SalesOrder AS SalesOrder,
  I_MMTimeRecording.SalesOrderItem AS SalesOrderItem,
  I_MMTimeRecording.PurchaseOrder AS PurchaseOrder,
  I_MMTimeRecording.PurchaseOrderItem AS PurchaseOrderItem,
  I_MMTimeRecording.Quantity AS Quantity,
  I_MMTimeRecording.UnitOfMeasure AS UnitOfMeasure,
  I_MMTimeRecording.IsSettled AS IsSettled,
  I_MMTimeRecording.WorkItem AS WorkItem,
  I_MMTimeRecording.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_MMTimeRecording.PurchasingOrganization AS PurchasingOrganization,
  I_MMTimeRecording.PurchasingGroup AS PurchasingGroup,
  I_MMTimeRecording.Plant AS Plant,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  _ServiceEntrySheetItem.ServiceEntrySheet AS ServiceEntrySheet,
  _ServiceEntrySheetItem._ServiceEntrySheet.ApprovalStatus AS ApprovalStatus,
  _ServiceEntrySheetItem._ServiceEntrySheet.MaterialDocument AS MaterialDocument,
  _ServiceEntrySheetItem.IsDeleted AS ServiceEntrySheetItemIsDeleted
FROM I_MMTimeRecording
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceEntrySheetItemBasic AS _ServiceEntrySheetItem ON ReferenceDocument = _ServiceEntrySheetItem.OriginObject AND I_MMTimeRecording.PurchaseOrder = _ServiceEntrySheetItem.PurchaseOrder AND I_MMTimeRecording.PurchaseOrderItem = _ServiceEntrySheetItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN E_SESTimeRecording AS _SESTimeRecExtension ON I_MMTimeRecording.ReferenceDocument = _SESTimeRecExtension.ReferenceDocument AND I_MMTimeRecording.IsDeleted = _SESTimeRecExtension.IsSettled  -- association [1..1]
;