FI Report Custom development ALV report TR · Türkiye

Türkiye Input VAT List Report

Short answer: 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. Invoice date, series and number, vendor name, tax ID, amount excluding VAT and VAT come in one Excel-ready list.

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

Why is the standard not enough?

S_ALR_87012357 totals tax lines per tax code but does not give an invoice-level list with the vendor tax ID and invoice series and number. Teams usually build this list by hand in Excel from ledger extracts, which can take days at period close.

Who uses it? Tax and accounting teams, certified public accountants and finance teams preparing VAT refunds.

Closest standard alternatives

  • S_ALR_87012357 Advance Return for Tax on Sales/Purchases. Totals per tax code; does not give an invoice-level list with vendor tax ID and invoice series and number.
  • FBL1N Vendor Line Item Display. Lists vendor items; does not show the VAT base and VAT amount on the same line.

Localization and legal basis

Tables used

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

TableRoleJoinSystem
BKPFAccounting Document HeaderDocument type, document date, period and invoice number (driving table)—ECC + S/4
BSETTax Data Document SegmentTax code, amount excluding VAT and VATBSET-BUKRS = BKPF-BUKRS AND BSET-BELNR = BKPF-BELNR AND BSET-GJAHR = BKPF-GJAHRECC + S/4
BSEGAccounting Document SegmentVendor line (account type K) and item textBSEG-BELNR = BKPF-BELNR AND BSEG-KOART = 'K'ECC + S/4
LFA1Vendor Master (General Section)Vendor name and tax IDLFA1-LIFNR = BSEG-LIFNRECC + S/4
T001Company CodesCompany code local currencyT001-BUKRS = BKPF-BUKRSECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBKPF-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
S_MONATPeriodRange / multipleBKPF-MONATYes10
S_MWSKZInput VAT tax codesRange / multipleBSET-MWSKZYesV1 – V3
S_BLARTDocument typeRange / multipleBKPF-BLARTNoRE, KR

Output columns

#ColumnSource
1Invoice dateBKPF-BLDAT
2Invoice series and numberBKPF-XBLNR
3Vendor nameLFA1-NAME1
4Tax IDCalculated LFA1-STCD1 or LFA1-STCD2 depending on system usage (Business Partner tax number in S/4HANA)
5Goods / servicesBSEG-SGTXT
6Amount excl. VATBSET-HWBAS
7VATBSET-HWSTE
8Tax codeBSET-MWSKZ
9Deduction periodCalculated BKPF-GJAHR / BKPF-MONAT

Sample output

Invoice dateInvoice series and numberVendor nameTax IDGoods / servicesAmount excl. VATVATTax codeDeduction period
10/03/2026ATL2026000000123Atlas Ambalaj1234567890Packaging material46,2009,240V22026/10
10/08/2026DLT2026000000456Delta Metal9876543210Steel sheet48,9609,792V22026/10
10/15/2026EGE2026000000789Ege Kimya5554443332Paint25,5605,112V22026/10
A view built with fictional sample data; not real system data.

How does the report work?

  1. Purchase documents are read from BKPF for the selected company code, fiscal year and periods, optionally narrowed by document type.
  2. Each document’s tax lines are read from BSET and limited to input VAT tax codes; the amount excluding VAT (HWBAS) and the VAT (HWSTE) are in local currency.
  3. The vendor is taken from the document’s vendor line (BSEG, account type K); name and tax ID come from LFA1.
  4. The invoice series and number come from the document reference (BKPF-XBLNR), the invoice date from the document date (BKPF-BLDAT).
  5. Lines are totalled per invoice and shown in the column order of the GİB list.

Performance notes

Read BSET by company code, fiscal year and tax codes; join BKPF and BSEG by document key in one pass. Run yearly selections in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a line opens FB03.
  • Export to Excel Column order matches the GİB list.
  • Runs as a background job

Authorization objects

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

Frequently asked questions

Which field holds the tax ID?

In SAP systems in Türkiye the tax ID is usually kept in LFA1-STCD1 or LFA1-STCD2; which one is used is checked during installation. In S/4HANA, Business Partner tax numbers can be read as well.

Does the list follow the GİB format?

The columns follow the order of the input VAT list. Because GİB rules can change, the current format is checked during installation and columns are updated if needed.

Does it work on S/4HANA?

Yes. BKPF, BSEG and BSET are still used in S/4HANA; for high volumes, ACDOCA-based CDS views can be preferred.

Related reports

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: Türkiye Input VAT List Report