The KPI definition delivered for Liquidity Forecast is as follows: You can define
valuation/visualization on the KPI definition delivered, or duplicate it to create your own z version and then define evaluation/visualization.
1. Launch the KPI modeler in your browser. (Example URL:
https://[server]:[port]/sap/bc/ui5_ui5/sap/ca_kpi/modeler/index.html)
2. Choose the action menu on the bottom left side, in the pop-up list, choose Add KPI. 3. On the Add New KPI screen, fill in the below information:
Field Name Value Mandatory
KPI Code ZLiquidityForecast X
KPI Title Liquidity Forecast X
Short Description
With this app, Cash Managers can check liquidity forecast by date Semantic Object Action Tags Improvement Direction Maximizing X
Value Type Currency X
KPI Owner
OData Path /sap/hba/r/sappl604/odata/fin/kpi.xsodata X Entity Set CashLiquidityForecastQueryResults X
Measure BalanceAmountInDisplayCrcy_E X
4. Choose Save and Continue to continue define the evaluation for the KPI.
3.3.4.2 Evaluation
To display a KPI, you must associate it with an evaluation. An evaluation is a combination of filter settings and input parameters (the variant), thresholds, parameters, trends, and authorizations related to a KPI that defines what can be seen by the SAP Smart Business user at runtime. Define the Evaluation according to below tables following the steps described in section 3.3.4.1 KPI Definition.
1. Continue from the last step of the previous chapter. On the Add Evaluation screen, on the Apply Variant tab page, you can either Create New Variant or Apply Existing Variant.
© SAP SE Page 35 of 43 Apply Variant tab page
Field Name Value Mandatory
Variant ID LiquidityForecastV1 X
Variant Title LiquidityForecast X
Description
OData Path Prefilled from the KPI definition Entity Set Prefilled from the KPI definition Related Tags
Filter Settings
Input Parameters P_FromOffsetDays = 1 P_ToOffsetDays = 7 P_CashManagementGrouping = 'SAPCM_CA' P_ExchangeRateType = 'M' P_TargetCurrency = 'USD' V_SAPClient = '002' 3. Choose Next.
4. On the Parameters tab page, fill in the below information (fields with bold text are mandatory): Parameters tab page:
Field Name Value Mandatory
Evaluation Text Forecast in 7 Days (USD) X Scaling Factor
Tags
Unit USD
Decimal 00.00 X
Target and Thresholds tab page:
Field Name Value Mandatory
Improvement Direction From KPI definition X Warning High
Critical High
Target 200000000
Warning
Critical -200000000
Apply Trend tab page:
Field Name Value
Comparison Variant for trend calculation
SAP Fiori Apps for the SAP ERP Application FICO
© SAP SE Page 36 of 43
3.3.4.3 Managing Visualization
Define Visualization according to below tables following the steps:
1. On the home screen of KPI modeler, choose Explore Visualizations from the action menu in the bottom left corner.
2. Choose the evaluation to which you want to apply the visualization in the All Evaluations side panel.
3. Choose the Tiles tab page, then choose Add Tile.
4. On the Add Tile screen, choose Tile Type as KPI Tile, and then choose Tile Format as Numeric Tile.
Tile Definition: Tile1
Field Name Value Mandatory
Tile Type KPI Tile X
Tile Format Numeric Tile X
Dimension (Only needed for certain Tile format)
3.3.4.3.1 Generic Drill-Down Definition
When you configure the drill-down, you can create at least one and up to seven views (charts or tables). You can also configure the KPI header details, and the filters to suit your requirements. 1. Choose Drill-Down tab page, and then choose Configure Details.
2. You can choose Add View to add up to 7 views for the drill-down. For each view, fill in the below information (fields with bold text are mandatory).
Overview setting:
Field Name Value Mandatory
KPI Header Details (On/Off?)
Off X
Enable Time Series (On/Off?)
Select Dimension
Filter (On/Off?) on X
Select Dimension LiquidityStructureItemName Select Dimension CompanyCodeName
Select Dimension Date_E
Select Dimension PlanningLevelName Select Dimension CashSource
© SAP SE Page 37 of 43 Views (Up to 7 views possible)
View1
Field Name Value Mandatory
Show As Chart and Table X
Default View (If Show As Chart and Table)
Chart X
Chart Type Combination X
View Name Forecast By Date X
Order By None
Select Measures BalanceAmountInDisplayCrcy_E X Select Measures AmountInDisplayCurrency_E
Select Measures Select Measures Select Measures
Select Dimensions Date_E X
Select Dimensions Select Dimensions Select Dimensions Select Dimensions Limit records to
3.3.5 Configuration for Baseline Scenarios
You can use the liquidity forecast to identify the medium-term cash inflows and outflows generated by the posted debit-side and credit-side invoices.
Cash Management Customizing for back-end Financials:
1. SAP Best Practice Baseline – Cash Management BB160 Configuration Guide
2. Cash Management Levels (= Planning Levels) of type BNK (Bank) and PSK (Sub Ledger) must be defined.
3. Cash Management Groups (= Planning Groups) must be defined – each with a PSK Level inside.
4. Each G/L account must be configured with a house bank and house bank account ID. 5. Vender or customer should have been assigned with reconciliation account and cash
management group according to the cash management group configured in Building Block 160.
Account → Financial Accounting → Accounts Receivable/Accounts Payable → Master Records → Display → Company Code Data
6. Cash Management Configuration Guide 160, section 3.3.2 Define Groupings and Maintain Headers. Configuration Activity:
SAP Fiori Apps for the SAP ERP Application FICO
© SAP SE Page 38 of 43
Financial Supply Chain Management → Cash and Liquidity Management → Cash Management → Structuring → Grouping → Define Grouping and Maintain Headers Add your grouping with a name starting with SAPCM. Each grouping entry represents a category of liquidity structure. You make settings that affect the way the cash position and liquidity forecast is displayed or you can use the pre-configured grouping from baseline and change the input parameter entry for cash management group during creating the KPI. 7. Cash Management Configuration Guide 160, section 3.3.3 Maintain Structure. Configuration
Activity:
Financial Supply Chain Management → Cash and Liquidity Management → Cash Management → Structuring → Grouping → Maintain Structure
You define the grouping structures that group together particular bank and/or sub ledger accounts in the cash position or the liquidity forecast display. The selection of a certain grouping during execution of Cash position & Liquidity Forecast influences the result of this report.
One or more appropriate Groupings for selection and structuring of Cash Management reports must be defined and maintained. For example, SAPCM_CA.
8. Specify a planning level for the grouping defined for each category of liquidity structure. Planning levels are maintained in the corresponding G/L accounts. If you want to show the liquidity structure by bank, each bank must have a separate G/L account for each category of liquidity structure, and the house bank and house bank ID must be maintained in the G/L. The liquidity structure information is calculated from documents posted to the G/L. Therefore, this information reflects the real situation only if the amounts posted to the G/L are reliable and capture the meaningful value of your liquidity structure items.
9. Vender or customer should have been assigned with reconciliation account and cash management group according to the cash management group configured in above Building Block 160.
Account → Financial Accounting → Accounts Receivable/Accounts Payable → Master Records →Display → Company Code Data
10. Post memo record, customer/vendor invoice and payment. Make sure that this posting is properly reflected in invoice level of the Liquidity Forecast report:
© SAP SE Page 39 of 43 2. Fill in company code and suitable Grouping (for example, SAPCM_CA).
3. Verify the change in liquidity forecast in the corresponding currency, amount and expected date. This information appears in the form of memo records in the cash position, or as planned items in the liquidity forecast.
4. Look at the chart in the liquidity forecast tile on the dash board.
4 Fact Sheets for Finance and Controlling
The fact sheets display contextual information about central objects used in your business operations. They are designed to be intuitive and harmonized fact sheets which allow navigation from one fact sheet to other related fact sheets. This way you can navigate from master data like asset or cost center to related documents like accounting document, controlling document or vice versa.Fact sheets run only on a SAP HANA database and require an ABAP stack.