0BALANCE in 0FI_GL_14 / FLAGFLEXA

[Former Member]

Hello Folks,

Financial Statements are based on 0FI_GL_10 i.e FLAGFLEXT.

We are doing an RRI from the Financial Statements to the GL Line Items. My Question is on the Balance field in the Line Items.

When we jump for the Income Statement or P&L, the jump reports shows the correct value. I am using the Keyfigure 0VALUE_LC.

Can you please advise, how can i get the cumulative balance in the Line Items datasource or FlagflexA.

So that when the user jump from balance sheets, they will be able see the balance.

Appreciate all you help!

Thank You

[dennis_scoville4 · Accepted solution]

Because the FLAGFLEXA table contains actual accounting document postings, you would have to calculate cumulative balances ourself. For example, you could load to a DSO that has only goes to the GL Account Number and then load from the 0FI_GL_14 DataSource with extracted data from inception-to-date.

You should be able to get Balance Sheet balances from the 0FI_GL_10 DataSource, however, since that is really cumulative balances to begin with.

[Former Member · Accepted solution]

Thanks again Dennis,

Do you recommed that I can do a infoset on the DSOs based on 0FI_GL_10 & 0FI_GL_14 with join on GL Account Number.

[dennis_scoville4 · Accepted solution]

You could create an InfoSet that joins the data from 0FI_GL_10 and 0FI_GL_14. The join would be better on GL Account, Fiscal Year and Fiscal Period, however. Just be aware that the cumulative balance for the account and Fiscal Year/Period will always be the same for every row of detail data because you'd be combining details (0FI_GL_14) with already calculated cumulative values (0FI_GL_10).

A better bet may be to create a query on a DSO or InfoCube that contains the 0FI_GL_10 (FAGLFLEXT) data, create a separate query based on the 0FI_GL_14 (FAGLFLEXA) data. Create filters for the second query for fields that could be passed from the first query. Setup a Report-to-Report Interface (RRI) so that the second query is identified as a Jump Query for the first query. With this, your end customers would be able to execute a Financial Statement report using the cumulative data and then jump into the details for the GL Account and Fiscal Year/Period.

[mr_v]

I don't think you will manage to get Cumulative Balances at line item level and I don't think Infoset helps either.

To me it looks like you are trying for something which is (logically) not possible... Because, if u check totals extractor (0FI_GL_10), SAP has taken many factors (currency type, posting period, fiscal period, fiscal year variant etc) into consideration to calculate cumulative balances, while doing that it also takes balance from previous year as carryforward.

So, you can't manage this logic either at DSO, Cube or Infoset... Only way is to try by enhancing 0FI_GL_14 to manage this kind of logic. Best bet would be consulting your Business / Functional team to find weather it make sense (business/logically) calculating Cumulative balances at line item level

[Former Member]

Thank You all for all the responses and time!!!!

Our requirement is, we have financial statements coming from 0FI_GL_10 i.e 0FIGL_M10 Cube and after execution whether its a P&L/Balance Sheet, the user wants to RRI to the GL Line Item Details which should show the sum.

Example:

P&L : Gross Sales is a combination of some GL Accounts and the Key figure is 0SALES = 1000

Balance Sheet: Assets is a combination of some GL Accounts and the Key Figure is 0BALANCE i.e Cumulative Balances = 5678.....

The RRI report has the line item details and is out of 0FI_GL_14. And this doesnt have cumulative balances.

The RRI works for P&L Statements will show 1000, but it wont work for Balance Sheet, doesnt not show 5678, instead it will show the 0SALES for Assets GL Accounts.

I thought the infoset is the best solution, and would resolve this issue, but logically I am not sure if this is the only way.

[Former Member]

Hi Rian,

You can get the cumulative balance through start routine. It can be calculated from debit and credit amount. Please find the relevant code as below.

• calculate 0BALANCE from debit and credit value

ls_data_package-balance = ls_data_package-debit

- ls_data_package-credit.

"Credit is positive!

modify SOURCE_PACKAGE from ls_data_package.

if ls_data_package-balance ne 0.

• if 0BALANCE is not zero =>

• append periods to internal table for datapackage

clear: ls_data_package-credit,

ls_data_package-debit,

• ls_data_package-sales,

ls_data_package-quantity.

Hope it is useful.

Regards,

Muthu.