ALV Display

[Former Member]

Hi,

I need to display the GL number and and corresponding entries like

151233 XXXXXXXX 121 122

XXXXXXXX 222 222

xxxxxxxx 252 252

IN the above 151233 G/L should be merged for all the rows for their corresponding entries.

For this which alv FM is to used.

Please provide me the code. How to download to excel?

Please let me know.

Thanks,

Pavan.

Message was edited by: Pavan Panduru

Message was edited by: Pavan Panduru

Message was edited by: Pavan Panduru

[Manohar2u]

You can use REUSE_ALV_GRID_DISPLAY and with sort on GL Account number.

http://www.sap-img.com/abap/alv-grid.htm

Regds

Manohar

[Manohar2u]

Dowload a report to excel sheet

http://www.sap-img.com/abap/download-to-excel-with-format-border-color-cell-etc.htm

http://www.sapdevelopment.co.uk/ms/ms_excel.htm

ALV example programs

http://www.sap-img.com/abap-function.htm

Regds

Manohar

[RichHeilman]

All you need to do is sort by the GL number, then the column will merge like GL accounts.

Regards,

Rich Heilman

[Former Member]

Hi,

When I sort by gl account the alv display screen is going down.

Please let me know what is the reason?

Thanks,

Pavan.

Message was edited by: Pavan Panduru

[Manohar2u]

Going down? It might be due the entire list has one GL account. Or one GL has 100+ items?

Regds

Manohar