topic Re: Problem while reading data from AL11 in Application Development and Automation Discussions

Problem while reading data from AL11

Former Member — Tue, 07 Feb 2012 08:41:16 GMT

Hi Experts,

I am using OPEN DATASET

READ DATASET

CLOSE DATASET to read data from the application sever. In application sever the file type is .CSV. So after reading data from application layer(AL11) to a text variable, using statement ' SPLIT AT ',' ' all the values passing into correspoding internal table fields. And it getting updated successfully into DB also.

In above scenario my question is, if aquantity figure with coma seperator( 95,000,000.000), then while SPLIT it's creating problem. Same case in .XLS file, it will be created # seperator in the application layer. if any field having # then it will create problem again.

So can anybody suggest how can we over come the problem. Or is there any other way to read data properly from application layer(AL11)?

Thanks and regards,

Phani.

Re: Problem while reading data from AL11

andreas_mann3 — Tue, 07 Feb 2012 13:02:19 GMT

to overcom this problem,

normally we use tab as sparator

so use CL_ABAP_CHAR_UTILITIES=>VERTICAL_TAB to separate your fields!

grx

Andreas

Re: Problem while reading data from AL11

Former Member — Wed, 08 Feb 2012 09:12:46 GMT

We can use 'CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB' as a seperator to split single field value into different.

Thanks,

Phani