I_PurchaseOrderItemOverdue

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_PurchaseOrderItemOverdue.
-- 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: IMMPURORDOVERDUE

CREATE VIEW I_PurchaseOrderItemOverdue AS
SELECT
  ebeln AS PurchaseOrder,
  ebelp AS PurchaseOrderItem,
  etenr AS ScheduleLine,
  cast ( DATS_DAYS_BETWEEN( eindt, cast( $session.system_date as abap.dats) ) as abap.int8) as OverdueDays AS int8asOverdueDays,
  case when ( _PurchaseOrderItem.OrderQuantity = 0 ) then 0 else cast((menge - wemng) * DIVISION( _PurchaseOrderItem.NetAmount , _PurchaseOrderItem.OrderQuantity, 3 ) as abap.curr( 15, 3 )) end as OpenPurchaseOrderNetAmount AS curr153endasOpenPurchaseOrderNetAmount,
  _PurchaseOrderItem.DocumentCurrency AS Currency
FROM eket
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;