Ansicht
Dokumentation
RFLQ_ASSIGN_CCR - Liquidity Calculation: Assignment with Uni-Directional Document Chains
Fill RESBD Structure from EBP Component Structure SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
Purpose
This program assigns liquidity items to the Liquidity Planner (LP) line items, so as to describe the uses and sources of cash in a company.
Integration
When the Financials (FI) component actual line items are initially copied into the Liquidity Planner (LP) line items – either online or with the Customizing activity Regenerate Flow Data (transaction FLQC10), the line items already have a liquidity item. However, this initial liquidity item only tells whether the cash flow is incoming or outgoing and thus lacks the essential uses and sources information. This assignment program evaluates document chains in the FI component in order to assign proper liquidity items to the LP line items that represent the cash flow in a company.
Prerequisites
Features
Selection
The program provides selections for you to restrict the set of actual items to be processed. For example, to process the actual items of last month that have not been assigned manually, you can simply specify the Payment Date range and exclude value M from the Origin field.
On the selection screen, you can enter the Query Sequence and Derivation Function that evaluates offsetting info line items and derives liquidity items for them.
In the Control section, you can switch between test run (no changes on the database) and productive run and decide on the format of the output list.
Algorithm
Liquidity Planner (LP) is tightly integrated with the Financials (FI) component. Some of the most important concepts are listed below to assist you in understanding the underlying algorithm.
Key Concepts:
- Actual accounts:
- Actual accounts are G/L accounts that represent cash in a company, such as G/L accounts linked to external house bank accounts. The FI line items under these accounts (actual line items) are copied to the Liquidity Planner. They represent actual cash flow.
- You can define the house banks in transaction FI12 House Banks and define more actual G/L accounts in transaction FLQC4 Liquidity Calculation – Other Actual Accounts.
- Info accounts:
- Info accounts are the second group of G/L accounts used to process document chains and derive liquidity items. Items linked to these accounts are called info items. The program evaluates them to derive liquidity items. Info accounts (with default liquidity items attached) are defined either in the Liquidity Planner settings, transaction FLQINFACC Liquidity Calculation – Accounts with Assignment Information (recommended) or in the Customizing activity Define Query-Relevant G/L Accounts (transaction FLQC7). You can assign a liquidity item to an info account.
- The program distinguishes two groups of info accounts: intermediate and final info accounts. By default, all vendor and customer reconciliation accounts are intermediate info accounts; all profit and loss accounts are final info accounts. In the transactions for defining info accounts, you also can configure whether an account is an intermediate or final info account.
- Offsetting items
- In the most ideal scenario, for a document that has only two line items, each line item is the unique offsetting item of the other one. In the clearing process involving only two line items, each item is the unique offsetting item of the other one. In most cases, for documents and the clearing process, the offsetting relationship could be 1: N or even N: M. The program provides a built-in pairing algorithm to identify and split offsetting items. For this split, it uses the amounts in local currency.
Program Logic
First Part of the Document Chain
The starting point of the chain is the actual items (FI) that correspond to the LP line items. The program determines the offsetting items for this actual item in the FI document. Each offsetting item belongs to one of the following three groups:
- Actual items: This is often the case when the document is for a bank transfer. Such an item is already an ending point for the document chain. It contributes to a transfer liquidity item from transaction FLQC2 Liquidity Calculation - Global Settings.
- Info offsetting items: This is the desired end of a document chain. The program tries to derive a liquidity item - either from the G/L account, or from a Query Sequence, or from the DerivationFunction. If the derivation is successful, the new liquidity item is assigned to the offsetting item. If not, the initial incoming or outgoing liquidity item from the Liquidity Calculation - Global Settings is assigned.
- Items that are neither actual nor info: The offsetting item is neither an actual item nor an info item. If it is still an open item, the document chain ends here. The liquidity item assigned is the initial incoming and outgoing liquidity item from the Liquidity Calculation - Global Settings. If it is cleared, the program continues the chain until it finds the final offsetting item in the document.
Second Part of the Document Chain
The second part of the chain starts at every offsetting item (identified in the first part) that meets the following criteria:
- It is an intermediate info item. If it is the final info item, the document chain ends at the first part.
- The liquidity item derived in the first step is a Buffer Item. On the selection screen you can specify the buffer items.
- It is cleared. If it is an open item, the program can only determine it as an incoming or outgoing liquidity item.
The program identifies the offsetting items in the clearing and then fetches the offsetting items in the cleared documents. The cases for these offsetting items are slightly different from the first part of the chain:
- Non-info items: The chain ends, and the offsetting item is assigned with the buffer liquidity item.
- Intermediate Info items: If the final offsetting item is an OPEN info item, the chain ends here with the buffer liquidity item. If it is cleared, the chain continues.
- Final Info items: The program derives a new liquidity item that replaces the buffer liquidity item.
Standard Variants
Output
Activities
During the setup phase of LP, maintain the necessary settings as needed, such as info accounts and query sequences. We recommend that you first run this program manually and test whether it works properly. Later you can run the program regularly as a batch job. There is no problem in processing the same actual line items several times.
Example
This example explains how the program derives liquidity items from an actual FI line item.
In this example, two vendor invoices are paid by the payment program. The bank confirms the payment in a bank statement document with one line item.
Prerequisites:
- The G/L accounts corresponding to real bank accounts have been defined as actual G/L accounts.
- The bank clearing account is not defined as an info nor an actual account.
Procedure
- A chain starts with the actual items in the bank statement document. The offsetting line item is the bank clearing line item in this document.
| Line item: Bank account (actual) | Amount 100- |
| Line item: Bank clearing account |
- Provided that the FI line item is the only item to be cleared in this document, the chain continues with this document:
| Line item: Bank clearing account | Amount 100- |
| Line item: Vendor |
- When the program reaches the vendor line item, it returns the liquidity item MATERIAL.
- This might already be the end of the chain if the program cannot find any other clearing document.
- If this vendor line item clears two vendor line items in different invoices, the program drills down to the invoices and returns the following items:
| Line item: Vendor | Amount 40- |
| Line item: Expenses |
| Line item: Vendor | Amount 60- |
| Line item: Investment |
- The program identifies the expense and investment line items in the invoices.
- If the expense line item contributes to no new liquidity item, and the program derives from the investment line item the liquidity item INVESTMENT, the final liquidity item assignment would be as follows:
| Amount 40- | Assigned to MATERIAL |
| Amount 60- | Assigned to INVESTMENT |
