I_FldLogsRcvdItmInContainerAll

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_FldLogsRcvdItmInContainerAll.
-- 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_FldLogsRcvdItmInContainerAll AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItmHndlgUnitID,
  OutboundDelivery,
  OutboundDeliveryItem,
  Batch,
  Material,
  FldLogsItemType,
  cast(FldLogsShptItmHndlgUnitID as exidv) AS HandlingUnitExternalID,
  WBSElementExternalID,
  _ShipmentItem._KitHeader.FieldLogisticsKitIdentifier AS FieldLogisticsKitIdentifier,
  InboundDelivery,
  FldLogsShptItemUUID,
  _DeliveryDocument.ShippingPoint AS ShippingPoint
FROM I_FldLogsContainerItemRecord
LEFT OUTER JOIN I_FldLogsRcvdPackaging AS _RcvdPackgg ON FldLogsContainerID = _RcvdPackgg.FldLogsContainerID AND FldLogsDispatchPlant = _RcvdPackgg.FldLogsDispatchPlant AND DispatchedStartDate = _RcvdPackgg.DispatchedStartDate AND NumberOfCtnTripsPerDay = _RcvdPackgg.NumberOfCtnTripsPerDay  -- association [0..1]
LEFT OUTER JOIN I_FldLogsShipmentItem AS _ShipmentItem ON FldLogsShptItemUUID = _ShipmentItem.FldLogsShptItemUUID  -- association [1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON OutboundDelivery = _DeliveryDocument.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_FldLogsFlogReturnBasic AS _ReturnItems ON OutboundDelivery = _ReturnItems.OutboundDelivery AND OutboundDeliveryItem = _ReturnItems.OutboundDeliveryItem AND _ReturnItems.OutboundDelivery is not initial  -- association [0..1]
;