You can use this query to display and analyze the number, weight, volume, and effort for confirmed picking warehouse tasks (WT). You can see these tasks grouped by hour, day, week, or month. This information can reveal trends to help you make the following decisions:
Adjust the warehouse work schedules according to demand
Hire new workers, or let existing workers go
Request additional budget for expenses such as extra equipment
You can drill down to specific warehouse areas to determine when to move workers around the warehouse to meet demands, or when to move more stock to those areas.
The following points are specifics about this query:
A pick WT is a product WT or handling unit (HU) WT that is executed in the first step of an outbound process. This query uses the warehouse number and day, week, and month time intervals. The time intervals are determined by the confirmation date and time of the WT.
Since picking task occurs in the first step of an outbound process, this query does not monitor the outbound process end-to-end.
The query does not compare planned execution time and total execution time because these KPIs are each based on different data.
The query does not support drill-down by product.
The Employee
free characteristic behaves as follows: if the Labor Management (LM) component is active in the EWM system, Employee
contains the value of the Processor
field. If the Processor
field
is empty (LM is not active), then the system takes the value of the Confirmed By
field.
The query can help you identify a cross-dock picking WT if you know the source storage type assigned to it. If you do not know the source storage type assigned to a cross-dock picking WT, you can use the document category field (0WM_RDOCCAT
) to look
for document category types that denote cross-dock picking (PDI). However you would need to modify the query to display this.
Example
This is how you can use the document type field to find a cross-dock picking WT:
The regular document category for a picking task is PDO. When you see a different value for the document category, such as PDI, this indicates that the picked stock has been assigned to an inbound delivery. This identifies the cross-docking process.
A complete list of query filters, selection criteria, drill-down criteria, and key figures are provided in the table below.
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Warehouse Number |
0WM_LGNUM |
[ |
| Calendar Year/Week |
0CALWEEK |
[ |
| DocCat for DocRef |
0WM_RDOCCAT |
! = # |
| Warehouse Process Category |
0WM_TRART |
= 2 |
| WT Status |
0WM_TOSTAT |
= C |
Object Type | Name | Technical Name |
|---|---|---|
| Calendar Year |
0CALYEAR |
| Calendar Year/Month |
0CALMONTH |
| Calendar Day |
0CALDAY |
| Hour |
0WM_HOUR |
| Source Activity Area |
0WM_AAREA |
| Source Storage Type |
0WM_VLTYP |
| Source Storage Section |
0WM_VLBER |
| Source Bin Type |
0WM_VPTYP |
| Entitled Party |
0WM_ENTL |
| Warehouse Process Type |
0WM_PROCTY |
| Employee |
0WM_PRCSR12 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of picks |
0WM_COUNT2 |
Key figure |
| Weight |
0WM_WEIGHT |
Key figure, hidden |
| Volume |
0WM_VOLUM |
Key figure, hidden |
| Planned Processing Time |
0WM_MP05_CK002 |
Calculated key figure, hidden |
| Extractions |
0WM_MP05_CK001 |
Calculated key figure, hidden |
| Actual Processing Time |
0WM_MP05_CK010 |
Calculated key figure, hidden |
| Warehouse Number |
0WM_LGNUM |
First view characteristic |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar Year/Week |
0CALWEEK |
First view characteristic |