# Export Sales Exchange Rate Effect and Margin by Currency Report

> A custom ALV report that splits the change in local currency revenue from foreign currency billing items into volume, price and exchange rate effects, and shows the gross margin by customer, country and currency. Exporters see how much of the revenue growth really comes from sales and how much from currency movements.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (6–8 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/export-sales-exchange-rate-effect-and-margin-by-currency-report/


## Why is the standard not enough?

VF05 lists billing documents; KE30 profitability reports can show revenue in two currencies depending on configuration. There is no standard key figure structure that splits the revenue difference between two periods into volume, price and exchange rate effects, so this is usually done by hand in Excel. The custom report makes the split at billing item level with the posted rates.

### Closest standard alternatives

- KE30: Profitability reports can show revenue in two currencies; they do not split it into volume, price and exchange rate effects.
- VF05: Lists billing documents; there is no period comparison or exchange rate effect.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBRK | Billing header: document currency, accounting rate, billing date (driving table) | Read | - | ECC + S/4 |
| VBRP | Billing item: quantity, net value, cost | Read | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| KNA1 | Customer name and country | Read | KNA1-KUNNR = VBRK-KUNAG | ECC + S/4 |
| T001 | Company code currency | Read | T001-BUKRS = VBRK-BUKRS | ECC + S/4 |
| TCURR | Average rate for the selected exchange rate type | Read | TCURR-KURST = P_KURST AND TCURR-FCURR = VBRK-WAERK AND TCURR-TCURR = T001-WAERS | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = VBRP-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_BillingDocumentItem | In S/4HANA it can replace VBRP with a clean core approach | Read | BillingDocument = VBRK-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | VBRK-BUKRS | Yes |
| S_VKORG | Sales organization | Range / multiple | VBRK-VKORG | No |
| S_FKDAT | Current period billing date | Range / multiple | VBRK-FKDAT | Yes |
| S_FKDA0 | Comparison period billing date | Range / multiple | VBRK-FKDAT | Yes |
| S_WAERK | Document currency | Range / multiple | VBRK-WAERK | No |
| S_LAND1 | Customer country | Range / multiple | KNA1-LAND1 | No |
| P_KURST | Average rate type (if empty, the billing rate is used) | Single value | TCURR-KURST | No |
| P_LEVEL | Detail level: C = customer, M = material, D = currency | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Customer | KNA1-NAME1 |
| Country | KNA1-LAND1 |
| Currency | VBRK-WAERK |
| Quantity (current) | Calculated: Σ VBRP-FKIMG, credit memos negative |
| Revenue (document currency) | Calculated: Σ VBRP-NETWR |
| Average rate (current) | Calculated: Local revenue / revenue in document currency |
| Revenue (local, current) | Calculated: Σ VBRP-NETWR × VBRK-KURRF |
| Revenue (local, comparison) | Calculated: Σ VBRP-NETWR × VBRK-KURRF in the comparison period |
| Volume effect | Calculated: (Q1 − Q0) × P0 × R0 |
| Price effect | Calculated: (P1 − P0) × Q1 × R0 |
| Exchange rate effect | Calculated: Q1 × P1 × (R1 − R0) |
| Cost | Calculated: Σ VBRP-WAVWR |
| Gross margin % | Calculated: (Local revenue − cost) / local revenue × 100 |

## How does the report work?

1. Billing documents and credit memos that are not cancelled and fall into the current or comparison period are read from VBRK for the selected company code and sales organization; only those whose document currency differs from the company code currency (T001-WAERS) remain.
2. Quantity (FKIMG), net value in document currency (NETWR) and cost (WAVWR) come from VBRP; credit memos are counted with a negative sign.
3. Revenue in local currency = NETWR × VBRK-KURRF (the rate passed to accounting). Depending on the selection, the average rate in TCURR can be used instead.
4. For each customer, material and currency, the average unit price (P) and average rate (R) are calculated for the current (1) and comparison (0) periods.
5. Volume effect = (Q1 − Q0) × P0 × R0; price effect = (P1 − P0) × Q1 × R0; exchange rate effect = Q1 × P1 × (R1 − R0). The three effects add up to the local revenue difference.
6. Gross margin = local revenue − cost; subtotals are given by customer, country and currency.

## Authorization objects

- V_VBRK_VKO: Billing document display authorization by sales organization
- V_VBRK_FKA: Display authorization by billing type

## Frequently asked questions

### Which exchange rate is used?

By default the rate with which the invoice was passed to accounting (VBRK-KURRF) is used, so the figures match revenue in the general ledger. Optionally the period average of a selected exchange rate type can be used for the comparison.

### Are exchange differences on collection included?

No. The report shows the exchange rate effect on the sales side. Exchange gains and losses realized on collection are tracked separately in accounting; a separate report can be used for the valuation of open items.

### Does it work on S/4HANA?

Yes. VBRK and VBRP are the same in S/4HANA; if clean core is preferred, billing items are read via I_BillingDocumentItem.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-export-fx-effect-analysis
