I_FldLogsWarehouseTask

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_FldLogsWarehouseTask.
-- 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: IFLDWHTASK

CREATE VIEW I_FldLogsWarehouseTask AS
SELECT
  _OpenWHTask.EWMWarehouse AS EWMWarehouse,
  _OpenWHTask.WarehouseTask AS WarehouseTask,
  _OpenWHTask.IsHandlingUnitWarehouseTask AS IsHandlingUnitWarehouseTask,
  _OpenWHTask.SourceStorageBin AS SourceStorageBin,
  _OpenWHTask.WarehouseTaskStatus AS WarehouseTaskStatus,
  _OpenWHTask.DestinationStorageBin AS DestinationStorageBin,
  _OpenWHTask.DestinationStorageType AS DestinationStorageType,
  _OpenWHTask.ReferenceDocumentUUID AS ReferenceDocumentUUID,
  _OpenWHTask.ReferenceDocumentItemUUID AS ReferenceDocumentItemUUID,
  _OpenWHTask.WarehouseActivityType AS WarehouseActivityType,
  cast( _OpenWHTask.SourceHandlingUnit as ewm_de_sourcehuident preserving type ) AS SourceHandlingUnit,
  _OpenWHTask.SourceHandlingUnitUUID AS SourceHandlingUnitUUID,
  _OpenWHTask.WarehouseProcessCategory AS WarehouseProcessCategory,
  _ConfirmWHTask.WhseTaskCrtnUTCDateTime AS WhseTaskCrtnUTCDateTime
FROM I_FldLogsPlants AS _FlogPlant
INNER JOIN I_EWM_PlantStorLocMapToWhse AS _PlantWH ON /* join condition not captured in parsed metadata */
INNER JOIN I_EWM_OpenWarehouseTasks_2 AS _OpenWHTask ON /* join condition not captured in parsed metadata */
INNER JOIN I_EWM_ConfirmedWarehouseTask_2 AS _ConfirmWHTask ON /* join condition not captured in parsed metadata */
INNER JOIN I_EWM_WarehouseProcessCategory AS _wpc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FldLogsPlants
;