topic Re: remove 0 in Application Development and Automation Discussions

remove 0

Former Member — Fri, 19 Sep 2008 02:59:20 GMT

hi experts,

I have one requirement that in my zreport one column i have taken quantity field which is a neumeric field. but when there is no quantity in report it shows 0. but my customer want it should be ' ' <blank> bcz 0 indicates some different meaning . so how can i do this

This is an ALV report.

Re: remove 0

Former Member — Fri, 19 Sep 2008 03:05:14 GMT

in the fieldcatalog mention the NO_ZERO equal to 'X'.

fieldcat-no_zero = 'X'.

Re: remove 0

Former Member — Fri, 19 Sep 2008 03:08:29 GMT

HI friend.

I have tried that but it is giving error.

data : gd_field type slis_fieldcat_main0.

perform field.

perform alv.

form field .

gd_field-no_zero = 'X'.

endform. " field

form alv.

REUSE_ALV_GRID_DISPLAY

IT_FIELDCAT = gd_field

endform.

I tried this method but it is giving error.

Please guide me.

Thank you very much.

regards.

Re: remove 0

Former Member — Fri, 19 Sep 2008 03:11:35 GMT

FIELDCAT-NO_ZERO = 'X'.

No_zero (suppress zeros): Only relevant for value fields.

Value set: SPACE, 'X'.

'X' = suppress zeros.

The decimal places are displayed with the proper unit.

- An initial value field with reference to a non-initial unit is displayed as '0' (provided that FIELDCAT-NO_ZERO is initial). If unit-specific totals are calculated for this value field, the unit is considered in the analysis of whether homogeneous units exist.

- An initial value field with reference to an initial unit is displayed as SPACE. If unit-specific totals are calculated for this value field, the unit SPACE has no effect on the homogeneity of the unit if the value field is initial.

- For non-initial value fields with initial unit, the unit SPACE is considered as a unit when unit-specific totals are calculated.

Re: remove 0

Former Member — Fri, 19 Sep 2008 03:31:00 GMT

what error you are getting..?

i think you are doing some thing wrong.

Re: remove 0

former_member137336 — Fri, 19 Sep 2008 03:46:09 GMT

Hello Sarvanan,

What error you are getting? Vijay's solution should work.

While you are creating the field catalogue, for the value fields which you don't want to show zeroes just give the field no_zero as 'X' and append to field catalogue internal table.

Regards

Farzan

Re: remove 0

Former Member — Fri, 19 Sep 2008 04:17:11 GMT

hi there.

it is not error but it is dump error when it reach to the FM of the alv.

Re: remove 0

Former Member — Fri, 19 Sep 2008 04:20:07 GMT

that means you declared your parameters or fieldcatalog wrongly. show your fieldcatalog declartion, and population.

Re: remove 0

Former Member — Fri, 19 Sep 2008 04:21:56 GMT

hi vijay.

data : gd_field type slis_fieldcat_main0.

perform field.

perform alv.

form field .

gd_field-no_zero = 'X'.

endform. " field

form alv.

REUSE_ALV_GRID_DISPLAY

IT_FIELDCAT = gd_field

endform.

this is how i declared.

Re: remove 0

former_member137336 — Fri, 19 Sep 2008 04:30:18 GMT

Can you please brief on the dump??

Regards

Farzan

Re: remove 0

Former Member — Fri, 19 Sep 2008 04:31:22 GMT

if you do like this it never work...

Do you know how to work on ALV..?

report  ztest_alv.

type-pools: slis.
data: it_data type table of sflight.


data:
it_fieldcat type  slis_t_fieldcat_alv,  "Fieldcatalog declarion should be like this
wa_fcat like line of it_fieldcat.

select * from sflight into table it_data
up to 20 rows.

call function 'REUSE_ALV_FIELDCATALOG_MERGE'
  exporting
    i_program_name         = sy-repid
    i_structure_name     = 'SFLIGHT'
    i_inclname             = sy-repid
  changing
    ct_fieldcat            = it_fieldcat
  exceptions
    inconsistent_interface = 1
    program_error          = 2.


call function 'REUSE_ALV_GRID_DISPLAY'
  exporting
    i_callback_program = sy-repid
    it_fieldcat        = it_fieldcat
  tables
    t_outtab           = it_data
  exceptions
    program_error      = 1.

Re: remove 0

Former Member — Fri, 19 Sep 2008 04:37:34 GMT

Hi Vijay.

Thank you very much for the nice and kind reply.

regards,

s.saravannan