Skip to Content
Author's profile photo Gustavo Vazquez

Liquidity Planner – Tips

In this document we will analyze different functionality of Liquidty Planner

1. Create Query

2. Delete & Recreate Data

3. Liquidity Analysis

4. Structured Reports

5. List GL Accounts

6. Transfer Information from one client to another

7. Forecast

1. Create Query

Onte of the functionalities of Liquidity Planner is the possibility of creating queries, this means redirect the natural flow of the document chain to a Liquidity Position because of external conditions. Once a query condition is met, FSCM-LP stops searching for the next level and replaces the Liquidity Position with the one in the query

a) Create a query

b) Assign the query to a Query Sequence

a) Create a Query

If you create a query you define the Liquidity Position and the query conditions which will re-assing the new Liquidity Position

07-03-2016 12-17-37.jpg

There are to types of queries from the origin conception. Origin C is for payment documents (Vendor/Customers) in the document chain, and D are for G/L Accounts (Incomes & expenses Accounts). Depending on what query do you want to create you will have the following trx

Transactions

Origin C

      • FLQQC1         Create a Query
      • FLQQC3         Display Query
      • FLQQC5         Assign a query to a query sequence
      • FLQQC7         Test a query

Origin D

      • FLQQD1         Create a Query
      • FLQQD3         Display Query
      • FLQQD5         Assign a query to a query sequence
      • FLQQD7         Test a query

Each query needs:

    • Name
    • Description
    • Liquidity Position
    • Conditions

if we click on Conditions, we  will see

07-03-2016 12-26-13.jpg

There are different areas from where you can obtain information, Accounting Document & Vendor/Customer Master Data.

b) Assign the query to a Query Sequence

In trx FLQAD/FLQAF you don’t have query names, instead you have query sequences which is a group of querys. Query sequence (as well as queries) can be defined for a company group or all companies; only condition is if a query is defined for a company code then query sequence should also be for the company code. The query sequence is done in customizing


Transactions


FLQCB      Create Query Sequence for FI Mechanism (Origin C)

FLQC11     Create Query Sequence for Invoices (Origin D)


Once the query sequence is created, you can assign queries and use them in FLQAD/FLQAF

07-03-2016 12-40-16.jpg



2. Create and Delete Data


Sometimes there is the need to delete all data and start from scratch. Thes 2 trx will help you do that


FLQC9        Delete all Liquidity Information

FLQC10      Reconstruct Liquidity Information



3. Liquidity Analisys


In ECC 6.0 EhP7, in FLQAD you have the radio button “Analysis” that will show how the systems reconstructs the document chain


In ECC EhP6 and earlier versions you will run program RFLQ_REXCHAIN which will reconstruct document chain the same way as FLQAD


4. Structure Reports


Liquidity Reports (FLQLS, FLQREP) does not offer a structured report; this means all expenses / incomes are not grouped by their origin, they are only listed alphabetically according to Liquidity Positions. You would like to group them according to their origin.


Apply sap note 998071


5. List GL Accounts


When analyzing LP reports you would like a tool to determine the G/L Account and its Liquidity Position for faster analysis.


FLQLACC


6. Transfer information from one client to another


Not all information is transfered by customizing, ie: FLQINFACC . You would like to transfer it from one system to another


FLQUPINFAC      Download/Upload FLQINFAC information

FLQUPQR            Download/Upload Queries

FLQUPGRP          Download/Upload Query Sequences (defined in FLQQD5 or FLQQC5)


7. Forecast


If you have concluded your liquidity analysis fro actuals and would like to determine forecast information, here are the programs:


RFLQ_CASH_FORECAST_FIN            Liquidity Calculation: Forecast from Accounting (Open Items)

RFLQ_CASH_FORECAST_MMPO        Liquidity Calculation: Forecast from MM PO and Scheduling Agreemen

RFLQ_CASH_FORECAST_MMPR        Liquidity Calculation: Forecast from MM Purchase Request

RFLQ_CASH_FORECAST_SDSO         Liquidity Calculation: Forecast from Sales Orders

RFLQ_CASH_FORECAST_TRD1          Liquidity Calculation: Forecast from Loans (FS-CML)

RFLQ_CASH_FORECAST_TRT1          Liquidity Calculation: Forecast from TR Transactions (FSCM-TRM)


