Liquidity analysis in SAP S/4HANA Cloud

End user wants to to enable Liquidity Analysis in One Exposure from Operations in SAP S/4HANA Cloud. Following we will discuss the related scope items and related configuration activities.

Scope:-

  1. BFB (Basic Cash Operation).
  2. J78 (Advance Cash Operation).

BFB:

You can get a midterm liquidity forecast based on incoming and outgoing payments and manually entered planning items.

Planned items is relevant to Liquidity Forecast.

Cannot define liquidity items and derivation rules.

J78:

Provides enhanced functionalities like:

Liquidity item, Liquidity item derivation mode for flow builder, Liquidity item hierarchies.

Liquidity item derivation rules can be defined with the below mention steps:

User has to choose the derivation tool for liquidity items.

Go to Configuration step: SSCUI Define Basic Settings for Liquidity Analysis (SSCUI ID 105488).

Select the derivation tool as following.

  1. Undefined.
  2. P – BRF Plus.
  3. Q – Query Sequence.

SSCUI%20ID%20105488

SSCUI ID 105488 Define Basic Settings for Liquidity Analysis

Choosing Derivation tool as Undefined will not derive liquidity items.

Following I will discuss the option 2(BRF Plus rule) and 3 (Query sequence).

Define Derivation Rules – BRF Plus

  1. Go to App Liquidity Item Hierarchy (App ID F1088).
  2. Choose Define Derivation Rules.
  3. Select Decision Table: Extended Liquidity Item Table.
  4. Choose Edit, on the Decision Table: LQI_TABLE, Liquidity Item table.
  5. In the Table Setting dialog box, you can choose/change Condition Columns attribution per your needs and choose OK.
  6. In the Table Contents section. Maintain the value for the relevant condition columns to derivate the liquidity item.
  7. Choose Activate. Choose Yes to confirm the message.
    BRF-plus

BRF-plus rule.

Define Derivation Rules – Query Sequence

  1. Configuration step: SSCUI Define Query Sequences (SSCUI ID 105878).
  2. Choose Configure.
  3. In the pop-up provide the work area C or D.
  4. Create query sequence.
  5. Save.
    SSCUI%20105878%20Define%20Query%20Sequence
  6. Configuration step: Assign Sequence to Company Codes (SSCUI ID 105900).
  7. Assign the query sequence to company code.
  8. Save.
    SSCUI%20105900
  9. Open App Define Queries for Liquidity Item Derivation(FLQQA1). app library link
  10. Define Query.
  11. Make conditions.
  12. Save.
    App%20Define%20Queries%20for%20Liquidity%20Item%20Derivation%20%28FLQQA1%29
  13. Open App Assign Queries to Query Sequence(FLQQA5). help document
  14. Select the sequence.
  15. Assign query.
  16. Save.
    Assign%20Queries%20to%20Query%20Sequence%28FLQQA5%29

Alternatively, you can Define Default Liquidity Items for G/L Accounts from App Define Default Liquidity Items for G/L Accounts (FLQINFACC). help document

Final step is to open App Schedule Job for Rebuild Tool for Liquidity Item (App ID F6770) and schedule job template Rebuild to rebuild liquidity items in accounting documents. help document

Refer the test script for Advance Cash Operations (J78) here.

Conclusion:-

With the configuration steps mention above user should be able to configure the liquidity analysis in One Exposure from Operations.

“Image/data in this blog post is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.”