topic Re: Validation in Application Development and Automation Discussions

Validation

Former Member — Tue, 05 Jun 2007 08:44:29 GMT

In at selection screen iam validating PRODH field which is in MVKE.

but value table is T179.

can i validate like tis

select single prodh from mvke....

i need to do

select single prodh from t179..etc

Thanks

Re: Validation

Former Member — Tue, 05 Jun 2007 08:46:59 GMT

use

<b>select single prodh from t179..etc</b>

Reward points if useful

Regards

Anji

Re: Validation

santhosh_patil — Tue, 05 Jun 2007 08:48:34 GMT

Hi,

use

select single prodh from t179..

--Patil

Re: Validation

Former Member — Tue, 05 Jun 2007 08:50:59 GMT

U can use any one of them. But, coz the second method fetches the value from the check table where the primary key would be the field in interest, there is no chance of a duplicate key..hence would be more efficient.

If you dont have a check table then use

select <field list>

from dbtab up to 1 rows

....

.....

santhosh

Re: Validation

Former Member — Tue, 05 Jun 2007 08:55:36 GMT

select single prodh from t179..

IF sy-subrc <> 0.

message: not found.

endif.

Re: Validation

Former Member — Tue, 05 Jun 2007 08:55:38 GMT

Hi krk

Please use the check table for this validation.PRODH is the primary key in table T179. Hence this would be a more efficient way of validating.

Cheers

shivika