Change Value While Uploading data From Excel File

[Former Member]

Dear Expert,

Please guide me is it Possible?, if yes then How?

We have one BDC Uploader there After uploading data from Excel File, i want to check one field like this....

if it_f65data-newbs contains any Alphabet.

then user Should be able to change value on the same time while executing Program in table.

Please tell me how i can change value in running program

Regards'

Shelly Malik

[Former Member]

HI,

Loop the internal table before filling the BDC table.

and check

if it_f65data-newbs CA sy-abcde.

Change the value.

endif.

Regards and Best wishes.

[Former Member]

hi,

Actually i want if newbs contains any alphabet some pop up should come where user can eneter value for newbs and value gets changed in internal table.

Regards

Shelly Malik

[Former Member]

Hi,

What you can probably do is, perform a consistency check on your data in the internal table and segregate all those rows that have inconsistent data (in your case, the field NEWBS containing albhabets) into another temporary internal table. Display the temporary internal table in an editable ALV grid saying that these data have not been inserted to the database, coz they have inconsistent data in the field NEWBS. Allow the user to edit and then save the data which will consequently refresh the internal table contents.