I_FldLogsCtnDispatchRdyEnhcd

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_FldLogsCtnDispatchRdyEnhcd.
-- 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: IFLCTNITMRDYCOL

CREATE VIEW I_FldLogsCtnDispatchRdyEnhcd AS
SELECT
  FldLogsContainerID,
  DispatchedStartDate,
  FldLogsDispatchPlant,
  NumberOfCtnTripsPerDay,
  FldLogsReferenceDocumentNumber,
  Material,
  LoadingQtyInOrderUnit AS RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  RemoteStorageLocation,
  SupplyingStorageLocation,
  FldLogsReturnStatus,
  FldLogsSupplyProcess,
  FldLogsCtnItmChangeDateTime,
  FldLogsRecommendedAction,
  MaterialName,
  cast ('' as aufnr ) AS ReferenceOrder,
  cast ( '' as mblnr ) AS MaterialDocument,
  cast ( '' as ebeln ) AS PurchasingDocument,
  cast ('' as flog_item_status) AS FldLogsContainerItemStatus,
  cast ( '' as flog_qk_action) AS FldLogsCtnQuickAction,
  cast ( '' as flog_doctyp) AS FldLogsReferenceDocCategory,
  cast ( '' as ebeln ) AS ReferencePurchasingDocument,
  cast ('' as ebeln ) AS StockTransportOrder,
  cast ( '' as flog_rt_cmnts ) AS FldLogsReturnComment,
  cast('' as /scwm/lgtyp) AS FldLogsStorageType,
  cast('' as charg_d) AS Batch,
  cast('' as bwtar_d) AS ValuationType,
  cast('' as gernr) AS SerialNumber,
  cast('' as ebeln ) AS FldLogsRetServicePurOrd,
  IsMarkedForDeletion
FROM I_FldLogsCtnItmDispatchReady
;