Dispalying trailing zeros in Bex

[Former Member]

Hi,

I have an infoobject with ALPHA conversion to remove leading zeros. Is there any way to display leading zeros on selected Bex reports for that infoobject?

Thanks

[Former Member]

Hi,

It's not a problem to show leading zeros in Excel!

You need to write a macro and for cells with these zeros set a format:

SET PROPERTY OF CELL 'NumberFormat' = '@'

Best regards,

Eugene

[Former Member]

Thanks for your answer...

Actually the topic should Displaying Leading Zeros not Trailing zeros....

Anyway...Can u explain a bit more...Do I have to write the macro first and then change the cell property?

Thanks

[Former Member]

Hi,

Removing of Alpha conversion is the not proper solution.If do not have the alpha conversion , the system will consider 001 and 1 as two different values,for example.

We can get this one for material using Transaction code: OMSL

Here you can see check box for 'Leading Zeros'.If you select his , in the output system will display material number with leading zeros.

Similarly, I hope, there will one Transaction code, to do above procedure, for Z Info objects also.

Do Some R&D , and also take SAP OSS help.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi,

The statement I wrote should be in macro embedded into Excel workbook. But data coming to Excel should be with leading zeros already.

If you need further clarifications just post back.

Best regards,

Eugene

[Former Member]

Hello,

With excel there is a problem displaying leading zero for a number field, the only way you can probably do it is by

A. Create a new Character Object and Pass the information with leading Zeros in the Cube using update rules or

2. Create a Virtual Character and populate the Info object with Leading zeros during Query Run time.

Hope this helps…

Sridhar.