Wave Pick Item
This virtual data model provides the prerequisites for analyzing the data generated throughout the process for warehouse picking tasks. Areas for analysis include open and confirmed warehouse tasks as well as aggregated weight and volume of workload.
The following main views are grouped together in this virtual data model:
Query view for
Wave Pick Item Query
(WavePickItemQuery
)Query view for
Wave Pick Item Current Date Query
(WavePickItemCurrentDateQuery
)Query view for
Wave Pick Item First Release Current Time Query
(WavePickItemFirstReleaseCurrentTimeQuery
)Query view for
Wave Pick Item Planned Pick Completion Current Time Query
(WavePickItemPlndPickCompltnCurrentTimeQuery
)Reuse view for
Wave Pick Item
(WavePickItem
)
Structure
Business Objects
The main views of this virtual data model are primarily built on the following business objects:
Wave Pick Item
Wave Pick Header
Open Warehouse Task
Confirmed Warehouse Task
Measures and Attributes
For all main views, the measures included are:
Item Capacity Usage
(ItemConsumedCapacity
)Items with Incompl. Whse Task Creation
(NmbrOfItmsIncmpltWhseTaskCrtn
)Number of Confirmed Whse Tasks
(NumberOfConfirmedWrhsTasks
)Number of Open Whse Tasks
(NumberOfOpenWrhsTasks
)
For the main query views, the following measures are also included:
Item Volume in Display Unit
(ItemVolumeInDisplayUnit_E
)Item Weight in Display Unit
(ItemWeightInDisplayUnit_E
)
For the main reuse view, the following measures are also included:
Item Quantity
(ItemQuantity
)Item Volume
(ItemVolume
)Item Weight
(ItemWeight
)
The main views of this virtual data model cover important attributes, such as, warehouse, weight, volume and status of warehouse task creation.
Filters
The main query views use the following variables:
Client
(mandatory)Warehouse
The measures of the main query views are calculated for a specified time interval based on the planned release date and time of the wave pick. Therefore, you can only filter for wave pick items with a planned wave release time stamp that falls within a specified time interval.
The main query views use the following mandatory input parameters:
For the Wave Pick Item Query
view:
Time Zone
(P_TimeZone
)Plnd Release Start Date
(P_PlannedReleaseStartDate
)Plnd Release Start Time
(P_PlannedReleaseStartTime
)Plnd Release End Date
(P_PlannedReleaseEndDate
)Plnd Release End Time
(P_PlannedReleaseEndTime
)Display Volume Unit
(P_DisplayVolumeUnit
)Display Weight Unit
(P_DisplayWeightUnit
)
For the Wave Pick Item Current Date Query
view:
Time Zone
(P_TimeZone
)Shift Start Time
(P_ShiftStartTime
)Shift End Time
(P_ShiftEndTime
)Display Volume Unit
(P_DisplayVolumeUnit
)Display Weight Unit
(P_DisplayWeightUnit
)
For the Wave Pick Item First Release Current Time Query
view:
Shift Start Time
(P_ShiftStartTime
)Minutes Before Shift Start Time
(P_BeforeShiftStartTimeMinutes
)Display Volume Unit
(P_DisplayVolumeUnit
)Display Weight Unit
(P_DisplayWeightUnit
)
For the Wave Pick Item Planned Pick Completion Current Time Query
view:
Time Zone
(P_TimeZone
)Shift Start Time
(P_ShiftStartTime
)Minutes Before Shift Start Time
(P_BeforeShiftStartTimeMinutes
)Minutes After Current Time
(P_AfterCurrentTimeMinutes
)Display Volume Unit
(P_DisplayVolumeUnit
)Display Weight Unit
(P_DisplayWeightUnit
)
Used Tables and Views
The main views grouped together in this virtual data model select data mainly from the following tables:
/SCWM/WAVEHDR
(wave header)/SCWM/WAVEITM
(wave item)/
SCWM/ORDIM_O
(warehouse tasks open)/SCWM/ORDIM_C
(warehouse tasks confirmed)/SCDL/DB_PROCI_O
(outbound delivery order item)
Constraints
The main views of this virtual data model retrieve data for wave pick items only. To this end in exclusion of other warehouse activities, such as packing, certain conditions are hard-coded in the main views.
For selecting wave pick items, the following hard-coded conditions were applied:
Reference Document Category
=Outbound Delivery
(table field value/SCWM/WAVEHDR-RDOCCAT
=PDO
)Wave Release Date/Time
exists (fieldRLS_DT
of table/SCWM/WAVEHDR
is filled)
For selecting warehouse tasks, the following hard-coded condition was applied:
Reference Document Category
=Outbound Delivery
(tables/SCWM/ORDIM_O-RDOCCAT
=PDO
and/SCWM/ORDIM_C-RDOCCAT
=PDO
)
More Information
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 
Master, Installation, Security, Configuration, and Operations Information
Administrator’s Guide
.