I_FldLogsReceivedShipmentItem

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_FldLogsReceivedShipmentItem.
-- 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_FldLogsReceivedShipmentItem AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  FldLogsReferenceDocCategory,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsCtnItmChangeDateTime,
  FldLogsSupplyProcess,
  FldLogsStorageType,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsProcessType,
  FieldLogisticsReceivingPlant,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  FldLogsItemType,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsShptItmHndlgUnitID,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  PurchasingDocumentItem,
  IsMarkedForDeletion,
  _StorageBin.WarehouseStorageBin AS WarehouseStorageBin,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  _InspectionLot.InspectionLot AS InspectionLot,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument
FROM I_FldLogsReturnCtnItmsBasic
LEFT OUTER JOIN I_FldLogsReturnProcgComment AS _Comment ON FldLogsContainerID = _Comment.FldLogsContainerID AND DispatchedStartDate = _Comment.DispatchedStartDate AND FldLogsDispatchPlant = _Comment.FldLogsDispatchPlant AND NumberOfCtnTripsPerDay = _Comment.NumberOfCtnTripsPerDay AND FldLogsReferenceDocumentNumber = _Comment.FldLogsReferenceDocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRcvdOutboundDelivery AS _DeliverySTO ON OutboundDelivery = _DeliverySTO.DeliveryDocument AND OutboundDeliveryItem = _DeliverySTO.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _ReferenceSDDocument ON ReferenceSDDocument = _ReferenceSDDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_FieldLogisticsStorageBin AS _StorageBin ON Material = _StorageBin.Material AND FldLogsItmActualReceivingPlant = _StorageBin.Plant AND FldLogsDestStorLocID = _StorageBin.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON MaterialDocument = _InspectionLot.MaterialDocument AND MaterialDocumentYear = _InspectionLot.MaterialDocumentYear AND MaterialDocumentItem = _InspectionLot.MaterialDocumentItem AND _InspectionLot.MaterialDocument is not initial AND _InspectionLot.MaterialDocumentItem is not initial AND _InspectionLot.MaterialDocumentYear is not initial  -- association [0..1]
;