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
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The input VAT list requested for VAT refund claims under the Turkish VAT General Application Communiqué.
The list columns are checked against the current Revenue Administration (GİB) rules during installation and updated if needed.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BKPFAccounting Document Header | Document type, document date, period and invoice number (driving table) | — | ECC + S/4 |
| BSETTax Data Document Segment | Tax code, amount excluding VAT and VAT | BSET-BUKRS = BKPF-BUKRS AND BSET-BELNR = BKPF-BELNR AND BSET-GJAHR = BKPF-GJAHR | ECC + S/4 |
| BSEGAccounting Document Segment | Vendor line (account type K) and item text | BSEG-BELNR = BKPF-BELNR AND BSEG-KOART = 'K' | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name and tax ID | LFA1-LIFNR = BSEG-LIFNR | ECC + S/4 |
| T001Company Codes | Company code local currency | T001-BUKRS = BKPF-BUKRS | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| S_MONAT | Period | Range / multiple | BKPF-MONAT | Yes | 10 |
| S_MWSKZ | Input VAT tax codes | Range / multiple | BSET-MWSKZ | Yes | V1 – V3 |
| S_BLART | Document type | Range / multiple | BKPF-BLART | No | RE, KR |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Invoice date | BKPF-BLDAT |
| 2 | Invoice series and number | BKPF-XBLNR |
| 3 | Vendor name | LFA1-NAME1 |
| 4 | Tax ID | Calculated LFA1-STCD1 or LFA1-STCD2 depending on system usage (Business Partner tax number in S/4HANA) |
| 5 | Goods / services | BSEG-SGTXT |
| 6 | Amount excl. VAT | BSET-HWBAS |
| 7 | VAT | BSET-HWSTE |
| 8 | Tax code | BSET-MWSKZ |
| 9 | Deduction period | Calculated BKPF-GJAHR / BKPF-MONAT |
Sample output
| Invoice date | Invoice series and number | Vendor name | Tax ID | Goods / services | Amount excl. VAT | VAT | Tax code | Deduction period |
|---|---|---|---|---|---|---|---|---|
| 10/03/2026 | ATL2026000000123 | Atlas Ambalaj | 1234567890 | Packaging material | 46,200 | 9,240 | V2 | 2026/10 |
| 10/08/2026 | DLT2026000000456 | Delta Metal | 9876543210 | Steel sheet | 48,960 | 9,792 | V2 | 2026/10 |
| 10/15/2026 | EGE2026000000789 | Ege Kimya | 5554443332 | Paint | 25,560 | 5,112 | V2 | 2026/10 |
How does the report work?
- Purchase documents are read from BKPF for the selected company code, fiscal year and periods, optionally narrowed by document type.
- 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.
- The vendor is taken from the document’s vendor line (BSEG, account type K); name and tax ID come from LFA1.
- The invoice series and number come from the document reference (BKPF-XBLNR), the invoice date from the document date (BKPF-BLDAT).
- 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
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 …
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.