SD Report Custom development ALV report

Sales Order – Delivery – Invoice Status Report

Short answer: 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 not shipped, which deliveries have not been billed and how much of the order value has turned into invoices.

Estimated effort
M · 4–6 working days
System
ECC and S/4HANA
Tables
7
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

VA05 lists orders, VL06O deliveries and VF05 invoices separately. The document flow is visible only for one document at a time in VA03. Seeing the shipping and billing status of hundreds of orders in one list needs a custom report.

Who uses it? Sales operations, customer service, logistics and billing teams.

Closest standard alternatives

  • VA05 List of Sales Orders. Lists orders; does not show delivery and invoice numbers on the same line.
  • VL06O Outbound Delivery Monitor. Tracks deliveries by status; does not combine them with order value and invoice data.

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderOrder header, sales area and customer (driving table); in S/4HANA it also holds the overall status—ECC + S/4
VBAPSales Document ItemOrder item, material, quantity and net valueVBAP-VBELN = VBAK-VBELNECC + S/4
VBFASales Document FlowDocument flow from order to delivery and invoiceVBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNRECC + S/4
LIKPDelivery HeaderDelivery number and goods issue dateLIKP-VBELN = VBFA-VBELN (VBTYP_N = J)ECC + S/4
VBRKBilling Document HeaderInvoice number and billing dateVBRK-VBELN = VBFA-VBELN (VBTYP_N = M)ECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
VBUKSales Document Header Status (ECC)Overall order status in ECCVBUK-VBELN = VBAK-VBELNECC 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_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_VTWEGDistribution channelRange / multipleVBAK-VTWEGNo10
S_SPARTDivisionRange / multipleVBAK-SPARTNo00
S_AUARTSales document typeRange / multipleVBAK-AUARTNoOR
S_KUNNRSold-to partyRange / multipleVBAK-KUNNRNo200100
S_AUDATOrder date rangeRange / multipleVBAK-AUDATYes01.10.2026 – 31.10.2026
S_VBELNSales documentRange / multipleVBAK-VBELNNo12001
P_OPENIncomplete orders onlyCheckbox—NoX

Output columns

#ColumnSource
1Sales orderVBAK-VBELN
2ItemVBAP-POSNR
3Sold-toVBAK-KUNNR
4Customer nameKNA1-NAME1
5MaterialVBAP-MATNR
6Order qtyVBAP-KWMENG
7UnitVBAP-VRKME
8Net valueVBAP-NETWR
9CurrencyVBAK-WAERK
10DeliveryLIKP-VBELN
11Goods issue dateLIKP-WADAT_IST
12InvoiceVBRK-VBELN
13Billing dateVBRK-FKDAT
14Overall statusCalculated ECC: VBUK-GBSTK, S/4HANA: VBAK-GBSTK (A open, B partially processed, C completed)

Sample output

Sales orderItemSold-toCustomer nameMaterialOrder qtyUnitNet valueCurrencyDeliveryGoods issue dateInvoiceBilling dateOverall status
1200110200100Marmara GıdaFG-5001500PC155,000TRY8000450110/12/20269000780110/13/2026Completed
1200120200100Marmara GıdaFG-5002200PC48,000TRY8000450110/12/2026Partially processed
1204410200245Karadeniz MarketFG-5001120PC37,200TRYOpen
A view built with fictional sample data; not real system data.

How does the report work?

  1. VBAK and VBAP are read with the selection criteria; items with a reason for rejection (ABGRU) can be excluded.
  2. For each item, subsequent documents are read from VBFA: VBTYP_N = J are deliveries, VBTYP_N = M are invoices.
  3. Delivery data (actual goods issue date) comes from LIKP, invoice data (billing date) from VBRK.
  4. Overall status is read from VBUK-GBSTK in ECC and from VBAK-GBSTK in S/4HANA.
  5. When an item has several deliveries, each delivery is shown on its own line; the customer name is added from KNA1.

Performance notes

VBFA is a large table; read it by preceding document (VBELV + POSNV) with a VBTYP_N filter. Keep the order date range mandatory. In S/4HANA the VBFA key changed, so do not rely on read order; sort explicitly.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a document number opens VA03, VL03N or VF03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Unbilled deliveries can be sent to the billing team every morning.

Authorization objects

  • V_VBAK_VKOSales document authorization by sales area
  • V_VBAK_AATAuthorization by sales document type

Frequently asked questions

How are the order, delivery and invoice linked?

Through the VBFA document flow table. The preceding document is the order item (VBELV, POSNV) and the subsequent document is the delivery (VBTYP_N = J) or invoice (VBTYP_N = M).

What changes in this report on S/4HANA?

S/4HANA no longer uses VBUK and VBUP; the status fields moved to VBAK, VBAP, LIKP and VBRK. Reports that read VBUK in ECC must be adjusted at this point.

How are partial deliveries shown?

Each delivery of an order item is shown on its own line; a summarized one-line-per-item view can be added if needed.

Related reports

FI Report Custom ALV report

Vendor Open Items Aging Report

A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …

BSIK · LFA1 · LFB1 · T001

MM Report Custom ALV report

Open Purchase Orders by Vendor Report

A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …

EKKO · EKPO · EKET · LFA1

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: Sales Order – Delivery – Invoice Status Report