Automatic Bank File Reception (SAP Library

Automatic Bank File Reception

Files in the format SISPAG Itaú, PFEB (Banco Bradesco) and Febraban/CNAB can be automatically read and processed by the Brazilian localization. This includes the simultaneous processing of different payment forms.

The automatic file reception is based on the standard bank account statement. For the bank account statement, choose the following Customizing paths:

Import: Treasury ® Cash Management ® Basic Functions ® Input ® Electronic bank statement ® Import
Post processing: Treasury ® Cash Management ® Basic Functions ® Input ® Electronic bank statement ® Post processing
Display: Treasury ® Cash Management ® Basic Functions ® Input ® Electronic bank statement ® Display

For standard bank account statement functionality, see the standard R/3 documentation.

Unlike for A/R, the clearing occurs on a G/L account, preferably on a bank subaccount. Therefore, the relevant document number to search for clearing is the payment document number generated through the payment run.

Beyond the standard functionality, i.e. automatic posting and clearing, the Brazilian localization offers the following:

Status update on rejected and confirmed payments
Automatic reversal of rejected payments on the bank subaccount and of the corresponding clearing on the vendor account. The automatic reversal is posted immediately regardless whether you used batch input or immediate processing.
In post-process mode, drill-down to documents still to be posted.

Base Customizing for the file formats SISPAG Itaú and PFEB (Banco Bradesco) is part of the Brazilian localization. This includes the definition of SAP-internal transaction codes, the allocation to external transaction codes used in the SISPAG Itaú format, and the required rules for postings.

When using the Febrahan/CNAB layout, the same Customizing may be used as for Banco Itaú.

For Customizing, see electronic bank account statement.

In addition, the following maintenance has to be considered:

Error codes

Customizing follows standard electronic bank account statement Customizing

Only for PFEB (Banco Bradesco): The external transaction, i.e. the return code from the bank, is customized as a composition:

P (fixed), 1 character
'Tipo de processamento' in the file header, 1 character
'Nive' in the detail record, 1 character
'Situação de pagamento' in the detail record, 2 characters

Tipo de processamento = 1

Nivel = 2

Situação de pagamento = 02

External transaction = P1202

When introducing new external transaction codes, it is advisable to maintain the interpretation algorithm '20' for all transactions.