PROB in GUI_upload for numeric and date fields

[abaper_guy]

I have txt file with 2 records each with 5 fields out of which 2 are numeric n 1 is date.I hv written a report for uploading this to the database. First i m bringing the the data from txt file into screen fields. During this process i find out that the numeric fields n date fileds r not coming in the screen fields.

It gives a error "ZSCREEN_EMP-SAL value is larger than screen field". where SAL is a numeric field.The data which im giving in within the limits of max length.

In the text file , i m give each field seperated by a tab space.

i hv given file type as ASC n WRITE_FIELD_SEPERATOR as 'X". All other attributes r default values (commented).

[abaper_guy]

I have txt file with 2 records each with 5 fields out of which 2 are numeric n 1 is date.I hv written a report for uploading this to the database. First i m bringing the the data from txt file into screen fields. During this process i find out that the numeric fields n date fileds r not coming in the screen fields.

It gives a error "ZSCREEN_EMP-SAL value is larger than screen field". where SAL is a numeric field.The data which im giving in within the limits of max length.

In the text file , i m give each field seperated by a tab space.

i hv given file type as ASC n WRITE_FIELD_SEPERATOR as 'X". All other attributes r default values (commented).

[Former Member]

If you are using GUI_UPLOAD, set the export parameter DAT_MODE as 'X' and check if you are able to upload the numeric and date fields

Vikranth

[abaper_guy]

thanks for ur rely vikrant .I tried that but same prob

[Sandeep_Panghal]

if you already know the field you can progamatically modify the data after uploading data.

[abaper_guy]

but wat to modify coz i m having int as data for integer field n date for date already in the txt file.

[abaper_guy]

Please help

[Former Member]

Hi Amber,

Please make sure that your field length and type is same as your screen field length and type.

Regards,

Md Ziauddin.

[abaper_guy]

hi md.

Actually i have added the screen fields from dictionary so they r automatically allotted the same type as the fields in dict table i guess.

N in my prog when i define the internal table , there also each type for the field i m mentioning using LIKE keyword followed by the dictionary table's field name.So even they r assigned the same data type as the dict table.

Now dunno where is the prob.

NOTE: the prob is coming only for the numeric fields n not character field