FI Report Custom development ALV report TR · Türkiye

Türkiye Stamp Tax Calculation and List Report

Short answer: A custom ALV report that calculates stamp tax on the value of sales and purchasing contracts with the rate and the maximum amount cap, compares it with the stamp tax posted in accounting and shows missing or excess postings. The list grouped by declaration period is used when preparing the withholding and social security declaration.

Estimated effort
S · 4–6 working days
System
ECC and S/4HANA
Tables
7
Scope
TR
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

VA45 lists sales contracts and ME3L lists purchasing contracts; neither calculates stamp tax, applies the maximum amount cap or compares with the accounting posting. Teams export the contract list to Excel and calculate the tax by hand. The report calculates both contract types in one list and reconciles them with the postings.

Who uses it? Tax and accounting teams, purchasing and sales contract management teams.

Closest standard alternatives

  • VA45 List of Contracts. Lists sales contracts; does not calculate stamp tax.
  • ME3L Outline Agreements per Vendor. Lists purchasing contracts per vendor; there is no tax calculation or posting comparison.

Localization and legal basis

Tables used

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

TableRoleJoinSystem
VBAKSales Document HeaderSales contracts: date, customer and net value—ECC + S/4
EKKOPurchasing Document HeaderPurchasing outline agreements: date, vendor—ECC + S/4
EKPOPurchasing Document ItemTarget values of the purchasing contractEKPO-EBELN = EKKO-EBELNECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
BSEGAccounting Document SegmentPostings to the stamp tax accountBSEG-HKONT = damga vergisi hesabı AND BSEG-ZUONR = sözleşme noECC + S/4
TCURRExchange RatesRate on the contract date for foreign currency contractsTCURR-FCURR = VBAK-WAERKECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBKPF-BUKRSYes1000
S_DATEContract dateRange / multipleVBAK-AUDATYes01.10.2026 – 31.10.2026
S_AUARTSales contract typesRange / multipleVBAK-AUARTNoWK1, WK2
S_BSARTPurchasing contract typesRange / multipleEKKO-BSARTNoMK, WK
P_RATEStamp tax rate (per mille)Single value—Yes9,48
P_CAPMaximum amount per documentSingle value—No23000000
S_HKONTStamp tax accountRange / multipleBSEG-HKONTNo360000020

Output columns

#ColumnSource
1Contract typeCalculated Sales (VBAK) or purchasing (EKKO)
2Contract no.Calculated VBAK-VBELN or EKKO-EBELN
3Contract dateCalculated VBAK-AUDAT or EKKO-BEDAT
4CounterpartyCalculated KNA1-NAME1 or LFA1-NAME1
5Contract valueVBAK-NETWR
6CurrencyVBAK-WAERK
7Value (TRY)Calculated Contract value × rate on the contract date
8Calculated stamp taxCalculated min(Value (TRY) × P_RATE / 1000, P_CAP) × company share
9Posted stamp taxCalculated Σ BSEG-DMBTR on the stamp tax account matched by contract number
10DifferenceCalculated Calculated − posted
11Declaration periodCalculated Year and month of the contract date

Sample output

Contract typeContract no.Contract dateCounterpartyContract valueCurrencyValue (TRY)Calculated stamp taxPosted stamp taxDifferenceDeclaration period
Sales4000081510/03/2026Örnek Tekstil A.Ş.2,500,000TRY2,500,00023,70023,70002026-10
Purchasing460000039110/14/2026Anadolu Ambalaj San. Ltd.120,000EUR4,920,00046,641.60046,641.602026-10
Sales4000082210/28/2026Demo Retail Ltd.750,000TRY750,0007,1107,900-7902026-10
A view built with fictional sample data; not real system data.

How does the report work?

  1. Sales contracts are read from VBAK (contract document types by parameter) and purchasing contracts from EKKO (outline agreement types) by document date.
  2. The contract value comes from the header net value; foreign currency contracts are converted to local currency at the rate on the contract date.
  3. Stamp tax = value × rate (per mille); if the result exceeds the maximum amount per document, the maximum is used. The company’s share (all or split between the parties) is set by parameter.
  4. Postings to the stamp tax account are read from BSEG and matched by the contract number in the item text or assignment field.
  5. Calculated and posted amounts are compared; the difference is shown as a contract without posting or a posting without contract.
  6. Rows are grouped by declaration period (month of the contract date).

Performance notes

Limit VBAK and EKKO by document type and date range; read the stamp tax account's items once by account and period.

Features

  • ALV list (sort, filter, subtotals)
  • Export to Excel
  • Double-click drill-down to the document From a row you can jump to the contract or the stamp tax posting.
  • User-specific layout variants

Authorization objects

  • V_VBAK_VKOContract display authorization by sales organization
  • M_BEST_EKOContract display authorization by purchasing organization
  • F_BKPF_BUKAccounting document display authorization by company code

Frequently asked questions

What about contracts signed outside SAP?

The report covers sales and purchasing contracts in SAP. For contracts that do not exist as documents in SAP, such as lease, service or loan agreements, the same calculation can be done as an extra option with a list uploaded from Excel.

Does the program need a change when the rate or the maximum amount changes?

No. The rate and the maximum amount are entered as parameters on the selection screen; for the yearly update only the variant values are changed.

Related reports

FI Report Custom ALV report TR

Türkiye Input VAT List Report

A custom ALV report that produces the input VAT list required for Turkish VAT refund files from purchase documents in SAP, one line per invoice. …

BKPF · BSET · BSEG · LFA1

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: Türkiye Stamp Tax Calculation and List Report