Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Upload longtext from EXCEL

Go to solution
Former Member

‎2008 Jul 23 10:18 AM

0 Likes
1,146

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Jul 23 10:21 AM

0 Likes
1,056

HI

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

Aditya

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

Reply
7 REPLIES 7
Read only

Go to solution
Former Member

‎2008 Jul 23 10:21 AM

0 Likes
1,056

HI

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

Aditya

Read only

Go to solution
Former Member
In response to Former Member

‎2008 Jul 23 10:27 AM

0 Likes
1,056

Hi Aditya,

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

Do you have a better idea?

Read only

Go to solution
Former Member
In response to Former Member

‎2008 Jul 23 3:34 PM

0 Likes
1,056

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.

Read only

Go to solution
Former Member
In response to Former Member

‎2008 Jul 23 3:46 PM

0 Likes
1,056

Did you try using GUI_UPLOAD instead?

Read only

Go to solution
Former Member

‎2008 Jul 23 10:21 AM

0 Likes
1,057

HI

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

Aditya

Read only

Go to solution
Former Member

‎2008 Jul 23 10:21 AM

0 Likes
1,056

Hi

Go through the link given below :

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

With Regards

Nikunj Shah

Read only

Go to solution
former_member196064
Active Participant

‎2008 Jul 23 4:10 PM

0 Likes
1,056

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 -