WM Report Custom development ALV report

Dock-to-Stock Putaway Lead Time Report

Short answer: A KPI report that calculates, for each goods receipt, the hours from posting the material document to creating and confirming the putaway transfer order, and flags putaways above the target time. Average dock-to-stock time and target hit rate are shown by storage type, day and shift.

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

Why is the standard not enough?

LT22 and LT23 list transfer orders with creation and confirmation dates but do not link them to the posting time of the goods receipt document or calculate durations. LX44 counts inward and outward movements and does not measure putaway delay. Dock-to-stock time is usually calculated by matching two lists in Excel.

Who uses it? Warehouse managers, logistics performance teams, goods receipt supervisors and supply chain managers.

Closest standard alternatives

  • LT22 Transfer Orders by Storage Type. Lists transfer orders by storage type with creation and confirmation dates; does not calculate durations from the goods receipt time.
  • LX44 Inward and Outward Movements. Counts inward and outward movements; does not measure putaway delay.

Tables used

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

TableRoleJoinSystem
LTAKTransfer Order HeaderPutaway transfer order: movement type, material document, creation time (driving table)—ECC + S/4
LTAPTransfer Order ItemDestination storage type and bin, confirmation time and userLTAP-LGNUM = LTAK-LGNUM AND LTAP-TANUM = LTAK-TANUMECC + S/4
MKPFMaterial Document HeaderEntry date and time of the goods receiptMKPF-MBLNR = LTAK-MBLNR AND MKPF-MJAHR = LTAK-MJAHRECC only
MATDOCMaterial Documents (S/4HANA)Goods receipt document and entry time in S/4HANAMATDOC-MBLNR = LTAK-MBLNR AND MATDOC-MJAHR = LTAK-MJAHRS/4HANA only
MAKTMaterial DescriptionsMaterial description in the logon languageMAKT-MATNR = LTAP-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

S/4HANA notes

  • MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleLTAK-LGNUMYes100
S_BWLVSPutaway WM movement typeRange / multipleLTAK-BWLVSNo101
S_BDATUTransfer order creation dateRange / multipleLTAK-BDATUYes01.11.2026 – 16.11.2026
S_NLTYPDestination storage typeRange / multipleLTAP-NLTYPNo001
P_TARGETTarget dock-to-stock time (hours)Single value—Yes8
P_CALRemove non-working hours using the factory calendarCheckbox—NoX
R_DETAILItem detailRadio button—NoX
R_SUMMSummary by storage type and dayRadio button—No—

Output columns

#ColumnSource
1Material documentLTAK-MBLNR
2GR entry dateMKPF-CPUDT
3GR entry timeMKPF-CPUTM
4Transfer orderLTAK-TANUM
5Created onLTAK-BDATU
6Created atLTAK-BZEIT
7MaterialLTAP-MATNR
8DescriptionMAKT-MAKTX
9Dest. storage typeLTAP-NLTYP
10Dest. binLTAP-NLPLA
11Confirmed onLTAP-QDATU
12Confirmed atLTAP-QZEIT
13Waiting (h)Calculated LTAK-BDATU/BZEIT − MKPF-CPUDT/CPUTM
14Processing (h)Calculated LTAP-QDATU/QZEIT − LTAK-BDATU/BZEIT
15Dock-to-stock (h)Calculated Waiting + processing; non-working hours excluded when P_CAL is selected
16TargetCalculated Met when dock-to-stock ≤ P_TARGET, otherwise missed

Sample output

Material documentGR entry dateGR entry timeTransfer orderCreated onCreated atMaterialDescriptionDest. storage typeDest. binConfirmed onConfirmed atWaiting (h)Processing (h)Dock-to-stock (h)Target
500018442011/12/202608:14000041900211/12/202608:31RM-1001Carton box 40x3000101-05-0211/12/202610:050.301.601.90Met
500018443711/12/202615:40000041908811/12/202618:52RM-2040Steel sheet 2 mm00303-02-0411/13/202607:203.2012.5015.70Missed
500018451211/13/202610:02000041914011/13/202610:09FG-5120Canned tomato 400 g00101-09-0111/13/202611:470.101.601.70Met
A view built with fictional sample data; not real system data.

How does the report work?

  1. Transfer orders linked to a material document (MBLNR, MJAHR) are read from LTAK for the selected warehouse number and putaway movement types (e.g. 101), with creation date and time (BDATU, BZEIT).
  2. From LTAP, the destination storage type and bin, confirmation date and time (QDATU, QZEIT) and confirming user of confirmed items are read.
  3. The entry date and time of the goods receipt come from MKPF-CPUDT and CPUTM in ECC and from MATDOC in S/4HANA.
  4. Waiting time (goods receipt → transfer order), processing time (creation → confirmation) and total dock-to-stock time are calculated in hours; optionally weekend hours are removed using the factory calendar.
  5. The total is compared with the target hours; the summary view gives average, median and target hit rate by storage type, day and shift.

Performance notes

Restrict LTAK by warehouse number, movement type and creation date; read MKPF only for the document numbers found, with FOR ALL ENTRIES. On S/4HANA, restrict the MATDOC read by document key and keep the duration calculation in ABAP.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants Separate variants can be saved for item detail and summary views.
  • Double-click drill-down to the document Double-clicking the material document opens MIGO; double-clicking the transfer order opens LT21.
  • Export to Excel
  • Runs as a background job Can be scheduled as a weekly KPI summary.
  • Send the result by email The summary can be emailed weekly to logistics management.

Authorization objects

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

Frequently asked questions

Why does dock-to-stock time matter?

Stock that has been received but is not on the shelf may not be available for sales and production, or is searched for in the wrong place. The time is one of the key indicators of warehouse efficiency and stock availability.

How is it calculated with two-step putaway?

When several transfer orders follow the goods receipt (e.g. staging area → shelf), the time of the last confirmed transfer order is taken as the end. The intermediate steps can be listed as separate lines in the detail view.

Where does the shift come from?

The shift is derived from the goods receipt time using hour ranges defined on the selection screen. Warehouses with different shift patterns save their own ranges as a variant.

Packages that include this solution

WM Package Custom

Warehouse Storage Discipline and Slotting Pack

A four-component pack that shows whether stock in the warehouse is stored in the right place and moved in the right order: FIFO and FEFO picking …

4 components · v1.0

Related reports

WM Report Custom ALV report

Interim Storage Stuck and Negative Stock Report

A custom ALV report that lists quants in goods receipt, shipping, posting change and difference interim storage types that have been waiting longer …

LQUA · LTBP · LTBK · LTAP

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: Dock-to-Stock Putaway Lead Time Report