You are now able to:
Configure Customizing for the ERP part of SAP Liquidity Planner
Carry out the steps required for activation
SAP PORTUGAL | USO EXCLUSIVO | 2013
SAP PORTUGAL | USO EXCLUSIVO | 2013
© SAP AG FSC800 3-17
Exercises
Unit: Customizing
Topic: Setting Up Customizing
At the conclusion of these exercises, you will be able to:
• Configure baseline Customizing
• Name the relationships required from a business perspective
You want to configure baseline Customizing for SAP Liquidity Planner.
1-1 Which the transaction code calls the Customizing path for baseline Customizing?
1-2 In company code AC##, create a cash account in chart of accounts INT (for example, 101000) as an “Other Actual Account” for your company code AC##.
1-3 Activate your company code AC## with number range 01. The number range should already exist (if not, you can use transaction ot20).
1-4 For company code AC##, create a query sequence for Deutsche Bank. Since you want this to be valid for your company code only, name the query sequence AC##_DEUBA.
1-5 In your company code AC##, assign the query sequence defined in steps 1-4 for Deutsche Bank (house bank 1000 and account ID 1000).
1-6 Explain the function of the “Part. Reassign.” indicator in transaction FLQC13 (Liquidity Calculation – Settings for FI Mechanisms).
1-7 Explain the function of the “N:M Treatment” indicator.
1-8 Explain the function of the “Info Accts in Appl.” indicator.
SAP PORTUGAL | USO EXCLUSIVO | 2013
1-9 Map G/L accounts to liquidity items for your company code AC## using transaction
“Query-Relevant G/L Accounts”. When doing so, use chart of accounts INT. The mapping between G/L accounts and liquidity items should be as follows:
G/L
220000 340000
273100 330000
273300 330000
300000 122000
300010 122000
310000 122000
416300 127000
416302 127000
420000 121100
440000 121200
473000 125000
473110 125000
476000 127000
477100 126000
800000 111000
800001 112000
SAP PORTUGAL | USO EXCLUSIVO | 2013
© SAP AG FSC800 3-19
Map your reconciliation accounts to the corresponding “Buffer Items”. Make a note of this mapping, for example:
G/L
140000 DEBTOR
141000 DEBTOR
160000 VENDOR
160100 VENDOR
1-10 Define a query sequence for the “From FI Information” mechanism. Use the following name: AC##_FIINFO.
1-11 Define a query sequence for the “From Invoices” mechanism. Use the following name:
AC##_INVOICE.
1-12 As a rule, what is the purpose of report “Regenerate Flow Data” in a project?
SAP PORTUGAL | USO EXCLUSIVO | 2013
SAP PORTUGAL | USO EXCLUSIVO | 2013
© SAP AG FSC800 3-21
Solutions
Unit: SAP Liquidity Planner and Basic Business Knowledge
Topic: Basic Background Knowledge
1-1 Transaction FLQCUST calls the Customizing path for SAP Liquidity Planner.
1-2 Go to Customizing (transaction SPRO):
→ Financial Supply Chain Management → Cash and Liquidity Management
→ Liquidity Planner → Basic Settings: Liquidity Calculation → Define Other Actual Accounts
Choose “New Entries”.
Enter the following values:
Chrt/Accts CoCode G/L Account Not Actual
INT AC## 101000 Leave blank
and save.
1-3 Go to Customizing:
→ Financial Supply Chain Management → Cash and Liquidity Management
→ Liquidity Planner → Basic Settings: Liquidity Calculation → Activate Company Code
Choose “New Entries”.
Enter the following values:
CoCd Company Name Act. No.
AC## Copied automatically Set X indicator 01 and save.
(If required: Create the number range using transaction ot20. Enter your company code (AC##). Choose “Insert Interval”).
SAP PORTUGAL | USO EXCLUSIVO | 2013
1-4 Go to Customizing:
→ Financial Supply Chain Management → Cash And Liquidity
Management → Liquidity Planner → Assignment → From Bank Statement
→ Define Query Sequences
Choose “New Entries”.
Enter the following values:
Query Sequence
Query CoCd Name Description
AC##_DEUBA AC## Query_Deuba Query_Deuba
and save.
1-5 Go to Customizing:
→ Financial Supply Chain Management → Cash and Liquidity Management
→ Liquidity Planner → Assignment → From Bank Statement → Assignment to Bank Accounts
Choose “New Entries”.
Enter the following values:
CoCd House Bk Acct ID Seq.
AC## 1000 1000 AC##-DEUBA
and save.
1-6 Explanation of the “Part. Reassign.” indicator:
If you select Part. Reassign. (partial reassignment), assignment to a liquidity item is carried out also in cases where the payment has only been partly cleared. The actual document is split temporarily, whereby the partial amounts cleared are assigned to the liquidity item determined and the remaining amount stays assigned to the original
SAP PORTUGAL | USO EXCLUSIVO | 2013
© SAP AG FSC800 3-23
1-7 Explanation of the “N:M Treatment” indicator:
In standard company accounting, multiple bank statement postings (N) are cleared to the bank subaccounts together with a number of postings (M). This is known as N:M
treatment. In this case, the assignment mechanism cannot trace the document chains. This means that no liquidity items can be determined. If you select N:M Treatment, a
workaround is activated for the case described above. This enables the document chains to be traced.
1-8 Explanation of the “Info Accts in Appl.” indicator:
You use this indicator to specify that info accounts for cash accounting (that is, accounts for which assignment programs try to derive a liquidity item from the information in the document line item) are entered in the application rather than in Customizing (FLQC7).
1-9 Go to Customizing:
→ Financial Supply Chain Management → Cash and Liquidity Management
→ Liquidity Planner → Assignment → From FI Information → Define Query-Relevant G/L Accounts
Choose “New Entries”.
Enter all values specified in the task:
Chart of Accounts
Company Code G/L Account
Further Default Value
INT AC## 1000 230000
SAP PORTUGAL | USO EXCLUSIVO | 2013
1-10 Go to Customizing:
→ Financial Supply Chain Management → Cash and Liquidity Management
→ Liquidity Planner → Assignment → From FI Information → Define Query Sequences
Choose “New Entries” and enter the following values:
Query
Sequence Origin Query CoCd Name Description
AC##_FIINFO C AC## FI INFO FI INFO
Save your data.
1-11 Go to Customizing:
→ Financial Supply Chain Management → Cash And Liquidity
Management → Liquidity Planner → Assignment → From Invoices → Define Query Sequences
Choose “New Entries” and enter the following values:
Query Sequence Origin Query CoCd Name Description
AC##_INVOICE C AC## Invoice Invoice
Save your data.
1-12 As a rule, the report “Regenerate Flow Data” is used to generate data created before the activation date of the actual calculation.
SAP PORTUGAL | USO EXCLUSIVO | 2013
© SAP AG FSC800 4-1
SAP AG 2008
Contents:
Using Liquidity Planner
Application in ERP
SAP PORTUGAL | USO EXCLUSIVO | 2013
SAP AG 2008