Skip to Content
0
Former Member
Sep 04, 2012 at 08:02 AM

RSCRM_REPORT adds leading zeros

17 Views

Hello Experts,

I am using RSCRM_REPORT to extract a query data into a csv file.

The file is generating correctly but all the objects are added with the leading zeros (which is not the case when I run the Bex Report).

i.e. TAX Account is part of the report. The Infoobject is type CHAR and length is 20.

Most of the TAX Accounts in my system are 7 digit long. example 1010001

The BEx report shows the TAX Account correctly as 1010001

But the csv extract shows the data as 00000000000001010001. (it adds 13 zeros in front of the TAX Account). Attached file shows screen shot of csv file and Bex. Same is happening for all fields. I highlighted the issue in RED in attached file.

Is there a way to overcome this issue.

Regards,

Sandeep

Attachments