# Dock-to-Stock Putaway Lead Time Report

> 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.

- Type: Report, Custom development, ALV report
- Module: WM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/dock-to-stock-putaway-lead-time-report/


## 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.

### Closest standard alternatives

- LT22: Lists transfer orders by storage type with creation and confirmation dates; does not calculate durations from the goods receipt time.
- LX44: Counts inward and outward movements; does not measure putaway delay.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LTAK | Putaway transfer order: movement type, material document, creation time (driving table) | Read | - | ECC + S/4 |
| LTAP | Destination storage type and bin, confirmation time and user | Read | LTAP-LGNUM = LTAK-LGNUM AND LTAP-TANUM = LTAK-TANUM | ECC + S/4 |
| MKPF | Entry date and time of the goods receipt | Read | MKPF-MBLNR = LTAK-MBLNR AND MKPF-MJAHR = LTAK-MJAHR | ECC only |
| MATDOC | Goods receipt document and entry time in S/4HANA | Read | MATDOC-MBLNR = LTAK-MBLNR AND MATDOC-MJAHR = LTAK-MJAHR | S/4HANA only |
| MAKT | Material description in the logon language | Read | MAKT-MATNR = LTAP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | LTAK-LGNUM | Yes |
| S_BWLVS | Putaway WM movement type | Range / multiple | LTAK-BWLVS | No |
| S_BDATU | Transfer order creation date | Range / multiple | LTAK-BDATU | Yes |
| S_NLTYP | Destination storage type | Range / multiple | LTAP-NLTYP | No |
| P_TARGET | Target dock-to-stock time (hours) | Single value | - | Yes |
| P_CAL | Remove non-working hours using the factory calendar | Checkbox | - | No |
| R_DETAIL | Item detail | Radio button | - | No |
| R_SUMM | Summary by storage type and day | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Material document | LTAK-MBLNR |
| GR entry date | MKPF-CPUDT |
| GR entry time | MKPF-CPUTM |
| Transfer order | LTAK-TANUM |
| Created on | LTAK-BDATU |
| Created at | LTAK-BZEIT |
| Material | LTAP-MATNR |
| Description | MAKT-MAKTX |
| Dest. storage type | LTAP-NLTYP |
| Dest. bin | LTAP-NLPLA |
| Confirmed on | LTAP-QDATU |
| Confirmed at | LTAP-QZEIT |
| Waiting (h) | Calculated: LTAK-BDATU/BZEIT − MKPF-CPUDT/CPUTM |
| Processing (h) | Calculated: LTAP-QDATU/QZEIT − LTAK-BDATU/BZEIT |
| Dock-to-stock (h) | Calculated: Waiting + processing; non-working hours excluded when P_CAL is selected |
| Target | Calculated: Met when dock-to-stock ≤ P_TARGET, otherwise missed |

## 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.

## Authorization objects

- L_LGNUM: Display authorization by warehouse number and storage type
- L_BWLVS: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=wm-dock-to-stock-putaway-lead-time
