Backorders and Unconfirmed Sales Order Items Report
Short answer: A custom ALV report that shows, for open sales orders, how much of the requested quantity is not confirmed, the value of that quantity, how many days the customer has been waiting and whether unrestricted stock exists in the plant, all in one list. Sales and planning teams see at once which customer is waiting on which item and whether a rescheduling run would help.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
V.15 shows backorders per material or customer, but it does not show the value of the unconfirmed quantity, the days the customer has been waiting and the unrestricted stock in the plant on the same line. VA05 lists the confirmed quantity but calculates neither the difference nor its age. Teams rebuild this table in Excel every week. The custom report derives the unconfirmed quantity from the schedule lines, converts it to value and flags items that remain unconfirmed although stock exists.
Who uses it? Customer service, sales operations, demand and supply planners.
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 |
|---|---|---|---|
| VBAKSales Document Header | Order header: customer, sales area, currency (driving table) | — | ECC + S/4 |
| VBAPSales Document Item | Item: material, plant, net price, reason for rejection | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBEPSales Document: Schedule Line Data | Schedule lines: requested date, ordered and confirmed quantity | VBEP-VBELN = VBAP-VBELN AND VBEP-POSNR = VBAP-POSNR | ECC + S/4 |
| VBUPSales Document: Item Status | Item delivery status in ECC | VBUP-VBELN = VBAP-VBELN AND VBUP-POSNR = VBAP-POSNR | ECC only |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| MARDStorage Location Data for Material | Unrestricted stock in the plant | MARD-MATNR = VBAP-MATNR AND MARD-WERKS = VBAP-WERKS | ECC + S/4 |
| I_SalesDocumentScheduleLineSales Document Schedule Line | In S/4HANA it can replace VBEP with a clean core approach | SalesDocument = VBAK-VBELN | S/4HANA only |
S/4HANA notes
- VBUP → VBAP: VBUP was removed in S/4HANA; the item status fields moved directly into VBAP (sales), LIPS (delivery) and VBRP (billing).
- MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes | 1000 |
| S_AUART | Order type | Range / multiple | VBAK-AUART | No | TA |
| S_KUNNR | Sold-to party | Range / multiple | VBAK-KUNNR | No | 200100 |
| S_WERKS | Plant | Range / multiple | VBAP-WERKS | No | 1000 |
| S_MATNR | Material | Range / multiple | VBAP-MATNR | No | FG-1001 |
| S_EDATU | Requested delivery date range | Range / multiple | VBEP-EDATU | No | 01.10.2026 – 30.11.2026 |
| P_KEYDT | Key date for days waiting (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_NOCONF | Only items with no confirmation at all | Checkbox | — | No | — |
| P_STOCK | Show unrestricted stock | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Sales order | VBAK-VBELN |
| 2 | Item | VBAP-POSNR |
| 3 | Customer | VBAK-KUNNR |
| 4 | Customer name | KNA1-NAME1 |
| 5 | Material | VBAP-MATNR |
| 6 | Description | VBAP-ARKTX |
| 7 | Plant | VBAP-WERKS |
| 8 | Requested delivery date | VBEP-EDATU |
| 9 | Ordered qty | Calculated Σ VBEP-WMENG |
| 10 | Confirmed qty | Calculated Σ VBEP-BMENG |
| 11 | Unconfirmed qty | Calculated Ordered qty − confirmed qty |
| 12 | Unit | VBAP-VRKME |
| 13 | Unconfirmed value | Calculated Unconfirmed qty × VBAP-NETPR ÷ VBAP-KPEIN |
| 14 | Currency | VBAK-WAERK |
| 15 | Days waiting | Calculated Key date − VBEP-EDATU |
| 16 | Unrestricted stock | Calculated Σ MARD-LABST in the plant |
Sample output
| Sales order | Item | Customer | Customer name | Material | Description | Plant | Requested delivery date | Ordered qty | Confirmed qty | Unconfirmed qty | Unit | Unconfirmed value | Currency | Days waiting | Unrestricted stock |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0000012450 | 000010 | 200100 | Marmara Gıda | FG-1001 | Jam jar 380 g | 1000 | 10/28/2026 | 1,200 | 700 | 500 | CS | 21,250 | TRY | 20 | 180 |
| 0000012488 | 000020 | 200245 | Karadeniz Market Zinciri | FG-1120 | Tomato paste 830 g | 1000 | 11/05/2026 | 800 | 0 | 800 | CS | 49,600 | TRY | 12 | 0 |
| 0000012502 | 000010 | 200388 | Toros Yapı Market | FG-2050 | Plastic bucket 10 L | 2000 | 11/12/2026 | 3,000 | 2,400 | 600 | PC | 33,000 | TRY | 5 | 350 |
| 0000012517 | 000030 | 200512 | Anadolu Toptan Gıda | FG-1001 | Jam jar 380 g | 1000 | 11/14/2026 | 400 | 0 | 400 | CS | 17,000 | TRY | 3 | 180 |
How does the report work?
- VBAK and VBAP are read with the selection-screen criteria; only order-category documents (VBAK-VBTYP = C), items without a reason for rejection (VBAP-ABGRU) and items not fully delivered are kept (VBUP-LFSTA ≠ C in ECC, VBAP-LFSTA in S/4HANA).
- The VBEP schedule lines of each item are summed: ordered quantity = Σ VBEP-WMENG, confirmed = Σ VBEP-BMENG. Unconfirmed quantity = the difference; items where it is zero are skipped.
- The requested delivery date is VBEP-EDATU of the first schedule line. Days waiting = key date − that date.
- Unconfirmed value = unconfirmed quantity × VBAP-NETPR ÷ VBAP-KPEIN.
- With “Show unrestricted stock” selected, the sum of MARD-LABST for the material in the plant is added. Items that are unconfirmed although stock exists are highlighted; they usually need a rescheduling run (V_V2) or a change to the availability check setup.
- The result is sorted by days waiting, with subtotals per material and customer.
Performance notes
Narrow the VBAK selection by sales organization and order date. Read VBEP aggregated in a single JOIN; read MARD only for the materials and plants in the list with FOR ALL ENTRIES.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the order opens VA03; clicking the material opens the stock overview (MMBE).
- Export to Excel
- Runs as a background job
- Send the result by email Items waiting longer than 10 days can be emailed to customer service every morning.
Authorization objects
- V_VBAK_VKOSales document display authorization by sales area
- V_VBAK_AATAuthorization by sales document type
Frequently asked questions
How is the unconfirmed quantity calculated?
The sum of the requested quantity (VBEP-WMENG) over all schedule lines of the item minus the sum of the confirmed quantity (VBEP-BMENG). Rejected and fully delivered items are not included.
Why would an item be unconfirmed while stock exists?
If the stock arrived after the order was entered and no rescheduling run (V_V2) took place, or the stock is reserved for other orders, the item stays unconfirmed. The report flags these items; running it again after rescheduling shows the effect.
Does the report work on S/4HANA?
Yes. VBUP does not exist in S/4HANA; the delivery status is read from VBAP-LFSTA. For a clean core approach, I_SalesDocumentScheduleLine can replace VBEP.
Packages that include this solution
Order Fulfilment and Backorder Pack
A three-component pack that tracks every day whether customer orders are delivered on time and in full: unconfirmed and backordered order items, a …
Related reports
Credit-Blocked Sales Orders by Value and Age Report
A custom ALV report that groups credit-blocked sales orders per credit account and shows the blocked order value, the age of the oldest block, the …
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 …
Overnight Outbound Delivery Creation Job for Due Sales Orders with Exception List
A custom background program that creates outbound deliveries every night for confirmed sales order items whose material availability date has come, …
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.