Ansicht
Dokumentation

RFKKBEINC000 - Convert CODA Bank Statements to Multicash Format (Belgium)

TXBHW - Original Tax Base Amount in Local Currency   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Purpose

You use this report to convert the CODA 2.1, CODA 2.2, and CODA 2.3 bank statements to MultiCash format. The report imports a CODA file from the file system and generates MultiCash files. This report is for use in Belgium only.

Integration

Prerequisites

You need to make the following Customizing settings:,,,,

• Electronic bank statement configuration

To use this report, you need to configure the standard electronic bank statement in Customizing for Financial Accounting (FI), by choosing Bank Accounting -> Business Transactions -> Payment Transactions -> Electronic Bank Statement -> Make Global Settings for Electronic Bank Statement.

To process the converted files using the Bank Statement: Various Formats (SWIFT, MultiCash, BAI...) make the settings as described in its report documentation.

• Bank log number and external transaction number

To convert the external transactions into internal ones, maintain the bank log number, external transaction number, and their mappings. Each Belgian bank has its own log number and certain external transactions have their own contents. Therefore, the system must convert external transactions into internal ones.

Example

External transaction: 0150000, Bank log number: 999

First time the system reads the table as XX 0150000999 (XX identifies the bank account number internally)

Second time it reads as XX 0150000

If the system completes the first reading successfully, this value is transferred to the converted file (015000999 in the example), otherwise the value from the second reading is used (0150000).

This option allows you to differentiate only external transactions in which multiple banks have allocated different contents to the same transaction.

Note

This parameter has no effect on detailed posting items.

• House bank and house bank accounts

Some banks use the same account numbers for different bank accounts, and the currency key differentiates these accounts. Therefore, specify the bank account currency for a house bank account. You must also define the G/L account for a bank account.

Features

The report imports a CODA file from a PC (hard or floppy disk) or from a file system. It generates two MultiCash files. The statement file contains data of the statements (statement number, old balance, new balance, currency, bank account number, and so on), and the line item file contains the individual statement transactions. Once the report has converted the statement into MultiCash format, it automatically transfers it to FI-CA if you set the Further Processing indicator. There, it is processed by the Data Transfer from Bank Statement to Payment/Returns Lot (RFKKKA00) report.

Selection

Enter data as required in the following group boxes on the selection screen:

• Bank Account

Here, you enter a bank account number. For more details, refer to the field help.

• Input Files

Here you specify the file to be converted.

• Lists

Here you specify whether you want output lists to be displayed.

• Posting Simulation

Here you specify what you want to be included in the log during the posting simulation.

• General Posting Parameters

Under General Posting Parameters, set the User Exit indicator

The coding in the report is as follows:

LOOP AT T_C31.

IF T_C31-COMIF = '1' AND

IF (T_C31-COMM1 (3) = '001' )OR (T_C31-COMM1 (3) = 002).

T_VWZ = T_C31-COMM1+3.

APPEND T_VWZ.

ENDIF.

ENDLOOP.

E_AGKTO = I_AGKTO.

E_AGBNK = I_AGBNK.

• CODA Output File

Here you specify the server in which you want to save the output file.

• FICA: Multicash Files

Here you specify the names of the resulting MutiCash statement and line-item files. You can also specify a variant for the Data Transfer from Bank Statement to Payment/Returns Lot (RFKKKA00) report, which the system calls and runs automatically after the conversion program. If you set the Further Processing indicator, the report automatically transfers the resulting MultiCash statement to FI-CA.

Standard Variants

Output

Activities

Example

BAL_S_LOG - Application Log: Log header data   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 5831 Date: 20240601 Time: 055921     sap01-206 ( 83 ms )