Ansicht
Dokumentation

/PF1/PRG_FI_RCN_AUTO_PS - End-of-Day Reconciliation of Advanced Payment Management and FI

/PF1/PRG_FI_RCN_AUTO_PS - End-of-Day Reconciliation of Advanced Payment Management and FI

BAL_S_LOG - Application Log: Log header data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You can use this report to evaluate whether payment items were correctly processed and posted to a SAP ERP Financials (FI) within a specified period, such as a business day. In this way, you can identify and reconcile discrepancies.

Integration

Prerequisites

Items are posted from advanced payment management via the FI proxy class /PF1/CL_FI_ACCOUNT_GL on General Ledger accounts.

Features

When items are posted on General Ledger accounts a new document gets created in the FI system. After posting the document, important details like the posting date, the advanced payment management reconciliation date, AWKEY etc. are stored in table /PF1/DB_ITEM_FI.

This table is the starting point for /PF1/PRG_FI_RCN_AUTO_PS.

Executing the report with the reconciliation date would check if all FI postings found for that day in table /PF1/DB_ITEM_FI have a corresponding document on FI side. Executing the report with the posting date would select all items for that posting date from /PF1/DB_ITEM_FI and check for a document on FI side. The documents are identified by the reference key (BKPF-AWKEY) in the document header. This key is build by the payment item number, the payment item date and the short key for the clearing area.

For example:

A document with the reference key 00000005689109030308 was posted by a payment item with the following key:
PI number = 000000056891
PI date = 2009.03.03
Clearing area = 08

08 is the short key of a clearing area. This short key is set in the customizing of advanced payment management (Define Clearing Area).

The report checks the following:

  • Was exactly one document for a payment item created
  • Does the transaction amount match

Selection

You must select the clearing area, the account management area and and posting date or/and reconciliation date to restrict the report output.

Standard Variants

Output

Activities

Example






ABAP Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 2385 Date: 20240423 Time: 210850     sap01-206 ( 43 ms )