Cannot delete leading zeros in BW InfoObject

[Cr_1234]

Hi friends,

I have a very strange problem and I really need your help. My InfoObject always adds leading zeros to the int values.

Sounds easy to solve? I thought so too, but no..

The InfoObject is specified with char(250) and case-sensitive option is enabled. The ALPHA-Routine is removed in the InfoObject. The incoming values can be whole numbers or texts. When texts are flowing in, the text is identically displayed. When the numbers are flowing in, there are always 249 zeros added before the number. But I need them to be displayed just the same as the text.

I have already tried:

- CONVERSION_EXIT_ALPHA_OUTPUT

- Shift Variable LEFT deleting leading '0'

- CONCATENATE(Variable, ''{STRING} )

Nothing of the above has worked, the zeros are still there!

The only thing, that somehow worked, was when I used "CONCATENATE(Variable, 'A'{STRING} )" as a transformation formula. But since the InfoObject also contains text attributes, I do not want to change the key value.

Example of the current result:

abc-->abc

1 ---> 0000[...]01

Needed result:

1--->1

I am really looking forward to any help!

Thank you & kind regards,

[MKreitlein]

Hello Vera,

I have not heard or seen this before. Which BW Release do you have?

Might be your Infoobject was activated first with ALPHA conversion, before you changed it?

Have you tested it with another one, without conversion before activating?

BR, Martin

[Cr_1234]

Hello Martin,

I found the reason for this issue. As you have already suspected, the InfoObject war activated first with ALPHA conversion. But after I have deleted the ALPHA conversion from the IO and also activated the associated aDSO, the issue still persisted. The cause for this behaviour was within the transformation because the ALPHA routine was still in the transformation rule. Firstly, in the "Conversion Exit" in the rule details (where I have already unchecked the "Perform"-option.). Secondly in the "Taget Fields of Rule", where the Conversion Routine was still shown. This second occurence was the core of the issue.

My solution was then to delete the IO from the aDSO, activate the Transformation without the IO, add the IO again to the aDSO and then create the transformation rule again. By this, the ALPHA routine disappeared completely from the rule details. This does not seem logical to me because when the InfoObject does not contain a conversion exit anymore, it should not be possible to see this in the transformation rules either?!

(We are running on BW 7.5)