R_FldLogsProcessReturnHeaderTP

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 R_FldLogsProcessReturnHeaderTP.
-- 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 R_FldLogsProcessReturnHeaderTP AS
SELECT
  FldLogsReturnHeaderUUID,
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  cast( FldLogsShptItmHndlgUnitID as exidv preserving type ) AS HandlingUnitExternalID,
  Material,
  ReceiptDate,
  FldLogsRetdQtyInOrderUnit,
  FldLogsQtyInProcess,
  FldLogsRetdQtyOrderUnit,
  FldLogsSupplyProcess,
  FldLogsCtnQuickAction,
  FldLogsReturnedItemStatus,
  FldLogsKitItmRefDocument2,
  ReferenceDocumentItem,
  OrderID,
  FldLogsShptVoyageNumber,
  FldLogsRecommendedAction,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  FieldLogisticsProcessType,
  Batch,
  ValuationType,
  SerialNumber,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  PurchasingDocumentItem,
  FldLogsReturnProcgComment,
  WarehouseStorageBin,
  _PurOrdSpclStkDet.InventorySpecialStockType AS InventorySpecialStockType,
  FldLogsSuplrItemUUID,
  OutboundDelivery,
  OutboundDeliveryItem,
  IsMarkedForDeletion,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  Operation,
  PurchaseOrder,
  PurchaseOrderItem,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  FldLogsSrcePlnt,
  FldLogsDestPlnt,
  InboundDelivery,
  InboundDeliveryItem,
  OrderCategory
FROM I_FldLogsProcessReturnHeader AS ProcessReturnHeader
LEFT OUTER JOIN I_FldLogsReturnComment AS _ReturnComment ON FldLogsKitItmRefDocument2 = _ReturnComment.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _ReturnComment.ReferenceDocumentItem AND _ReturnComment.FldLogsReferenceDocumentNumber is not initial  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON FldLogsSuplrItemUUID = _SupplierItem.FldLogsSuplrItemUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnItem AS _ReturnItms ON OutboundDelivery = _ReturnItms.OutboundDelivery AND OutboundDeliveryItem = _ReturnItms.OutboundDeliveryItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsPlantBasic AS _PlantBasic ON FldLogsDispatchPlant = _PlantBasic.Plant AND FldLogsDispatchPlant = _PlantBasic.SupplyingPlant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ReceivingPlantText ON FldLogsDestPlnt = _ReceivingPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _DispatchPlantText ON FldLogsSrcePlnt = _DispatchPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _SourceStorageLocationText ON FldLogsSrceStorLocID = _SourceStorageLocationText.StorageLocation AND FldLogsSrcePlnt = _SourceStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _DestinationStorageLocationTxt ON FldLogsDestStorLocID = _DestinationStorageLocationTxt.StorageLocation AND FldLogsDestPlnt = _DestinationStorageLocationTxt.Plant  -- association [0..1]
LEFT OUTER JOIN E_FieldLogisticsReturnedItem AS _ProcRetHdrExt ON FldLogsReturnHeaderUUID = _ProcRetHdrExt.FldLogsReturnHeaderUUID  -- association [1..1]
LEFT OUTER JOIN R_FldLogsProcessReturnItemTP AS _ProcessReturnItem ON /* condition not available in parsed metadata */  -- association [0..*]
;