SD Program Custom development Form TR · Türkiye

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

  • MB51 Material Document List. Lists imported raw material receipts; does not link them to the certificate and its commitment.
  • VF05 List Billing Documents. Lists export invoices; does not show the remaining export obligation per certificate.

Localization and legal basis

Tables used

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

TableRoleAccessSystem
EKKOPurchasing Document HeaderImport purchase orders under the certificateReadECC + S/4
EKBEPurchasing Document HistoryRealized goods receipt quantities of imported raw materialReadECC + S/4
VBRKBilling Document HeaderExport invoices under the certificateReadECC + S/4
VBRPBilling Document: Item DataExported materials and quantitiesReadECC + S/4
MARCPlant Data for MaterialCustoms tariff number (GTİP)ReadECC + S/4
STXHSAPscript Text HeaderCertificate number in the order and invoice header textRead / writeECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_DIIBAuthorization certificate numberRange / multiple—Yes2026/D1-01234
P_FILECommitment lines file (on first run)Single value—NoC:\temp\diib_2026_01234.xlsx
S_BUKRSCompany codeRange / multipleVBRK-BUKRSYes1000
P_CLOSECreate closure listsCheckbox—No—

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 Certificate number issued by the Ministry of TradeYes
2Line typeBy rule Import or exportYes
3MaterialVBRP-MATNRNo
4Customs tariff no.MARC-STAWNYes
5Committed quantityBy rule Quantity permitted or committed in the certificateYes
6UnitBy rule Unit of measure in the certificateNo
7DeadlineBy rule End of validity of the certificateYes

Sample upload file

1Certificate no. *Line type *MaterialCustoms tariff no. *Committed quantity *UnitDeadline *
22026/D1-01234ImportRM-YRN-305205.12120,000KG06/30/2027
32026/D1-01234ExportFG-TSH-1006109.10300,000ST06/30/2027
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Certificate no.Calculated Certificate number from the commitment line
2Line typeCalculated Import or export
3MaterialVBRP-MATNR
4Customs tariff no.MARC-STAWN
5Committed quantityCalculated Quantity on the commitment line
6Realized quantityCalculated For imports Σ EKBE-MENGE (goods receipts), for exports Σ VBRP-FKIMG
7Remaining quantityCalculated Committed quantity − realized quantity
8Fulfilment %Calculated Realized / committed × 100
9Days to deadlineCalculated Deadline − today
10StatusCalculated In progress, at risk (deadline near and short), completed or closed

Sample result list

Certificate no.Line typeMaterialCustoms tariff no.Committed quantityRealized quantityRemaining quantityFulfilment %Days to deadlineStatus
2026/D1-01234ImportRM-YRN-305205.12120,00096,50023,50080.40225In progress
2026/D1-01234ExportFG-TSH-1006109.10300,000141,200158,80047.10225In progress
2025/D1-00877ExportFG-PNT-2006203.4280,00051,00029,00063.8034At risk
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. 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.
  3. 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.
  4. The customs tariff number (GTİP) comes from MARC; matching to the commitment line is by material or tariff number.
  5. The fulfilment rate, remaining quantity and days to the deadline are calculated per line; certificates close to the deadline with missing exports are flagged.
  6. 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

MM Report Custom ALV report

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 …

EKKO · EKPO · EKET · LFA1

SD Report Custom ALV report

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 …

VBAK · VBAP · VBFA · LIKP

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 Inward Processing Authorization (DİİB) Tracking and Closure Program