SAP Program RFREEXACCTSTMTGENDATA - Real Estate - Create Test Data in Multicash or DTAUS Format

Shorttext
Generate test files for the electronic account statement entry for RealEstate (RE).

Use
Use these test files for the implementation of electronic bankstatements as required in Customizing settings.
Use data generated with this program (RFVIMULTI01) to
Change a view maintenance retroactively
Update the account statement files with the help of program RFVIMULTI02
Both MULTICASH and the bank processes (special DTAUS) file formats aresupported.
You can choose between simulated credit memos or returned debit memos.
These programs are only for use in the test systems!
Background:
The electronic account statement entry is used for the automaticassignment of incoming and outgoing payment flows to house bankaccounts(transfers, checks,...) to the corresponding open items (alreadyposted in the system) on customer, vendor or clearing accounts. Ifpossible these are cleared. In the case of a returned debit memo, theclearing is reversed and new open items are generated.
In the implementation phase (especially in Customizing) there areusually two obstacles that hinder a quick and efficient implementation:
Difficulties in generating account statement files (UMSATZ.TXT andAUSZUG.TXT for MULTICASH or AUSZUG.TXT for the DTAUS format). Manyimplementation errors are due to files that have not been properlygenerated and contain formatting errors.
Difficulties in using files from the bank as the files are usually verybig.
Solution:
This program allows you to calculate open items in lease-outs of anycompany code (however the system does not take account of the paymentmethod) and to simulate returned debit memos and generate the resultingaccount statement data for a house bank account.
The company code of the house bank must not be the same as the companycode on the rental agreements. If required, data generated in thismanner can be manually changed using the view maintenance before it isrecorded.
You can read in the files directly with the read-in program RFEBKA00amdtest the settings in Customizing and the general functions of programRFEBKA00.

Prerequisites
Create a house bank and a house account in the company code for thestatements for which the account statements are to be generated.
The general ledger account in the house bank account master data has tobe maintained (for example G/L account 113100).
If necessary create customers and lease-outs with open items.
For returned debit memo simulation, the clearing of open items must betriggered using, for example, a payment program.
The following external process keys have to be assigned to the processtype that is linked to the house bank:

  • MULTICASH

  • Transfer credit memo: 051
    Returned debit memo : 009
    • DTAUS

    • Transfer credit memo: 52 000
      Returned debit memo : 09 051

      Activity
      You can make the following settings on the selection screen of programRFVIMULTI01:

      • Statement Data: Enter the house bank, house account, required statement
      • date and house bank company code.
        • Lease-Out Selection: Enter a valid company code for the lease-out and
        • select the required lease-outs. The number of data records (sales) canbe set at a maximum of 3 for test purposes.
          • Required Format: Select either MULTICASH or DTAUS format.

          • Business Transactions: Specify the business transactions to be
          • simulated. If you have selected the DTAUS procedure, you can onlyimplement credit- or returned debit memos.

            Program Output
            After the test data has been generated the program issues a listcontaining an overview of information.

            • Account information: Company code and house bank account information for
            • statement files generated is displayed. The statement number needed inprogam RFVIMULTI02 is of special importance.
              • The required format is displayed.

              • Credit memos and returned debit memos: You can see what has been
              • generated. Details such as the lease-out (credit memo), clearingdocument number (returned debit memos), sales amounts and the statementdate are displayed.