SD Report Custom development ALV report

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

  • VL06O Outbound Delivery Monitor. Shows picking and goods issue in separate worklists; does not total waiting time and value.
  • VL06G List of Outbound Deliveries for Goods Issue. Lists deliveries due for goods issue; does not age deliveries whose picking is complete.

Tables used

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

TableRoleJoinSystem
LIKPDelivery HeaderShipping 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-VBELNECC only
LIPSDelivery Item DataNet value of the delivery itemsLIPS-VBELN = LIKP-VBELNECC + S/4
KNA1Customer Master (General Section)Ship-to nameKNA1-KUNNR = LIKP-KUNNRECC + S/4
I_OutboundDeliveryOutbound Delivery DocumentIn S/4HANA it can replace LIKP and the status fields with a clean core approachOutboundDelivery = LIKP-VBELNS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_VSTELShipping pointRange / multipleLIKP-VSTELYes1000
S_WADATPlanned goods issue dateRange / multipleLIKP-WADATNo01.11.2026 – 17.11.2026
S_ROUTERouteRange / multipleLIKP-ROUTENoR00010
S_KUNNRShip-to partyRange / multipleLIKP-KUNNRNo200310
S_LFARTDelivery typeRange / multipleLIKP-LFARTNoLF
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_PARTLInclude partially picked deliveriesCheckbox—No—

Output columns

#ColumnSource
1DeliveryLIKP-VBELN
2Delivery typeLIKP-LFART
3Shipping pointLIKP-VSTEL
4Ship-toLIKP-KUNNR
5NameKNA1-NAME1
6RouteLIKP-ROUTE
7Picking dateLIKP-KODAT
8Planned goods issueLIKP-WADAT
9Picking statusVBUK-KOSTK
10Goods issue statusVBUK-WBSTK
11Days overdueCalculated Key date − LIKP-WADAT
12Net valueCalculated Sum of LIPS-NETWR over the delivery items
13WeightLIKP-BTGEW
14Weight unitLIKP-GEWEI

Sample output

DeliveryDelivery typeShipping pointShip-toNameRoutePicking datePlanned goods issuePicking statusGoods issue statusDays overdueNet valueWeightWeight unit
0080045120LF1000200310Kuzey Gıda DağıtımR0001011/11/202611/12/2026CA596,4001,850KG
0080045133LF1000200145Marmara Yapı MarketR0002011/14/202611/14/2026CA341,250620KG
0080045141LF1000200422Anadolu Elektrik ToptanR0001011/16/202611/17/2026CA018,900210KG
0080045150LF2000200510Ege Tarım KooperatifiR0003011/15/202611/16/2026BA127,300940KG
A view built with fictional sample data; not real system data.

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.

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

SD Package Custom

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 …

5 components · v1.0

Related reports

SD Report Custom ALV report

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 …

VBAK · VBAP · VBFA · LIKP

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: Picked but Not Goods-Issued Deliveries Report