Show TOC

 FIN-FSCM-CLM: Local BI Content for SAP Cash Management powered by SAP HANA

 

As of the SAP Simple Finance add-on 1.0 for SAP Business Suite powered by HANA, you can configure or enhance the following local BI objects according to your business needs for SAP Cash Management powered by SAP HANA.

To view the BI content predefined by SAP, in transaction RSA1, choose Start of the navigation path InfoPackage Financial Management & Controlling (/ERP/FMCO) Next navigation step Cash & Liquidity Management (/ERP/FCLM) End of the navigation path.

Virtual InfoProviders

The following Virtual InfoProviders are based on HANA Views:

  • Cash Position (/ERP/FC_VP06): calculates balance amounts of bank accounts.

  • Cash Flow and Short Term Cash Forecast (/ERP/FC_VP07): provides short-term cash flow and cash forecast based on the payments on the bank clearing accounts, memo records, and forecast from TRM deals (FX and Money Market).

  • Cash Flow Analysis (At Bank Clearing Level) (/ERP/FC_VP01): analyzes actual cash flows based on the payments on the bank clearing G/L accounts and derives liquidity items.

  • Cash Flow Analysis (At Invoice Level) (/ERP/FC_VP09): analyzes actual cash flows based on the invoices and derives liquidity items.

  • Liquidity Forecast (Basic Version) (ERP/FC_VP04): forecasts cash flows based on the open items at invoice level and derives liquidity items accordingly.

  • Liquidity Forecast (Light Version) (ERP/FC_VP05): forecasts cash flows based on the open items of bank clearing G/L accounts and derives liquidity items accordingly.

  • Bank Account Overdraft Limit (/ERP/FC_VP92): retrieves the overdraft limit amounts of bank accounts from the bank account master data.

ODPs

  • 0FCLM_CP_REAL_ITEM

    • ODP ID: 0FCLM_CP_RLI

      This ODP provides the line item details can be used in the Cash Position and Short Term Forecast report.

  • 0FCLM_CP_BS_IMP_CMP

    • ODP ID: 0FCLM_CP_BIC

      This ODP monitors the status of bank statement imports on bank or bank group level. You can only use it together with the Bank Account Management component.

Planning Real-Time Cubes & Aggregation Levels

  • Planning Real-Time InfoCube

    Liquidity Planning Cube (/ERP/FC_IC04): stores the results of liquidity planning.

  • Aggregation Level

    • Monthly Planning (/ERP/FC_AL06): provides aggregation level to monthly planning.

    • Planning by Liquidity Item (/ERP/FC_AL05): provides aggregation level to daily planning by liquidity item.

    • Planning by Planning Level (/ERP/FC_AL07): provides aggregation level to daily planning by planning level.

    • Planning by Liquidity Item and Bank Account (/ERP/FC_AL08): provides aggregation level to daily planning by liquidity item and bank account.

MultiProvider

  • Planning & Forecast & Actual (/ERP/FC_MP05): combines planned data, forecast data, and actual data all together, allowing you to define queries with all the relevant information together.

BEx Queries

The following BEx queries are based on ODPs:

  • Cash Position Line Item (FCLM_CP_LIT_Q1001): defined on ODP 0FCLM_CP_REAL_ITEM.

  • Bank Statement Import: Status (Tree) (FCLM_CP_BIC_Q1001): defined on ODP 0FCLM_CP_BS_IMP_CMP.

  • Bank Statement Import: Status (Table) (FCLM_CP_BIC_Q1002): defined on ODP 0FCLM_CP_BS_IMP_CMP.

The following BEx queries are based on MultiProvider:

  • Planning & Forecast & Actual (/ERP/FC_MP05)

  • Cash Position and Short-Term Cash Forecast (/ERP/FCLM_MP05_Q0003)

  • Cash Flow Analysis (/ERP/FCLM_MP05_Q0021)

  • Cash Flow Analysis (/ERP/FCLM_MP05_Q0021)

  • Monthly Planning by Liquidity Item (/ERP/FCLM_MP05_Q0001): input query for monthly planning.

  • Monthly Variance Report by Liquidity Item (/ERP/FCLM_MP05_Q0002): analyzes the monthly variances between actual, planning, and forecast data by liquidity item.

  • Monthly Variance Overview (/ERP/FCLM_MP05_Q0005): analyzes the monthly variances between actual, planning, and forecast data.

  • Cash Position (/ERP/FCLM_MP05_Q0003): provides data for the Cash Position and Short-Term Cash Forecast report.

  • Daily Planning by Planning Level (/ERP/FCLM_MP05_Q0009): input query for daily planning by planning level.

  • Daily Variance by Planning Level (/ERP/FCLM_MP05_Q0008): analyzes the daily variances between the actual and the planning data by planning level.

  • Daily Planning by Liquidity Item (/ERP/FCLM_MP05_Q0006): input query for daily planning by liquidity item.

  • Daily Variance by Liquidity Item (/ERP/FCLM_MP05_Q0007): analyzes the daily variances between actual, planning, and forecast data by liquidity item.

Effects on Customizing

You can copy the corresponding objects out, and make adjustments as needed.

More Information