topic Re: validation on explicit search help on a data element ? in Application Development and Automation Discussions

validation on explicit search help on a data element ?

Former Member — Thu, 23 Apr 2009 14:56:04 GMT

Hello,

i have assigned the search help on a data element level and used in a database table.

when i try to enter data into this screen through screen or maintenance view, how can i validate the data to be in the search help and not any random data?

will the system automatically check that? or do i need to do something??

Thanks

Re: validation on explicit search help on a data element ?

Former Member — Thu, 23 Apr 2009 15:12:11 GMT

Hi,

Can you please assign the check table which used in search help at database in se11 for that perticular field.

Thnaks,

suma.

Re: validation on explicit search help on a data element ?

Former Member — Fri, 24 Apr 2009 03:36:48 GMT

Hi ,

You need to create foreign key relation .Because search help only suggests the values

but do not validate it.

The table you used for search help , use the same for the FOREIGN KEY relation ship

as a check table.

Regards

Pinaki

Re: validation on explicit search help on a data element ?

Former Member — Fri, 24 Apr 2009 04:26:30 GMT

Hi,

Click on the field and create a foreign key relationship for that field

a popup window is generated provide the short text, the check table from which u need to validate the values for that field (eg Carrid field -> check table SCARR)

click on Generate Proppsal

if the field is a key field than select key fields/candidates

else if non key fields non-key-fields/candidates

select the cardinality

press om copy.

save and activate the table.

this this provide u the correct values for the particular field.

BUT make sure that the domain name of the fields should be same. (it's the pre-requisite)

thanks

ravi

Re: validation on explicit search help on a data element ?

Former Member — Fri, 24 Apr 2009 06:07:27 GMT

Hi,

System automatically checks it...

regards

padma