Supressing zero values in table control

[Former Member]

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.

[Former Member]

Hi,

Try like,

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

Regards.

[Former Member]

Hi,

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

[Former Member]

Hello

LVC_S_FCAT-NO_ZERO = 'X'

[Former Member]

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

[Former Member]

Go to screen painter.

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.