# Picked but Not Goods-Issued Deliveries Report

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

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: S (2–3 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/picked-not-goods-issued-deliveries-report/


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

### Closest standard alternatives

- VL06O: Shows picking and goods issue in separate worklists; does not total waiting time and value.
- VL06G: Lists deliveries due for goods issue; does not age deliveries whose picking is complete.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| LIKP | Shipping point, delivery type, route, planned goods issue and picking date, weight (driving table) | Read | - | ECC + S/4 |
| VBUK | Picking status (KOSTK) and goods issue status (WBSTK) | Read | VBUK-VBELN = LIKP-VBELN | ECC only |
| LIPS | Net value of the delivery items | Read | LIPS-VBELN = LIKP-VBELN | ECC + S/4 |
| KNA1 | Ship-to name | Read | KNA1-KUNNR = LIKP-KUNNR | ECC + S/4 |
| I_OutboundDelivery | In S/4HANA it can replace LIKP and the status fields with a clean core approach | Read | OutboundDelivery = LIKP-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VSTEL | Shipping point | Range / multiple | LIKP-VSTEL | Yes |
| S_WADAT | Planned goods issue date | Range / multiple | LIKP-WADAT | No |
| S_ROUTE | Route | Range / multiple | LIKP-ROUTE | No |
| S_KUNNR | Ship-to party | Range / multiple | LIKP-KUNNR | No |
| S_LFART | Delivery type | Range / multiple | LIKP-LFART | No |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes |
| P_PARTL | Include partially picked deliveries | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Delivery | LIKP-VBELN |
| Delivery type | LIKP-LFART |
| Shipping point | LIKP-VSTEL |
| Ship-to | LIKP-KUNNR |
| Name | KNA1-NAME1 |
| Route | LIKP-ROUTE |
| Picking date | LIKP-KODAT |
| Planned goods issue | LIKP-WADAT |
| Picking status | VBUK-KOSTK |
| Goods issue status | VBUK-WBSTK |
| Days overdue | Calculated: Key date − LIKP-WADAT |
| Net value | Calculated: Sum of LIPS-NETWR over the delivery items |
| Weight | LIKP-BTGEW |
| Weight unit | LIKP-GEWEI |

## How does the report work?

1. LIKP is read with the shipping point, planned goods issue date, route and delivery type from the selection screen.
2. 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.
3. The delivery value is the sum of LIPS-NETWR; the weight and its unit come from LIKP-BTGEW and LIKP-GEWEI.
4. Days overdue = key date − LIKP-WADAT. Positive values are deliveries past their goods issue date.
5. 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.

## Authorization objects

- V_LIKP_VST: Delivery 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-picked-not-goods-issued
