SD Report Custom development ALV report

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

  • VA25 Quotations List. Lists quotations with validity dates; does not calculate the converted value or the conversion rate.
  • VA05 List of Sales Orders. Lists orders; does not compare the order with the value of the quotation it came from.

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderQuotation header: sales area, sales group, customer and validity dates (driving table)—ECC + S/4
VBAPSales Document ItemQuotation items, net value and reason for rejection; quotation reference on order itemsVBAP-VBELN = VBAK-VBELNECC + S/4
VBFASales Document FlowDocument flow from quotation to orderVBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNR AND VBFA-VBTYP_N = 'C'ECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
I_SalesQuotationItemSales Quotation ItemIn S/4HANA it can be read for quotation items with a clean core approachSalesQuotation = VBAK-VBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_VKGRPSales groupRange / multipleVBAK-VKGRPNo110
S_AUARTQuotation typeRange / multipleVBAK-AUARTNoAG
S_KUNNRCustomerRange / multipleVBAK-KUNNRNo200145
S_AUDATQuotation dateRange / multipleVBAK-AUDATYes01.07.2026 – 17.11.2026
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_EXPDYFlag quotations expiring within (days)Single value—No14

Output columns

#ColumnSource
1QuotationVBAK-VBELN
2ItemVBAP-POSNR
3Sales groupVBAK-VKGRP
4CustomerVBAK-KUNNR
5Customer nameKNA1-NAME1
6MaterialVBAP-MATNR
7Valid toVBAK-BNDDT
8Quotation valueVBAP-NETWR
9CurrencyVBAK-WAERK
10Converted valueCalculated Sum of VBAP-NETWR of order items that refer to the quotation item
11Follow-on orderVBFA-VBELN
12Reason for rejectionVBAP-ABGRU
13Item statusCalculated Won / partly won / lost / open / expired
14Days to expiryCalculated VBAK-BNDDT − key date

Sample output

QuotationItemSales groupCustomerCustomer nameMaterialValid toQuotation valueCurrencyConverted valueFollow-on orderReason for rejectionItem statusDays to expiry
0020004410000010110200145Marmara Yapı MarketFG-100111/30/2026125,000TRY125,0000000123401Won13
0020004410000020110200145Marmara Yapı MarketFG-100511/30/202648,000TRY002 Price too highLost13
0020004436000010120200422Anadolu Elektrik ToptanFG-311011/24/202686,500TRY0Open7
0020004398000010120200510Ege Tarım KooperatifiFG-402010/31/202639,200TRY0Expired-17
A view built with fictional sample data; not real system data.

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.

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

SD Report Custom ALV report

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 …

VBAK · VBAP · VBFA · LIKP

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: Sales Quotation Conversion Rate and Open Quotations Report