FI Program Custom development Mass upload TR · Türkiye

Türkiye Investment Incentive Certificate Tracking Program

Short answer: A custom program that uploads the machinery and equipment list of an investment incentive certificate from Excel, matches it to fixed assets and tracks planned versus realized investment spending, the domestic/imported split and the investment contribution amount for reduced corporate tax. The spending list required for the completion visa is prepared from SAP data.

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

Why is the standard not enough?

AR01 and AW01N show fixed asset values but do not track which asset belongs to which incentive certificate and line, the realization against the certificate amount or the remaining tax benefit. Tracking is usually done in Excel and the spending list for the completion visa is prepared by hand. The program keeps the certificate-asset link in SAP and tracking is done from there.

Who uses it? Asset accounting and general ledger teams, finance teams working with tax and incentive advisors, investment project teams.

Closest standard alternatives

  • AR01 Asset Balances List. Lists asset balances; there is no incentive certificate link or tax benefit tracking.
  • AW01N Asset Explorer. Shows the values of a single asset; gives no tracking per certificate.

Localization and legal basis

Tables used

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

TableRoleAccessSystem
ANLAAsset Master RecordFixed asset master; the certificate link is written to the evaluation group fieldRead / writeECC + S/4
ANEPAsset Line ItemsAsset acquisition transactions and value datesReadECC + S/4
ANLCAsset Value FieldsCumulative acquisition valueReadECC + S/4
EKKOPurchasing Document HeaderPurchase order and vendor of the asset purchaseReadECC + S/4
LFA1Vendor Master (General Section)Vendor country (domestic/imported split)ReadECC + S/4

S/4HANA notes

  • ANEP → ACDOCA: In S/4HANA new asset accounting asset transactions are written to ACDOCA; ANEP is read through the compatibility view FAAV_ANEP.
  • ANLC → ACDOCA: In S/4HANA new asset accounting the actual values are kept in ACDOCA; ANLC is only read through the compatibility view FAAV_ANLC.

BAPIs and functions used

  • BAPI_FIXEDASSET_CHANGEChange Fixed Asset. Writes the incentive certificate and line code to the asset's evaluation group field
  • BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits the change after each asset

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_FILEMachinery and equipment list fileSingle value—NoC:\temp\tesvik_2026_5512.xlsx
P_BUKRSCompany codeSingle valueANLA-BUKRSYes1000
P_RATEInvestment contribution rate (%)Single value—No30
P_USEDInvestment contribution already usedSingle value—No1250000
P_TESTTest mode (check without writing the link)Checkbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Certificate no.By rule Number of the incentive certificateYes
2Certificate line no.By rule Line number in the machinery and equipment listYes
3Domestic / importedBy rule Domestic or imported split in the listYes
4Planned amountBy rule Spending amount planned in the certificateYes
5AssetANLA-ANLN1Yes
6Sub-numberANLA-ANLN2No

Sample upload file

1Certificate no. *Certificate line no. *Domestic / imported *Planned amount *Asset *Sub-number
22026-5512001Imported4,200,0003000012450
32026-5512002Domestic850,0003000012460
42026-5512003Domestic600,0003000013010
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Certificate line no.Calculated Certificate line from the link
2AssetANLA-ANLN1
3Asset descriptionANLA-TXT50
4Capitalization dateANLA-ZUGDT
5Planned amountCalculated Planned amount on the certificate line
6Realized amountCalculated Σ ANEP-ANBTR within the certificate period (acquisitions)
7Realization %Calculated Realized / planned × 100
8Investment contributionCalculated Realized amount × P_RATE
9StatusCalculated Matched, written, error or spending outside the certificate period

Sample result list

Certificate line no.AssetAsset descriptionCapitalization datePlanned amountRealized amountRealization %Investment contributionStatus
001300001245CNC Dik İşleme Merkezi04/18/20264,200,0004,365,000103.901,309,500Written
002300001246Kompresör ve Hava Kurutucu05/02/2026850,000812,40095.60243,720Written
003300001301Konveyör Hattı600,000000Error
A view built with fictional sample data; not real system data.

How does the program work?

  1. The certificate’s machinery and equipment list (certificate no., line no., domestic/imported, description, quantity, planned amount) and the fixed asset numbers to be matched are read from Excel.
  2. Pre-checks: the asset exists in ANLA and is active, the company code is correct and the asset is not linked to another certificate.
  3. The link is written to the asset’s evaluation group field (e.g. ANLA-ORD41) as the certificate and line code with BAPI_FIXEDASSET_CHANGE; nothing is written in test mode.
  4. Tracking: acquisitions of linked assets are read from ANEP (value date within the certificate period) and cumulative values from ANLC; the vendor and the domestic/imported split are checked via the purchase order in EKKO and LFA1.
  5. Per certificate line, planned and realized amounts, the realization rate and the investment contribution (realized × contribution rate) are calculated; the contribution already used is entered as a parameter and the remaining benefit is shown.
  6. The spending list for the completion visa (invoice, date, vendor, amount) is taken as ALV and Excel.

Performance notes

Read ANEP only for the assets linked to the certificate and within the certificate period. With many assets, read the link through the evaluation group field.

Features

  • Test mode (check without posting)
  • Download failed lines as a separate file Rows that could not be matched are downloaded in the same template, corrected and uploaded again.
  • Export to Excel The spending list for the completion visa is exported to Excel.
  • ALV list (sort, filter, subtotals)
  • Line-by-line result and error log

Authorization objects

  • A_S_ANLKLAuthorization to change asset master data by asset class
  • F_BKPF_BUKAccounting data display authorization by company code

Frequently asked questions

Why is the evaluation group field used for the certificate link?

Evaluation groups are free classification fields available as standard in the asset master; they can be used in reports and selections without adding a field. If the company already uses that field, another free group is chosen during installation.

Can customs duty and VAT exemptions also be tracked?

Yes. Amounts with VAT and customs duty exemption applied can be shown as extra columns using the purchasing documents of imported and domestic purchases. The default scope is spending realization and the investment contribution amount.

Related reports

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 Investment Incentive Certificate Tracking Program