SD Report Custom development ALV report

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

  • V.15 Display Backorders. Shows backorders per material or customer; no unconfirmed value, days waiting or unrestricted stock in the same list.
  • VA05 List of Sales Orders. Lists orders and the confirmed quantity; does not calculate the unconfirmed difference or its age.

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderOrder header: customer, sales area, currency (driving table)—ECC + S/4
VBAPSales Document ItemItem: material, plant, net price, reason for rejectionVBAP-VBELN = VBAK-VBELNECC + S/4
VBEPSales Document: Schedule Line DataSchedule lines: requested date, ordered and confirmed quantityVBEP-VBELN = VBAP-VBELN AND VBEP-POSNR = VBAP-POSNRECC + S/4
VBUPSales Document: Item StatusItem delivery status in ECCVBUP-VBELN = VBAP-VBELN AND VBUP-POSNR = VBAP-POSNRECC only
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
MARDStorage Location Data for MaterialUnrestricted stock in the plantMARD-MATNR = VBAP-MATNR AND MARD-WERKS = VBAP-WERKSECC + S/4
I_SalesDocumentScheduleLineSales Document Schedule LineIn S/4HANA it can replace VBEP with a clean core approachSalesDocument = VBAK-VBELNS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_AUARTOrder typeRange / multipleVBAK-AUARTNoTA
S_KUNNRSold-to partyRange / multipleVBAK-KUNNRNo200100
S_WERKSPlantRange / multipleVBAP-WERKSNo1000
S_MATNRMaterialRange / multipleVBAP-MATNRNoFG-1001
S_EDATURequested delivery date rangeRange / multipleVBEP-EDATUNo01.10.2026 – 30.11.2026
P_KEYDTKey date for days waiting (default: today)Single valueSY-DATUMYes17.11.2026
P_NOCONFOnly items with no confirmation at allCheckbox—No—
P_STOCKShow unrestricted stockCheckbox—NoX

Output columns

#ColumnSource
1Sales orderVBAK-VBELN
2ItemVBAP-POSNR
3CustomerVBAK-KUNNR
4Customer nameKNA1-NAME1
5MaterialVBAP-MATNR
6DescriptionVBAP-ARKTX
7PlantVBAP-WERKS
8Requested delivery dateVBEP-EDATU
9Ordered qtyCalculated Σ VBEP-WMENG
10Confirmed qtyCalculated Σ VBEP-BMENG
11Unconfirmed qtyCalculated Ordered qty − confirmed qty
12UnitVBAP-VRKME
13Unconfirmed valueCalculated Unconfirmed qty × VBAP-NETPR ÷ VBAP-KPEIN
14CurrencyVBAK-WAERK
15Days waitingCalculated Key date − VBEP-EDATU
16Unrestricted stockCalculated Σ MARD-LABST in the plant

Sample output

Sales orderItemCustomerCustomer nameMaterialDescriptionPlantRequested delivery dateOrdered qtyConfirmed qtyUnconfirmed qtyUnitUnconfirmed valueCurrencyDays waitingUnrestricted stock
0000012450000010200100Marmara GıdaFG-1001Jam jar 380 g100010/28/20261,200700500CS21,250TRY20180
0000012488000020200245Karadeniz Market ZinciriFG-1120Tomato paste 830 g100011/05/20268000800CS49,600TRY120
0000012502000010200388Toros Yapı MarketFG-2050Plastic bucket 10 L200011/12/20263,0002,400600PC33,000TRY5350
0000012517000030200512Anadolu Toptan GıdaFG-1001Jam jar 380 g100011/14/20264000400CS17,000TRY3180
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-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).
  2. 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.
  3. The requested delivery date is VBEP-EDATU of the first schedule line. Days waiting = key date − that date.
  4. Unconfirmed value = unconfirmed quantity × VBAP-NETPR ÷ VBAP-KPEIN.
  5. 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.
  6. 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

SD Package Custom

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 …

3 components · v1.0

Related reports

SD Report Custom ALV report

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 …

VBUK · VBAK · VBAP · VBUP

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: Backorders and Unconfirmed Sales Order Items Report