Note 591208 - Liquidity calculation: Technical documentation

Version / Date 1 / 2004-08-24
Priority Recommendations/additional info
Category Consulting
Primary Component FIN-FSCM-LP Liquidity Planer
Secondary Components


You require technical background information for the actual calculation of the Liquidity Planner component.

History: Date and release of this documentation:
August 20, 2004 for PI2003 and those following.

To control the overall liquidity in the company, it is advisable to monitor the plan/forecast/actual cycle for the inflows and outflows of funds. That was already attempted in the old R/3 product TR-CB Cash Budget Management. Since the response was somewhat cool, TR-CB is discontinued after Release 470. The alternatives provided by SAP are:

  • The liquidity planning in SEM-BPS (Strategic Enterprise Management - Business Planning and Simulation). SEM-BPS starts with the SAP Business Warehouse; it is the universal instrument for the entire Business Planning and Simulation. In this case, planning areas and layouts can be defined freely, there are several options for the data entry and for the automatic plan/plan and plan/actual integration. In addition, there are utilities for coordinating offline planning. The planning area delivered in SEM -BPS Content as an example for liquidity planning with monthly period split and liquidity items for the description of the technical origin and usage of the cash flows only shows the manual data entry and subsequent consolidation; in no way does it exhaust all the possibilities of SEM-BPS. On the contrary, SEM-BPS is a fully featured and relatively open tool whose use and implementation in a project must be worked out first for the customer.
  • Liquidity forecast in R/3 Cash Management (TR-CM). This component analyzes all flows entered in the R/3 system with regard to their payment relevancy and delivers the day and amount of the payment expected or already made. In addition, the manual entry of additional payment noted items is possible. Depending on lead time (such as between calculation and payment), this component provides a complete, and to a large extent, self-updating overview of the payments to be expected in the next days or weeks.
  • In the liquidity calculation (or analysis), the actual payments updated in the R/3 system are updated completely and classified according to origin and use. For that, liquidity items are used like in planning.

The combination of planning and actual calculation is also marketed as SAP Liquidity Planner.
The plan/forecast/actual liquidity cycle mapped by the three components specified is incomplete; specifically, the information on the technical origin and usage is missing in the forecast. Therefore, programs that can supplement a part of the forecast information with liquidity items are also delivered with the liquidity calculation as of PI2003.1. There is no procedure model yet for usefully combining these and the TR-CM data in BW to an entire forecast.
Therefore, this SAP note only addresses the core process of the liquidity calculation, the online update of the actual payments and the most important mechanisms for the assignment of liquidity items.

Other terms


Reason and Prerequisites

The liquidity calculation function is delivered with the R3 Plug-In (which was first delivery with PI2001.1); it is available for R/3 as of Release 4.5B as well as in ECC (SAP ERP).

Solution (SAP Service marketplace login required)

Key words :    , liquidity items, information lines, actual lines, liquidity calculation, query sequence, vendor   , clearing   ,   vendor , actual document, customizing flqc13, cleared lines, actual accounts, information accounts, selection options, information total, online update, clearing account, liquidity planner, selection screen, table flqitembs, query sequences, paying company, dummy items, clearing accounts, lines information, vendor lines, sample reduce, current actual, program issues, lines without, bank   , offsetting lines, actual amount, potential information, business transaction, accounting document, actual account, accounts which, function module, outgoing payments, technical origin, document project, table flqacc, totals table, sample assign, assignment program, payee parameter, other words, assignment programs, payment document,   bank ,

Related Notes
819269Amounts on buffer item in spite of clearing
731562Liquidity calculation: Enhancements in plug-in 2004.1
666327Extended reduction exit for invoices
623255Liquidity calculation: Enhancements in plug-in 2003.1
614240FLQAD: Rules for the second step
585540Error code 1 for long payment chains
558167Liquidity calculation: Enhancements in plug-in 2002.2
519465Liquidity calculation: enhancements in plug-in 2002.1
497118Modification to change table fields used in Queries
412605Implementation of the liquidity calculation