I_FldLogsReturnContainerBasic

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_FldLogsReturnContainerBasic.
-- 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: IFLFLOGRETCTN

CREATE VIEW I_FldLogsReturnContainerBasic AS
SELECT
  cont_id AS FldLogsContainerID,
  dispatchdat AS DispatchedStartDate,
  dispatch_loc AS FldLogsDispatchPlant,
  cont_tripcnt AS NumberOfCtnTripsPerDay,
  cont_status AS FldLogsContainerStatus,
  process_start_dat AS FldLogsCtnProcessingStartDate,
  process_end_dat AS FldLogsCtnProcessingEndDate,
  supply_plant AS SupplyingPlant,
  FldLogsShipmentID,
  FldLogsContainerUUID,
  process_type AS FieldLogisticsProcessType,
  FldLogsContainerUnitUUID,
  receivingplant AS FieldLogisticsReceivingPlant,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  del_flag AS IsMarkedForDeletion,
  changedat AS FldLogsCtnChangeDateTime,
  FldLogsRcvdContainerIsReleased,
  _FldLogsShipmentContainer.FldLogsContainerOwner AS FldLogsContainerOwner,
  FldLogsCtnActualDispatchPlant,
  FldLogsCtnActualReceivingPlant
FROM flog_retctn
LEFT OUTER JOIN I_FldLogsShipmentContainer AS _FldLogsShipmentContainer ON _FldLogsShipmentContainer.FldLogsContainerUUID = FldLogsContainerUUID  -- association [0..1]
;