topic Re: Issue with open dataset in Application Development and Automation Discussions

Issue with open dataset

Former Member — Tue, 24 Jun 2014 06:52:16 GMT

Hello Experts,

I have CSV file in application server and one program will run daily basis to pick the file and read the content using open dataset and posting the transaction FB01.

Below the content I could see in Application server and I am using R/3 4.7.

240,17015,27436,143601,2436405,836002A,21.38,U04066,,DunnXX Feb 17 - Feb 22,20#

240,17015,37436,143601,2436405,837203A,36.00,U04066,,DunnXX Feb 17 - Feb 22,20#

240,17015,47436,143601,2436405,836003A,237.64,U04066,,DunnXX Feb 17 - Feb 22,20#

When I post into the transaction FB01, and the reference column 20# also coming but it it should be 20.

My question is when I open into notepad file the '#' not coming but when I debug in program the value 20 and '#' also coming. I tried to replace and find also but not working.

Can you please anyone help me to resolve.

Regards,

Vadamalai A

Re: Issue with open dataset

Former Member — Tue, 24 Jun 2014 06:58:17 GMT

That '#' is the special character which is 'Enter' Key in notepad.

Sap also reads that character as 'Enter'

Re: Issue with open dataset

Former Member — Tue, 24 Jun 2014 06:58:59 GMT

Hi Vadamalai,

when you do the split operation for identifying next line.. use

cl_abap_char_utilities=>cr_lf.

SPLIT lv_filestring AT cl_abap_char_utilities=>cr_lf INTO TABLE lt_filedata.

Thanks & Regards,

Tashi

Re: Issue with open dataset

Former Member — Tue, 24 Jun 2014 07:01:49 GMT

Yes,

I dont want to post reference along with #. I couldnt replace also.

How to address this.

Regards,

Vadamalai A.

Re: Issue with open dataset

Mohamed_Mukhtar — Tue, 24 Jun 2014 07:12:04 GMT

Hello Vadamalai,

Please go through the below link and it will resolve your issue.