
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.
3) FI:
a) For FI Liquidity Item assignment to table BSEG: The logic can be checked in the report FCLM_UPDATE_LQITEM.
So, the priority here works like: Exit -> Query -> FLQINFACC.
Note:
• 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.
Note:
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:
Query/Origin types supported in S4HANA for Liquidity Item assignment are C, D and X.
SPRO path
Transactions used in S/4 HANA for Liquidity Item:
Tcode | SPRO Name | Table |
FLQQA1(step 4) | Define Queries for Liquidity Item Derivation | FLQQRCOND |
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 | FLQACC_INFO_APP |
FLQC1(all LI seen here) | Edit Liquidity Items |
Notes:
As liquidity item assignment depends on Flow Types when assigned from table BSEG to FQM_FLOW it is important to know that any change in the flow type will also impact the assignment of liquidity item. SAP pre-defines a set of flow types. So, if there is not any specific business requirement, we do not need to change the standard flow types.
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 comment your suggestions, feedback or questions and follow for future posts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 |