Türkiye Inward Processing Authorization (DİİB) Tracking and Closure Program
Short answer: A custom program that matches raw materials imported duty-free under an inward processing authorization (DİİB) with the exports made under the same authorization, per certificate, and shows committed and realized quantities, the remaining export obligation and the certificate deadline. When the certificate is closed, the required import and export lists are prepared as a form.
- Estimated effort
- L · 10–15 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB51 lists imported raw material receipts and VF05 lists export invoices separately; neither links the movements to the authorization certificate or shows the remaining obligation against the committed quantity and the certificate deadline. Tracking is usually done in Excel files per certificate, and a shortfall in exports is not noticed until closure. The program produces the balance per certificate and the closure list from SAP data.
Who uses it? Foreign trade and import-export teams, sales operations teams, accounting teams and teams working with customs brokers.
Closest standard alternatives
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The Inward Processing Regime Decision and Export Communiqué No. 2006/12 on the Inward Processing Regime; Customs Law No. 4458.
The closure application is made through the Ministry of Trade system; the program prepares the import and export lists the application is based on.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| EKKOPurchasing Document Header | Import purchase orders under the certificate | Read | ECC + S/4 |
| EKBEPurchasing Document History | Realized goods receipt quantities of imported raw material | Read | ECC + S/4 |
| VBRKBilling Document Header | Export invoices under the certificate | Read | ECC + S/4 |
| VBRPBilling Document: Item Data | Exported materials and quantities | Read | ECC + S/4 |
| MARCPlant Data for Material | Customs tariff number (GTİP) | Read | ECC + S/4 |
| STXHSAPscript Text Header | Certificate number in the order and invoice header text | Read / write | ECC + S/4 |
BAPIs and functions used
- READ_TEXTRead Long Text. Reads the certificate number from the order and invoice text
- SAVE_TEXTSave Long Text. Writes the certificate number into the text of the export invoice assigned to the certificate
- SSF_FUNCTION_MODULE_NAMEGet Smart Form Function Module Name. Calls the closure list form
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_DIIB | Authorization certificate number | Range / multiple | — | Yes | 2026/D1-01234 |
| P_FILE | Commitment lines file (on first run) | Single value | — | No | C:\temp\diib_2026_01234.xlsx |
| S_BUKRS | Company code | Range / multiple | VBRK-BUKRS | Yes | 1000 |
| P_CLOSE | Create closure lists | Checkbox | — | No | — |
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 Certificate number issued by the Ministry of Trade | Yes |
| 2 | Line type | By rule Import or export | Yes |
| 3 | Material | VBRP-MATNR | No |
| 4 | Customs tariff no. | MARC-STAWN | Yes |
| 5 | Committed quantity | By rule Quantity permitted or committed in the certificate | Yes |
| 6 | Unit | By rule Unit of measure in the certificate | No |
| 7 | Deadline | By rule End of validity of the certificate | Yes |
Sample upload file
| 1 | Certificate no. * | Line type * | Material | Customs tariff no. * | Committed quantity * | Unit | Deadline * |
|---|---|---|---|---|---|---|---|
| 2 | 2026/D1-01234 | Import | RM-YRN-30 | 5205.12 | 120,000 | KG | 06/30/2027 |
| 3 | 2026/D1-01234 | Export | FG-TSH-100 | 6109.10 | 300,000 | ST | 06/30/2027 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Certificate no. | Calculated Certificate number from the commitment line |
| 2 | Line type | Calculated Import or export |
| 3 | Material | VBRP-MATNR |
| 4 | Customs tariff no. | MARC-STAWN |
| 5 | Committed quantity | Calculated Quantity on the commitment line |
| 6 | Realized quantity | Calculated For imports Σ EKBE-MENGE (goods receipts), for exports Σ VBRP-FKIMG |
| 7 | Remaining quantity | Calculated Committed quantity − realized quantity |
| 8 | Fulfilment % | Calculated Realized / committed × 100 |
| 9 | Days to deadline | Calculated Deadline − today |
| 10 | Status | Calculated In progress, at risk (deadline near and short), completed or closed |
Sample result list
| Certificate no. | Line type | Material | Customs tariff no. | Committed quantity | Realized quantity | Remaining quantity | Fulfilment % | Days to deadline | Status |
|---|---|---|---|---|---|---|---|---|---|
| 2026/D1-01234 | Import | RM-YRN-30 | 5205.12 | 120,000 | 96,500 | 23,500 | 80.40 | 225 | In progress |
| 2026/D1-01234 | Export | FG-TSH-100 | 6109.10 | 300,000 | 141,200 | 158,800 | 47.10 | 225 | In progress |
| 2025/D1-00877 | Export | FG-PNT-200 | 6203.42 | 80,000 | 51,000 | 29,000 | 63.80 | 34 | At risk |
How does the program work?
- The commitment lines of the certificate (certificate no., import/export line, material or customs tariff number, committed quantity, value, deadline) are read from Excel or taken from the previous run.
- Imports: purchase orders whose header text (STXH, READ_TEXT) holds the certificate number are found in EKKO; the realized import quantity comes from goods receipts in EKBE.
- Exports: export invoices whose header text holds the certificate number are read from VBRK and exported quantities from VBRP. Export invoices without the text are assigned to a certificate by user selection, and the number is written to the invoice text with SAVE_TEXT.
- The customs tariff number (GTİP) comes from MARC; matching to the commitment line is by material or tariff number.
- The fulfilment rate, remaining quantity and days to the deadline are calculated per line; certificates close to the deadline with missing exports are flagged.
- When closure is selected, the import and export lists are created as a form (PDF) and exported to Excel.
Performance notes
Read text tables limited by object and text ID; when searching for the certificate number in texts, filter the STXH headers first. Read EKBE and VBRP in bulk by the order and invoice numbers linked to the certificate.
Features
- ALV list (sort, filter, subtotals)
- Double-click drill-down to the document From a row you can drill down to the related import orders and export invoices.
- Export to Excel Closure lists can also be exported to Excel.
- Send the result by email A weekly alert e-mail can be sent for certificates close to the deadline with missing exports.
- Line-by-line result and error log
Authorization objects
- V_VBRK_VKOBilling display authorization by sales organization
- M_BEST_EKOPurchase order display authorization by purchasing organization
Frequently asked questions
Where is the certificate number kept in SAP?
In the default setup the number is kept in the header text of the purchase order and the export invoice, so it can be used without adding a field. If the company uses another field (e.g. order reference or batch characteristic), the reading logic is adapted to it during installation.
Is the conversion ratio of raw material into the export product considered?
Because the commitment lines of the certificate give import and export quantities separately, the program tracks each line with its own quantity. If needed, the raw material content of exported products can also be calculated from BOM component quantities as an extra column.
Related reports
Open Purchase Orders by Vendor Report
A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …
Subcontracting Component Consumption and Stock at Vendor Reconciliation Report
A custom ALV report that compares the planned consumption of components sent to the vendor on subcontracting orders with the consumption posted at …
Sales Order – Delivery – Invoice Status Report
A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …
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.