WM Report Custom development ALV report

Warehouse Picker Productivity Report

Short answer: A custom ALV report that groups confirmed transfer order items by confirming user, day and source storage type, and calculates items confirmed per hour, average time from creation to confirmation and the difference rate. Warehouse management tracks team capacity and target compliance with data.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
4
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

LT22 and LT23 list confirmed transfer orders per document, but they do not calculate items per hour per confirming user, active working time or performance against a target rate. To measure productivity, the records are usually downloaded to Excel and processed with a pivot table.

Who uses it? Warehouse managers, shift supervisors and operational excellence teams.

Closest standard alternatives

  • LT23 Transfer Orders by Number. Lists confirmed transfer orders per document; does not calculate items per hour per user.
  • LT22 Transfer Orders by Storage Type. Shows transfer orders by storage type; has no productivity or target comparison.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
LTAPTransfer Order ItemConfirmed items: confirming user, confirmation date/time, source storage type, difference quantity (driving table)—ECC + S/4
LTAKTransfer Order HeaderMovement type and creation date/timeLTAK-LGNUM = LTAP-LGNUM AND LTAK-TANUM = LTAP-TANUMECC + S/4
T333WM Movement TypesWM movement type definitionT333-LGNUM = LTAK-LGNUM AND T333-BWLVS = LTAK-BWLVSECC + S/4
T301WM Storage TypesStorage type definitionT301-LGNUM = LTAP-LGNUM AND T301-LGTYP = LTAP-VLTYPECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAK-LGNUMYes100
S_QDATUConfirmation dateRange / multipleLTAP-QDATUYes10.11.2026 – 16.11.2026
S_QNAMEConfirmed byRange / multipleLTAP-QNAMENoTOPLAYICI01
S_BWLVSWM movement typeRange / multipleLTAK-BWLVSNo601
S_VLTYPSource storage typeRange / multipleLTAP-VLTYPNo001
P_TARGETTarget items/hourSingle value—No40
R_DETAILView: user-day-storage type / user-day onlyRadio button—Nokullanıcı-gün-depo tipi

Output columns

#ColumnSource
1Confirmed byLTAP-QNAME
2Conf. dateLTAP-QDATU
3Movement typeLTAK-BWLVS
4Source typeLTAP-VLTYP
5TO countCalculated Count of distinct LTAP-TANUM
6Item countCalculated Count of confirmed LTAP items
7First conf.Calculated Minimum LTAP-QZEIT
8Last conf.Calculated Maximum LTAP-QZEIT
9Active time (h)Calculated Last conf. − first conf. − gaps longer than 30 minutes
10Items/hourCalculated Item count ÷ active time
11Avg completion (min)Calculated Σ (LTAP-QDATU/QZEIT − LTAK-BDATU/BZEIT) ÷ item count
12Difference rate %Calculated Items with LTAP-VDIFM ≠ 0 ÷ item count × 100
13vs target %Calculated Items/hour ÷ target × 100

Sample output

Confirmed byConf. dateMovement typeSource typeTO countItem countFirst conf.Last conf.Active time (h)Items/hourAvg completion (min)Difference rate %vs target %
TOPLAYICI0111/16/20266010014831207:0514:507.1043.90380.60110
TOPLAYICI0211/16/20266010025526807:2015:107.3036.70461.9092
TOPLAYICI0311/16/20266010013119015:0522:406.4029.70643.7074
FORKLIFT0111/16/2026999902626207:0014:306.90995022
A view built with fictional sample data; not real system data.

How does the report work?

  1. Confirmed items (PQUIT = X) in the selected confirmation date range are read from LTAP; the confirming user (QNAME), confirmation date and time (QDATU, QZEIT), source storage type and difference quantity (VDIFM) are taken.
  2. Movement type and creation date/time (BDATU, BZEIT) are added from LTAK; the movement type description is read from T333.
  3. Records are grouped by user, day, movement type and source storage type (or summarized only at user-day level, depending on the selection).
  4. Active time = last confirmation time − first confirmation time; gaps longer than 30 minutes are deducted. Items per hour = item count ÷ active time.
  5. Average completion time = Σ (QDATU/QZEIT − BDATU/BZEIT) ÷ item count. Difference rate = items with a difference quantity ÷ item count. Rows below the target rate are flagged.

Performance notes

Read LTAP by warehouse number and confirmation date; large warehouses may need a secondary index on the confirmation date. Do the aggregation in the database with GROUP BY. Running the report as a weekly background job reduces online load.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Export to Excel
  • Runs as a background job Can be scheduled as a background job for weekly or monthly summaries.
  • Send the result by email

Authorization objects

  • L_LGNUMDisplay authorization by warehouse number and storage type
  • L_BWLVSAuthorization by WM movement type

Frequently asked questions

Can this report be used for employee performance appraisal?

The report gives operational data per user ID. If it is used for individual appraisal, the decision should be made with HR and employee representatives under the company's labour law and data protection rules; the report can also run as an anonymous team or shift summary.

Are items confirmed with mobile (RF) devices included?

Yes. Confirmations made with RF are also written to LTAP-QNAME, QDATU and QZEIT; the report does not depend on the device used.

How are jobs of different weight compared?

The split by source storage type and movement type separates pallet and piece picking. If needed, weighted productivity using the item weight (LTAP-BRGEW) or a distance factor can be added.

Related reports

WM Program Custom Mass upload

Mass Transfer Order Confirmation Upload Program

A custom program that confirms hundreds of transfer order items in one run from picking results that come from handheld scanners, warehouse automation …

LTAK · LTAP · LQUA · LAGP

WM Report Custom ALV report

Unconfirmed Transfer Orders Aging Report

A custom ALV report that lists transfer order items that were created but not confirmed across a warehouse number, by hours waiting, planned goods …

LTAK · LTAP · LIKP · T301

Let us build this report for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Warehouse Picker Productivity Report