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.
| Table | Role | Join | System |
|---|---|---|---|
| VBAKSales Document Header | Order header: customer, order date, sales area, statistics currency (driving table) | — | ECC + S/4 |
| VBAPSales Document Item | Item net value, statistics exchange rate and reason for rejection | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| TVAKSales Document Types | Document category of the order type; quotations and contracts are excluded | TVAK-AUART = VBAK-AUART | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name and city | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| KNVVCustomer Master Sales Data | Sales office and sales group of the customer | KNVV-KUNNR = VBAK-KUNNR AND KNVV-VKORG = VBAK-VKORG AND KNVV-VTWEG = VBAK-VTWEG AND KNVV-SPART = VBAK-SPART | ECC + S/4 |
| I_SalesOrderItemSales Order Item | In S/4HANA it can replace VBAP with a clean core approach | SalesOrder = VBAK-VBELN | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes | 1000 |
| S_VTWEG | Distribution channel | Range / multiple | VBAK-VTWEG | No | 10 |
| S_VKBUR | Sales office | Range / multiple | VBAK-VKBUR | No | 1100 |
| S_KUNNR | Sold-to party | Range / multiple | VBAK-KUNNR | No | 200100 |
| S_AUDAT | Current period (order date) | Range / multiple | VBAK-AUDAT | Yes | 01.01.2026 – 17.11.2026 |
| P_DROP | Minimum drop in percent | Single value | — | Yes | 15 |
| P_MINPY | Minimum prior-year order value | Single value | — | No | 100000 |
| P_REJ | Exclude rejected items | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Customer | VBAK-KUNNR |
| 2 | Customer name | KNA1-NAME1 |
| 3 | City | KNA1-ORT01 |
| 4 | Sales office | KNVV-VKBUR |
| 5 | Sales group | KNVV-VKGRP |
| 6 | Orders (period) | Calculated Number of distinct VBAK-VBELN in the current period |
| 7 | Order value (period) | Calculated Σ VBAP-NETWR × VBAP-STCUR (current period) |
| 8 | Order value (prior year) | Calculated Σ VBAP-NETWR × VBAP-STCUR (same period one year earlier) |
| 9 | Difference | Calculated Period value − prior-year value |
| 10 | Change % | Calculated Difference ÷ prior-year value × 100 |
| 11 | Last order date | Calculated Latest VBAK-AUDAT |
| 12 | Days without order | Calculated Today − last order date |
| 13 | Statistics currency | VBAK-STWAE |
Sample output
| Customer | Customer name | City | Sales office | Sales group | Orders (period) | Order value (period) | Order value (prior year) | Difference | Change % | Last order date | Days without order | Statistics currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 200245 | Karadeniz Market Zinciri | Trabzon | 1100 | 110 | 14 | 1,820,000 | 2,650,000 | -830,000 | -31.30 | 11/03/2026 | 14 | TRY |
| 200388 | Toros Yapı Market | Mersin | 1200 | 120 | 6 | 410,000 | 980,000 | -570,000 | -58.20 | 10/21/2026 | 27 | TRY |
| 200512 | Anadolu Toptan Gıda | Konya | 1100 | 130 | 22 | 3,150,000 | 3,900,000 | -750,000 | -19.20 | 11/14/2026 | 3 | TRY |
| 200610 | Ege Kuruyemiş Dağıtım | İzmir | 1300 | 140 | 0 | 0 | 720,000 | -720,000 | -100 | 04/18/2026 | 213 | TRY |
How does the report work?
- 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).
- 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.
- 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.
- Totals are built per sold-to party: number of distinct orders in the period, the value of both periods and the latest VBAK-AUDAT.
- 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%.
- 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
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 …
Sales Quotation Conversion Rate and Open Quotations Report
A custom ALV report that lists sales quotations per item with the value converted into orders, the value lost with a rejection reason and the …
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 …
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.