10-06-2008 1:48 PM
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®ards
raj.a
Edited by: soosai raj on Oct 6, 2008 3:14 PM
10-06-2008 2:30 PM
10-06-2008 2:30 PM
10-06-2008 2:51 PM
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®ards
raj.a
10-06-2008 2:58 PM
You can validate the length of string read from excel using
if strlen( l_excelfield ) GT 10.
* do validation error handling
endif.