SD Report Custom development ALV report

Customers with Declining Order Intake vs Prior Year Report

Short answer: A custom ALV report that compares each customer's order value in the selected period with the same period of the previous year and shows the drop in percent, the last order date and the days without an order. Sales managers see customers that are slipping away without waiting for month end and plan their visits accordingly.

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

Why is the standard not enough?

VA05 lists the orders of a period, but it gives no per-customer comparison with the previous year, no drop percentage and no days since the last order. LIS analyses (information structures) are not updated in many systems or include rejected items. Teams download both periods separately and match them in Excel. The custom report calculates both periods from the documents in one run, leaves out rejected items and compares values in the statistics currency.

Who uses it? Sales managers, regional sales representatives and sales operations teams.

Closest standard alternatives

  • VA05 List of Sales Orders. Lists the orders of one period; no per-customer comparison with the previous year, no drop percentage and no days without an order.

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, order date, sales area, statistics currency (driving table)—ECC + S/4
VBAPSales Document ItemItem net value, statistics exchange rate and reason for rejectionVBAP-VBELN = VBAK-VBELNECC + S/4
TVAKSales Document TypesDocument category of the order type; quotations and contracts are excludedTVAK-AUART = VBAK-AUARTECC + S/4
KNA1Customer Master (General Section)Customer name and cityKNA1-KUNNR = VBAK-KUNNRECC + S/4
KNVVCustomer Master Sales DataSales office and sales group of the customerKNVV-KUNNR = VBAK-KUNNR AND KNVV-VKORG = VBAK-VKORG AND KNVV-VTWEG = VBAK-VTWEG AND KNVV-SPART = VBAK-SPARTECC + S/4
I_SalesOrderItemSales Order ItemIn S/4HANA it can replace VBAP with a clean core approachSalesOrder = VBAK-VBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_VTWEGDistribution channelRange / multipleVBAK-VTWEGNo10
S_VKBURSales officeRange / multipleVBAK-VKBURNo1100
S_KUNNRSold-to partyRange / multipleVBAK-KUNNRNo200100
S_AUDATCurrent period (order date)Range / multipleVBAK-AUDATYes01.01.2026 – 17.11.2026
P_DROPMinimum drop in percentSingle value—Yes15
P_MINPYMinimum prior-year order valueSingle value—No100000
P_REJExclude rejected itemsCheckbox—NoX

Output columns

#ColumnSource
1CustomerVBAK-KUNNR
2Customer nameKNA1-NAME1
3CityKNA1-ORT01
4Sales officeKNVV-VKBUR
5Sales groupKNVV-VKGRP
6Orders (period)Calculated Number of distinct VBAK-VBELN in the current period
7Order value (period)Calculated Σ VBAP-NETWR × VBAP-STCUR (current period)
8Order value (prior year)Calculated Σ VBAP-NETWR × VBAP-STCUR (same period one year earlier)
9DifferenceCalculated Period value − prior-year value
10Change %Calculated Difference ÷ prior-year value × 100
11Last order dateCalculated Latest VBAK-AUDAT
12Days without orderCalculated Today − last order date
13Statistics currencyVBAK-STWAE

Sample output

CustomerCustomer nameCitySales officeSales groupOrders (period)Order value (period)Order value (prior year)DifferenceChange %Last order dateDays without orderStatistics currency
200245Karadeniz Market ZinciriTrabzon1100110141,820,0002,650,000-830,000-31.3011/03/202614TRY
200388Toros Yapı MarketMersin12001206410,000980,000-570,000-58.2010/21/202627TRY
200512Anadolu Toptan GıdaKonya1100130223,150,0003,900,000-750,000-19.2011/14/20263TRY
200610Ege Kuruyemiş Dağıtımİzmir130014000720,000-720,000-10004/18/2026213TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. The current period is the date range on the selection screen (VBAK-AUDAT); the comparison period is the same days one year earlier (29 February moves to 28 February).
  2. VBAK and VBAP are read for both periods; the document category of the order type is checked through TVAK-VBTYP, and with “Exclude rejected items” selected, items with a reason for rejection (VBAP-ABGRU) are skipped.
  3. The item net value (VBAP-NETWR) is converted with the statistics exchange rate (VBAP-STCUR) into the statistics currency (VBAK-STWAE), so customers ordering in different currencies can be compared.
  4. Totals are built per sold-to party: number of distinct orders in the period, the value of both periods and the latest VBAK-AUDAT.
  5. Change % = (current − prior) ÷ prior × 100. Customers whose prior-year value is above the minimum and whose drop exceeds the threshold remain; customers with no order in the current period appear with −100%.
  6. Sales office and sales group are added from KNVV. The list is sorted by the difference in ascending order.

Performance notes

Read both periods in one SELECT narrowed by date range and sales organization and aggregate in the database (GROUP BY). On large systems, run the report as a background job on the night of the first day of the month.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a customer opens the orders of both periods in a VA05-like list.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Each sales office can receive its own customer list by email on the first day of the month.

Authorization objects

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

Frequently asked questions

Why is the order value used instead of the invoiced value?

Order intake shows the customer's behaviour weeks before billing does, so a drop is noticed early. A comparison of the invoiced value (VBRP-NETWR) can be added with the same logic; this raises the effort range slightly.

How are different currencies compared?

Each item is converted with the statistics exchange rate stored at order entry (VBAP-STCUR) into the statistics currency of the sales organization (VBAK-STWAE). No later exchange-rate effect is added, and both periods are totalled in the same currency.

Does the report work on S/4HANA?

Yes. VBAK, VBAP, TVAK, KNA1 and KNVV also exist in S/4HANA. Even though customer master data is maintained as a business partner (BP), the customer number in KNA1 stays the same. For clean core, I_SalesOrderItem can be used.

Related reports

SD Report Custom ALV report

Sales Order Gross Margin Report by Item

A custom ALV report that compares the net value of every sales order item with the cost determined in pricing and shows the gross profit and margin …

VBAK · VBAP · KNA1 · KONV

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: Customers with Declining Order Intake vs Prior Year Report