Custom table data upload error

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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.

[SuhaSaha]

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

[Former Member]

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

[Former Member]

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