I_FldLogsInboundDel

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_FldLogsInboundDel.
-- 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: IFLDOCFLOWINBDEL

CREATE VIEW I_FldLogsInboundDel AS
SELECT
  _InDel.DeliveryDocument AS InboundDelivery,
  _InDel.DeliveryDocumentItem AS DeliveryDocumentItem,
  _InDel.DeliveryDocumentItemCategory AS InboundDeliveryItemCategory,
  _InDel._DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  _RetDoc.FldLogsReferenceDocumentNumber AS ReferenceDocumentNumber,
  _RetDoc.ReferenceDocumentItem AS ReferenceDocumentItem,
  _InDel._ItemCategory AS _ItemCategory,
  _InDel._DeliveryDocument._OverallGoodsMovementStatus AS _OverallGoodsMovementStatus,
  _InDel.Warehouse AS Warehouse,
  _InDel.SDDocumentCategory AS SDDocumentCategory,
  cast( _InDel.DeliveryDocument as /scdl/dl_docno_int ) AS EWMDelivery,
  cast( lpad( _InDel.DeliveryDocumentItem,10,'0') as /scdl/dl_itemno) AS EWMDeliveryItem,
  _InDel.GoodsMovementType AS DeliveryDocumentasInboundDelivery,
  _InDel.GoodsMovementType AS GoodsMovementType
FROM I_FldLogsFlogReturnBasic AS _RetDoc
LEFT OUTER JOIN I_DeliveryDocumentItem AS _InDel ON _InDel.ReferenceSDDocument = _RetDoc.FldLogsReferenceDocumentNumber AND _InDel.ReferenceSDDocumentItem = _RetDoc.ReferenceDocumentItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FldLogsFlogReturnBasic
;