Kontakt

Ansicht
Dokumentation

RFEBESCSB00 - Bank statement Spain - conversion to MultiCash format

RFEBESCSB00 - Bank statement Spain - conversion to MultiCash format

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

Title

Purpose

You use this program to convert electronic bank statements in formats CSB57 (payment lots) or CSB19.2 (return lots) into MultiCash format. If you use Contract Accounts Receivable and Payable (FI-CA), you can also have the program transfer the data to FI-CA for payment lot and return lot processing.

The program is for use in Spain only.

Integration

Prerequisites

If you have any special requirements regarding the program, you can adapt it by creating an implementation for its Business Add-In (BAdI) FI_BSTM_MC_EXIT. The BAdI has three methods:

  • MODIFY_MAPPING (modifies the mapping to MultiCash format)
  • PROCESS_MC_FILES (further processing of MultiCash files)
  • LIST_DOUBLE_CLICK (double-click event on the display list)

In addition, if you want to use the program with FI-CA, you must make a number of Customizing settings, for more information on which see Activities below.

Features

The program reads the CSB electronic bank statement file either from your PC (hard or floppy disk) or from a file system, and generates two files in MultiCash format: a statement file and a line item file. The statement file contains general data relating to the bank statement (for example, the statement number, the total debit amount, the total credit amount, the currency, and the bank account number), and the line item file contains information about the individual transactions.

Once the program has converted the statement into MultiCash format, it automatically transfers it to FI-CA, if you require (set the Further Processing indicator). There, it is processed by the Data Transfer from FI Bank Statement to Payment/Returns Lot program (RFKKKA00).

Selection

Standard Variants

Output

As well as generating the two files, the program displays two lists:

  • List of customers that want to pay by direct debit in future
If a customer decides that it wants to change its payment method to direct debit, it provides the bank with all the information (for example, its account details) that your company will need to be able to draw on the customer's account. The bank passes this information on to you in the electronic bank statement, in format CSB57. The program displays a list of all these customers sio that you can change their payment details accordingly.
  • List of records with negative amounts
Sometimes, payments are reversed, for example, if a clerk posts a payment wrongly, reverses it, and then posts it correctly. The system records these as three separate transactions, and they are displayed accordingly on the electronic bank statement. The program displays a list of all transactions with negative amounts. Payment reversals of this type can be indicated in the same file format CSB57.

Activities

To use the program to transfer the data to FI-CA, you have to configure your system as described in the following.

Create Transaction Codes

  1. Create a copy of transaction code FPB7, and call the new transaction code ZFPB17.
  2. Assign the new transaction code to program RFKKKA00, screen 1000.
  3. Save and activate the new transaction code.
  4. Call up transaction ZFPB17 to load the MultiCash files.

Customizing for Electronic Bank Statement

  1. In Customizing for FI, choose Bank Accounting -> Business Transactions -> Payment Transactions -> Electronic Bank Statement -> Make Global Settings for Electronic Bank Statement.
  2. Enter the following external business transactions:
Purpose Ext. trans +/- Int. algorithm
Credit for CSB57 in pesetas 20 + 001: Standard algorithm
Debit for CSB57 in pesetas 20- - 001: Standard algorithm
Credit for CSB57 in euros 70 + 001: Standard algorithm
Debit for CSB57 in euros 70- - 001: Standard algorithm
Notification of insufficient funds for CSB 19.2 in pesetas and euros 90 - 001: Standard algorithm

If you expect the incoming electronic bank statements to contain negative amounts and you want to post them, make sure that you maintain the external transactions for positive and negative amounts.
  1. Assign the transaction type to the bank accounts that are affected.
In the case of format CSB57, assign it to the first four digits of the house bank key, but do not enter the bank account number.

Customizing for FI-CA (Incoming Payments)

In Customizing for FI, work through the following activities under Contract Accounts Receivable and Payable -> Business Transactions -> Payments -> Incoming/Outgoing Payment Processing ...

  1. -> Define Clarification Account.
  2. -> Define Bank Clearing Accounts for Payment Lots.
  3. -> Define Transactions for Electronic Bank Statement Transfer.
Enter the external transaction code from the electronic bank statement and classify it as a payment or return.
  1. -> Define Interpretation Rules for Note to Payee.
For CSB57, you need category 1 (document number). Define a structure with the length according to your FI-CA invoice document number, and the minimum/maximum value. Then assign the selection categories, using B for document number.

Customizing for FI-CA (Returns)

In Customizing for FI, work through the following activities under Contract Accounts Receivable and Payable -> Business Transactions -> Returns ...

  1. -> Configure Internal Returns Reasons
Map the returns activities and charges.
  1. -> Assign Return Reasons to House Banks
Assign the banks' return reasons to your own returns reasons.
  1. -> Define Bank Clearing Account for Returns Lot
  2. -> Define Accounts for Returns
Enter an account for charges arising from returns.
  1. -> Define Transactions for Electronic Bank Statement Transfer

Customizing for FI-CA (Activation of Additional Function Modules)

In Customizing for FI, choose Contract Accounts Receivable and Payable -> Program Enhancements -> Define Customer-Specific Function Modules, and enter the following function modules in the corresponding events as follows:

  • Event 0950
Add function module FKK_SAMPLE_0950, which implements the customizable interpretation of note to payee for payment lots.
  • Event 0954
In the case of CSB57, the bank file does not provide enough information to identify the house bank clearing account, so create an additional function module to feed the bank clearing account and the company code. We recommend that you make a copy of the sample function module FKK_SAMPLE_0954, and implement source code such as:
move '0000572001' to C_BFKKZK-BVRKO.
move 'ES01'   to C_BRKKZK-BUKRS.
Then enter the function module in the event's Customizing.
  • Event 0960
Enter function module FKK_SELECTIONS_REFUSAL_0960, which extracts the FI-CA document number from notes to payees for return lots.
  • Event 0963
Enter function module FKK_BSTM_RETURN_REASON_0963, which extracts house banks' return reasons from notes to payees for return lots.

Example






BAL_S_LOG - Application Log: Log header data   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 9765 Date: 20240520 Time: 143710     sap01-206 ( 128 ms )