# Returns and Credit Memos by Return Reason Report

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

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/returns-and-credit-memos-by-reason-report/


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

### Closest standard alternatives

- VA05: Lists returns together with other orders; the original invoice and the credit memo are not on the same line.
- VF05: Lists credit memos; does not show the return reason or the invoice that was returned.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBAK | Return document header: type, customer, date and return reason (driving table) | Read | - | ECC + S/4 |
| VBAP | Returned material, quantity and reference to the original invoice | Read | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBFA | Document flow to the return delivery and the credit memo | Read | VBFA-VBELV = VBAP-VBELN AND VBFA-POSNV = VBAP-POSNR | ECC + S/4 |
| LIKP | Goods receipt date of the return delivery | Read | LIKP-VBELN = VBFA-VBELN (VBTYP_N = T) | ECC + S/4 |
| VBRK | Credit memo header and cancellation flag | Read | VBRK-VBELN = VBFA-VBELN (VBTYP_N = O) | ECC + S/4 |
| VBRP | Credit memo amount and quantity on the original invoice | Read | VBRP-VBELN = VBRK-VBELN; orijinal fatura için VBRP-VBELN = VBAP-VGBEL AND VBRP-POSNR = VBAP-VGPOS | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| I_CustomerReturnItem | In S/4HANA it can be read for return items with a clean core approach | Read | CustomerReturn = VBAK-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes |
| S_AUART | Return document type | Range / multiple | VBAK-AUART | No |
| S_AUDAT | Document date | Range / multiple | VBAK-AUDAT | Yes |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No |
| S_AUGRU | Return reason | Range / multiple | VBAK-AUGRU | No |
| S_MATNR | Material | Range / multiple | VBAP-MATNR | No |
| P_OPEN | Only returns without a credit memo | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Return order | VBAK-VBELN |
| Item | VBAP-POSNR |
| Return reason | VBAK-AUGRU |
| Customer | VBAK-KUNNR |
| Customer name | KNA1-NAME1 |
| Material | VBAP-MATNR |
| Returned qty | VBAP-KWMENG |
| Unit | VBAP-VRKME |
| Original invoice | VBAP-VGBEL |
| Billed qty | VBRP-FKIMG |
| Return rate % | Calculated: VBAP-KWMENG ÷ VBRP-FKIMG on the original invoice × 100 |
| Return delivery | LIKP-VBELN |
| Goods receipt date | LIKP-WADAT_IST |
| Credit memo | VBRK-VBELN |
| Credit amount | VBRP-NETWR |
| Currency | VBRK-WAERK |

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

## Authorization objects

- V_VBAK_VKO: Sales document display authorization by sales area
- V_VBAK_AAT: Authorization by sales document type
- V_VBRK_VKO: Billing 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-returns-credit-memos-by-reason
