regarding validation for input field

[Former Member]

hi,

i want to check the entered value in input field

(field level validation) is it integer or not suppose entered value not integer then intimate to enter integer value. how can i write code for this.

and another requirement is i want to check this value is already there or not in database table.how to write code for this.

[Former Member]

Hi,

For field level validation use AT SELECTION-SCREEN ON <field> in it compare the input value whether it contains pattern of '0123456789' and for value check in database...

Check in the check table of that field( which is specified at Domain level) or write a query as

Select single * from <database table> into <internal table> where <keyfield> = <input field >.

check whether SY-SUBRC EQ 0. if its zero then record is present in tables else not present..

Hope this would help you.

Regards

Narin