topic SELECTION SCREEN VALIDATION in Application Development and Automation Discussions

SELECTION SCREEN VALIDATION

Former Member — Thu, 09 Aug 2007 04:45:38 GMT

HI ALL

pLZ TELL ME HOW TO VALIDATE SELECTION SCREEN.

I HAVE ARRIVAL NOTICE NO IN SELECTION SCREEN.ITS FIELD NAME IS

/RBC2/YV_ARRNO AND TABLE IS /RBC2/YV_AN_ARNO .

NOW I WANT TO VALIDATE ARRIVAL NOTICE NO.

AT SELECTION-SCREEN.

perform validations

form validations .

select /RBC2/YV_ARRNO from /RBC2/YV_AN_ARNO where /RBC2/YV_ARRNO in

s_arrno .

enDFORM

IT IS SHOWING ERROR IN THE ABOVE CODE. HOW TO SOLVE THIS.

Re: SELECTION SCREEN VALIDATION

Former Member — Thu, 09 Aug 2007 04:51:47 GMT

Hi,

data : l_arno like /RBC2/YV_ARRNO .

AT SELECTION-SCREEN on s_arrno.

select /RBC2/YV_ARRNO into l_arno from /RBC2/YV_AN_ARNO

where /RBC2/YV_ARRNO in s_arrno .

if sy-subrc ne 0.

print "error msg".

endif.

If it helps REWARD

rgds

harris

Re: SELECTION SCREEN VALIDATION

Former Member — Thu, 09 Aug 2007 04:51:52 GMT

If you want to validate the field on the basis of some database value that is if it exists or not

it can be done as

select single <field name> from <table name> where <entered field > = < field in data base>

if sy-subrc ne 0 < throw error message>

hope it helps

reward if helpful

regards

Ankit

Re: SELECTION SCREEN VALIDATION

Former Member — Thu, 09 Aug 2007 04:55:26 GMT

hi,

try like this,

AT SELECTION-SCREEN. [ or use AT SELECTION-SCREEN on output]

select single * from /RBC2/YV_ARRNO where /RBC2/YV_ARRNO in

s_arrno . [ if it is a select option otherwise use '=' or 'EQ' ]

if sy-subrc ne 0.

message 'wrong value' type 'E'.

endif.

if helpful reward some points.

with regards,

Suresh Aluri.