opening and closing balances

[Former Member]

Hi sapgurus

I need a report with similar to MB5B at particular posting date with opening and closing balances but I am unable to download the report to excel the data with MB5B tranasaction.Is there any similar transaction with same output values which can be easily transported to excel from Sap.

Thanx

[former_member433442]

Hi,

I tested in ECC6.0 and i could able to do so, you try as mentioned below.

In the output screen of MB5B, goto menu details > click on list > select save > select file > select spreadsheet. Here you can save tthe output in excel format.

Regards,

Prabu

[kunal_ingale]

hi

goto LIST>save?localfile

or

ask ur abaper to copy the programme of MB5B and make new Zreport

theat will be more benififcial

by developing z report u can get the report in proper ALV format

regards

kunal

[Former Member]

Any inputs please

Thanx

[former_member433442]

Hi,

Try with the table S033.

Regards,

Prabu