I_FldLogsReturnCtnItmsBasic

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_FldLogsReturnCtnItmsBasic.
-- 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.
-- SQL view name: IFLOGRETCTNITM

CREATE VIEW I_FldLogsReturnCtnItmsBasic AS
SELECT
  cont_id AS FldLogsContainerID,
  dispatchdat AS DispatchedStartDate,
  dispatch_loc AS FldLogsDispatchPlant,
  cont_tripcnt AS NumberOfCtnTripsPerDay,
  ref_doc AS FldLogsReferenceDocumentNumber,
  ref_doctyp AS FldLogsReferenceDocCategory,
  matnr AS Material,
  load_quantity AS RetblQtyInOrderUnit,
  loadqtyorderunit AS RetblQtyOrderUnit,
  unit AS RetblQtyBaseUnit,
  loadqtyinbaseunit AS RetblQtyInBaseUnit,
  ret_status AS FldLogsReturnStatus,
  item_status AS FldLogsContainerItemStatus,
  quk_action AS FldLogsCtnQuickAction,
  FldLogsSupplyProcess,
  gr AS MaterialDocument,
  ret_po AS PurchasingDocument,
  ret_po AS StockTransportOrder,
  ret_po AS FldLogsRetServicePurOrd,
  Batch,
  valuation_typ AS ValuationType,
  serialno AS SerialNumber,
  process_type AS FieldLogisticsProcessType,
  receivingplant AS FieldLogisticsReceivingPlant,
  del_flag AS IsMarkedForDeletion,
  changedat AS FldLogsCtnItmChangeDateTime,
  storage_type AS FldLogsStorageType,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsSubcontrgPOIsCreated,
  FldLogsSubcontractingPO,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  item_type AS FldLogsItemType,
  FldLogsRefurbishmentOrder,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  reservation AS FldLogsRefrbmtOrderReservation,
  reservationitem AS FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsShptItmHndlgUnitID,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  cast ( warehousetask as /scwm/tanum_conv_alpha preserving type ) AS WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  PurchasingDocumentItem,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem
FROM flog_retctn_itm
;