Picked but Not Goods-Issued Deliveries Report
Short answer: A custom ALV report that lists deliveries whose picking is complete but whose goods issue has not been posted, with the number of days they have been waiting since the planned goods issue date, their value, weight, route and ship-to. Shipping supervisors see every morning which shipments sit at the dock and cannot be billed.
- Estimated effort
- S · 2–3 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VL06O shows picking, confirmation and goods issue in separate worklists. VL06G lists deliveries due for goods issue, but it does not age deliveries whose picking finished days ago, and it does not total the waiting value and weight per shipping point and route. Shipments waiting at the dock are often noticed only at month end.
Who uses it? Shipping and warehouse supervisors, logistics planners and billing teams that track month-end closing.
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 |
|---|---|---|---|
| LIKPDelivery Header | Shipping point, delivery type, route, planned goods issue and picking date, weight (driving table) | — | ECC + S/4 |
| VBUKSales Document Header Status (ECC) | Picking status (KOSTK) and goods issue status (WBSTK) | VBUK-VBELN = LIKP-VBELN | ECC only |
| LIPSDelivery Item Data | Net value of the delivery items | LIPS-VBELN = LIKP-VBELN | ECC + S/4 |
| KNA1Customer Master (General Section) | Ship-to name | KNA1-KUNNR = LIKP-KUNNR | ECC + S/4 |
| I_OutboundDeliveryOutbound Delivery Document | In S/4HANA it can replace LIKP and the status fields with a clean core approach | OutboundDelivery = LIKP-VBELN | S/4HANA only |
S/4HANA notes
- VBUK → VBAK: VBUK is not used in S/4HANA. The status fields moved to the respective document header: VBAK for sales, LIKP for deliveries, VBRK for billing. It is one of the most common fixes when custom reports move from ECC.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VSTEL | Shipping point | Range / multiple | LIKP-VSTEL | Yes | 1000 |
| S_WADAT | Planned goods issue date | Range / multiple | LIKP-WADAT | No | 01.11.2026 – 17.11.2026 |
| S_ROUTE | Route | Range / multiple | LIKP-ROUTE | No | R00010 |
| S_KUNNR | Ship-to party | Range / multiple | LIKP-KUNNR | No | 200310 |
| S_LFART | Delivery type | Range / multiple | LIKP-LFART | No | LF |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_PARTL | Include partially picked deliveries | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Delivery | LIKP-VBELN |
| 2 | Delivery type | LIKP-LFART |
| 3 | Shipping point | LIKP-VSTEL |
| 4 | Ship-to | LIKP-KUNNR |
| 5 | Name | KNA1-NAME1 |
| 6 | Route | LIKP-ROUTE |
| 7 | Picking date | LIKP-KODAT |
| 8 | Planned goods issue | LIKP-WADAT |
| 9 | Picking status | VBUK-KOSTK |
| 10 | Goods issue status | VBUK-WBSTK |
| 11 | Days overdue | Calculated Key date − LIKP-WADAT |
| 12 | Net value | Calculated Sum of LIPS-NETWR over the delivery items |
| 13 | Weight | LIKP-BTGEW |
| 14 | Weight unit | LIKP-GEWEI |
Sample output
| Delivery | Delivery type | Shipping point | Ship-to | Name | Route | Picking date | Planned goods issue | Picking status | Goods issue status | Days overdue | Net value | Weight | Weight unit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0080045120 | LF | 1000 | 200310 | Kuzey Gıda Dağıtım | R00010 | 11/11/2026 | 11/12/2026 | C | A | 5 | 96,400 | 1,850 | KG |
| 0080045133 | LF | 1000 | 200145 | Marmara Yapı Market | R00020 | 11/14/2026 | 11/14/2026 | C | A | 3 | 41,250 | 620 | KG |
| 0080045141 | LF | 1000 | 200422 | Anadolu Elektrik Toptan | R00010 | 11/16/2026 | 11/17/2026 | C | A | 0 | 18,900 | 210 | KG |
| 0080045150 | LF | 2000 | 200510 | Ege Tarım Kooperatifi | R00030 | 11/15/2026 | 11/16/2026 | B | A | 1 | 27,300 | 940 | KG |
How does the report work?
- LIKP is read with the shipping point, planned goods issue date, route and delivery type from the selection screen.
- Deliveries with picking completed (VBUK-KOSTK = C; optionally partially picked B as well) and goods issue not completed (VBUK-WBSTK ≠ C) remain. In S/4HANA these status fields are in LIKP.
- The delivery value is the sum of LIPS-NETWR; the weight and its unit come from LIKP-BTGEW and LIKP-GEWEI.
- Days overdue = key date − LIKP-WADAT. Positive values are deliveries past their goods issue date.
- The ship-to name is added from KNA1. ALV shows subtotals per shipping point and route; the list is sorted by days overdue in descending order.
Performance notes
Narrow LIKP by shipping point and planned goods issue date. Read VBUK and LIPS in a single JOIN with the delivery list. The report is usually fast and can run in the background every morning.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the delivery number opens VL02N.
- Export to Excel
- Runs as a background job
- Send the result by email Each shipping point supervisor can receive their own list every morning.
Authorization objects
- V_LIKP_VSTDelivery display authorization by shipping point
Frequently asked questions
Does the report work with warehouse management (WM/EWM)?
Yes. Picking confirmed in WM or EWM is reflected in the picking status of the delivery, and the report reads that status.
Can goods issue be posted from the report?
The report only lists. For the selected deliveries you can switch to VL06G, or a separate background program can be built.
Does it work on S/4HANA?
Yes. In S/4HANA the picking and goods issue status are stored in LIKP, so VBUK is not read; the logic stays the same.
Packages that include this solution
Order-to-Cash Control Pack
A five-report pack that shows every point where a sales order gets stuck, with one sales organization selection: missing data, credit blocks, picked …
Related reports
Sales Order – Delivery – Invoice Status Report
A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …
On-Time In-Full (OTIF) Delivery Performance Report by Customer
A custom ALV report that compares every sales order item with the customer's requested delivery date and ordered quantity, and works out whether the …
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.