I_MMTimeRecording

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_MMTimeRecording.
-- 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: IMMTMERECG

CREATE VIEW I_MMTimeRecording AS
SELECT
  catsmm.counter AS ReferenceDocument,
  catsmm.stokz AS IsDeleted,
  catsmm.ltxa1 AS TimeSheetNote,
  catsmm.pernr AS PersonnelNumber,
  catsmm.workdate AS ServicePerformanceDate,
  catsmm.rkostl AS CostCenter,
  catsmm.rproj AS WBSElementInternalID,
  cast( catsmm.rproj as ps_s4_pspnr preserving type ) AS WBSElementInternalID_2,
  catsmm.raufnr AS OrderID,
  catsmm.rkdauf AS SalesOrder,
  catsmm.rkdpos AS SalesOrderItem,
  catsmm.sebeln AS PurchaseOrder,
  catsmm.sebelp AS PurchaseOrderItem,
  catsmm.transfer AS IsSettled,
  catsmm.catsquantity AS Quantity,
  catsmm.unit AS UnitOfMeasure,
  catsmm.work_item_id AS WorkItem,
  I_PurchaseOrder.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  I_PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  R_PurchaseOrderItem.Plant AS Plant
FROM catsmm
INNER JOIN I_PurchaseOrder ON /* join condition not captured in parsed metadata */
INNER JOIN R_PurchaseOrderItem ON /* join condition not captured in parsed metadata */
;