Balance Sheet Ledger Report

[Former Member]

Hi All,

I was not given any func specs nor tech specs. I am having only the end users format with me.Now I got to implement the same in BW and generate a report. The following is the required format.....

Total Fixed Assets

Gross Fixed assets

Accumulated Depreciation

Net Fixed Assets

capital work in progress (CWIP)

Current Assets

Inventory Finished goods

Inventory raw Materials

Inventory Stores and spares

Inventory Work in Progress

Inventory

Trade Debitors - Critical

Trade Debitors non-Critical

My question in order to develop the above reports is it required to create opening balance in BW using the datasource 2lis_03_bx or i can use directly the data source 0fi_gl_06.

Please provide inputs on these

Regards

Pavan Kumar Prakhya

[Former Member · Accepted solution]

Hi,

Inventory Datasources(2lis_03_bx,..) are not suitable for this

I think you have to look at the either GL cubes or Asset cubes.

http://help.sap.com/saphelp_nw04/helpdata/en/04/7b95fb42b0f94aba334c0890dbbda4/frameset.htm

With rgds,

Anil Kumar Sharma .P