# Sample-to-Order Conversion Rate Report

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

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: S (4–5 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/sample-to-order-conversion-rate-report/


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

### Closest standard alternatives

- VA05: Lists sales orders; it does not match samples with later orders or give a conversion rate.
- VA25: Lists quotations; since samples are not kept as quotations, it does not show their conversion.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBAK | Sample and follow-up order headers: type, customer, date, sales group (driving table) | Read | - | ECC + S/4 |
| VBAP | Order items: material, net value, cost, rejection reason | Read | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| MARA | Material group (for collection matching) | Read | MARA-MATNR = VBAP-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = VBAP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| TVAKT | Order type name | Read | TVAKT-AUART = VBAK-AUART AND TVAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_SalesOrderItem | In S/4HANA it can replace VBAP with a clean core approach | Read | SalesOrder = VBAK-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes |
| S_AUARS | Sample order types | Range / multiple | VBAK-AUART | Yes |
| S_AUARO | Sales order types to follow | Range / multiple | VBAK-AUART | Yes |
| S_AUDAT | Sample date range | Range / multiple | VBAK-AUDAT | Yes |
| 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 |
| R_MAT | Match at material level | Radio button | - | No |
| R_GRP | Match at material group level | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Customer | KNA1-NAME1 |
| Sales group | VBAK-VKGRP |
| Sample order | VBAK-VBELN |
| Sample date | VBAK-AUDAT |
| Material | VBAP-MATNR |
| Material group | MARA-MATKL |
| Sample cost | VBAP-WAVWR |
| First follow-up order | Calculated: Earliest matching sales order within the window |
| Days to order | Calculated: Date of first follow-up order − sample date |
| Follow-up order value | Calculated: Σ VBAP-NETWR (matching items within the window) |
| Currency | VBAK-WAERK |
| Converted | Calculated: Yes if there is at least one follow-up order |
| Customer conversion rate % | Calculated: Converted samples / samples × 100 (per customer) |

## How does the report work?

1. 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.
2. The material group comes from MARA; depending on the selection, the match is made at material or material group level.
3. 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.
4. 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".
5. Number of samples, converted samples, conversion rate and order value per unit of sample cost are summarized by customer, sales group and material group.
6. Order type names are added from TVAKT.

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=textile-sample-to-order-conversion
