FI Program Custom development Interface

Electronic Bank Statement Import and Automatic Posting Interface

Short answer: A custom interface program that reads the account movements banks deliver in different formats (MT940, CAMT.053, bank XML or an Excel export) every day, writes them into the SAP electronic bank statement tables, finds the customer, vendor or G/L account from the counterparty IBAN and text rules, and triggers the standard posting step. Unmatched movements land on the postprocessing list.

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

Why is the standard not enough?

FF_5 imports statements from defined formats such as MT940, but a bank's own XML, web service or Excel export has to be converted first. Standard search strings find patterns in the note to payee, but finding the customer or vendor from the counterparty IBAN, splitting one movement across several invoices or posting bank charges and similar fees to a separate account needs extra rules. The custom program converts all formats in one place, applies a rule table and keeps the standard posting and postprocessing (FEBAN).

Who uses it? Accounting teams doing bank reconciliation, treasury teams and SAP FI consultants managing bank integrations.

Closest standard alternatives

  • FF_5 Import Electronic Bank Statement. Imports statements in defined formats; bank-specific formats and IBAN-based matching need extra development.
  • FEBAN Bank Statement Postprocessing. Unmatched items are still postprocessed in the standard screen.

Tables used

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

TableRoleAccessSystem
FEBKOElectronic Bank Statement HeadersStatement header: house bank, account, statement number and date; duplicate checkRead / writeECC + S/4
FEBEPElectronic Bank Statement Line ItemsStatement items: value date, amount, external and internal transaction codeWriteECC + S/4
FEBREReference Records for Electronic Bank Statement Line ItemsNote to payee lines of the itemsWriteECC + S/4
FEBCLClearing Data for Electronic Bank Statement Line ItemsAccount type, account and clearing selection found by the rule tableWriteECC + S/4
T012KHouse Bank AccountsHouse bank accounts and their G/L accountReadECC + S/4
TIBANIBAN NumbersFrom the counterparty IBAN to bank account detailsReadECC + S/4
KNBKCustomer Bank DetailsCustomer bank accounts: finding the customer from the IBANReadECC + S/4
LFBKVendor Master: Bank DetailsVendor bank accounts: finding the vendor from the IBANReadECC + S/4
BSIDCustomer Open ItemsCustomer open items to match against incoming paymentsReadECC + S/4

S/4HANA notes

  • T012K: In S/4HANA reads of T012K go through the compatibility view V_T012K_BAM; bank accounts are maintained in Bank Account Management (BAM).
  • BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

BAPIs and functions used

  • SO_NEW_DOCUMENT_ATT_SEND_API1SAPoffice: Send New Document with Attachments. Emails the run summary to the accounting team

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_HBKIDHouse bankRange / multipleFEBKO-HBKIDNoAKB01
S_HKTIDAccount IDRange / multipleFEBKO-HKTIDNoTRY01
R_SRCSource: file folder or bank serviceRadio button—NoDosya klasörü
P_FILEFile path (for a single file)Single value—No/interface/bank/in/
P_POSTStart the posting step after importCheckbox—NoX
P_TESTTest mode (show without writing to the tables)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.

#ColumnTarget fieldRequired
1Account IBANBy rule Mapped to the house bank account in T012K; stored in FEBKO as house bank and account IDYes
2Value dateFEBEP-VALUTYes
3Amount (signed)FEBEP-KWBTRYes
4CurrencyBy rule Compared with the account currency; the row is rejected if it differsYes
5Bank transaction codeFEBEP-VGEXTNo
6DescriptionFEBRE-VWEZWNo
7Counterparty IBANBy rule Looked up in TIBAN, KNBK and LFBK to find the customer or vendorNo
8Counterparty nameBy rule Used for name matching when no IBAN is found, and shown in the listNo

Sample upload file

