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
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Presidential Decisions on State Aid in Investments and Article 32/A of Corporate Tax Law No. 5520 (reduced corporate tax).
The decision period the incentive certificate is based on, the investment contribution rate and the support items are defined per certificate during installation.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| ANLAAsset Master Record | Fixed asset master; the certificate link is written to the evaluation group field | Read / write | ECC + S/4 |
| ANEPAsset Line Items | Asset acquisition transactions and value dates | Read | ECC + S/4 |
| ANLCAsset Value Fields | Cumulative acquisition value | Read | ECC + S/4 |
| EKKOPurchasing Document Header | Purchase order and vendor of the asset purchase | Read | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor country (domestic/imported split) | Read | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Machinery and equipment list file | Single value | — | No | C:\temp\tesvik_2026_5512.xlsx |
| P_BUKRS | Company code | Single value | ANLA-BUKRS | Yes | 1000 |
| P_RATE | Investment contribution rate (%) | Single value | — | No | 30 |
| P_USED | Investment contribution already used | Single value | — | No | 1250000 |
| P_TEST | Test mode (check without writing the link) | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Certificate no. | By rule Number of the incentive certificate | Yes |
| 2 | Certificate line no. | By rule Line number in the machinery and equipment list | Yes |
| 3 | Domestic / imported | By rule Domestic or imported split in the list | Yes |
| 4 | Planned amount | By rule Spending amount planned in the certificate | Yes |
| 5 | Asset | ANLA-ANLN1 | Yes |
| 6 | Sub-number | ANLA-ANLN2 | No |
Sample upload file
| 1 | Certificate no. * | Certificate line no. * | Domestic / imported * | Planned amount * | Asset * | Sub-number |
|---|---|---|---|---|---|---|
| 2 | 2026-5512 | 001 | Imported | 4,200,000 | 300001245 | 0 |
| 3 | 2026-5512 | 002 | Domestic | 850,000 | 300001246 | 0 |
| 4 | 2026-5512 | 003 | Domestic | 600,000 | 300001301 | 0 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Certificate line no. | Calculated Certificate line from the link |
| 2 | Asset | ANLA-ANLN1 |
| 3 | Asset description | ANLA-TXT50 |
| 4 | Capitalization date | ANLA-ZUGDT |
| 5 | Planned amount | Calculated Planned amount on the certificate line |
| 6 | Realized amount | Calculated Σ ANEP-ANBTR within the certificate period (acquisitions) |
| 7 | Realization % | Calculated Realized / planned × 100 |
| 8 | Investment contribution | Calculated Realized amount × P_RATE |
| 9 | Status | Calculated Matched, written, error or spending outside the certificate period |
Sample result list
| Certificate line no. | Asset | Asset description | Capitalization date | Planned amount | Realized amount | Realization % | Investment contribution | Status |
|---|---|---|---|---|---|---|---|---|
| 001 | 300001245 | CNC Dik İşleme Merkezi | 04/18/2026 | 4,200,000 | 4,365,000 | 103.90 | 1,309,500 | Written |
| 002 | 300001246 | Kompresör ve Hava Kurutucu | 05/02/2026 | 850,000 | 812,400 | 95.60 | 243,720 | Written |
| 003 | 300001301 | Konveyör Hattı | 600,000 | 0 | 0 | 0 | Error |
How does the program work?
- 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.
- Pre-checks: the asset exists in ANLA and is active, the company code is correct and the asset is not linked to another certificate.
- 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.
- 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.
- 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.
- 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
Fixed Asset Register with Book and Tax Depreciation Report
A custom ALV report that shows every fixed asset on one row with acquisition cost, accumulated depreciation, depreciation of the year and net book …
Mass Asset Retirement Upload from Excel (Scrapping and Sale)
A custom program that retires fixed assets in bulk from an Excel list, either by scrapping or with sales revenue. It supports full and partial …
WBS Budget vs Actual vs Commitment Report with Remaining Budget
A custom report that shows, for each WBS element, the current budget, plan, actual cost, requisition and order commitments, remaining budget and …
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.