cancel
Showing results for 
Search instead for 
Did you mean: 

Financial reporting and balance carry forward at Line item level

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

mr_v
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks for the response.

In case I create a totals cube and drill down to details DSO, how would I create a ITD balance on the detail level?

Thanks

Raju Kosuru

mr_v
Active Contributor
0 Kudos

I think Totals cube will give u Cumulative Balances, NOT sum of credit and debit...

U should create Cal KF in totals cube (sum of credit and debits) and in drill down u should see item level details on DSO report.