Page tree
Skip to end of metadata
Go to start of metadata

 

Purpose

The purpose of this page is to clarify the customizing of the Cash Flow Statement for Russia, Ukraine, Kazakhstan.


Overview

Cash Flow Statement customized via Version of Cash Flow (tr. J3RFF4V). Cash Flow Statement runs using tr. J3RFF4.

Cash Flow Statement reads data that is stored in the tables J_3RKKR0 and J_3RK_CORR_ITEMS. Account Offsetting Determination subsystem updates these tables. On this page only Cash Flow Statement is described. Account Offsetting Determination has its own page.


How to check that the last version of Cash Flow Statement is used

In order to be sure that the last version of account offsetting determination is used it is recommended to find SAP Notes in SAP ONE Support Launchpad with Search Term: J3RFF4 (for Russia) J1UFCFS J1UFPTAX J1UFSCE (for Ukraine) FIKZCFL (for Kazakhstan) J_3RFFORM4 J3RFF4V (for all countries).


For more information please refer to the Knowledge Base Article: 2383765: SAP RU-FI, UA-FI, KZ-FI: How to find full list of Notes with restriction by SP.

According to recommendations from SAP Development team it is necessary to implement all SAP Notes for Cash Flow Statement that relevant for your system SP level.


Soluton Development

Beginning from EHP7 SP05, sFIN SP02 you could use HANA-version of Cash Flow Statement which performance is higher then in ABAP-version of Cash Flow Statement. Transaction and customizing are the same. In order start using HANA-version there is a need to check that SP level is not lower then EHP7 SP05 or sFIN SP02 and activate Business Function FIN_LOC_CI_42.


How to define Cash Flow Statement Versions and create Cash Flow Statement

Creating and customizing version of Cash Flow (J3RFF4V -> Statement Items)

 

 

Prameters of Statement Version

Chart of Accounts – define which Chart of Accounts will be taken in the Cash Flow customizing (accounts from another Chart of Accounts will not be processed).

In case of using alternative chart of Accounts check-box Group Account Number should set ON

Item Long Code – define using four-digit id of Statement Item Code (for current Cash Flow Version once switched ON can’t be changed)


Statement Items tree graph definition

Tree graph behavior


  • In the report result Statement Items are always sorted in ascending order (the Statement Item with the lowest code is always on the top of results)

  • The Statement Item result is always contains the amount of child Statement Items

 

Statement Item settings


  • Item code - unique identifier

  • Technical name – this name is shown in the tree J3RFF4V

  • Item description – this name is shown in the result of J3RFF4

  • Section – the results display type

    • Continue – to continue to display as in the previous item (NB! cannot be applied to the Statement Item with the lowest code), table with result has no own header

 

    • 1 Column – display the result in the one column, table with result has a header

    • 2 Columns – display the result in two columns (to compare the data of previous year), table with result has a header

 

    • 3 Columns and 4 Columns - not used in Russian Cash Flow

  • Change +/- Sign – the result of current Statement Item used in the parent Item with sign “-“, i.e. the result of current Statement Item reduces the amount of the parent Item

  • Do Not display – the result of current Statement Item is not shown

  • Hide row number – the Item code is not shown

  • Separate debit/credit – not used in Russian Cash Flow

  • Change +/- Sign For Out – change sign of the result of current Statement only in display (does not affect the amount of the parent Item)

 

Statement Item Accounts determination

 


To customize accounts determination click “Assign Accounts” or double click on Account number

 

Item type


  • Balance

    • Beginning Balance – result from table GLT0 or FAGLEFLEXT

    • Ending Balance – result from table GLT0 or FAGLEFLEXT

    • Period total – result is (Ending Balance - Beginning Balance)

       

  • Debit Transactions – debit turnovers for Cash Accounts

     

  • Credit Transactions – credit turnovers for Cash Accounts

     

  • Only Debit – only positive amount will be shown (can be applied to Parent Item)

     

  • Only Credit – only negative amount will be shown (can be applied to Parent Item)

Example of usage "Only Debit" and "Only Credit" options: two symmetric nodes are created, one is set to 'Only Debit' and the second node is set to 'Only Credit'. Then, depending on the sign of the resulting amount, the result will be considered in the calculations to the desired parent node. 

 

 


For Balance Item type only Cash Accounts must be defined.


 

For Debit/Credit Transactions minimum two accounts must be defined (Cash Account and Invoice Account). Original Accounts might be defined but it is optional parameter.

 

If several Cash Accounts and Several Invoice Accounts have been defined this means that will be considered all possible combinations as shown on the picture.


Account may be defined as mask (using symbol *) and/or range. For example it would be analyzed all variants of correspondence 60*, 76* or 901* from one side and 50* or 51* of 52* or 55* or 57* from other side.

 

 


Flag Excl. means exclude this account.

 

Additional parameters might be defined. There is an opportunity to narrow down the selection by the value of the field or the group of fields.


