Liquidity Assignment for SO, MM, FI and Treasury
This blog post is about the Liquidity Item Assignment in S4HANA Cash Management. It explains how the Liquidity Item is assigned for Sales Order, Material Management, Finance and Treasury in the table FQM_FLOW.
1) For Sales Order documents you can define query, query sequence and assign them to company codes with origin ‘X’ using the below IMG nodes:
SPRO->Financial Supply Chain Management->Cash Management->Liquidity Items->Define Liquidity Item Derivation Settings for Company Code”.
2) For MM define query and query sequence. After that you have to assign the Query Sequence in transaction FCLM_FB_UTIL in “Query Sequence for MM” and generate the loading class. The same Query Sequence should be defined in all the systems (like, Test, Dev) where you want to assign the Liquidity Item. Liquidity Item is updated by the report FCLM_FLOW_BUILDER.
Also please refer KBA: 2354048 – Information Note for MM Flow Builder: Available Fields in Query Sequence
Note: When adding the condition for the Query ID, do not add more than 8 conditions for any field. For large group of data, you can use the ‘Select Range’ option.
a) For FI Liquidity Item Assignment to table BSEG: The logic can be checked in the report FCLM_UPDATE_LQITEM.
- For accounting documents (in database table BSEG), if liquidity items can be determined by G/L accounts, you can use the “Define Default Liquidity Items for G/L Accounts”(FLQINFACC) activity to define the derivation rules.
- You can also define query/query sequence to override the FLQINFACC setting as per requirement. Evaluation of vendor and customer line items in payment documents query (category C) and for expense and revenue line items in invoices query (category D).
- You should always specify the Origin as D or C when defining queries and query sequences for accounting documents.
- Origin C applies to line items with account type D (customer) or K (supplier).
- Origin D applies to line items with account types other than D (customer) or K (supplier).
- If Exit (Derivation Function) has been maintained for Origin type C or D, then the priority will be given to exit then to query sequence.
So, the priority here works like: Exit -> Query -> FLQINFACC.
• If Exit function is maintained in this SPRO ->Liquidity Items->Define Liquidity Item Derivation Settings for Company Code, then Query Sequence will not be considered. If Exit is not maintained, it will look for Query Sequence. Priority will be given to the Exit (derivation function).
• If liquidity item is not assigned by either query sequence or Exit, then FLQINFACC setting will be checked.
b) Liquidity Item Assignment from table BSEG to table FQM_FLOW: Liquidity Item is updated by the report FCLM_FLOW_BUILDER.
- Liquidity item is determined among the items on the chain, mainly by flow level(FQFTYPE in BSEG).
- If the Liquidity Item is maintained in FLQINFACC for the G/L account and the ‘Further’ flag is checked, then it discards the chain trace and assigns the Liquidity Item from FLQINFACC to table FQM_FLOW.
• If in FLQINFACC, ‘Further’ is checked, priority will be given to this setting while updating the Liquidity Item to table FQM_FLOW.
4) For Treasury document define query, query sequence and assign them to company codes with origin ‘X’ using the IMG nodes: SPRO-> Financial Supply Chain Management-> Cash Management-> Liquidity Items-> “Define Liquidity Item Derivation Settings for Company Code”. You can also use BADI BADI_FQM_DERIVE_LQITEM_TRM method DERIVE to derive the liquidity item.
Please refer the Note 2580031 – FAQ : Liquidity item assignment into one Exposure( FQM_FLOW ) in S4 Hana Cash management
SPRO path for the liquidity item configuration:
|FLQQA1(step 4)||Define Queries for Liquidity Item Derivation|
|FLQC15(step 3)||Define Query Sequences|
|FLQQA5(step 2)||Assign Queries to Query Sequences|
|FLQC0(step 1)||Define Liquidity Item Derivation Settings for Company Codes||FCLM_LQF_DERPARA|
|FLQINFACC||Define Default Liquidity Items for G/L Accounts|
|FLQC1(all LI seen here)||Edit Liquidity Items|
I believe this blog post will clear some of the common doubts about the Liquidity Item update in the table FQM_FLOW. Please feel free to provide your feedback, comment and ask question about the blog post and do like it.
Hi, do you have more informatio about CLM (cash liquid management), can you share with me please
Please refer this for more details on CLM: https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ac319d8fa4ea4624b40a58d23e3c4627/cd6705281eef4230b81ef5a7b1ec54ee.html
With the SAP Best Practice content (On Premise 2021 DE country template for Treasury applications) I noticed there doesn't appear to be any configuration of the liquidity item assignment provided.
This is inconsistent with the rest of Cash and Liquidity functionality where it effectively setup to work for best practice context and company code etc.
Is there any reason for this as it would be more useful with query and query sequences defined. These can then be used as a baseline solution.
Are there any notes that provide some sample query and query sequence definition?
is it possible to use Group Accounts when defining Liquidity Item derivation settings for GL Accounts?
Group Account G0111 is the Group Account for Account number range 01100000 - 01009999.
Can I use "G0111" in the derivation settings?
Thank you in advance for your help
You cannot use Group Accounts to assign Liquidity items using query id because BKPF and BSEG do not have these entry. But you can make use of the Derivation Function/Exit and write your own code for the Group Account to assign the Liquidity Item.
Thank you for your comment I will not use them. However, if I want to devide inflows and outflows I cannot use default liquidity item assignment and have to use Queries for X with Condition FI_ACCOUNT. What further condition would be best to devide between in and outflows as somehow amount is not a condition for origin X and Origin C only shows total amount + using GL indicator is not an option for bulk amount of accounts that need to be mapped (would require a lot of time to devide between assets and liabilities + P&L and G/L Accounts).
Thank you in advance