3633617 - Define queries for liquidity Item assignment in accounting documents - SAP S/4HANA Cloud Public Edition

• Define Queries for liquidity item assignment from various origin application.
• Know how to use origin type for defining queries for liquidity item assignment in accounting documents.

SAP S/4HANA Cloud Public Edition

To use Liquidity Item analysis in SAP S/4HANA Cloud Public Edition the Cash Scope should be Full Scope.

Based on queries of origin

1. 1. Use the Define Queries for Liquidity Item Derivation app to define queries.

   2. Use SSCUI Define Query Sequences to define query sequence.

   3. Use the Assign Queries to Query Sequences app to assign the queries (from step 1) to the query sequence (from step 2).

   4. Use SSCUI Assign Sequences to Company Codes to assign the query sequence to a company code.

Use the Schedule Jobs for Flow Builder app with the job template Rebuild Liquidity Items in Accounting Documents to rebuild Liquidity Item of Accounting Documents. -> Either using Query Sequence or Liquidity Calculation: G/L Classification.

Liquidity item assignment from BSEG into FQM_FLOW is determined based on chain tracing steps to lowest document in chain.

For evaluation of customers(Account type = D) and suppliers((Account type = K)) line items in payment/Invoice documents define condition with query id origin= C.

For expense/revenue(Account type = S) line items define condition with query id origin = D.

SAP help portal: Integration of Accounting Documents

SAP S/4HANA Cloud community blog: Understanding the transition to Liquidity Calculation: G/L Classification

Liquidity item, Assignment, SAP S/4HANA Cloud, public, edition,  Financial document, Purchase order, Sales order, Cash management, Treasury, Contract, FLQINFACC, FQM_FLOW, FQM_UPD_LITEM, FCLM_UPDATE_LQITEM, LI , PAYRQ, Payment request, Origin C, Origin D, G/L Classification, Liquidity Calculation: G/L Classification, query, sequence, , KBA , FIN-FSCM-CLM-LM-2CL , Liquidity Management (Public Cloud) , Problem