DataSources

[Former Member]

I need to do 2 reports in bw, the balance sheet report monthly and commulative, and the income statement report, can someone tell me what datasources i need to use pls?

[Former Member · Accepted solution]

Hi,

Please check data source 0FI_GL_10.

Regards,

Kams

[Former Member · Accepted solution]

is that data source good for both reports??

i already checked that but it doesnt have the cost center and functional area, should it have the profit center? i mean it does have that filed in the structure, and its coming empty

Edited by: Pizza Girl on May 11, 2009 7:49 PM

[Former Member · Accepted solution]

Hi,

I think both the reports could be generated from this and we are already using reports created on the data target 0FIGL_V10/0FIGL_C10.

Please check if there is any record created in source system with profit center.

Regards,

Kams

[Former Member]

Hi,

If your ERP system (R/3) has been updated with Enhancement pack 3 then you can use 0FI_GL_14 which is a new Datasource which meets ur requirement. It maintains line item level with cost center in it.

[http://help.sap.com/saphelp_nw70/helpdata/EN/45/4f8e8bbf3f4f63a5dd197ef7d53fa2/frameset.htm]

cheers

Rammi

Edited by: Rammi on May 11, 2009 11:55 PM