FI Program Custom development Interface TR · Türkiye

Türkiye VAT Refund List Preparation Cockpit

Short answer: A custom cockpit that prepares the sales invoice list, the input VAT list and the calculation of VAT incurred together for one period and refund type, for refund-generating transactions such as export exemption and reduced-rate sales. The lists are produced as files in the GİB upload template, the approved list version is frozen and the refundable VAT amount is transferred to the relevant account.

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

Why is the standard not enough?

S_ALR_87012357 gives return amounts per tax code; it does not produce the sales invoice list per refund type, customs declaration details or the VAT-incurred calculation. FB41 posts the tax payable but does not prepare the transfer of refundable VAT. An input VAT list report only covers the purchase side. The cockpit prepares all lists of the refund file from the same data and version.

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

Closest standard alternatives

  • S_ALR_87012357 Advance Return for Tax on Sales/Purchases. Gives return amounts per tax code; there are no lists per refund type and no VAT-incurred calculation.
  • FB41 Post Tax Payable. Posts the tax payable; does not prepare the refundable VAT transfer.

Localization and legal basis

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
VBRKBilling Document HeaderRefund-generating sales invoices (driving table)ReadECC + S/4
VBRPBilling Document: Item DataInvoice items and delivery valueReadECC + S/4
KNA1Customer Master (General Section)Buyer name and countryReadECC + S/4
BKPFAccounting Document HeaderPurchase documents and the refundable VAT transfer postingRead / writeECC + S/4
BSETTax Data Document SegmentInput VAT base and amountReadECC + S/4
LFA1Vendor Master (General Section)Vendor name and tax numberReadECC + S/4
STXHSAPscript Text HeaderCustoms declaration number and date on the invoiceReadECC + S/4

BAPIs and functions used

  • READ_TEXTRead Long Text. Reads the customs declaration details from the invoice text
  • BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Transfers the refundable VAT amount to the relevant account

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueBKPF-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
P_MONATPeriodSingle valueBKPF-MONATYes10
P_RTYPERefund type (transaction code)Single value—Yes301
S_MWSKZExemption and reduced-rate tax codesRange / multipleBSET-MWSKZNoA0, A1
P_TESTTest mode (without files or postings)Checkbox—NoX

Result list columns

#ColumnSource
1ListCalculated Sales invoices, input VAT or VAT incurred
2DocumentCalculated VBRK-VBELN for sales, BKPF-BELNR for purchases
3Invoice dateBKPF-BLDAT
4Invoice series and numberBKPF-XBLNR
5CounterpartyCalculated KNA1-NAME1 for sales, LFA1-NAME1 for purchases
6Base / delivery valueBSET-HWBAS
7VATBSET-HWSTE
8Customs declarationCalculated Declaration number and date from the invoice text
9StatusCalculated Listed, missing data, changed after approved version

Sample result list

ListDocumentInvoice dateInvoice series and numberCounterpartyBase / delivery valueVATCustoms declarationStatus
Sales invoices9003137710/09/2026ABC2026000004812Demo Retail GmbH1,450,000026341300EX001284 / 2026-10-10Listed
Input VAT510000431810/07/2026ANB2026000001207Anadolu Ambalaj San. Ltd.46,2009,240Listed
Sales invoices9003141510/21/2026ABC2026000004890Nordic Home AB620,0000Missing data
A view built with fictional sample data; not real system data.

How does the program work?

  1. Refund-generating sales invoices are read from VBRK and VBRP for the selected company code, period and refund type (e.g. 301 export of goods); tax code and billing type are limited by parameter. The customs declaration number and date come from the invoice text or foreign trade data.
  2. Sales invoice list: built with invoice date, series and number, buyer, delivery value and customs declaration details; buyer data comes from KNA1.
  3. Input VAT list: purchase documents of the period come from BKPF and BSET, vendor name and tax number from LFA1.
  4. VAT incurred: VAT attributable to refund-generating transactions is calculated directly and with an allocation key; refundable amount = min(VAT incurred, delivery value × standard rate).
  5. Lists are produced as files in the GİB upload template; when the user approves, the list version is frozen and later changes are shown as differences.
  6. The refundable VAT amount is transferred from the input VAT account to the refundable VAT account with BAPI_ACC_DOCUMENT_POST; nothing is posted in test mode.

Performance notes

Read VBRK by company code, billing date and billing type, and BSET by company code, fiscal year and tax code. Prepare yearly or multi-period refund files in the background.

Features

  • Test mode (check without posting)
  • ALV list (sort, filter, subtotals)
  • Export to Excel Lists are produced in the GİB upload template and as Excel.
  • Double-click drill-down to the document From a row you can jump to the invoice or the purchase document.
  • Line-by-line result and error log

Authorization objects

  • F_BKPF_BUKDisplay and posting authorization by company code
  • V_VBRK_FKABilling display authorization by billing type

Frequently asked questions

How does it differ from the Input VAT List Report?

The Input VAT List Report gives only the purchase-side list. The cockpit also prepares the sales invoice list, the VAT-incurred calculation and the transfer posting for the same period and refund type, and freezes the approved version; the whole refund file is managed in one place.

What happens if a document changes after approval?

The approved version does not change. In the next run, changed, added or removed documents are shown as differences; if needed a new version is created and listed separately for the amended return.

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

SD Report Custom ALV report

Billing Documents Not Posted to Accounting Report

A custom ALV report that lists billing documents which exist in SD but have no accounting document yet, with the reason code, age and amount. At …

VBRK · VBRP · BKPF · KNA1

Let us build this program 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 VAT Refund List Preparation Cockpit