bdc call transaction

[Former Member]

Dear Abapers,

how to validation check in excel sheets.that means one excel sheet data in one particular field data in 10 digits.some times 9 digits record is updated.the upload timing the bdc will be error displayed.and first three letters started in *ABC* only.suppose start S bdc will be displayed in error message.

thanks&regards

raj.a

Edited by: soosai raj on Oct 6, 2008 3:14 PM

[Former Member]

Dear Abapers,

how to validation check in excel sheets.that means one excel sheet data in one particular field data in 10 digits.some times 9 digits record is updated.the upload timing the bdc will be error displayed.and first three letters started in *ABC* only.suppose start S bdc will be displayed in error message.

thanks&regards

raj.a

Edited by: soosai raj on Oct 6, 2008 3:14 PM

[Former Member]

can you make requirement clear...not able to understand ?

[Former Member]

Dear experts,

i am uploading the data in excel to sap. using bdc.using call transaction method.my requirements excel sheet one particular field record in 10 digits is must .suppose the excel sheet particular field will be 12 digits(manual problem).that record uploading timing is one error message displayed.

thanks&regards

raj.a

[Former Member]

You can validate the length of string read from excel using

if strlen( l_excelfield ) GT 10.
*  do validation error handling
endif.