topic Re: ALV Grid Filter it_filter in Application Development and Automation Discussions

ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 19:08:59 GMT

Hi Experts.

Filter is not working. Giving DUMP "Unable to interpret '*' as number".

I am trying not to show 0.00 values in ALV for field 'OPEN_BAL'.

My code

 
  ls_filter-fieldname = 'OPEN_BAL'.  " *Is a Currency Field of TYPE umxxs* 
  ls_filter-tabname = 'GT_AR_FINAL_TABLE'. 
  ls_filter-sign0 = 'I'. 
  ls_filter-optio = 'NE'. 
  ls_filter-valuf_int = '0'. 
  APPEND ls_filter TO lt_filter. 

  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' 
    EXPORTING 
      i_callback_program      = sy-cprog 
      i_callback_user_command = 'USER_COMMAND' 
      i_callback_top_of_page  = 'TOP_OF_PAGE' 
      is_layout               = ls_struct_layout 
      it_fieldcat             = gt_fieldcat[] 
      i_save                  = 'A' 
      it_events               = gt_events 
      it_filter               = lt_filter[] 
    TABLES 
      t_outtab                = gt_ar_final_table 
    EXCEPTIONS 
      program_error           = 1 
      OTHERS                  = 2.

Not sure why. When i debug the DUMP i can see I and NE in the selopt table but then low value has * init.....Not sure why.

Any Ideas.

Regards,

Sharat Chandra.

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 19:47:21 GMT

Instead of ls_filter-valuf_int = '0' use ls_filter-valuf_int = 0. Here remove single cote.

Re: ALV Grid Filter it_filter

MarcinPciak — Wed, 17 Dec 2008 19:57:17 GMT

Hi Sharat,

Try giving up this line at all.

ls_filter-valuf_int = '0'.

It would mean: filter the values where NE empty. Assuming OPEN_BAL is an amount field, empty would be by default set to 0, therefore it should work.

Hope it will help you

Marcin

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 20:35:31 GMT

Hello Gunasekhar,

Tried that ...no luck....

Sharat

Edited by: Sharat Chandra on Dec 17, 2008 2:35 PM

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 20:41:08 GMT

Hello Marcin Pciak

No Luck here also.

Can you let me know what else do i have to take care before doing a filter.

Regards

Sharat

Re: ALV Grid Filter it_filter

MarcinPciak — Wed, 17 Dec 2008 20:58:21 GMT

Hi Sharat,

Maybe this will help:


ls_filter-valuf = '0.00'.
ls_filter-valuf_int = '0'.

Once again: what is the select options name, and what table GT_AR_FINAL_TABLE has data in?

Marcin

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 21:17:41 GMT

Hello Marcin Pciak,

 
ls_filter-valuf = '0.00'. 
ls_filter-valuf_int = '0'. " *No luck here Still giving me DUMP*

What select options name do u want?

GT_AR_FINAL_TABLE has two charactor field and 6currency field.

i need that if first currency field is 0.00 then don't show that row at all.

Regards

Sharat,

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 22:52:53 GMT

Any Clues plz...

thanks

Sharat

Edited by: Sharat Chandra on Dec 17, 2008 4:52 PM

Re: ALV Grid Filter it_filter

Sandra_Rossi — Wed, 17 Dec 2008 23:01:26 GMT

Note 1159560 - ALV filter: Incorrect length in filter dialog box

The correction also applies to your case.

Re: ALV Grid Filter it_filter

Former Member — Wed, 17 Dec 2008 23:11:54 GMT

Hi Sandra Rossi,

Can you please explain.

if you can, plz send me a simple filter program in ALV. It will help me a lot.

Thank you in advance.

Regards

Sharat Chandra

Re: ALV Grid Filter it_filter

Sandra_Rossi — Wed, 17 Dec 2008 23:21:11 GMT

apply this sap note to correct the bug (be sure that it applies to your current sap release/patch). There is also another sap note, check by yourself if it is needed, and tell us if it works.

I found this note because I have the same bug in release 7.0, and I debugged where was the problem and found that this correction will probably help (in fact, the number is right-aligned by SAP at 45 characters, but is then truncated to 39 and SAP loses the "0" value and replaces it by "*" because of some dark reasons...)

Your program is correct

Re: ALV Grid Filter it_filter

Former Member — Thu, 18 Dec 2008 04:36:49 GMT

Ooppss!!............thats very very bad news......

Is there any alternative you found for that. If yes, please let me know.

And thanks very much from stopping break my head.

Cheers,

Sharat Chandra

Re: ALV Grid Filter it_filter

Sandra_Rossi — Thu, 18 Dec 2008 19:01:41 GMT

why bad news? just apply the correction, that's all. Do you know how to do it?

Re: ALV Grid Filter it_filter

Former Member — Fri, 19 Dec 2008 00:34:45 GMT

Bad news is i dont know....

Can you help me how to....

Thanks

Sharat

Re: ALV Grid Filter it_filter

Sandra_Rossi — Fri, 19 Dec 2008 09:01:31 GMT

To apply a note, ask the administrator. They will use SNOTE transaction, to download the note and apply it (one button to do it automatically). If this note does not apply to your current release, the admins will tell you. If this notes requires other notes, the admins will apply them (normally they should inform you). It takes 10 minutes.

Good luck.

Re: ALV Grid Filter it_filter

Former Member — Wed, 21 Jan 2009 19:45:48 GMT

Hi Sandra Rossi ,

Can you please send the note number to solve this porblem

Thanks

Sharat

Re: ALV Grid Filter it_filter

Sandra_Rossi — Wed, 21 Jan 2009 20:18:54 GMT

refer to my answer [here|;

Re: ALV Grid Filter it_filter

sudarshan_b — Fri, 29 Apr 2011 13:48:05 GMT

Hi Sharat,

Even I am facing the same problem that you described above. You have marked this question as "Answered".

So can you share what solution did you apply to get rid of this dump? Did you implement the SAP Note which Sandra was talking about?

Appreciate if you could reply.

Thank you.

Regards,

Sud.