Sample-to-Order Conversion Rate Report
Short answer: A custom ALV report that matches sample orders sent to customers with sales orders received from the same customer for the same product or product group within a given time, and shows with which customer and collection sample cost turns into orders. Sales teams steer the sample budget to customers and products with a high conversion rate.
- Estimated effort
- S · 4–5 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VA05 lists sales orders, but since there is no document flow between a sample order and later orders, it cannot show which sample turned into an order. Reports that measure quotation conversion rely on reference document flow; samples are usually created without a reference, so that method does not work. The custom report makes the match by customer, product and time window.
Who uses it? Sales and marketing managers, account managers, collection and product development teams.
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 | Sample and follow-up order headers: type, customer, date, sales group (driving table) | — | ECC + S/4 |
| VBAPSales Document Item | Order items: material, net value, cost, rejection reason | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| MARAGeneral Material Data | Material group (for collection matching) | MARA-MATNR = VBAP-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = VBAP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| TVAKTSales Document Types: Texts | Order type name | TVAKT-AUART = VBAK-AUART AND TVAKT-SPRAS = SY-LANGU | 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_AUARS | Sample order types | Range / multiple | VBAK-AUART | Yes | ZNM |
| S_AUARO | Sales order types to follow | Range / multiple | VBAK-AUART | Yes | OR |
| S_AUDAT | Sample date range | Range / multiple | VBAK-AUDAT | Yes | 01.01.2026 – 30.06.2026 |
| S_KUNNR | Sold-to party | Range / multiple | VBAK-KUNNR | No | — |
| S_VKGRP | Sales group | Range / multiple | VBAK-VKGRP | No | — |
| P_DAYS | Follow-up window (days) | Single value | — | Yes | 180 |
| R_MAT | Match at material level | Radio button | — | No | X |
| R_GRP | Match at material group level | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Customer | KNA1-NAME1 |
| 2 | Sales group | VBAK-VKGRP |
| 3 | Sample order | VBAK-VBELN |
| 4 | Sample date | VBAK-AUDAT |
| 5 | Material | VBAP-MATNR |
| 6 | Material group | MARA-MATKL |
| 7 | Sample cost | VBAP-WAVWR |
| 8 | First follow-up order | Calculated Earliest matching sales order within the window |
| 9 | Days to order | Calculated Date of first follow-up order − sample date |
| 10 | Follow-up order value | Calculated Σ VBAP-NETWR (matching items within the window) |
| 11 | Currency | VBAK-WAERK |
| 12 | Converted | Calculated Yes if there is at least one follow-up order |
| 13 | Customer conversion rate % | Calculated Converted samples / samples × 100 (per customer) |
Sample output
| Customer | Sales group | Sample order | Sample date | Material | Material group | Sample cost | First follow-up order | Days to order | Follow-up order value | Currency | Converted | Customer conversion rate % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Örnek Tekstil A.Ş. | S01 | 1300112 | 02/10/2026 | KM-PNY-220-LAC | PNY | 1,850 | 1200188 | 23 | 284,000 | EUR | Yes | 67 |
| Örnek Tekstil A.Ş. | S01 | 1300131 | 03/04/2026 | KM-SAT-150-SYH | SAT | 920 | 0 | EUR | No | 67 | ||
| Nordic Apparel GmbH | S02 | 1300145 | 03/18/2026 | KM-DNM-160-IND | DNM | 2,400 | 1200241 | 41 | 512,000 | EUR | Yes | 50 |
| Demo Retail Ltd. | S03 | 1300160 | 04/02/2026 | KM-KTN-180-BEJ | KTN | 1,100 | 0 | GBP | No | 0 |
How does the report work?
- Orders created in the selected sales organization, sample order types and date range are read from VBAK; material and cost (WAVWR) come from VBAP. Rejected items (ABGRU filled) are dropped.
- The material group comes from MARA; depending on the selection, the match is made at material or material group level.
- For each sample item, items in standard order types from the same sold-to party, created within P_DAYS days after the sample date and not rejected, are searched.
- The first follow-up order, the days until that order and the total net value of follow-up orders within the window are calculated; a sample with at least one follow-up order counts as “converted”.
- Number of samples, converted samples, conversion rate and order value per unit of sample cost are summarized by customer, sales group and material group.
- Order type names are added from TVAKT.
Performance notes
Read sample orders and follow-up orders in two separate selections by sales organization and date range, and match follow-up orders in memory by customer and material key. Select orders up to the end of the follow-up window in one pass.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a sample or follow-up order opens VA03.
- Export to Excel
- Runs as a background job
Authorization objects
- V_VBAK_VKOSales document display authorization by sales organization
- V_VBAK_AATDisplay authorization by sales document type
Frequently asked questions
What if samples are sent as deliveries without an order?
If samples are created as free-of-charge deliveries, the report is adapted to read the starting documents from delivery types (LIKP, LIPS); the matching logic stays the same. This adds about 1 day to the estimate.
Can matching be done by collection or season?
Yes. If the collection or season is kept as a characteristic in material classification, that characteristic can be used instead of the material group; every order from the same collection then counts as conversion of the sample.
Does it work on S/4HANA?
Yes. VBAK and VBAP are the same in S/4HANA; if clean core is preferred, items are read via I_SalesOrderItem.
Related reports
Customers with Declining Order Intake vs Prior Year Report
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 …
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.