1Account IBAN *Value date *Amount (signed) *Currency *Bank transaction codeDescriptionCounterparty IBANCounterparty name
2TR12 0006 4000 0011 2345 6789 0111/16/2026125,400TRYNTRFPayment of invoice 2026-004512TR55 0001 0009 8765 4321 0000 11Örnek Tekstil A.Ş.
3TR12 0006 4000 0011 2345 6789 0111/16/2026-86,250TRYNTRFNovember rent paymentTR77 0004 6000 1122 3344 5566 77Demo Gayrimenkul Ltd.
4TR12 0006 4000 0011 2345 6789 0111/16/2026-42.50TRYNCHGTransfer fee
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Statement no.FEBKO-AZNUM
2ItemFEBEP-ESNUM
3Value dateFEBEP-VALUT
4AmountFEBEP-KWBTR
5CounterpartyCalculated Counterparty name from the file
6Account foundFEBCL-AGKON
7Rule appliedCalculated IBAN, invoice reference, fixed pattern or no match
8Accounting documentFEBEP-BELNR
9StatusCalculated Posted and cleared, posted, left for postprocessing or error

Sample result list

Statement no.ItemValue dateAmountCounterpartyAccount foundRule appliedAccounting documentStatus
00317111/16/2026125,400Örnek Tekstil A.Ş.300145Invoice reference1400008812Posted and cleared
00317211/16/2026-86,250Demo Gayrimenkul Ltd.200388IBAN1500004410Posted
00317311/16/2026-42.50780100Fixed pattern1500004411Posted
00317411/16/202618,700Mavi Ev Ürünleri Ltd.No matchLeft for postprocessing
A view built with fictional sample data; not real system data.

How does the program work?

  1. A source is defined for each bank account (file folder, SFTP or bank web service), and a reader class converts that bank’s format into one common structure.
  2. The house bank and account ID are found in T012K and T012; a statement that arrives twice is rejected by checking its number and date in FEBKO.
  3. A rule table is applied to each movement in order: the counterparty IBAN is looked up in TIBAN, KNBK and LFBK; if nothing is found, the invoice or reference number in the text is matched against open items in BSID; patterns for bank charges, interest and taxes are routed to fixed G/L accounts.
  4. The header is written to FEBKO, the items to FEBEP, the note to payee lines to FEBRE and the clearing information found to FEBCL; each item gets an internal transaction code.
  5. If P_POST is set, the standard bank statement posting step is started; matched items are posted and open items cleared, unmatched ones stay in FEBAN for postprocessing.
  6. A run summary (movements received, posted and left for postprocessing, with amounts) is listed and sent by email.

Performance notes

Daily movements rarely exceed a few hundred. For BSID matching, only open items in the movement's company code and within the amount tolerance are read. The job can be scheduled several times a day.

Features

  • Runs as a background job Runs automatically at planned intervals during the day.
  • Test mode (check without posting)
  • Line-by-line result and error log
  • Send the result by email The run summary and errors are sent by email.

Authorization objects

  • F_FEBB_BUKAuthorization to import and process bank statements for the company code
  • F_BKPF_BUKPosting authorization for the bank statement entries

Frequently asked questions

Can it connect to the bank's web service directly?

Yes. The reader layer depends on the source; movements can be fetched from a file folder, SFTP or the bank's API. Connection and certificate settings are managed through SAP's standard communication settings.

What if one receipt pays several invoices?

If the text contains several invoice numbers, all of them are written to FEBCL as clearing selections, and the item is cleared in one posting when the total matches. If it does not match, the item is left for postprocessing.

Can it be used on S/4HANA?

Yes. The bank statement tables and postprocessing are the same on S/4HANA, and the Fiori bank statement apps show the same data.

Related reports

FI Program Custom Interface

Daily Central Bank Exchange Rate Import Interface

A custom interface program that reads the daily exchange rates published by the central bank over the internet and writes them into the SAP rate table …

TCURR · TCURF · TCURV

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: Electronic Bank Statement Import and Automatic Posting Interface