FIELD BLANK

[Former Member]

HI,

IN THE ALV GRID OUT I AM HAVING ONE FIELD CALLED EKET-WEMNG

WHEN I EXECUTE THE REPORT I AM GETTING SOME VALUE FOR THIS FIELD BUT THIS FIELD NEEDS TO BE BLANK IN THE OUT PUT

HOW TO DO THIS

CAN ANYONE GUIDE ME PLZ

SIRI

[Former Member]

First, make the "X" uppercase, if it still doesn't work, try adding this line as well.

fieldcatalog-fieldname = 'WEMNG'.

fieldcatalog-seltext_m = 'QTY RECEIVED'.

fieldcatalog-col_pos = 15 .

fieldcatalog-no_zero = 'X'.

fieldcatalog-datatype = 'QUAN'. "< -

---

This line

fieldcatalog-REF_TABNAME = 'EKET'.

fieldcatalog-REF_FIELDNAME = 'WEMNG'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

Regards

RIch Heilman

[RichHeilman]

Do you mean, that is is showing as 0, but you need it to be blank? If so, you can try setting the NO_ZERO flag in the field catalog.

....
fc_tmp-NO_ZERO = 'X'.
append fc_tmp to fieldcat.

Regards,

Rich Heilman

[Former Member]

no rich

i did the same even though it is showing me the same

0.0000

how to delete that value i have to put that filed blank

[RichHeilman]

Can you tell me how the field is defined in the internal table used in the ALV as well as the code which builds the column in the field catalog.

Regards,

RIch Heilman

[Former Member]

ya definetly rich...

here is the int table declaration...

Types: begin of t_ekko,

ebeln type ekko-ebeln,

aedat type ekko-aedat,

ekgrp type ekko-ekgrp,

ekorg type ekko-ekorg,

lifnr type ekko-lifnr,

ebelp type ekpo-ebelp,

menge type ekpo-menge,

meins type ekpo-meins,

matnr type ekpo-matnr,

lgort type mard-lgort,

idnlf type ekpo-idnlf,

TXZ01 type ekpo-TXZ01,

lgpbe type mard-lgpbe,

LGOBE TYPE T001L-LGOBE,

MENGE1 TYPE EKES-MENGE,

<b>wemng type eket-wemng,</b>

end of t_ekKo.

and field catalog for that field is here

fieldcatalog-fieldname = 'WEMNG'.

fieldcatalog-seltext_m = 'QTY RECEIVED'.

fieldcatalog-col_pos = 15 .

fieldcatalog-no_zero = 'x'.

fieldcatalog-REF_TABNAME = 'EKET'.

fieldcatalog-REF_FIELDNAME = 'WEMNG'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

I am getting in the out put 0.000

Thanks alot for your time Rich...

[Former Member]

hi sri

i think we can use this code for ur problem

declare :

data: wa_fieldcat type slis_fieldcat_alv.

read table vt_fieldcat into WA_fieldcat with key fieldname =' '.

if sy-subrc = 0.

WA_fieldcat-reptext_ddic = ' '.

modify vt_fieldcat from WA_fieldcat index sy-tabix.

endif.

[RichHeilman]

First, make the "X" uppercase, if it still doesn't work, try adding this line as well.

fieldcatalog-fieldname = 'WEMNG'.

fieldcatalog-seltext_m = 'QTY RECEIVED'.

fieldcatalog-col_pos = 15 .

fieldcatalog-no_zero = 'X'.

fieldcatalog-datatype = 'QUAN'. "< -

---

This line

fieldcatalog-REF_TABNAME = 'EKET'.

fieldcatalog-REF_FIELDNAME = 'WEMNG'.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

Regards

RIch Heilman

[Former Member]

solved the problem rich...

but for 0.0000 then it is giving me blank, for some records there r other values also like 5.000 those r not blank

how to do these also blank rich...

[RichHeilman]

Blank meaning that you don't want the decimal places? If so, then set field DECIMALS_OUT = 0.

fc_tmp-DECIMALS_OUT = 0.

Be sure to award points for any helpful answers and marked as solved when solved completely.

Regards,

Rich Heilman

[Former Member]

No rich

its is the same again.. I should not display any value in that field so that client can enter their value in that field so it should be blank not even with 0.

SIRI

[RichHeilman]

Then you shouldn't be filling it in your internal table. When filling your internal table, clear it out. Then there will be no value for it, nor will it show as 0.

Regards,

Rich HEilman

[Former Member]

internal table declare without header line rich

how to clear that value can shoot me a statement plz

[RichHeilman]

data: wa like line of itab.

loop at itab into wa.
 clear wa-fld1.
 modify itab from wa index sy-tabix.
endloop.

Regards,

Rich Heilman

[Former Member]

Thanks alot rich problem solved....