# 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 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.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: S (3–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/sales-quotation-conversion-rate-report/


## 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.

### Closest standard alternatives

- VA25: Lists quotations with validity dates; does not calculate the converted value or the conversion rate.
- VA05: Lists orders; does not compare the order with the value of the quotation it came from.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBAK | Quotation header: sales area, sales group, customer and validity dates (driving table) | Read | - | ECC + S/4 |
| VBAP | Quotation items, net value and reason for rejection; quotation reference on order items | Read | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBFA | Document flow from quotation to order | Read | VBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNR AND VBFA-VBTYP_N = 'C' | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| I_SalesQuotationItem | In S/4HANA it can be read for quotation items with a clean core approach | Read | SalesQuotation = VBAK-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes |
| S_VKGRP | Sales group | Range / multiple | VBAK-VKGRP | No |
| S_AUART | Quotation type | Range / multiple | VBAK-AUART | No |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No |
| S_AUDAT | Quotation date | Range / multiple | VBAK-AUDAT | Yes |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes |
| P_EXPDY | Flag quotations expiring within (days) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Quotation | VBAK-VBELN |
| Item | VBAP-POSNR |
| Sales group | VBAK-VKGRP |
| Customer | VBAK-KUNNR |
| Customer name | KNA1-NAME1 |
| Material | VBAP-MATNR |
| Valid to | VBAK-BNDDT |
| Quotation value | VBAP-NETWR |
| Currency | VBAK-WAERK |
| Converted value | Calculated: Sum of VBAP-NETWR of order items that refer to the quotation item |
| Follow-on order | VBFA-VBELN |
| Reason for rejection | VBAP-ABGRU |
| Item status | Calculated: Won / partly won / lost / open / expired |
| Days to expiry | Calculated: VBAK-BNDDT − key date |

## How does the report work?

1. 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.
2. 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).
3. Items with a reason for rejection (VBAP-ABGRU) and no follow-on order count as lost.
4. Item status: won, partly won, lost, open (BNDDT ≥ key date) or expired. "Days to expiry" = BNDDT − key date.
5. Conversion rate = won value ÷ (won + lost + expired value) × 100, shown in subtotals per sales group and customer.

## Authorization objects

- V_VBAK_VKO: Sales document display authorization by sales area
- V_VBAK_AAT: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-quotation-conversion-rate
