data in changed format in ODS

[Former Member]

Hi,

I read data to BW from .csv files.

One column is CHAR(20) type and sometimes it contains numbers.

The problem is that these numbers apperar in the ODS with 0s on the left: 42 becomes 00000000000000000042.

How can i get rid of these 0s?

Thanks in advance:

Bianca

[Former Member]

Your char lenth is 20 so ur getting zero, Double click on ur infoobject and select alpha .

se this document:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/7108a690-0201-0010-4cbc-9bca94f9a...

http://help.sap.com/saphelp_nw70/helpdata/EN/9b/f9c18f5a07f0459127e9676ae22a54/frameset.htm

[Former Member]

hi,

Write a field level routine for the infoobject  using FM CONVERSION_EXIT_ALPHA_OUTPUT.

input as source field and output as RESULT.

Regards

Konda Reddy

[Former Member]

Hi Bianca,

It is because your info object is of type CHAR and contains numeric values  .

If it is numeric only then set data type as NUMC .Also please check whether conversion routine of info object is set as ALPHA or not .If it is not then values will be fixed (padded 0 with numeric values ).

Regards,

Jaya

[Former Member]

Hi Jaya,

Thank you for your answer but this column contains both numbers and strings so  i cannot change the type of the column to NUMC.

And some of the values begin with zero: (for exemaple 04) so cutting await all zeros from the left neither a solution.

Regards:

Bianca

[Former Member]

Hi Bianca,

Then you need to change your infoobject a little , put ALPHA in Conversion Routine box  .This will solve your problem .

Regards,

Jaya