Programme SAP RFLQ_S005 - Liquidity Calculation: Statistics on First Clearing in FI

Purpose
This program helps you to assess if the FI postings in the payment areaare more linear (and therefore well suited for the mechanisms forderiving liquidity items from information in FI), or if the data isfound more in large clusters. Data in large clusters is detrimental togathering the information.

Integration
The program operates only on accounting documents (table BSEG).However, it uses the following information, if it was already main
tained in Customizing for the liquidity calculation:

  • Additional actual accounts

  • Additional info accounts
  • Prerequisites
    Accounting documents have to exist.

    Features
    The program works like this:
    First, it reads the actual line items per the selections made. Then itgets the complete documents for these items. The items of thesedocuments are classified into:

    • Actual items (this means at least those originally selected)

    • Info items

    • Other items: with clearing

    • Other items: open

    • The number of each type of item is displayed in the results log (1stblock). The ratio of actual items to actual documents (among otherinformation) helps provide initial information about the amount ofclustering. The ideal ratio is 1:1, that is, each actual document hasexactly one actual item.
      In the second step, the program considers further only those actualitems with a document that contains a cleared item (that is, neither anactual item nor an info item). The program collects the clearing points(account, clearing amount, and date) in these documents.
      For each clearing point, the program gets the cleared items. Then theoffsetting line items (in the given documents) are classified asexplained above.
      This appears in the second block of the results log.
      For the assessment, it can be viewed as positive if there is arelatively large number of clearing points, and only a small number ofactual items appearing for the first time. Both of these indicate thatclusters are probably small. If only a few cleared line items remain,this is also good (short chains). If a large number of cleared itemsremain here, then the ability of this report to provide helpfulinformation is limited, since the next steps of the program are notperformed.
      Last, the log shows statistics on the number of actual documents orclearing points that contain more than one actual line item. Suchactual documents and clearing points, with the exception of actualtransfer postings, are likely to cause problems during retrieval ofinformation.

623255Liquidity calculation: Enhancements in plug-in 2003.1