Skip to Content
author's profile photo Former Member
Former Member

Financial reporting and balance carry forward at Line item level

Hello

We are in the process of implementing a new GL and using it to create Balance Sheet and P&L statements in BW.

We have installed the new datasource for GL line items 0FI_GL_14 and loaded the data to a DSO. Installed the 0FI_GL_10 (totals infosource) as well.

Also we created a custom infocube on the line items DSO and want to use it to report against a Financial Statement Version. In order to do that we created a

virtual cube with the FM and added the necessary Financial Statement Item and other key figures in the virtual infocube.

Now I want to know is it the correct way to create financial reports?

Can we load totals and Line items to the same infocube? Do we have to load totals to a different DSO/Cube or same Cube?

How do we address the Balance Carry Forward on the Line items cube? Since the balance carry forward is done on totals only, and the cube I created is a detailed cube is it possible to carry forward balances at that level?

Also can someone let me know what is the best approach to create financial reports and give drill down capability at the document level?

Thanks in Advance

Raju Kosuru

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 14, 2011 at 03:54 PM

    Now I want to know is it the correct way to create financial reports?

    NO .. Its not.

    Can we load totals and Line items to the same infocube?

    NO

    Do we have to load totals to a different DSO/Cube or same Cube?

    Yes.. SAP has delivered C10 for Totals and O14 for line items... No point in creating cube for line items i.e. on top of O14.

    Balance carry forward can be done on totals only (that is how totals extractor _10 is designed), U can not do that on the Line items. Pls contact functional consultant for clarification

    Best approach is RRI (Jump targets) for _10 report to _14 report to give drill down capability at the document level.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.