SAP Knowledge Base Article - Public

3670979 - How to configure liquidity item derivation rules for cash flows - SAP S/4HANA Cloud Public Edition

Symptom

  • Liquidity item derivation is not working in app Cash Flow Analyzer.
  • How to configure liquidity item derivation rules for cash flows.

Environment

SAP S/4HANA Cloud Public Edition

Resolution

1. Define Query for Supplier-Based Derivation:

  • Use app Define Queries for Liquidity Item Derivation.
  • Create a new query with Origin = C (for customer/vendor line items).

2. Create Query Sequence:

  • Use SSCUI Define Query Sequences (SSCUI ID 105878).
  • Configure for work area C (Customer/Vendor).
  • Create a query sequence that will contain supplier-based queries.

3. Assign Queries to Query Sequence:

  • Use app Assign Queries to Query Sequences app.
  • Select the query sequence created in step 2.
  • Assign the supplier-based query from step 1 to this sequence.
  • Define the sequence order if multiple queries exist.

4. Assign Query Sequence to Company Code:

  • Use SSCUI Assign Sequences to Company Codes (SSCUI ID 105900).
  • Assign the query sequence to the relevant company code.
  • This enables the derivation logic for invoices in those company codes.

5. Rebuild existing liquidity items:

  • Use app Schedule Jobs for Flow Builder with job template Rebuild Liquidity Items in Accounting Documents.

See Also

Refer to: Assign Queries to Query Sequences | Help Portal

Keywords

Liquidity item derivation, cash flow, supplier-based query, query sequence, company code assignment, rebuild liquidity items, sap s/4hana cloud public edition, cash management , KBA , FIN-FSCM-CLM-2CL , Cash Management (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions