Interpretation Algorithms (SAP Library - Electronic Account Statement (FI-BL))

Interpretation Algorithms

The following algorithms are available:

000 (No interpretation)

You use this algorithm if you do not want to use the standard algorithms supplied by SAP. If this is the case, the system calls up the algorithms you defined yourself, in conjunction with functional enhancements (user exits).

001 (Standard algorithm)

Algorithm 001 interprets the values in the note to payee fields of the electronic account statement as either document numbers or reference document numbers. In the process, it checks whether the values are in the document/reference document number ranges you entered when importing the account statement. If (and only if) they are, it then tries to find the items to be cleared in the system.

Note that you must prescribe the possible intervals for documents/reference documents using the values "BELNR number range" and "XBLNR number range" in the selection screen for importing the electronic account statement.

If the reference document was stored with leading zeroes in the system, the system can find a line item only if the reference document number in the account statement is imported with these leading zeroes. If, on the account statement import selection screen, you were to enter 00100 - 00200 as the interval, the system does not find the value if the reference document number is simply 100.

011 (Outgoing check: Check number not identical to document number)

This algorithm is used for payments by check if the bank uses pre-numbered checks. Your house bank supplies the check number in the account statement. The algorithm uses the check number to find the appropriate document number.

012 (Outgoing check: Check number identical to document number)

You use this algorithm for payments by check if checks are printed using forms that do not yet contain a check number. The SAP document number is then printed on the check as the check number. Your house bank confirms this check number on the account statement. The algorithm finds the check number (which in this case is the same as the document number) in the note to payee lines in the statement.

On the selection screen for importing electronic account statements, you must specify the possible number ranges for the document number search (see algorithm 001).

013 (Outgoing check: Check number identical/not identical to document number)

This algorithm finds the check number in the note to payee lines either per algorithm 11 or per algorithm 12.

015 (Clearing transaction: Selection per assignment number)

This algorithm enables you to clear open items according to the assignment number:

- If the posting rule in question permits clearing, the system selects the items for clearing according to the assignment number.

- If the posting rule in question does not permit clearing, the system writes the bank reference (check number for example) as the assignment number in the line item of the posting on account.

Then, at a later date, you can use report SAPF123W to clear the item automatically via the assignment number.

These algorithms have the following limitations:

- The system can only clear an item by means of the assignment number if it can locate the account to be cleared (the bank data in the case of customers/vendors or the posting rule in the case of G/L accounts).

- To select items using the assignment number, the system uses the Bank reference or Check number field from the account statement. (If there is no entry in this field, it uses the start of the Note to payee field.) Check whether these fields contain the information that the system requires to be able to find open items in the relevant account.

- Since the assignment number is a text field, the information in the account statement may not be correctly formatted. If you want selection to take place using the assignment number even though the information in the account statement is missing or not in the correct format, you can use the customer exit to enter data in the Check number field FEBEP-CHECT).

019 (DME administration reference number)

You use this algorithm to import those account statement line items that relate to a previous payment run. All the items for a payment medium generated by the payment program are summarized by means of a DME (data medium exchange) reference number. Your house bank confirms the overall total for the line items, together with the DME reference number. The algorithm finds the DME reference number in the note to payee lines in the account statement. The reference number is used to find and clear all the line items in the system.

020 (Document number search)

Algorithm 020 functions in the same way as algorithm 001, except that it interprets the contents of the note to payee fields only as a document number.

021 (Reference document number search)

Algorithm 020 functions in the same way as algorithm 001, except that it interprets the contents of the note to payee fields as a reference document number only.

022 (BZÜ bank transfer method (Germany only) with document number)

Algorithm 022 refers to the BZÜ procedure (payment form transfer without documents). Under this procedure, a billing system creates a transfer form that contains a thirteen digit number in the coding line. This number normally consists of the document number and a check digit and is returned by your house bank. This algorithm cuts off the check digit and interprets the number (right-aligned) as document number.

023 (BZÜ bank transfer method (Germany only) with reference document number)

This algorithm also refers to the BZÜ procedure (payment form transfer without documents). Under this procedure, a billing system creates a transfer form that contains a thirteen digit number in the coding line. This number normally consists of the reference document number and a check digit and is returned by your house bank. This algorithm interprets the number (including the check digit) in the note to payee fields of the electronic account statement as a reference document number.

You define the interpretation algorithm under the Customizing activities for the electronic account statement. In Customizing for Bank Accounting, choose Business Transactions ® Payment Transactions ® Electronic Account Statement ® Make Global Settings for Electronic Bank Statement ® Assigne External Transaction Codes to Posting Rules. For each external transaction, you then define which interpretation algorithm is to apply. For more information, see Assigning External Transactions.

If the standard algorithms supplied by SAP for interpreting note to payee fields do not meet your requirements, customer exits can be programmed which do so. These exits do not involve any modification to the standard system.

026 (Search for reference document number with leading zeros, if < 10).

You can use this algorithm if the ten digit reference number in the account statement does not contain leading zeros (if for example the reference document number in the statement is 100 and not 0000000100). This algorithm works in three stages:

a. As with algorithm 021, algorithm 026 reads the Note to payee field searching for possible reference document numbers. (Number range XBELNR on the selection screen following import of the account statement).

b. In contrast to algorithm 21, algorithm 026 enters ten digits by adding leading zeros.

c. Finally, it compares the reference document numbers from the account statement with the reference document numbers in the system.

027 (Reference number TITO)

This algorithm searches for the Payment reference supplied by the Finnish TITO account statement format.

028 (Reference number per MULTICASH conversion programs)

This algorithm is the same as algorithm 027. The account statement files are imported in MULTICASH format. The algorithm uses number range BELNR.

029 (Payment order number)

This algorithm searches using the payment order number. The algorithm uses number range XBELNR.

030 (Brazil)

Applies where the electronic account statement is implemented in Brazil. It searches for the document number, the fiscal year, and the number of the line item within the accounting document.

031 (Document number search (customer number in line item))

This algorithm functions in the same way as algorithm 020 (document number search). Here are some exceptions:

If the system can identify the business partner from a document number entered in the Note to payee field, then you have the system add the bank details to the master data. This facility also exists with algorithm 021. Since the account statement normally contains the bank details, these details can be used to supplement the master data. You can use report RFEBKA80 to generate a file containing customers’ bank details and add this data to the master records using report RFBIDE00. For more information, see the documentation for these programs.

Where an alternative payer is specified, the bank details contained in the account statement are not those of the business partner to which the document number previously found in the note to payee refers. The bank details in question are not added to the correct business partner.

This algorithm is used automatically to create payment advice notes when importing account statements. The system creates a payment advice note if, when importing the account statement data, it could not clear every open item right away (for example because it could not find every document number contained in the Note to payee field). The payment advice note contains the document numbers the system found, and can be used to post the account statement items if you enter the missing document numbers yourself.

It is possible that the individual document number or payment advice note items relate to different business partners. If this is the case, these items are only automatically assigned to the correct business partner if you use algorithm 031. If you use algorithm 21, you need to add the correct business partner information to each individual payment advice note items.

040 (Treasury (TR): Standard search followed by loan search)

You can use this algorithm if you implement the Treasury Management (TR-TM) application component. The system first runs algorithm 001 (document and reference number search). If this search is unsuccessful, it then searches for Treasury documents. A Treasury customer exit is used here.

To search for Treasury documents, the Treasury customer exit must not be activated.

041 (Treasury: Search for loan, then standard search)

As for algorithm 040 above, except that the search is carried out in the reverse order.