Sales Quotation Conversion Rate and Open Quotations Report
Short answer: 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 quotations about to expire. Sales managers see the quotation conversion rate per sales group and customer, and the quotations that need follow-up, in one list.
- Estimated effort
- S · 3–4 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VA25 lists quotations with their validity dates, but it does not calculate how much of each quotation turned into orders by value, does not group lost items by rejection reason and does not flag quotations that expire in the coming days. The conversion rate is usually found by matching VA25 and VA05 lists in Excel.
Who uses it? Sales managers, sales representatives and inside sales teams that prepare quotations.
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 | Quotation header: sales area, sales group, customer and validity dates (driving table) | — | ECC + S/4 |
| VBAPSales Document Item | Quotation items, net value and reason for rejection; quotation reference on order items | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBFASales Document Flow | Document flow from quotation to order | VBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNR AND VBFA-VBTYP_N = 'C' | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| I_SalesQuotationItemSales Quotation Item | In S/4HANA it can be read for quotation items with a clean core approach | SalesQuotation = 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_VKGRP | Sales group | Range / multiple | VBAK-VKGRP | No | 110 |
| S_AUART | Quotation type | Range / multiple | VBAK-AUART | No | AG |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No | 200145 |
| S_AUDAT | Quotation date | Range / multiple | VBAK-AUDAT | Yes | 01.07.2026 – 17.11.2026 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_EXPDY | Flag quotations expiring within (days) | Single value | — | No | 14 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Quotation | VBAK-VBELN |
| 2 | Item | VBAP-POSNR |
| 3 | Sales group | VBAK-VKGRP |
| 4 | Customer | VBAK-KUNNR |
| 5 | Customer name | KNA1-NAME1 |
| 6 | Material | VBAP-MATNR |
| 7 | Valid to | VBAK-BNDDT |
| 8 | Quotation value | VBAP-NETWR |
| 9 | Currency | VBAK-WAERK |
| 10 | Converted value | Calculated Sum of VBAP-NETWR of order items that refer to the quotation item |
| 11 | Follow-on order | VBFA-VBELN |
| 12 | Reason for rejection | VBAP-ABGRU |
| 13 | Item status | Calculated Won / partly won / lost / open / expired |
| 14 | Days to expiry | Calculated VBAK-BNDDT − key date |
Sample output
| Quotation | Item | Sales group | Customer | Customer name | Material | Valid to | Quotation value | Currency | Converted value | Follow-on order | Reason for rejection | Item status | Days to expiry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0020004410 | 000010 | 110 | 200145 | Marmara Yapı Market | FG-1001 | 11/30/2026 | 125,000 | TRY | 125,000 | 0000123401 | Won | 13 | |
| 0020004410 | 000020 | 110 | 200145 | Marmara Yapı Market | FG-1005 | 11/30/2026 | 48,000 | TRY | 0 | 02 Price too high | Lost | 13 | |
| 0020004436 | 000010 | 120 | 200422 | Anadolu Elektrik Toptan | FG-3110 | 11/24/2026 | 86,500 | TRY | 0 | Open | 7 | ||
| 0020004398 | 000010 | 120 | 200510 | Ege Tarım Kooperatifi | FG-4020 | 10/31/2026 | 39,200 | TRY | 0 | Expired | -17 |
How does the report work?
- Quotations (VBAK-VBTYP = B) and their items (VBAP) are read with the sales area, sales group, customer and quotation date from the selection screen; validity starts at ANGDT and ends at BNDDT.
- Converted value: sum of VBAP-NETWR of order items that refer to the quotation item (VBAP-VGBEL / VGPOS = quotation item). The order number comes from VBFA (VBTYP_N = C).
- Items with a reason for rejection (VBAP-ABGRU) and no follow-on order count as lost.
- Item status: won, partly won, lost, open (BNDDT ≥ key date) or expired. “Days to expiry” = BNDDT − key date.
- Conversion rate = won value ÷ (won + lost + expired value) × 100, shown in subtotals per sales group and customer.
Performance notes
Select quotations by date range and sales organization. Read the order items once through VBFA with the list of quotation items; without a secondary index on VBAP-VGBEL, the VBFA path should be preferred.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a quotation or order number opens VA23 or VA03.
- Export to Excel
- Runs as a background job
- Send the result by email Quotations about to expire can be sent to the responsible sales group every Monday.
Authorization objects
- V_VBAK_VKOSales document display authorization by sales area
- V_VBAK_AATAuthorization by sales document type
Frequently asked questions
How is a partly converted quotation treated?
The converted value per item is compared with the quotation value. If it is lower, the item is marked "partly won" and enters the rate with the value that was actually converted.
Where do the reasons for lost quotations come from?
From the reason for rejection on the item (VBAP-ABGRU). To report on lost reasons, sales teams need to enter a reason for rejection when they close the quotation.
Does it work on S/4HANA?
Yes. The quotation and order tables are the same in S/4HANA; for clean core, I_SalesQuotationItem can be used.
Related reports
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 …
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 …
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.