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

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-16
- URL: https://nekuhub.com/en/reports/sales-order-delivery-invoice-status-report/


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

### Closest standard alternatives

- VA05: Lists orders; does not show delivery and invoice numbers on the same line.
- VL06O: Tracks deliveries by status; does not combine them with order value and invoice data.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBAK | Order header, sales area and customer (driving table); in S/4HANA it also holds the overall status | Read | - | ECC + S/4 |
| VBAP | Order item, material, quantity and net value | Read | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBFA | Document flow from order to delivery and invoice | Read | VBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNR | ECC + S/4 |
| LIKP | Delivery number and goods issue date | Read | LIKP-VBELN = VBFA-VBELN (VBTYP_N = J) | ECC + S/4 |
| VBRK | Invoice number and billing date | Read | VBRK-VBELN = VBFA-VBELN (VBTYP_N = M) | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| VBUK | Overall order status in ECC | Read | VBUK-VBELN = VBAK-VBELN | ECC only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes |
| S_VTWEG | Distribution channel | Range / multiple | VBAK-VTWEG | No |
| S_SPART | Division | Range / multiple | VBAK-SPART | No |
| S_AUART | Sales document type | Range / multiple | VBAK-AUART | No |
| S_KUNNR | Sold-to party | Range / multiple | VBAK-KUNNR | No |
| S_AUDAT | Order date range | Range / multiple | VBAK-AUDAT | Yes |
| S_VBELN | Sales document | Range / multiple | VBAK-VBELN | No |
| P_OPEN | Incomplete orders only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Sales order | VBAK-VBELN |
| Item | VBAP-POSNR |
| Sold-to | VBAK-KUNNR |
| Customer name | KNA1-NAME1 |
| Material | VBAP-MATNR |
| Order qty | VBAP-KWMENG |
| Unit | VBAP-VRKME |
| Net value | VBAP-NETWR |
| Currency | VBAK-WAERK |
| Delivery | LIKP-VBELN |
| Goods issue date | LIKP-WADAT_IST |
| Invoice | VBRK-VBELN |
| Billing date | VBRK-FKDAT |
| Overall status | Calculated: ECC: VBUK-GBSTK, S/4HANA: VBAK-GBSTK (A open, B partially processed, C completed) |

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

## Authorization objects

- V_VBAK_VKO: Sales document authorization by sales area
- V_VBAK_AAT: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-order-delivery-invoice-status
