topic Re: Upload longtext from EXCEL in Application Development and Automation Discussions

Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 09:18:01 GMT

Hi experts,

i am trying to upload a catalogue from an excel-file. I am using the FM: TEXT_CONVERT_XLS_TO_SAP.

I get my data into my internal table, but unfortunately the longtext can not be uploaded completly, because although my itab contains a string-field, i can not upload more than 255 characters per field.

Can anybody of you please advise what i need to do to get all characters into my itab?

Thanks in advance!

Points will be awarded for every helpfull answer!

Felix

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 09:21:03 GMT

Replace the STRING TYPE by TEXT500 or TEXT600 as per requirement.

Aditya

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 09:21:09 GMT

Replace the STRING TYPE by TEXT500 or TEXT600 as per requirement.

Aditya

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 09:21:56 GMT

Go through the link given below :

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a6a6f6b1-0a01-0010-97b4-90ccb35e2e54

With Regards

Nikunj Shah

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 09:27:56 GMT

Hi Aditya,

sorry, but i am still getting only 255 characters into may text512 field.

Do you have a better idea?

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 14:34:03 GMT

Hello, I have debugg the funcion and I have seen that in sentence: CALL METHOD l_iref_spreadsheet->get_ranges_data the function get value of excel in the table l_table_range. This table is declarated of type SOI_GENERIC_TABLE that has a field "Value" where get the content of excel. The problem is that the field value of l_table_range is type char(256).

The solution may be that you copy the function to Z and modify this fields for more length.

Hope help you.

Re: Upload longtext from EXCEL

Former Member — Wed, 23 Jul 2008 14:46:30 GMT

Did you try using GUI_UPLOAD instead?

Re: Upload longtext from EXCEL

former_member196064 — Wed, 23 Jul 2008 15:10:33 GMT

Aparna is right, use GUI_UPLOAD.

I use it to upload my functional locations.

they have a long text descpription on them.

I created a table of type string & use it in the

GUI_UPLOAD CALL then parse based on

the delimiter from Excel...

You might be able to use a regular itab

with a string type field in that field's position. though.

Doug -