Depo Yönetimi Veri Template'iniz

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

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