Validation

[Former Member]

Hi

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....

or

i need to do

select single prodh from t179..etc

Thanks

[Former Member]

Hi

use

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

Reward points if useful

Regards

Anji

[santhosh_patil]

Hi,

use

select single prodh from t179..

--Patil

[Former Member]

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

[Former Member]

select single prodh from t179..

IF sy-subrc <> 0.

message: not found.

endif.

[Former Member]

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