Datatemplate voor magazijnbeheer

DEFINE VIEW Z_C_EWM_EVENTLOG_CDS
  WITH PARAMETERS
    P_StartDate : abap.dats,
    P_EndDate   : abap.dats
  AS SELECT FROM I_WarehouseOrder AS WO
{
  -- Required Attributes
  WO.WarehouseOrder                                     AS WarehouseOrder,
  CAST('Warehouse Order Created' AS abap.char(40))        AS ActivityName,
  WO.CreationDateTime                                   AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20))                     AS SourceSystem,
  tstmp_current_utctimestamp()                            AS LastDataUpdate,
  -- Recommended Attributes
  CAST(NULL AS abap.tstp)                                 AS EventEndTime,
  CAST(NULL AS abap.char(40))                             AS MaterialNumber,
  WO.CreationUser                                       AS User,
  WO.WarehouseOrderType                                 AS WarehouseOrderType,
  WO.WarehouseOrderStatus                               AS WarehouseOrderStatus,
  WO.Priority                                           AS Priority,
  CAST(NULL AS abap.dec(15, 2))                           AS ProcessingTime
}
WHERE
  CAST(WO.CreationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseOrder AS WO
{
  WO.WarehouseOrder,
  CAST('Warehouse Order Completed' AS abap.char(40)) AS ActivityName,
  WO.ConfirmationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  CAST(NULL AS abap.char(40)) AS MaterialNumber,
  WO.ConfirmationUser AS User,
  WO.WarehouseOrderType,
  WO.WarehouseOrderStatus,
  WO.Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WO.WarehouseOrderStatus = 'C' AND
  CAST(WO.ConfirmationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseOrder AS WO
{
  WO.WarehouseOrder,
  CAST('Warehouse Order Canceled' AS abap.char(40)) AS ActivityName,
  WO.LastChangeDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  CAST(NULL AS abap.char(40)) AS MaterialNumber,
  WO.LastChangeUser AS User,
  WO.WarehouseOrderType,
  WO.WarehouseOrderStatus,
  WO.Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WO.WarehouseOrderStatus = 'X' AND
  CAST(WO.LastChangeDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
  LEFT JOIN I_InboundDeliveryItem AS IBD ON WT.DeliveryDocument = IBD.InboundDelivery AND WT.DeliveryDocumentItem = IBD.InboundDeliveryItem
{
  WT.WarehouseOrder,
  CAST('Goods Receipt Posted' AS abap.char(40)) AS ActivityName,
  IBD.ActualGoodsMovementDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  IBD.LastChangedByUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '1' AND -- Putaway
  IBD.GoodsMovementStatus = 'C' AND -- Completed
  CAST(IBD.ActualGoodsMovementDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Putaway Task Created' AS abap.char(40)) AS ActivityName,
  WT.CreationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  WT.ConfirmationDateTime AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.CreationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '1' AND -- Putaway
  CAST(WT.CreationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Putaway Task Confirmed' AS abap.char(40)) AS ActivityName,
  WT.ConfirmationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.ConfirmationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  WT.ProcessorProcTimeInSec AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '1' AND -- Putaway
  WT.WarehouseTaskStatus = 'C' AND
  CAST(WT.ConfirmationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Picking Task Created' AS abap.char(40)) AS ActivityName,
  WT.CreationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  WT.ConfirmationDateTime AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.CreationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '2' AND -- Stock Removal
  CAST(WT.CreationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Picking Task Confirmed' AS abap.char(40)) AS ActivityName,
  WT.ConfirmationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.ConfirmationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  WT.ProcessorProcTimeInSec AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '2' AND -- Stock Removal
  WT.WarehouseTaskStatus = 'C' AND
  CAST(WT.ConfirmationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Packing Started' AS abap.char(40)) AS ActivityName,
  WT.CreationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  WT.ConfirmationDateTime AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.CreationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '5' AND -- Packing
  CAST(WT.CreationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Packing Completed' AS abap.char(40)) AS ActivityName,
  WT.ConfirmationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.ConfirmationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  WT.ProcessorProcTimeInSec AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '5' AND -- Packing
  WT.WarehouseTaskStatus = 'C' AND
  CAST(WT.ConfirmationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
{
  WT.WarehouseOrder,
  CAST('Staging Task Confirmed' AS abap.char(40)) AS ActivityName,
  WT.ConfirmationDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  WT.ConfirmationUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  WT.ProcessorProcTimeInSec AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '4' AND -- Staging
  WT.WarehouseTaskStatus = 'C' AND
  CAST(WT.ConfirmationDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_EWMTransportationUnit AS TU
  INNER JOIN I_WarehouseTask AS WT ON TU.TransportationUnit = WT.ShipmentOrTransportationUnit
{
  WT.WarehouseOrder,
  CAST('Loading Started' AS abap.char(40)) AS ActivityName,
  TU.LoadingStartDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  TU.LoadingEndDateTime AS EventEndTime,
  WT.Product AS MaterialNumber,
  TU.LastChangeUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE 
  TU.LoadingStartDateTime IS NOT NULL AND
  CAST(TU.LoadingStartDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_EWMTransportationUnit AS TU
  INNER JOIN I_WarehouseTask AS WT ON TU.TransportationUnit = WT.ShipmentOrTransportationUnit
{
  WT.WarehouseOrder,
  CAST('Loading Completed' AS abap.char(40)) AS ActivityName,
  TU.LoadingEndDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  TU.LastChangeUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE 
  TU.LoadingEndDateTime IS NOT NULL AND
  TU.LoadingStatus = 'C' AND
  CAST(TU.LoadingEndDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

UNION ALL

SELECT FROM I_WarehouseTask AS WT
  LEFT JOIN I_OutboundDeliveryItem AS OBD ON WT.DeliveryDocument = OBD.OutboundDelivery AND WT.DeliveryDocumentItem = OBD.OutboundDeliveryItem
{
  WT.WarehouseOrder,
  CAST('Goods Issue Posted' AS abap.char(40)) AS ActivityName,
  OBD.ActualGoodsMovementDateTime AS EventTime,
  CAST('S4HANA_EWM' AS abap.char(20)) AS SourceSystem,
  tstmp_current_utctimestamp() AS LastDataUpdate,
  CAST(NULL AS abap.tstp) AS EventEndTime,
  WT.Product AS MaterialNumber,
  OBD.LastChangedByUser AS User,
  WT.WarehouseOrderType,
  CAST(NULL AS abap.char(1)) AS WarehouseOrderStatus,
  CAST(NULL AS abap.numc(2)) AS Priority,
  CAST(NULL AS abap.dec(15, 2)) AS ProcessingTime
}
WHERE
  WT.WhseTskProcessCat = '2' AND -- Stock Removal
  OBD.GoodsMovementStatus = 'C' AND -- Completed
  CAST(OBD.ActualGoodsMovementDateTime AS abap.dats) BETWEEN :P_StartDate AND :P_EndDate

WITH
params AS (
    SELECT
        CAST('[Start date and time]' AS TIMESTAMP) AS start_time,
        CAST('[End date and time]' AS TIMESTAMP) AS end_time,
        CAST('[Source system name]' AS VARCHAR(255)) AS source_system,
        CAST(CURRENT_TIMESTAMP AS TIMESTAMP) AS last_data_update
),
warehouse_orders AS (
    SELECT
        CAST(wo.[Warehouse order ID field] AS VARCHAR(255)) AS WarehouseOrder,
        CAST(wo.[Warehouse order type field] AS VARCHAR(255)) AS WarehouseOrderType,
        CAST(wo.[Warehouse order status field] AS VARCHAR(255)) AS WarehouseOrderStatus,
        CAST(wo.[Priority field] AS VARCHAR(255)) AS Priority,
        CAST(wo.[Warehouse order creation timestamp field] AS TIMESTAMP) AS WarehouseOrderCreatedTime,
        CAST(wo.[Warehouse order completion timestamp field] AS TIMESTAMP) AS WarehouseOrderCompletedTime,
        CAST(wo.[Warehouse order cancellation timestamp field] AS TIMESTAMP) AS WarehouseOrderCanceledTime,
        CAST(wo.[Material number field] AS VARCHAR(255)) AS MaterialNumber,
        CAST(wo.[User field] AS VARCHAR(255)) AS [User]
    FROM [Your warehouse order header table] wo
),
warehouse_tasks AS (
    SELECT
        CAST(wt.[Warehouse order ID field] AS VARCHAR(255)) AS WarehouseOrder,
        CAST(wt.[Warehouse task ID field] AS VARCHAR(255)) AS WarehouseTask,
        CAST(wt.[Task category or process type field] AS VARCHAR(255)) AS TaskType,
        CAST(wt.[Material number field] AS VARCHAR(255)) AS MaterialNumber,
        CAST(wt.[Task creation timestamp field] AS TIMESTAMP) AS TaskCreatedTime,
        CAST(wt.[Task confirmation timestamp field] AS TIMESTAMP) AS TaskConfirmedTime,
        CAST(wt.[User field] AS VARCHAR(255)) AS [User]
    FROM [Your warehouse task table] wt
),
events AS (
    SELECT wo.WarehouseOrder, 'Warehouse Order Created' AS ActivityName, wo.WarehouseOrderCreatedTime AS EventTime, CAST(NULL AS TIMESTAMP) AS EventEndTime, wo.MaterialNumber, wo.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_orders wo
    UNION ALL
    SELECT gr.[Warehouse order ID field], 'Goods Receipt Posted', CAST(gr.[Goods receipt posting timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(gr.[Material number field] AS VARCHAR(255)), CAST(gr.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your goods receipt posting table] gr LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(gr.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT wt.WarehouseOrder, 'Putaway Task Created', wt.TaskCreatedTime, CAST(NULL AS TIMESTAMP), wt.MaterialNumber, wt.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_tasks wt LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = wt.WarehouseOrder WHERE wt.TaskType = '[Verified putaway task type]'
    UNION ALL
    SELECT wt.WarehouseOrder, 'Putaway Task Confirmed', wt.TaskConfirmedTime, CAST(NULL AS TIMESTAMP), wt.MaterialNumber, wt.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_tasks wt LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = wt.WarehouseOrder WHERE wt.TaskType = '[Verified putaway task type]' AND wt.TaskConfirmedTime IS NOT NULL
    UNION ALL
    SELECT wt.WarehouseOrder, 'Picking Task Created', wt.TaskCreatedTime, CAST(NULL AS TIMESTAMP), wt.MaterialNumber, wt.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_tasks wt LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = wt.WarehouseOrder WHERE wt.TaskType = '[Verified picking task type]'
    UNION ALL
    SELECT wt.WarehouseOrder, 'Picking Task Confirmed', wt.TaskConfirmedTime, CAST(NULL AS TIMESTAMP), wt.MaterialNumber, wt.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_tasks wt LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = wt.WarehouseOrder WHERE wt.TaskType = '[Verified picking task type]' AND wt.TaskConfirmedTime IS NOT NULL
    UNION ALL
    SELECT pk.[Warehouse order ID field], 'Packing Started', CAST(pk.[Packing start timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(pk.[Material number field] AS VARCHAR(255)), CAST(pk.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your packing event table] pk LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(pk.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT pk.[Warehouse order ID field], 'Packing Completed', CAST(pk.[Packing completion timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(pk.[Material number field] AS VARCHAR(255)), CAST(pk.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your packing event table] pk LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(pk.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT st.[Warehouse order ID field], 'Staging Task Confirmed', CAST(st.[Staging confirmation timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(st.[Material number field] AS VARCHAR(255)), CAST(st.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your staging event table] st LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(st.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT ld.[Warehouse order ID field], 'Loading Started', CAST(ld.[Loading start timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(ld.[Material number field] AS VARCHAR(255)), CAST(ld.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your loading event table] ld LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(ld.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT ld.[Warehouse order ID field], 'Loading Completed', CAST(ld.[Loading completion timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(ld.[Material number field] AS VARCHAR(255)), CAST(ld.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your loading event table] ld LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(ld.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT gi.[Warehouse order ID field], 'Goods Issue Posted', CAST(gi.[Goods issue posting timestamp field] AS TIMESTAMP), CAST(NULL AS TIMESTAMP), CAST(gi.[Material number field] AS VARCHAR(255)), CAST(gi.[User field] AS VARCHAR(255)), wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM [Your goods issue posting table] gi LEFT JOIN warehouse_orders wo ON wo.WarehouseOrder = CAST(gi.[Warehouse order ID field] AS VARCHAR(255))
    UNION ALL
    SELECT wo.WarehouseOrder, 'Warehouse Order Completed', wo.WarehouseOrderCompletedTime, CAST(NULL AS TIMESTAMP), wo.MaterialNumber, wo.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_orders wo WHERE wo.WarehouseOrderCompletedTime IS NOT NULL
    UNION ALL
    SELECT wo.WarehouseOrder, 'Warehouse Order Canceled', wo.WarehouseOrderCanceledTime, CAST(NULL AS TIMESTAMP), wo.MaterialNumber, wo.[User], wo.WarehouseOrderType, wo.WarehouseOrderStatus, wo.Priority FROM warehouse_orders wo WHERE wo.WarehouseOrderCanceledTime IS NOT NULL
)
SELECT
    e.WarehouseOrder,
    e.ActivityName,
    e.EventTime,
    e.EventEndTime,
    p.source_system AS SourceSystem,
    p.last_data_update AS LastDataUpdate,
    e.MaterialNumber,
    e.[User],
    e.WarehouseOrderType,
    e.WarehouseOrderStatus,
    e.Priority
FROM events e
CROSS JOIN params p
WHERE e.WarehouseOrder IS NOT NULL
  AND e.EventTime IS NOT NULL
  AND e.EventTime >= p.start_time
  AND e.EventTime < p.end_time
ORDER BY e.WarehouseOrder, e.EventTime, e.ActivityName;