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

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

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

  • Electronic bank statement configuration

  • To use this report, you need to configure the standard electronic bankstatement in Customizing for Financial Accounting (FI), by choosing BankAccounting -> Business Transactions -> Payment Transactions ->Electronic Bank Statement -> Make GlobalSettings for Electronic Bank Statement.
    To process the converted files using the Bank Statement:Various Formats (SWIFT, MultiCash, BAI...) make the settings asdescribed in its report documentation.
    Bank log number and external transaction number
    To convert the external transactions into internal ones, maintain thebank log number, external transaction number, and their mappings. EachBelgian bank has its own log number and certain external transactionshave their own contents. Therefore, the system must convert externaltransactions into internal ones.
    Beispiel
    External transaction: 0150000, Bank log number: 999
    First time the system reads the table as XX 0150000999 (XX identifiesthe bank account number internally)
    Second time it reads as XX 0150000
    If the system completes the first reading successfully, this value istransferred to the converted file (015000999 in the example), otherwisethe value from the second reading is used (0150000).
    This option allows you to differentiate only external transactions inwhich multiple banks have allocated different contents to the sametransaction.
    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, andthe currency key differentiates these accounts. Therefore, specify thebank account currency for a house bank account. You must also define theG/L account for a bank account.

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

    Selection
    Enter data as required in the following group boxes on the selectionscreen:

    • Bank Account

    • Here, you enter a bank account number. For more details, refer to thefield 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 theposting 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 andline-item files. You can also specify a variant for the DataTransfer from Bank Statement to Payment/Returns Lot (RFKKKA00)report, which the system calls and runs automatically after theconversion program. If you set the Further Processing indicator,the report automatically transfers the resulting MultiCash statement toFI-CA.