FI Report Custom development ALV report

Foreign Currency Open Items Exchange Difference Preview Report

Short answer: A custom ALV report that reads customer and vendor open items by document currency, revalues them at the key-date rate and shows the unrealized exchange difference per item, account and currency. The month-end effect is visible before any valuation posting is made.

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

Why is the standard not enough?

F.05 (FAGL_FCV on S/4HANA) performs the valuation and posts it; its test-run list does not offer a flexible summary by currency and account, or one Excel-ready view with customers and vendors together. FBL5N and FBL1N show the document currency amount but neither revalue at the key-date rate nor calculate the difference. Treasury usually works out the exchange effect in Excel during the month.

Who uses it? General ledger and month-end close teams, treasury and financial controllers, especially companies with large foreign currency payables and receivables.

Closest standard alternatives

  • F.05 Foreign Currency Valuation. Performs and posts the foreign currency valuation; does not offer a flexible preview summary.
  • FBL5N Customer Line Items. Lists the document currency amount; does not revalue at the key-date rate.

Tables used

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

TableRoleJoinSystem
BSIDCustomer Open ItemsCustomer open items: document and local currency amounts (driving table)—ECC + S/4
BSIKVendor Open ItemsVendor open items: document and local currency amountsBSIK-BUKRS = BSID-BUKRSECC + S/4
T001Company CodesCompany code currencyT001-BUKRS = BSID-BUKRSECC + S/4
TCURRExchange RatesExchange rate valid on the key dateTCURR-FCURR = BSID-WAERS AND TCURR-TCURR = T001-WAERS AND TCURR-KURST = P_KURSTECC + S/4
TCURFCurrency Conversion FactorsRatio factors for the currency pairTCURF-FCURR = TCURR-FCURR AND TCURF-TCURR = TCURR-TCURR AND TCURF-KURST = TCURR-KURSTECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = BSID-KUNNRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = BSIK-LIFNRECC + S/4

S/4HANA notes

  • BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
  • BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

BAPIs and functions used

  • READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the valid rate and factors for the key date and rate type
  • CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Translates the document currency amount into local currency at the key-date rate

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBSID-BUKRSYes1000
S_KUNNRCustomerRange / multipleBSID-KUNNRNo200150
S_LIFNRVendorRange / multipleBSIK-LIFNRNo100245
S_WAERSDocument currencyRange / multipleBSID-WAERSNoUSD
P_KEYDTKey dateSingle valueSY-DATUMYes30.11.2026
P_KURSTExchange rate typeSingle valueTCURR-KURSTYesM
P_CUSTInclude customer open itemsCheckbox—NoX
P_VENDInclude vendor open itemsCheckbox—NoX

Output columns

#ColumnSource
1Company codeBSID-BUKRS
2Account typeCalculated Customer when the item comes from BSID, Vendor when it comes from BSIK
3AccountCalculated BSID-KUNNR or BSIK-LIFNR
4Account nameCalculated KNA1-NAME1 or LFA1-NAME1
5DocumentBSID-BELNR
6Posting dateBSID-BUDAT
7Document currencyBSID-WAERS
8Amount in document currencyBSID-WRBTR
9Booked local amountBSID-DMBTR
10Historical rateCalculated DMBTR / WRBTR
11Key-date rateTCURR-UKURS
12Revalued amountCalculated WRBTR × key-date rate (with TCURF factors)
13Unrealized exchange differenceCalculated Revalued amount − DMBTR
14Local currencyT001-WAERS

Sample output

Company codeAccount typeAccountAccount nameDocumentPosting dateDocument currencyAmount in document currencyBooked local amountHistorical rateKey-date rateRevalued amountUnrealized exchange differenceLocal currency
1000Customer200150Kuzey Gıda Dağıtım180001204409/12/2026USD40,0001,360,0003434.651,386,00026,000TRY
1000Customer200388Marmara Yapı Market180001239110/03/2026EUR15,000585,0003940.10601,50016,500TRY
1000Vendor100387Delta Metal510000390208/21/2026USD-22,000-741,40033.7034.65-762,300-20,900TRY
1000Vendor100512Ege Kimya510000450211/04/2026EUR-8,500-340,85040.1040.10-340,8500TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. For the selected company codes, open items whose document currency (WAERS) differs from the company code currency (T001-WAERS) are read from BSID and BSIK.
  2. The booked local currency amount (DMBTR) and the document currency amount (WRBTR) are signed by the debit/credit indicator (SHKZG); historical rate = DMBTR / WRBTR.
  3. The key-date rate for the selected rate type is read from TCURR by validity date; translation follows the READ_EXCHANGE_RATE and CONVERT_TO_LOCAL_CURRENCY logic, taking the TCURF ratio factors into account.
  4. Revalued amount = WRBTR × key-date rate; unrealized difference = revalued amount − DMBTR.
  5. Customer names come from KNA1 and vendor names from LFA1; rows are subtotalled by account and currency.

Performance notes

Read BSID and BSIK with company code and currency conditions; read each currency's rate once and keep it in memory. On S/4HANA, open items can be aggregated in the database through I_OperationalAcctgDocItem.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the document number opens FB03.
  • Export to Excel
  • Runs as a background job Can run automatically with the month-end key date and be emailed to treasury.
  • Send the result by email

Authorization objects

  • F_BKPF_BUKAccounting document display authorization by company code
  • F_KNA1_BUKCustomer master authorization by company code
  • F_LFA1_BUKVendor master authorization by company code

Frequently asked questions

Does the report post anything?

No. The report is a preview only. The posting is still made with the standard valuation (F.05, or FAGL_FCV on S/4HANA); the report lets you check the amounts before posting.

Is a previous month's valuation taken into account?

If the valuation method reverses every month, the booked amount is enough for the comparison. For methods without reversal, earlier valuation differences are read from the valuation table and added to the booked amount; this option is set during installation.

Can G/L open items be valued too?

Yes. Open-item-managed G/L accounts such as foreign currency bank clearing accounts can be added from BSIS with the same logic; this scope adds a day or two to the effort range.

Packages that include this solution

FI Package Custom

Currency Valuation and VAT Reconciliation Pack

A four-component pack that brings period-end valuation and tax checks together: daily automatic import of central bank exchange rates, an exchange …

4 components · v1.0

Related reports

FI Report Custom ALV report

Customer Receivables Aging Report

A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …

BSID · BSAD · KNA1 · KNB1

FI Report Custom ALV report

Vendor Open Items Aging Report

A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …

BSIK · LFA1 · LFB1 · T001

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: Foreign Currency Open Items Exchange Difference Preview Report