SD Report Custom development ALV report Textile and Apparel

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

  • VA05 List of Sales Orders. Lists sales orders; it does not match samples with later orders or give a conversion rate.
  • VA25 Quotations List. Lists quotations; since samples are not kept as quotations, it does not show their conversion.

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderSample and follow-up order headers: type, customer, date, sales group (driving table)—ECC + S/4
VBAPSales Document ItemOrder items: material, net value, cost, rejection reasonVBAP-VBELN = VBAK-VBELNECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
MARAGeneral Material DataMaterial group (for collection matching)MARA-MATNR = VBAP-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = VBAP-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
TVAKTSales Document Types: TextsOrder type nameTVAKT-AUART = VBAK-AUART AND TVAKT-SPRAS = SY-LANGUECC + S/4
I_SalesOrderItemSales Order ItemIn S/4HANA it can replace VBAP with a clean core approachSalesOrder = VBAK-VBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_AUARSSample order typesRange / multipleVBAK-AUARTYesZNM
S_AUAROSales order types to followRange / multipleVBAK-AUARTYesOR
S_AUDATSample date rangeRange / multipleVBAK-AUDATYes01.01.2026 – 30.06.2026
S_KUNNRSold-to partyRange / multipleVBAK-KUNNRNo—
S_VKGRPSales groupRange / multipleVBAK-VKGRPNo—
P_DAYSFollow-up window (days)Single value—Yes180
R_MATMatch at material levelRadio button—NoX
R_GRPMatch at material group levelRadio button—No—

Output columns

#ColumnSource
1CustomerKNA1-NAME1
2Sales groupVBAK-VKGRP
3Sample orderVBAK-VBELN
4Sample dateVBAK-AUDAT
5MaterialVBAP-MATNR
6Material groupMARA-MATKL
7Sample costVBAP-WAVWR
8First follow-up orderCalculated Earliest matching sales order within the window
9Days to orderCalculated Date of first follow-up order − sample date
10Follow-up order valueCalculated Σ VBAP-NETWR (matching items within the window)
11CurrencyVBAK-WAERK
12ConvertedCalculated Yes if there is at least one follow-up order
13Customer conversion rate %Calculated Converted samples / samples × 100 (per customer)

Sample output

CustomerSales groupSample orderSample dateMaterialMaterial groupSample costFirst follow-up orderDays to orderFollow-up order valueCurrencyConvertedCustomer conversion rate %
Örnek Tekstil A.Ş.S01130011202/10/2026KM-PNY-220-LACPNY1,850120018823284,000EURYes67
Örnek Tekstil A.Ş.S01130013103/04/2026KM-SAT-150-SYHSAT9200EURNo67
Nordic Apparel GmbHS02130014503/18/2026KM-DNM-160-INDDNM2,400120024141512,000EURYes50
Demo Retail Ltd.S03130016004/02/2026KM-KTN-180-BEJKTN1,1000GBPNo0
A view built with fictional sample data; not real system data.

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.

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

SD Report Custom ALV report

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 …

VBAK · VBAP · KNA1 · KONV

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: Sample-to-Order Conversion Rate Report