This virtual data model provides the prerequisites for gaining an insight into warehouse performance by analyzing data generated through the execution of warehouse tasks.
The following main views are grouped together in this virtual data model:
Query view for Warehouse Task Execution Query
(WarehouseTaskExecutionQuery
)
Query view for Warehouse Task Item Query
(WarehouseTaskItemQuery
)
Reuse view for Warehouse Task Item
(WarehouseTaskItem
)
Business Objects
The main views of this virtual data model are primarily built on the following business objects:
Warehouse Order
Open Warehouse Task
Confirmed Warehouse Task
Measures and Attributes
For all main views, the measures included are:
Number of Confirmed Whse Tasks
(NumberOfConfirmedWrhsTasks
)
Number of Canceled Warehouse Tasks
(NumberofCanceledWrhsTasks
)
Number of Open Whse Tasks
(NumberOfOpenWrhsTasks
)
Number of Warehouse Tasks
(NumberOfWarehouseTasks
)
Number of Warehouse Task Items
(NumberOfWarehouseTaskItems
)
Target Quantity In Base Unit
(TargetQuantityInBaseUnit
)
Actual Quantity In Base Unit
(ActualQuantityInBaseUnit
)
Difference Quantity In Base Unit
(DifferenceQuantityInBaseUnit
)
For the main query view, Warehouse Task Item Query
, the following measures are also included:
Item Weight in Display Unit
(ItemWeightInDisplayUnit_E
)
Item Volume in Display Unit
(ItemVolumeInDisplayUnit_E
)
The main views of this virtual data model cover important attributes, such as, warehouse, weight, volume, status of warehouse task, and date & time of confirmed warehouse tasks.
Filters
The main query views for Warehouse Task Execution Query
and Warehouse Task Item Query
use the following variables:
Client
(mandatory)
Warehouse
The measures of these main query views are calculated for a specified time interval based on the creation date & time of the warehouse order.
You can only filter for warehouse orders with assigned warehouse tasks and items having a creation time stamp that belongs to a specified time interval.
To specify a time interval for the creation date & time of the warehouse order, the main query views for Warehouse Task Execution Query
and Warehouse Task Item Query
use the following mandatory input parameters:
Time Zone
(P_TimeZone
)
Shift Start Time
(P_ShiftStartTime
)
The Warehouse Task Execution Query
further uses the mandatory input parameter:
Minutes Before Shift Start Time
(P_BeforeShiftStartTimeMinutes)
The Warehouse Task Item Query
further uses the mandatory input parameters:
Shift Start Date
(P_ShiftStartDate
)
Shift End Date
(P_ShiftEndDate
)
Shift End Time
(P_ShiftEndTime
)
Used Tables and Views
The main views grouped together in this virtual data model select data mainly from the following tables:
/SCWM/WHO
(warehouse order)
/SCWM/ORDIM_O
(warehouse tasks open)
/SCWM/ORDIM_C
(warehouse tasks confirmed)
The main views of this virtual data model retrieve data only on the condition that:
Warehouse tasks are assigned to warehouse orders.
Warehouse orders contain at least one warehouse task.
In the SAP HANA Studio Modeler, you can automatically generate a PDF document listing in detail the technical Virtual Data Model features, which includes, for example, a complete list of attributes. For more information about the auto documentation function, see Auto Documentation..
For more information about working with the views, see the Administrator’s Guide for SAP HANA Live 1.0 on the SAP Help Portal at http://help.sap.com/hba, under .