I_FldLogsRcvdItmInbDelivery

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_FldLogsRcvdItmInbDelivery.
-- 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.

CREATE VIEW I_FldLogsRcvdItmInbDelivery AS
SELECT
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsItmActualReceivingPlant,
  _InboundDelivery.GoodsMovementStatus AS GoodsMovementStatus,
  FldLogsReferenceDocumentNumber,
  cast( InboundDelivery as /scdl/dl_docno_int ) AS EWMDelivery,
  cast( lpad( InboundDeliveryItem,10,'0') as /scdl/dl_itemno) AS EWMDeliveryItem,
  WarehouseTask,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsSubcontractingPO,
  OutboundDelivery,
  OutboundDeliveryItem,
  _InboundDelivery.SDDocumentCategory AS SDDocumentCategory,
  FldLogsRcvdItmIsAcctAssgd
FROM I_FldLogsRetCtnItemEnhanced
LEFT OUTER JOIN I_FldLogsRcvdInboundDelivery AS _InboundDelivery ON _InboundDelivery.DeliveryDocument = InboundDelivery AND _InboundDelivery.DeliveryDocumentItem = InboundDeliveryItem  -- association [0..1]
;