Skip to Content
0
Former Member
Sep 23, 2008 at 05:53 AM

data type mismatching

30 Views

hi all,

i m uploading data from excel sheet to an internal table through ALSM_EXCEL_TO_INTERNAL_TABLE, but its getting dumped when the data is coming to the field "wa_upload1-BSTMI",

loop at it_upload.

case it_upload-col.

when 1.

wa_upload1-matnr = it_upload-value.

when 2.

wa_upload1-WERKS = it_upload-value.

when 3.

wa_upload1-VERID = it_upload-value.

when 4.

wa_upload1-BDATU = it_upload-value.

when 5.

wa_upload1-ADATU = it_upload-value.

when 6.

wa_upload1-STLAL = it_upload-value.

when 7.

wa_upload1-STLAN = it_upload-value.

when 8.

wa_upload1-PLNTY = it_upload-value.

when 8.

wa_upload1-PLNNR = it_upload-value.

when 10.

wa_upload1-ALNAL = it_upload-value.

when 11.

wa_upload1-MDV01 = it_upload-value.

when 12.

wa_upload1-TEXT1 = it_upload-value.

when 13.

>>>>>>wa_upload1-BSTMI = it_upload-value.

when 14.

wa_upload1-BSTMA = it_upload-value.

when 15.

wa_upload1-STTAG = it_upload-value.

endcase.

endloop.

and the data in excel sheet is

1 rate 08.08.2008 08.08.2008 No a e w werkable qz werkable Short text on the production version 125.1 125.2 08.08.2008

help me out

thank you...