Skip to Content

Description

Application Type: SAP Smart Business.

The app shows the forecast bank balances at the end of the current day. Data sources of the application are confirmed by bank balances and other guaranteed payments and receipts: memo, financial transactions. The application is used to decide on the attraction / placement of cash in the event of a deficit / surplus of cash.

The forecast balance is shown in the currency specified in the application settings.

Analytics available within the app:

  1. Display currency

  • Bank country
  • Bank
  • Company
  • Bank and bank account currency
  • Bank account currency and country
  • Bank group
  • Bank account currency
  1. Bank account currency
  • Bank account currency

The app description in the library of fiori apps:

https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/index.html#/detail/Apps(‘F1737’)/S7OP

 

Data sources

App use CDS: C_CASHPOSITIONANALYTICS

CDS uses 2 sources of information:

  1. FDES «Cash Management and Forecast: Memo Records». Memo entry appears in the report when the following conditions are met:
  • In the memo entry fields filled HBKID “short key for house Bank” and HKTID “ID for account details”.
  • ARCHK «Archiving category» is empty.
  • DATUM «Planning Date» less or equal today.
  • AVDAT «Archiving or automatic expiration date»
  1. FQM_FLOW «FQM Flows». FQM entry appears in the report when the following conditions are met:
  • In the FQM records filled HOUSE_BANK ” Short key for a house bank” and HOUSE_BANK_ACCOUNT “ID for account details”.
  • FQM_FLOW-DELETED «Deleted» <> X.
  • FQM_FLOW-FLG_ACTUAL «General Flag» = X.
  • FQM_FLOW-TRANSACTION_DATE «Transaction Date» and less or equal today.
  • FLOW_CATEGORY «Flow Category» equal one of the value from set:

‘900000’ «Incoming Bank Cash»

‘900001’ «Outgoing Bank Cash»

‘900006’ «Incoming Bank confirmed Cash I»

‘900007’ «Incoming Bank confirmed Cash D»

‘900008’ «Outgoing Bank Confirmed Cash I»

‘900009’ «Outgoing Bank Confirmed Cash D»

‘900014’ «Incoming Bank Cash Increase»

‘900015’ «Incoming Bank Cash Decrease»

‘900016’ «Outgoing Bank Cash Increase»

‘900017’ «Outgoing Bank Cash Decrease»

‘900018’ «Incoming Bank Cash (Tax)»

‘900019’ «Outgoing Bank Cash (Tax)»

‘900100’ «Incoming Bank Cash (TRM)»

‘900101’ «Outgoing Bank Cash (TRM)»

‘900102’ «Bank Cash Balance Increase»

‘900103’ «Bank Cash Balance Decrease»

‘900104’ «Incoming Bank Cash (CML)»

‘900105’ «Outgoing Bank Cash (CML)»

‘900106’ «Incoming Cash (FI-CA)»

‘900107’ «Outgoing Cash (FI-CA)»

‘900108’ «Cash Balance Increase (IDOC)»

‘900109’ «Cash Balance Decrease (IDOC)»

‘900110’ «Incoming Cash (IDOC)»

‘900111’ «Outgoing Cash (IDOC)»

‘900112’ «Incoming Cash (LP)»

‘900113’ «Outgoing Cash (LP)»

‘900140’ «Incoming Cash – Net Value (SD)»

‘900141’ «Outgoing Cash – Net Value (SD)»

‘900142’ «Incoming Cash – Tax (SD)»

‘900143’ «Outgoing Cash – Tax (SD)»

‘900144’ «Deduction Incoming Cash – Give»

‘900145’ «Deduction Outgoing Cash – Take»

‘900900’ «Incoming Cash from Invoices»

‘900901’ «Outgoing Cash from Invoices»

‘900902’ «Incoming Cash from Payments»

‘900903’ «Outgoing Cash from Payments»

‘900910’ «Incoming Allocated Cash Increa»

‘900911’ «Outgoing Allocated Cash Increa»

‘900912’ «Outgoing Unallocated Cash Decr»

‘900913’ «Incoming Unallocated Cash Decr»

‘999000’ « Incoming Cash out of Company I»

‘999001’ « Incoming Cash out of Company I»

  • CERTAINTY_LEVEL « Certainty Level » equal one of the value from set:

‘ACTUAL’

‘SI_CIT’

‘FICA’

‘MEMO’

‘CMIDOC’

‘TRM_O’

‘TRM_D’

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply