Today, one can release bank statement data electronically in many countries. In Germany banks work with the Banking Communication Standard (BCS). To transfer data from the bank to the customer, both would need a transfer program (e. g. Multicash) that "understands" the BCS: Multicash "fetches" the desired data (e. g. bank statements) from the bank and creates two further data files:

• Revenue.TXT

• STATEMENT.TXT

The REVENUE.TXT contains the header data of the bank statement and the STATEMENT.TXT comprises the line items. These files can be imported in the SAP System. The system processes them automatically. You start a report that imports the files created by Multicash in the SAP System or to be more exact imports the data into the so-called bank data storage.

The transformation enriches the data of these files with SAP information for further processing (chart of accounts, company code, etc.) After the import, the system starts the analysis of the data in the bank data storage. The system attempts to identify the individual business transactions and to filter the information relevant for posting out of the as payment for fields on the bank statement such as document numbers ("interpretation of the as payment for fields).

If this succeeds, the system automatically triggers the posting (via batch input or Call Transaction). Normally all sales volume is posted automatically.

The statistics show that on average 90% of the customer data can be posted automatically. For the postprocessing of not posted revenues, you will find convenient tools in the System R/3.

Problems can arise, however, when posting incoming payments referring to customers. This can happen due to invoices not having been paid fully or due to processing bank transactions with incorrect references. In this cases, one has to manually postprocess the postings.

In customizing you can create the prerequisites so that all accounting transactions that are transferred from your bank via the electronic bank statement are posted correctly.

The program RFEBKATX supports your import of the electronic bank statement in view of the customizing settings and gives you a small insight in the opportunities of the electronic bank statement.

The electronic bank statement serves a. o. for the automatic assignment of incoming and outgoing payment flows to house bank accounts (credit transfer, checks, etc.) to the appropriate open items in the system.

The program RFEBKATX helps creating open items in a company code as well as appropriate (Multicash) bank statement files for a house bank account of the company code. These can be imported directly with the import program RFEBKA00, and this way you can test your customizing settings as well as the general functions of the program RFEBKA00.

For the import of the files with the bank statement data use the report RFEBKA00.