Kontakt

Ansicht
Dokumentation

RFVIMULTI01 - Real Estate - Create Test Data in Multicash or DTAUS Format

RFVIMULTI01 - Real Estate - Create Test Data in Multicash or DTAUS Format

BAL Application Log Documentation   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

Generate test files for the electronic account statement entry for Real Estate (IS-RE).

Use

Use these test files for the implementation of electronic bank statements as required in Customizing settings.

Use data generated with this program (RFVIMULTI01) to

  1. Change a view maintenance retroactively
  2. Update the account statement files with the help of program RFVIMULTI02

Both MULTICASH and the bank processes (special DTAUS) file formats are supported.

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 automatic assignment of incoming and outgoing payment flows to house bank accounts (transfers, checks,...) to the corresponding open items (already posted in the system) on customer, vendor or clearing accounts. If possible these are cleared. In the case of a returned debit memo, the clearing is reversed and new open items are generated.
In the implementation phase (especially in Customizing) there are usually two obstacles that hinder a quick and efficient implementation:

  • Difficulties in generating account statement files (UMSATZ.TXT and AUSZUG.TXT for MULTICASH or AUSZUG.TXT for the DTAUS format). Many implementation errors are due to files that have not been properly generated and contain formatting errors.

  • Difficulties in using files from the bank as the files are usually very big.

Solution:

This program allows you to calculate open items in rental agreements of any company code (however the system does not take account of the payment method) and to simulate returned debit memos and generate the resulting account statement data for a house bank account.
The company code of the house bank must not be the same as the company code on the rental agreements. If required, data generated in this manner can be manually changed using the view maintenance before it is recorded.
You can read in the files directly with the read-in program RFEBKA00 amd test the settings in Customizing and the general functions of program RFEBKA00.

Prerequisites

Create a house bank and a house account in the company code for the statements for which the account statements are to be generated.

The general ledger account in the house bank account master data has to be maintained (for example G/L account 113100).

If necessary create customers and rental agreements with open items.

For returned debit memo simulation, the clearing of open items must be triggered using, for example, a payment program.

The following external process keys have to be assigned to the process type 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

Activities

You can make the following settings on the selection screen, RFVIMULTI01:

  • Statement data: You can enter the house bank, house account, required statement date and house bank company code.
  • Rental agreement selection: You can enter a valid company code for the rental agreement and select the required rental agreements. The number of data records (sales) can be 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 only implement credit- or returned direct debits.

Program output

After the test data has been generated the program issues a list containing an overview of information.

  • Account information: Company code and house bank account information for the statement files generated is displayed. The statement number needed in progam 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 rental agreement (credit memo), clearing document number (returned direct debits), sales amounts and and the statement date are displayed.





BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 5226 Date: 20240601 Time: 161942     sap01-206 ( 74 ms )