RFLQ_DELETE_FC                               Liquidity Calculation: Delete Forecast Data (forecast – cleared documents)

RFLQ_REPORT_FC                              Liquidity Calculation: Forecast per Liquidity Item Report

In EhP7 you have trx FLQF1, FLQF2 & FLQF3 which cover some of the functions mentioned before.

If you want a comparison between actuals and forecast, you will need SAP BI/BO

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear Gustavo Vazquez,


      Excellent blog .. Great Job 🙂


      We have a scenario to show only the bank balances in the liquidity forecast report, what is the origin type i have to apply for this requirement.



      With Origin D - i tried to bring main bank balance in the report wich is not working at all,Origin C - I am able to see the chain upto bank statement processing for vendor invoices not the consolidated bank balance.


      Appreciate if you have any suggestion to achieve my requirement. 



      Regards,

      Naresh.


      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hi Naresh,

      Good to hear you liked the document.

      For Open/Closing Balance in Bank Accounts try report RFLQ_BALANCE_CF. and sap notes 922475, 1773752 . I don't have a system to test it 🙁

      Hope this helps.

      Kind Regards

      Author's profile photo Mithlesh Singh
      Mithlesh Singh

      Dear Gustavo,

      The queries created in FLQQD1 and FLQQC1 are only working when we registered the account number in FLQINFACC transaction. Is it required to registered the account in FLQINFACC for the query to be worked.
      Best regards,
      Mithlesh

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hi Mitlesh,

      Yes, you need the GL account in trx FLQINFACC .
      As most of my queries have been on Customer/Vendor level, I have already assigned them.

      If you create a query you define the Liquidity Position and the query conditions which will re-assign the new Liquidity Position.

      Kind Regards

      Author's profile photo Merve K.
      Merve K.

      Hi Gustavo,

      Thank you for that well explained document.

      I have an issue in liquidity item which is we have two documents and these documents are exactly the same, there is no difference at all; For 2020 document's Liq. The item seems wrong. I mean it shoud be OC-20-35. When I look at the screen below the only difference is document type. The system brought the vendor invoice document type (RC) but it's cleared document. What is the main problem? How should I control?

      Best Regards,

      Merve

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hi Merve,

      They should be cleared in some way to be related. May be its not  a Vendor clearence but a GL Account. Try to reconstruct Chain with program RFLQ_REXCHAIN

      Kind Regards

      Author's profile photo Merve K.
      Merve K.

      Hi Gustavo,

      Thank you so much for your response. I guess it's for Hana. Our system is R3. Another question is while the derivation, which one was derived first? Vendor/customer or GL accounts? I mean in the system, what is the sequence?

      Best Regards

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      This document is for R3, there is another solution for S4.

      Check blog Liquidity Planner Configuration | SAP Blogs
      Check sapnotes 751407, 685341.
      Which version of R3 are you on ?

      Author's profile photo Santafarma Support
      Santafarma Support

      Hi Gustavo,

      your articles are very helpful...

      I'm looking for a report that I can match with the RFLQ_CASH_FORECAST_MMPO report in the MM module.

      I tried comparing it with the ME2L report, but the LP report returned very different amounts.

      Can you suggest me a report where I can compare MM module and LP open PO..

      Thank you very much..

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hi,

      I don't think there is a report from the MM side.You could have the invoice but not the payment date.

      On FI you could check for FF7A with similar functionality.

      Kind Regards

      Author's profile photo Santafarma Support
      Santafarma Support

      Hi,

       

      Thank you so much.

       

      Kind Regards.

      Author's profile photo Santafarma Support
      Santafarma Support

      Hi,

       

      Thank you so much.

       

      Kind Regards...

      Author's profile photo Oswaldo Ostos Quintero
      Oswaldo Ostos Quintero

      Felicitaciones, un gran aporte todo los pasos y consejos. Mi pregunta es: debo hacer un flujo de efectivo por PEP proyecto; es viable esta opción? Ahora, tengo la versión S4HANA ON PREMISE 1610

       

      S4CORE 101 – 04 aplica para esta versión? Muchas gracias

      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hola,

      No lo hice en S4 pero deberías intentar con campos adicionales.

      Sino deberias ir con Investment Management, pero no llega el control a nivel factura.

      Additional Fields in Liquidity Planner | SAP Blogs

      Saludos