SAP ABAP IMG Activity REFX_CFMEUNUOFDICASH (Electronic Account Statement Entry)
Hierarchy
EA-FIN (Software Component) EA-FIN
   RE-FX (Application Component) Flexible Real Estate Management
     RE_CA_CU (Package) RE: Customizing (IMG) and Area Menu
IMG Activity
ID REFX_CFMEUNUOFDICASH Electronic Account Statement Entry  
Transaction Code S_PLN_06000357   (empty) 
Created on 20030702    
Customizing Attributes REFX_CFMEUNUOFDICASH   Electronic Account Statement Entry 
Customizing Activity    
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name REFX_CFMEUNUOFDICASH    

Prerequisites

The Business Transaction Events (BTE) must be active. Check the following setting:

  1. Start transaction FIBF.
  2. Choose Settings --> Identification --> SAP Applications.
  3. Check whether the Active field is set for the Real Estate (RE-FX) application.

Procedure

In RE-FX you can automatically process incoming payments and returned debit memos using account statement entry with different file formats (such as MultiCash or DTAUS).

The method is based on the standard function electronic account statement entry in Financial Accounting (FI). The IMG activities are in Customizing for Financial Accounting under Bank Accounting and are also summarized in RE-FX.

Account statement entry is divided into three steps:

  1. File import
  2. Analysis of the note to payee for each line item
  3. Corresponding postings

Since RE-FX intervenes in the standard FI function (to assign an incoming payment directly to a contract, for example), the Customizing settings for the individual steps are explained in the following.

1. File Import

Make the settings for the electronic account statement, particularly:

  1. Enter the house bank and the corresponding house bank accounts.
  2. Make the global settings for the electronic bank statement:
    • Create account symbols and assign accounts.
    • Create posting rules and assign them to the external transactions (see step 2 Analysis of Note to Payee).
  3. Configure returns processing

For more information, see the documentation for the individual IMG activities.

2. Analysis of Note to Payee

There are a number of standard and application-specific interpretation algorithms available for analyzing the note to payee of a line item.

To assign incoming payments, standard FI (interpretation algorithm 001) carries out a search for a document number or a reference document number of the open item.

Tenants, however, do not usually know the document number, so they will enter the rental agreement number as the assignment criterion in the Note to Payee field.

  • To interpret the data on the data medium differently from the standard procedure, assign the Real Estate-specific interpretation algorithm (051) in the activity Make Global Settings for Electronic Bank Statement under Assign External Transaction Types to Posting Rules.

    If you have entered the RE-specific algorithm 051 for a bank account and an external transaction, the RE-specific analysis of the note to payee in BTE (see Prerequisites) is run. Otherwise the module is exited and other applications (such as Treasury) can register for the transaction.

  • With returned debit memos, FI standard processing is used (see Configure Returns Processing). You should nevertheless enter the RE-specific algorithm 051 for this transaction because only then can the search for a clearing document number find the RE agreement and transfer it to the subsidiary ledger document. This makes it possible to assign the new open item and any fee to the agreement.

Note: The interpretation algorithm 050 REAL ESTATE: First Standard, Then Rental Agreement Search is a setting for Classic RE and triggers the same search in RE-FX as for algorithm 051.

3. Corresponding Postings

  • If the incoming payment could be assigned to a rental agreement, the system now searches for the open items of the customer for that rental agreement.
  • If their sum is greater than the incoming payment, the open items are sorted according to rules that you define in Customizing. The open items are cleared in the predefined sequence until the incoming payments are depleted.
  • If a difference remains, you can specify in the IMG whether an unqualified down payment or a new residual item should be posted.
    • You make the settings for account determination for the unqualified down payment in the IMG activity of Financial Accounting with the transaction EINZAHL: Define Posting Keys for Clearing
    • Overpayments are posted to the customer account with this account determination.
    • For new residual items, check the indicator in the IMG activity of RE-FX: Basic Settings in Company Code.
    • If the residual items indicator in the company code is set, open items are partially cleared and a new open item is posted for the remainder
      If the indicator is not set, an unqualified down payment is posted.

Business Attributes
ASAP Roadmap ID 203   Establish Master Data 
Mandatory / Optional 1   Mandatory activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG REFX_CFMEUNUOFDICASH 0 ALN0000042 Rental Accounting 
Maintenance Objects
Maintenance object type    
History
Last changed by/on SAP  20030702 
SAP Release Created in 200