I_FldLogsRcvdHndlgUnitItmRecd

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_FldLogsRcvdHndlgUnitItmRecd.
-- 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_FldLogsRcvdHndlgUnitItmRecd AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  FldLogsReferenceDocumentNumber,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  FldLogsReferenceDocCategory,
  Material,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSupplyProcess,
  FldLogsItemType,
  FldLogsReturnStatus,
  FldLogsContainerItemStatus,
  FldLogsCtnQuickAction,
  MaterialDocument,
  PurchasingDocument,
  StockTransportOrder,
  FldLogsRetServicePurOrd,
  FldLogsStorageType,
  Batch,
  ValuationType,
  SerialNumber,
  FieldLogisticsReceivingPlant,
  FieldLogisticsProcessType,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  FldLogsCtnItmChangeDateTime,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  MaintenanceOrder AS ReferenceOrder,
  _ReturnItms.FldLogsRecommendedAction AS FldLogsRecommendedAction,
  _ReturnItms.ReferencePurchasingDocument AS ReferencePurchasingDocument,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  _WarehouseNumber.EWMWarehouse AS EWMWarehouse,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  FldLogsContainerID,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  FldLogsRefrbmtOrderReservation,
  FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  cast(concat(FldLogsReferenceDocumentNumber,FldLogsShptItmHndlgUnitID) as char40 ) AS FldLogsRcvdHndlgUnitCnctntdID,
  WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  _PurOrdSpclStkDet.WBSElementExternalID AS WBSElementExternalID,
  _PurOrdSpclStkDet.InventorySpecialStockType AS InventorySpecialStockType,
  WarehouseStorageBin,
  PurchasingDocumentItem,
  IsMarkedForDeletion,
  FldLogsItmActualReceivingPlant,
  FldLogsItemActualDispatchPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  InspectionLot,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument
FROM I_FldLogsRcvdHndlgUntItm
LEFT OUTER JOIN I_FldLogsPlntStorLocWrhsNmbr AS _WarehouseNumber ON FldLogsItmActualReceivingPlant = _WarehouseNumber.Plant AND FldLogsDestStorLocID = _WarehouseNumber.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnItem AS _ReturnItms ON OutboundDelivery = _ReturnItms.OutboundDelivery AND OutboundDeliveryItem = _ReturnItms.OutboundDeliveryItem AND _ReturnItms.OutboundDelivery is not initial  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPurOrdSpclStockDetail AS _PurOrdSpclStkDet ON ReferenceSDDocument = _PurOrdSpclStkDet.ReferenceSDDocument AND PurchasingDocumentItem = _PurOrdSpclStkDet.PurchasingDocumentItem  -- association [0..1]
;