topic Re: ALV Problem in Application Development and Automation Discussions

ALV Problem

Former Member — Fri, 19 Dec 2008 03:59:23 GMT

Moderator message: please use a more meaningful subject in future

Hi Experts,

I have one query in ALV report. In ALV output I am not able to see the option for SUM & subtotal icons are not displayed.

I wanted to display both icons in my ALV output. Any suggestion how I can achieve this requirment.

Also, icons for Microsoft excel & word processing is not working.

Please suggest me.

Regards,

Poonam

Edited by: Matt on Dec 19, 2008 6:55 AM

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 04:02:44 GMT

hi,

can i have your code to returen for ALV.

Regards,

Arjun.

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 04:05:55 GMT

For Sum/Subtotal icon,atleast one summable field should be there in your internal table(Which you are showing in output).I guess all field are type CHAR in your internal table.Check it.

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 04:10:03 GMT

Are you usin OO method for ALV?

if you are using then you need to write the code for them

Regards

Shiva

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 04:37:56 GMT

hi,

You need to create 'Layout' for displaying the Tool bar.

If you are Creating ALV using OOPS method , then declare a work area like this,

Data : ty_lay1 TYPE lvc_s_layo.

ty_lay1-no_toolbar = ''.

Then pass this work area to method 'set_table_for_first_display'

CALL METHOD cl_alv->set_table_for_first_display

EXPORTING

is_layout = ty_lay1

CHANGING

it_outtab = t_output[]

it_fieldcatalog = t_fieldcat.

However If you are using FM REUSE_ALV_LIST_DISPLAY or FM REUSE_ALV_GRID_DISPLAY

then you have to declare above work area like this,

Data : ty_lay1 TYPE SLIS_LAYOUT_ALV.

ty_lay1-no_toolbar = ''.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

is_layout = ty_lay1

CHANGING

it_outtab = t_output[] " Internal table which holds data

it_fieldcatalog = t_fieldcat. " Field catlog

Re: ALV Problem

GauthamV — Fri, 19 Dec 2008 04:50:22 GMT

hi,

check this.

[https://forums.sdn.sap.com/click.jspa?searchID=20136253&messageID=5721304]

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 05:01:42 GMT

Hi,

I have developed ALV using normal FM's. Could you pls suggest me how I can display the icons for Sum & Subtotal options.

Also I wanted to use the option Microsoft work & Microsoft excel icon should work. How I can achieve this requirement.

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 05:29:33 GMT

HI..

Refer this link.

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

Regards.

Jay

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 05:31:15 GMT

Hi Poonam,

Do you have any numeric field in the output of ALV. If not, then i beleve SAP wont enable the Sum & sub total buttons .

Best regards,

Prashant

Re: ALV Problem

matt — Fri, 19 Dec 2008 05:55:42 GMT

Please use a more meaningful subject in future

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 06:54:46 GMT

Hi Prashant,

Yes, I have numeric field in my output table. Please tell me how I can go ahead.

Re: ALV Problem

Former Member — Fri, 19 Dec 2008 06:58:11 GMT

This is a issue related to Authorizations.

Try checking your ALV report output for other user having all authorizations.

Also consult Basis guy.

I faced the same issue.