Kontakt

Ansicht
Dokumentation

FIN_AR_QUERY_CACHE_UPD - Update Cache for CPU-Intensive DB Queries

FIN_AR_QUERY_CACHE_UPD - Update Cache for CPU-Intensive DB Queries

PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

This report updates the cache for CPU-intensive database queries. The cache is used by the Home Page Accounts Receivable Accounting application for the following CHIPs:

  • Top n customers with overdue outstanding amounts
  • Payment differences by reason code
  • Top n customers for each dunning level
  • Outstanding amounts by dunning level
  • Key figure: future outstanding amounts

In addition, it is also used for some key figures for the SAP Receivables Manager mobile app and for report FIN_AR_DUE_DATE_GRID.

Integration

While these applications are being used, the database queries and their results are buffered in the cache. You set how long a buffered result is valid in the Configuration of the Cache. Once this time has elapsed, the individual data record is updated during the next access.

If you have set a short retention period, it is not necessary for you to schedule this report, as the buffered results are kept up to date by being used.

For a longer retention period (such as several hours), it makes sense to schedule this report at regular intervals, so that the cache contains current data for times when many users start the applications mentioned above.

Prerequisites

Features

This report carries out the following steps:

  • It cleans up the cache by deleting entries that have not been used and for which the validity has expired.
  • It executes the database queries that have been used by users again, and places updated results in the cache.

If you start the report shortly after a previous run, it does not delete any entries, but updates them even if they have not yet been used.

While it is running, all applications that use the cache can be used as normal.

Selection

Standard Variants

Output

Activities

Example






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

Length: 2586 Date: 20240531 Time: 145305     sap01-206 ( 38 ms )