Kontakt

Ansicht
Dokumentation

RFEKA100 - Import DTAUS Format into Bank Data Buffer

RFEKA100 - Import DTAUS Format into Bank Data Buffer

ABAP Short Reference   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Description

You can use program RFEKA100 to process bank statement data in DTAUS format for disks (not for tapes).

Since the DTAUS format only contains a small part of the data for the financial transactions that take place in a bank account, the system must check whether the MultiCash format can be used. The MultiCash format contains all the information on a bank statement.

The DTAUS format should therefore only be used in those rare cases where an SAP user's house bank is unable to import all the 'note to payee' fields (max. 14) with MultiCash via the bank statement.

However, if you want to use the DTAUS format anyway, you must note the following:

  • The DTAUS format only contains the bank statement information that arrived at your house bank electronically (i.e. not in document form)
  • A DTAUS file contains either only credit memos or only debit memos.
  • When you use the DTAUS format, no header information from the bank statement is imported. There are no fields for the statement number, statement date, beginning balance, ending balance or currency.
    Therefore, the fields in the bank data buffer (BDB) are filled as following:
  • Statement date = disk creation date

  • Statement date = MMDDZ
    (where M = month und D = disk creation date; Z = 1 for credit memos,
    Z = 2 for debit memos)

  • Beginning balance = 0

  • Ending balance = 0

  • Currency = 'EUR'

  • You must ensure that your system is configured so that the financial transactions that were not imported in the DTAUS format are posted; if they are not, the balance of the G/L bank account will not agree with the balance of the actual bank account.
    You can do this in one of three ways:
  • Use the DTAUS format in conjunction with the MultiCash format
    With this method only the postings for posting area 2 (subledger accounts) are created with the DTAUS format.
    The postings for posting area 1 (bank postings) are created with the MultiCash format.
    Another feature of this method is that usually all the credit or debit memos imported via DTAUS are credited to or debited from a bank account as a block. Therefore the MultiCash format only ever shows a single credit and/or debit memo for each imported DTAUS file.

  • Use the DTAUS format in conjunction with the transaction for manual bank statements.
    With this method you should proceed as with the method described above.

  • Use the DTAUS format in conjunction with manual postings (employing the standard SAP transactions).
    With this method you should also proceed as with the method described above.






BAL_S_LOG - Application Log: Log header data   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 3279 Date: 20240520 Time: 104145     sap01-206 ( 52 ms )