SAP Note 24281 - User exit docu for electronic account statement

Symptom:

The documentation for the user exit is missing for the electronic account statement.

Reason and Prerequisites

This is caused by a transport error.

Solution
The documentation is delivered correctly as of Release 3.0!
This note contains the complete documentation.

Enhancement for the electronic account statement
Description

By means of this function exit, it is possible to analyze every line item on your electronic account statement and to add additional information.
In particular, it is possible:

1. to search for clearing information (for example, document numbers, customer numbers and so on) in every sale.

2. to change the internal activity (for example, on account of information from the note to payee),

3. to Influence account determination by means of account modification

CAUTION: If you want to post with summarization (i.e. the posting rule of the current line item allows summarization), you must not fill E_FEBEP-KFMOD. Since summarized posting posting to various accounts is not planned for the electronic account statement and would lead to errors.

4. to distribute the postings to different batch input sessions.

Link to the standard program

The electronic account statement is first imported completely into the bank data buffer. After importing, the so-called interpretation of data is carried out. During this step, every line item on the account statement is searched for clearing information by scanning the notes to payee line for document numbers or reference document numbers. After every interpretation of a individual sales by SAP modules, the function exit described here is called up. Here each customer can influence the further processing individually. After each callup of the function exit, the changed data is updated in the bank data buffer.
The actual creation of the postings is only carried out if all line items of the account statements to be processed were interpreted.

Structure of the transferred data

The function exit imports the following structures:

• I_FEBKO = header record of the electronic account statement

• I_FEBEP = line item of the electronic account statement

• T_FEBRE = table of the notes to payee

• T_FEBCL = table with clearing information

The function exit exports the following structures:

• E_XFEBKO = header record of the electronic account statement

• E_XFEBEP = line item of the electronic account statement

• E_UPDATE = indicator, whether data in the exit was changed

• E_MSGTYP = message category (E,S,W,I)

• E_MSGTEXT = message to be output

The structures FEBKO, FEBEP, FEBRE and FEBCL are defined in the Data Dictionary. Note

Note

Via the structures FEBKO and FEBEP as well as the tables FEBRE and FEBCL, you receive all data which is contained in the SAP System for an individual sale (line item) of an account statement. This is data which come from the bank (e.g. amounts) and data that was extended during the process (e.g. company code).

ad 1.: Finding and transferring clearing information

Procedure: If the standard SAP algorithms for finding clearing information are not sufficient for your purposes, you can complete or reject the information already found (FEBCL). To do this, you must evaluate information from table FEBRE. This table contains the notes to payee which were supplied by the bank for this line item.
Example:
Your customers use your pre-printed money transfer forms. In this case, you know where you can find the clearing information in the note to payee. For the automatic clearing, you either need the document number (BELNR) or the reference document number (XBLNR) or the account number plus additional information for automatic clearing, such as document date.
Once you found the document number, you can fill the table FEBCL as follows:
T_FEBCL-KUKEY = I_FEBEP-KUKEY
T_FEBCL-ESNUM = I_FEBEP-ESNUM
T_FEBCL-CSNUM = 1.
T_FEBCL-KOART = 'D' for customer
T_FEBCL-AGKON = SPACE if clearing with BELNR, no account required
T_FEBCL-SELFD = 'BELNR' the selection field is the document number
T_FEBCL-SELVON = found document number
T_FEBCL-SELBIS = SPACE only to be filled for intervals

In this case, it is not really necessary to specify the customer number. If you do it anyway, you can possibly facilitate the postprocessing of incorrect transactions in the batch input session considerably. You can then choose the correct open items from the open items of the customer.
By means of the table FEBCL, you can transfer any number of clearing information. This is necessary, for example, when a customer settles several invoices by means of one payment. Do not forget here to extrapolate the field FEBCL-CSNUM.
Once you found a customer number and a document number, you can transfer the clearing information as follows:
T_FEBCL-KUKEY = I_FEBEP-KUKEY
T_FEBCL-ESNUM = I_FEBEP-ESNUM
T_FEBCL-CSNUM = 1.
T_FEBCL-KOART = 'D'
T_FEBCL-AGKON = 'TESTDEBITOR'
T_FEBCL-SELFD = 'BLDAT'
T_FEBCL-SELVON = '19940520' for document date 20 May 1994

ad 2.: Changing the internal activity

The internal activity (field FEBEP-VGINT) determines the posting rule and the account determination. It was determined via the allocation of external to internal activities (table T028G). It can happen that not all line items, that received the same external activity from the bank, are to be updated with the same posting rule. In this case, you can allocate another internal activity to certain line items and therefore change the posting rule.
Example:
You have assigned the Telekom and the utility company for service of electronic power a collection authorization for the telephone bills or account statements. On the account statement, you then get the same external activity for both direct debits. As a result, you must use the same posting rule for both activities without function exit, since exactly one internal activity is allocated to this external activity. By means ofthe function exit, you can then filter the telephone bills from the direct debits due to the note to payee and allocate them to another internal activity. You can thus , for example, post the telephone bill with another document type than the electricity bills.

ad 3.: Influencing account determination by means of account modification

CAUTION: If you want to post with summarization (i.e. the posting rule of the current line item allows summarization), you must not fill E_FEBEP-KFMOD.
The accounts to be posted to are determined via the internal activity and by replacing the account symbols. Account determination can be additionally influenced by means of account modification (field FEBEP-KFMOD).
Example:
An insurance company has defined the account symbol GELDEINGANG for the cash receipts of the policyholders. To improve transparency, the accounting department would like to post the cash receipt postings to another cash receipt account, depending on the insurance type. The insurance type is encrypted in the first three characters of the insurance number. The policyholders pay the insurance contributions using the pre-printed money transfer forms of the insurance, on which the insurance number is printed. In the function exit, the account modification can be set equal to the first three characters of the insurance number.
The G/L account for the bank account is 113100. In account determination, the follwoing entries are made:

	Acct.symbol	Acct.modif.	Currency	G/L account
	GELDEINGANG	+	+	++++++++01
	GELDEINGANG	200	+	++++++++20
	GELDEINGANG	300	+	++++++++30

When a cash receipt occurs for the insurance numbers 200.1234.2345.11, the field FEBEP-KFMOD is set = '200' in the function exit. Thus, the postings are made to the account 113120. In case no insurance number is found with the cash receipt, the field FEBEP-KFMOD remains = SPACE and the postings are made to account 113101.
Note:
When defining the account determination, you can check with the function 'Simulation' whether your entries lead to the required result.

ad 4.: Distribution of the postings to different batch input sessions
You can distribute the postings of subledger accounting to different batch input sessions by filling in the field FEBEP-GRPNR with any two-digit identification code. The identification code is then part of the session name.