For example would be analyzed only those documents which has in field ZUONR first 4 symbols in range 1111 – 1211 OR 5-th symbol ‘R’. Please note that there are no brackets in the Additional Parameters. Any expression should be transform into the identical without brackets in accordance with the rules of Boolean algebra: (A OR B) AND C => A AND C OR B AND C.


 

If Original Accounts have been defined then the system would search all cleared with payment invoices having mentioned correspondence.

 

For example if Item has a Cash Account  51* - Invoice Account 62* - Original Account 901* then the system would analize payment received via correspondence Debet 51* - Credit 62* and in the case of turnovers would find invoices which have been cleared with this payment  via Debet 62* - Credit 901*. If correspondence Debet 62* - Credit 901* was not find such payment would get to the log (Document not assigned).


If Original Accounts haven’t been defined then clearing is not analizing. For example it would be analized only payment received via correspondence Debet (50* or 51* or 52* or 55* or 57*) – Credit (Any Account but Not 62* and Not 76*)

 

If there are several Statement Items like on the picture above and there is a turnover between 50 - 62. In case was found cleared invoice (62 – 9010) then the result amount would be shown with code 030 else if only part of amount was found as cleared invoice (62 – 9010) then this part amount would be shown with code 030 and the rest amount with code 210:

 

  1. Debet 50 – Credit 62      1000 rub

    Debet 62 – Credit 9010  1000 rub

    Result:  Code 030: 1000 rub

  2. Debet 50 – Credit 62      1000 rub

    Debet 62 – Credit 9010  250 rub

    Result:  Code 030: 250 rub and Code 210: 750 rub

  3. Debet 50 – Credit 62      1000 rub

    Debet 62 – Credit 9010  0 rub

    Result:  Code 210: 1000 rub

For Russian Cash Flow only one tab must be defined – All Activities. Operating Activities, Investing Activities, Financial Activities – are obsolete tabs (don’t use them). 2-d for UA – only for Ukraine (don’t use it for Russian Cash Flow)

Creating Cash Flow Statement (J3RFF4)


 

 

For creating Cash Flow Statement required parameters must be determined (on the picture marked red)


 

Also optional parameters might be determined (on the picture marked green).


If Leger is filled then the system would analyze data only from this Leger. If the Leger is empty then only data from Entry View would be analyzed.

 


Company Code summarization determine type of reflection results in case of several Company Codes. In a similar way works Business Area Summarization.

 

Field Scaling  controls the display of result amounts.  If the sum is greater than the size of the field then suitable scale should be selected.

 

In case the need to display negative amounts in Brackets the amount must be negative (flag Change +/- Sign for Out might be used in J3RFF4V) and flag Negative Amounts in Brackets on the List Output options.

 

In case flag Offsetting Accounts set ON then for determination correspondence of accounts system would use Offsetting Accounts specific settings (the same as transaction J3RKKRS uses). This option is not used on HANA-version (documents should be processed before running Cash Flow Statement)

 

If flag Save Offsetting Accounts set ON then the results of accounts offsetting would be saved (Note: Tables J_3RKKR0 and J_3RK_CORR_ITEMS will be updated).

 


GR/IR Clearing this flag is not used in Russian Cash Flow

 

Length of G/L account number have an influence only in case in J3RFF4V flag Group Accounts Number set ON.


Results might be displayed in Local Currency in Foreign Currency, 2-nd or 3-rd Local Currency. For Foreign Currency Historical Rate may be used.

 

The period for Cash Flow may be determined in Selection Criteria group fields as period number or in Other Settings group fields as dates range from Alternative Period.

 

Section Header and Footer Texts used for printing.

 

Shifted Fiscal Year

 

In case there are a ledger with Shifted fiscal year and ledger with Calendar fiscal year. In this case in the field Ledger should contain ledger with Calendar fiscal year.

 

In case there is no ledger with Calendar fiscal year then Alternative Period Selection should be used.


 

In case Cash Flow Statement takes too much time using Background mode will be helpful.

 

Note: On HANA Cash Flow Statement can be generated significantly faster.

 

Cash Flow Statement Results

 

 

For analyzing Cash Flow Statement results it is useful to double-click on turnover amount to drill-down the list of the documents, which form the result sum.

 

If the result is balance amount then drill-down cannot be used.

 

In case of error it might be helpful to analyze log.

 

Related Content

Related Documents

SAP Knowledge Warehouse: Customizing for Cash Flow Statements

SAP Knowledge Warehouse: Cash Flow Statement

Help portal: Customizing for Cash Flow Statements

Help portal: Cash Flow Statement

Related SAP Notes/KBAs

SAP Note 1992177: 5-digit OKOPF for CASH FLOW and balance forms

SAP Note 2019739: FIN_LOC_CI_42: VAT solution, Cash Flow, Stock Overview on HANA