SD Report Custom development ALV report

Returns and Credit Memos by Return Reason Report

Short answer: A custom ALV report that lists return orders with the return reason, the original invoice, the goods receipt of the return delivery and the credit memo amount on the same line. Sales and quality teams see which customer, material and reason drive returns, with the value attached.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

In VA05 returns are listed together with other orders; the return reason, the referenced invoice, the goods receipt of the return delivery and the credit memo are not on the same line. VF05 lists credit memos but not the return reason or the original invoice. There is no standard list of total return value and return rate per reason.

Who uses it? Sales managers, customer service, quality teams and financial controllers who track the cost of returns.

Closest standard alternatives

  • VA05 List of Sales Orders. Lists returns together with other orders; the original invoice and the credit memo are not on the same line.
  • VF05 List Billing Documents. Lists credit memos; does not show the return reason or the invoice that was returned.

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderReturn document header: type, customer, date and return reason (driving table)—ECC + S/4
VBAPSales Document ItemReturned material, quantity and reference to the original invoiceVBAP-VBELN = VBAK-VBELNECC + S/4
VBFASales Document FlowDocument flow to the return delivery and the credit memoVBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNRECC + S/4
LIKPDelivery HeaderGoods receipt date of the return deliveryLIKP-VBELN = VBFA-VBELN (VBTYP_N = T)ECC + S/4
VBRKBilling Document HeaderCredit memo header and cancellation flagVBRK-VBELN = VBFA-VBELN (VBTYP_N = O)ECC + S/4
VBRPBilling Document: Item DataCredit memo amount and quantity on the original invoiceVBRP-VBELN = VBRK-VBELN; orijinal fatura için VBRP-VBELN = VBAP-VGBEL AND VBRP-POSNR = VBAP-VGPOSECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
I_CustomerReturnItemReturns Order ItemIn S/4HANA it can be read for return items with a clean core approachCustomerReturn = VBAK-VBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGYes1000
S_AUARTReturn document typeRange / multipleVBAK-AUARTNoRE
S_AUDATDocument dateRange / multipleVBAK-AUDATYes01.07.2026 – 31.10.2026
S_KUNNRCustomerRange / multipleVBAK-KUNNRNo200145
S_AUGRUReturn reasonRange / multipleVBAK-AUGRUNoR02
S_MATNRMaterialRange / multipleVBAP-MATNRNoFG-1002
P_OPENOnly returns without a credit memoCheckbox—No—

Output columns

#ColumnSource
1Return orderVBAK-VBELN
2ItemVBAP-POSNR
3Return reasonVBAK-AUGRU
4CustomerVBAK-KUNNR
5Customer nameKNA1-NAME1
6MaterialVBAP-MATNR
7Returned qtyVBAP-KWMENG
8UnitVBAP-VRKME
9Original invoiceVBAP-VGBEL
10Billed qtyVBRP-FKIMG
11Return rate %Calculated VBAP-KWMENG ÷ VBRP-FKIMG on the original invoice × 100
12Return deliveryLIKP-VBELN
13Goods receipt dateLIKP-WADAT_IST
14Credit memoVBRK-VBELN
15Credit amountVBRP-NETWR
16CurrencyVBRK-WAERK

Sample output

Return orderItemReturn reasonCustomerCustomer nameMaterialReturned qtyUnitOriginal invoiceBilled qtyReturn rate %Return deliveryGoods receipt dateCredit memoCredit amountCurrency
0060001201000010R02 Damaged goods200145Marmara Yapı MarketFG-100224PC00900455123008008400031110/09/202600700022103,360TRY
0060001215000010R05 Wrong product200310Kuzey Gıda DağıtımFG-205050KG00900455881,2004.20008400032710/15/202600700022312,150TRY
0060001229000010R02 Damaged goods200422Anadolu Elektrik ToptanFG-31105PC0090045630806.30008400034110/27/20260TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. Returns (VBAK-VBTYP = H) and credit memo requests (K) are read with the sales area, document type and date range from the selection screen; the return reason comes from VBAK-AUGRU.
  2. The original invoice is taken from the item reference (VBAP-VGBEL / VGPOS); without a reference, the preceding billing document in VBFA (VBTYP_V = M) is used. The billed quantity is VBRP-FKIMG.
  3. The return delivery (VBTYP_N = T) is found through VBFA and its goods receipt date is added from LIKP-WADAT_IST.
  4. The credit memo (VBTYP_N = O) is read from VBRK/VBRP; cancelled documents (VBRK-FKSTO) are skipped.
  5. Return rate = returned quantity ÷ quantity on the original invoice × 100. ALV shows subtotals per return reason, customer and material.

Performance notes

Select the return documents by document type and date range; read VBFA once with the list of return items. Run long periods in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a document number opens VA03, VL03N or VF03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email A monthly returns summary can be sent to the sales and quality managers.

Authorization objects

  • V_VBAK_VKOSales document display authorization by sales area
  • V_VBAK_AATAuthorization by sales document type
  • V_VBRK_VKOBilling document authorization by sales organization

Frequently asked questions

What happens to returns without a reason?

They are listed in a "no reason" group. If the return reason is made a mandatory field for the return document type, this group disappears over time.

Can returns be linked to quality notifications?

Yes. If the return order or delivery is stored in the quality notification (QMEL), the notification number and defect code can be added as extra columns.

Does it work on S/4HANA?

Yes. The sales and billing tables used keep the same structure in S/4HANA; for clean core, I_CustomerReturnItem and the billing CDS views 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: Returns and Credit Memos by Return Reason Report