Ansicht
Dokumentation

RFBKPAYD - Payment Regulation List for Download to EXCEL

RFBKPAYD - Payment Regulation List for Download to EXCEL

ROGBILLS - Synchronize billing plans   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

Description

This report creates a list with payment run data from Table REGUH in order to transport this data by download to EXCEL, where it can be processed accordingly.

Requirements

The payment program SAPF110 must be started first.

Output

You can make the following restrictions in the selection screen:

Restriction to the data of particular payment runs by specifying an area, consisting of the parameters
- program run data
- identification characteristic.

Restriction to the data of particular company codes by specifying an area, consisting of the paramters
- paying company code.

Restriction to the data of particular house banks and the accounts kept there by specifying an area, consisting of the parameters
- house bank key
- account key.

All the selection parameters allow selection of valid values via the function key . If you select the valid values for one of the parameters 'Program run date' or 'Identification characteristic', the system displays an overview list for automatic payment transactions, containing the date of the payment run and the respective identification. If you select an entry from this list, both parameters are always filled in. This selection is implemented by the subroutines 'ZW_LAUFD_LOW_VAL' and 'ZW_LAUFD_HIGH_VAL'.

All the payment documents items are displayed, sorted according to company code, house bank and account code.

The output list is split up into two parts. The left part contains data on the respective house bank, such as
- name of the house bank
- bank key of the house bank
- account number at the house bank
- SWIFT code of the house bank
- bank group that belongs to the house bank
- house bank code
- account code and
- house bank currency.

The right side displays the data for the payee. This includes
- name of the payee's bank
- bank key of the payee's bank
- account number of the payee's bank
- SWIFT code of the payee's bank
- bank group to which the payee's bank belongs
- payment method key
- payment method description
- amount in local currency
- amount in payment currency
- payment currency
- instruction key for data medium exchange and
- flag indicating whether value date at payee's bank has been
specified (Y) or not (N).

The report is written such that you can download it easily to the EXCEL system using the normal default parameters set in this system. The tabulator can be used as a delimiter to distinguish the individual table cells. This is also the reason why all outputs with WRITE command have fixed positions: when the report output list is converted into an EXCEL table, all the position data is transformed into tabulators.






Addresses (Business Address Services)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 2987 Date: 20240601 Time: 183941     sap01-206 ( 47 ms )