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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| LTAKTransfer Order Header | Putaway transfer order: movement type, material document, creation time (driving table) | — | ECC + S/4 |
| LTAPTransfer Order Item | Destination storage type and bin, confirmation time and user | LTAP-LGNUM = LTAK-LGNUM AND LTAP-TANUM = LTAK-TANUM | ECC + S/4 |
| MKPFMaterial Document Header | Entry date and time of the goods receipt | MKPF-MBLNR = LTAK-MBLNR AND MKPF-MJAHR = LTAK-MJAHR | ECC only |
| MATDOCMaterial Documents (S/4HANA) | Goods receipt document and entry time in S/4HANA | MATDOC-MBLNR = LTAK-MBLNR AND MATDOC-MJAHR = LTAK-MJAHR | S/4HANA only |
| MAKTMaterial Descriptions | Material description in the logon language | MAKT-MATNR = LTAP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes | 100 |
| S_BWLVS | Putaway WM movement type | Range / multiple | LTAK-BWLVS | No | 101 |
| S_BDATU | Transfer order creation date | Range / multiple | LTAK-BDATU | Yes | 01.11.2026 – 16.11.2026 |
| S_NLTYP | Destination storage type | Range / multiple | LTAP-NLTYP | No | 001 |
| P_TARGET | Target dock-to-stock time (hours) | Single value | — | Yes | 8 |
| P_CAL | Remove non-working hours using the factory calendar | Checkbox | — | No | X |
| R_DETAIL | Item detail | Radio button | — | No | X |
| R_SUMM | Summary by storage type and day | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material document | LTAK-MBLNR |
| 2 | GR entry date | MKPF-CPUDT |
| 3 | GR entry time | MKPF-CPUTM |
| 4 | Transfer order | LTAK-TANUM |
| 5 | Created on | LTAK-BDATU |
| 6 | Created at | LTAK-BZEIT |
| 7 | Material | LTAP-MATNR |
| 8 | Description | MAKT-MAKTX |
| 9 | Dest. storage type | LTAP-NLTYP |
| 10 | Dest. bin | LTAP-NLPLA |
| 11 | Confirmed on | LTAP-QDATU |
| 12 | Confirmed at | LTAP-QZEIT |
| 13 | Waiting (h) | Calculated LTAK-BDATU/BZEIT − MKPF-CPUDT/CPUTM |
| 14 | Processing (h) | Calculated LTAP-QDATU/QZEIT − LTAK-BDATU/BZEIT |
| 15 | Dock-to-stock (h) | Calculated Waiting + processing; non-working hours excluded when P_CAL is selected |
| 16 | Target | Calculated Met when dock-to-stock ≤ P_TARGET, otherwise missed |
Sample output
| Material document | GR entry date | GR entry time | Transfer order | Created on | Created at | Material | Description | Dest. storage type | Dest. bin | Confirmed on | Confirmed at | Waiting (h) | Processing (h) | Dock-to-stock (h) | Target |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5000184420 | 11/12/2026 | 08:14 | 0000419002 | 11/12/2026 | 08:31 | RM-1001 | Carton box 40x30 | 001 | 01-05-02 | 11/12/2026 | 10:05 | 0.30 | 1.60 | 1.90 | Met |
| 5000184437 | 11/12/2026 | 15:40 | 0000419088 | 11/12/2026 | 18:52 | RM-2040 | Steel sheet 2 mm | 003 | 03-02-04 | 11/13/2026 | 07:20 | 3.20 | 12.50 | 15.70 | Missed |
| 5000184512 | 11/13/2026 | 10:02 | 0000419140 | 11/13/2026 | 10:09 | FG-5120 | Canned tomato 400 g | 001 | 01-09-01 | 11/13/2026 | 11:47 | 0.10 | 1.60 | 1.70 | Met |
How does the report work?
- 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).
- From LTAP, the destination storage type and bin, confirmation date and time (QDATU, QZEIT) and confirming user of confirmed items are read.
- The entry date and time of the goods receipt come from MKPF-CPUDT and CPUTM in ECC and from MATDOC in S/4HANA.
- 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.
- 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
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 …
Related reports
Automatic Putaway Transfer Order Creation Job for Goods Receipt Interim Storage
A custom background job that finds open transfer requirements waiting in goods receipt interim storage longer than a set time, converts them into …
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 …
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.