topic string problem in Application Development and Automation Discussions

string problem

Former Member — Fri, 05 Jun 2009 08:56:51 GMT

HI,

i am downloading the data from excel to internal table.in that i have one field which i have declared as string type.(since it will hold more than 300 char).but still when try to get the string length its displaying only 256 and only i am getting 256 character.

pls help me

Re: string problem

Former Member — Fri, 05 Jun 2009 09:03:11 GMT

Hi,

did u check the size of the field of the internal table in which you are passing the value.

Re: string problem

Former Member — Fri, 05 Jun 2009 09:04:05 GMT

i have declared as type string.the size of the field coming from the excel is 293.

Edited by: Shantha Sheela on Jun 5, 2009 11:07 AM

Re: string problem

former_member212005 — Fri, 05 Jun 2009 09:07:15 GMT

I did check it...by creating a dummy program but dont know why it is giving you 256?

May be you can try char datatype with higher value rather than using string

say, DATA: gv_data(1000) TYPE c.

Edited by: Vin on Jun 5, 2009 11:07 AM

Re: string problem

Former Member — Fri, 05 Jun 2009 09:08:02 GMT

i have tried that as well not taking.

Re: string problem

UmaArjunan — Fri, 05 Jun 2009 09:08:08 GMT

I had the same problem when i downloading the data from excel.

After 255 characters , remaining characters are truncated

Using std \ custom FM , it is not possible to send more than 255 characters in CSV ( excel ) file format.

The solution which we used is described in the following steps:

we collected all the final data in the internal table ( including the path to download ) .

Then, that internal table is passed to SAP XI system ( integrated system ) thru the method of proxy calling.

We did it with the help of an XI consultant.

XI will support for downloading more than 255 characteres in excel file becos XI considers as a string.

Please check with any XI consultant to create proxy and try to send the internal table data for downloading

Thanks,

Uma

Re: string problem

matteo_montalto — Fri, 05 Jun 2009 09:08:53 GMT

Hi Shanta,

try to look at other types of data element based on CHAR in se11 tx. You should find many types to replace the string one that could get more than 300 char (i.e, CHAR339, CHAR512, CHAR600 and many more).

HTH,

Matteo

Re: string problem

Former Member — Fri, 05 Jun 2009 09:09:10 GMT

Hi,

why dont u declare the variable as char type with length 300.

Re: string problem

former_member212005 — Fri, 05 Jun 2009 09:14:36 GMT

Looks to me like you got the solution from Uma...

Refer the below link....it says microsoft has designed in a way that it wont allow more than 255 characters in a column....

http://office.microsoft.com/en-us/excel/HP051992911033.aspx

(Worksheet and Workbook specification)

May be you can use a text file or something...

Re: string problem

Former Member — Fri, 05 Jun 2009 09:39:36 GMT

is it possible to download into two separate fields.

if anyone worked on it can u pls send me the sample code.

Re: string problem

Former Member — Fri, 05 Jun 2009 10:31:25 GMT

i tried with text tab delimted file.

same problem.

its taking only 255 character.

Re: string problem

Former Member — Fri, 05 Jun 2009 10:49:53 GMT

Hi,

Don't use FM because FM supports for 255 characters only. You use OLE concept to get data from excel with above 255 length of data.

L.Velu