Kontakt

Ansicht
Dokumentation

RFEBBECODA00 - Convert CODA Bank Statements to MultiCash Format (Belgium)

RFEBBECODA00 - Convert CODA Bank Statements to MultiCash Format (Belgium)

Vendor Master (General Section)   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

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

Integration

Prerequisites

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

  • Electronic bank statement configuration
To use this program, 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.

If you want to post the details of line items (for example, the tax associated with the payment), you need to make appropriate settings on the report selection screen (described under Selection below, under Posting Control) and activate the User exit FEB00001 from program RFEBKA00. You must include the following code in the program:

Program ZXF01U01 :
DATA: HLP_CNT(3) TYPE P.
CLEAR T_FEBCL.
DESCRIBE TABLE T_FEBCL LINES HLP_CNT.
READ TABLE T_FEBCL INDEX HLP_CNT.
LOOP AT T_FEBRE.
IF T_FEBRE-VWEZW = 'BE-BE-DETAIL'.
T_FEBCL-KUKEY = T_FEBRE-KUKEY.
T_FEBCL-ESNUM = T_FEBRE-ESNUM.
T_FEBCL-CSNUM = T_FEBCL-CSNUM + 1.
T_FEBCL-SELFD = 'FB'.
T_FEBCL-SELVON = 'FEB_1_CODA_SPLIT_VAT'.
APPEND T_FEBCL.
T_FEBCL-CSNUM = T_FEBCL-CSNUM + 1.
T_FEBCL-SELVON = 'FEB_2_CODA_GROSS'.
APPEND T_FEBCL.
ENDIF.
ENDLOOP.
I_FEBEP-BUDAT = I_FEBEP-VALUT
I_FEBEP-KFMOD(3) = I_FEBEP-PAKTO(3)
I_FEBEP-KFMOD+3(7) = I_FEBEP-PAKTO+4(7)
E_FEBEP = I_FEBEP.
E_FEBKO = I_FEBKO.
The user exit appears in the include when you post on the value date (and not on the posting date) in the program RFEBKA00. Used if you need to assign internal or external transfers to particular posting accounts. In symbol configuration, you can assign a symbol, + bank-business partner, to a particular account number.

If you choose to post this way, the system transfers the posting details into the MultiCash file as posting text. For each detail, there is a line on the bank statement in the format AAAAAAA/999.999.999.999-/BB, where:

  • AAAAAAA : the external transaction/
  • /999.999.999.999 : amount details of the external transaction AAAAAAA
  • /BB : tax code for bank charges/

The MultiCash program identifies these details with the text BE-BE-DETAIL on its bank statement list. For example, in the case of the external transaction for the total amount 3001000 and amount 101,205, the details are listed as follows:

BE-BE-DETAIL
3001011/ 205-/V3
3001012/ 1,000-/V3
3001100/ 100,000-/V3

The external transactions of the details (3001011, 3001012, and 3001100) and the external transaction of the total amount (3001000) must be properly configured. The system posts as follows:

  • If the external transaction of the total amount (3001000) does not exist, the system does not post.
  • If the external transaction of the total amount exists and one of the external transactions of the details does not, the system posts as if there are no details.
  • If the external transaction of the total amount exists and all external transactions (in the example 3001011, 3001012 and 3001100) are also configured, the system generates a posting with several line items if the debit and credit total agrees with the total amount.

Features

The program 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. The standard RFEBKA00 program imports the MultiCash files that are generated. See the program documentation Import bank statement: MultiCash, SWIFT_MT940report (RFEBKA00) for more information on this program.

Selection

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

  • Input File
Here you specify the file to be converted. You can also enter a bank account and/or statement number as required; for more details, refer to the field help.
  • Control Data
Set the Skip Globalization Record indicator according to your requirements.
  • Output
Here you specify the names of the resulting MutiCash statement and line-item files, and whether you want output lists to be displayed and what you want to be included in the log during the posting simulation.
Recommendation
The system validates if the file path entered by the user aligns with the file system configurations authenticated for the report.
The file system configuration includes a logical file name FI_RFEBBECODA00_FILE and logical file path FI_FTE_FILE_PATH, associated with the report. You should maintain the physical file path that you need to use in this report, against the logical file path FI_FTE_FILE_PATH using transaction FILE.
For further information on maintaining the physical file path, refer to Defining Logical Path and File Names.
  • Posting Control
General Settings
  • Under General Posting Parameters, set the User Exit indicator

The coding in the program 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.
  • Under CODA Tax and Detailed Postings, if you want to post the details of line items, set the Post Detailed Information indicator and specify a valid tax code for all company codes contained in the CODA file. Ensure that the User Exit FEB00001is activated and the coding has been included in the user exit as described in the prerequistes.

The standard posting interface allows only two line items for each document (if not compressed). However, when you select this field, several detail lines are delivered for specific transactions in the CODA file.
Refer to the following example to understand how the system posts and subsequently clears the line items based on your selection.
Bank transfer abroad, bank account amount: 101,205
Details of this amount:
,,Payment 100,000 BEF
,,Charges 1,000 BEF
,,Taxes 205 BEF

Posting
If you do not set the User Exit indicator, the posting is as follows:
Debit : Foreign payments 101,205
Credit : Bank 101,205-
If you set the User Exitand Post Detailed Information indicators, the posting is as follows:
Debit : Foreign payments 100,000
Debit : Bank charges 1,000
Debit : Taxes 205
Credit : Bank 101,205

Clearing
In the example, 100,000 is paid, but a bank transaction of 101,205 occurs. In posting area 2 (subledger accounting), 101,205 is cleared. This amount generates a debit which is not the same as the credit in the foreign payments account and a clearing amount too high in the vendor account. You can correct this posting amount by setting the Clear with bank transfer amount indicator and entering a Code for bank transfer amount (such as 100); refer to the field help for more information. The clearing amount is noted on the bank statement list (of the MultiCash program) with the text Gross. In the example, the net amount is 101,205 (the transaction amount on the bank account), and the transfer amount is 100,000.
  • Currency Selection
Here you can set the Foreign Currency indicator to make the payment in foreign currency.
  • Access MultiCash Programs
Here you can specify a variant for the MulitCash program (RFEBKA00), which the system calls and runs automatically after the conversion program.

Standard Variants

Output

Activities

Example






PERFORM Short Reference   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 13079 Date: 20240520 Time: 135540     sap01-206 ( 172 ms )