Replace the default u0091#u0092 in BEx

[Former Member]

BW Experts,

Can we replace the ‘#’ with ‘0’ that shows up in the Bex reports when there is no data?. Is there any table / program / transaction where we can customize this settings.

Suggestions appreciated.

Thanks,

BWer

[edwin_harpino]

hi BWer,

you may need vba code,

check this thread

[Former Member]

A.H.P

Could anyone please help where to write the vba macro. is there any sap notes or any document or how-to guide would be great.

Any documents please send it to mgmswsol@gmail.com

Thanks,

BWer

[edwin_harpino]

hi BWer,

you can follow the code in the thread, change 'not assigned' with '0', or use table interface

by Peter

SAPBEXonRefresh()

Dim c as range

For Each c in resultArea.cells

if c.Value = "#" then c.Value = "0"

Next c

or

by Jens (consider to performance)

put in SAPBEXonRefresh()

resultArea.Select

Cells.Replace What:="#", Replacement:="0", LookAt:=xlPart, _

SearchOrder:=xlByRows,

MatchCase:=False,

SearchFormat:=False, _

ReplaceFormat:=False

table interface, redefine CHARACTERISTIC_CELL method...

if I_CHAVL = '#'.

c_cell_content = '0'.

endif.