topic Re: Custom table data upload error in Application Development and Automation Discussions

Custom table data upload error

Former Member — Mon, 22 Mar 2010 13:04:03 GMT

I have an upload program for z table using gui_upload.

My fields in the table are in the sequense

client

land1

vkorg

vkbur

kunnr

createdate

userid

changeddate

userid.

I am using field separator in the FM.

First 6 fields get uploaded correctly but then the last 3 fields are getting mixed up , to be exact 7th field gets shifted by 2 position and so last 3 i.e. 7,8,9 get mixed up and last field looses some informatin. what could be the error? I am also using conversion exit for dates.

Re: Custom table data upload error

Former Member — Mon, 22 Mar 2010 14:46:57 GMT

What is the length of date fields in you internal table that recieves data?

I think you shoul give them 2 more characters...

Best Regards

Yossi

Re: Custom table data upload error

Former Member — Tue, 23 Mar 2010 05:45:42 GMT

The field is of char type and is of length 10. Is it a code page issue? Actually when I debug I can see everything is got perfectly in the internal table. But from itab to custom table something goes wrong and custom table has all wrong data.

Re: Custom table data upload error

SuhaSaha — Tue, 23 Mar 2010 05:51:50 GMT

Hello,

If the file contents are uploaded correctly in your internal table i dont think you have issues with the codepage.

Anyways i see you have dates in your file. In what format are the dates uploaded to your internal table ? (Whatever be the format to have to make sure before the update to the DB table you need to change to internal date format YYYYMMDD)

And can you provide the structure of your internal table & your DB table ?

BR,

Suhas

Edited by: Suhas Saha on Mar 23, 2010 11:27 AM

Re: Custom table data upload error

Former Member — Tue, 23 Mar 2010 05:52:14 GMT

Hi,

Define ur intenal table as

data: Itab type standatd table of zitab.

Don't define structure.

If u define internal table same as ztable by default it will take all daa types similar to that.

Try this .May solve ur proble.

Regards,

Pravin

Re: Custom table data upload error

Former Member — Tue, 23 Mar 2010 07:44:28 GMT

Thanks all for your inputs. I used Pravin's advice and it is solved.