topic Re: Supressing zero values in table control in Application Development and Automation Discussions

Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:17:28 GMT

Hi Gurus,

I'm getting data from db table to a table control in screen. But some currency amount data are having the value zero. I don't want to display the zero value but instead I just want the cell to be blank in the table control.

Pls advice how it can be done. Thks.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:29:04 GMT

Hi,

Try like,

SHIFT text RIGHT DELETING TRAILING '0'. "or LEFT

Regards.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:32:31 GMT

Hi,

But how do I do it in a table control. Could you kindly explain with an example. Thks.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:49:48 GMT

Hello

LVC_S_FCAT-NO_ZERO = 'X'

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:54:02 GMT

LVC_S_FCAT-NO_ZERO should be used in an ALV. But I'm using table control in a screen.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 08:55:29 GMT

Go to screen painter.

Double clock on that field.In attributes select 'Dict' tab and change format to CHAR.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 09:01:42 GMT

In the column, some rows have data and some rows have value zero. But if the change the type to char the entire colum becomes blank/no value.

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 09:12:07 GMT

why dont you change data type of currency

into char in internal table only

it will differentiate space and 0

then in PAI move back this character value

to currency in internal table

if its input field then u can prevent user to enter

character value also

Regards,

Alpesh

Re: Supressing zero values in table control

Former Member — Fri, 17 Oct 2008 09:30:10 GMT

hi,

you are moving datas from prg field to screen field in PBO loop statement.you can restic the zero value. like

if amt ne 0.

move prg-fld to scr-fld.

endif.