topic Re: Get value range value from Domain in Application Development and Automation Discussions

Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:31:08 GMT

Hi all,

My screen field ZXX is using data element ZDEXX and domain ZDOXX.

I maintain list of record in ZDOXX, eg

001 Pepsi

002 Cola

After user select value from value-help table for ZXX field(say 001), the field will be display '001'.

I want to display the description, "Pepsi" when user hit enter key on ZXX field.

How can i achieve that? Can i read the value range table value from Domain ZDOXX?

Many thanks.

Best regards,

Xiang Li Heah

Re: Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:34:01 GMT

Hi,

you can achieve that by using a search help....

you can create a search help and assign it to the ZDOXX field and in that search help also output the ZXX field....

which will give the proper results you require.

Regards,

Siddarth

Re: Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:38:53 GMT

Hi,

in se11->search help ->create a search help

provide the table name and the field for wich u need to provide the search help

now in the database table u need to provide the foreign key relationship for that field.

generate a proposal and give the data element name , make sure that the domain name is the same.

thanks

ravi aswani

Re: Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:42:22 GMT

Hi Siddarth, Ravi Aswani

Search help needed database table / view. I only maintain the value in Domain level.

THanks for suggestion.

Best regards,

Xiang Li Heah

Edited by: xiangli heah on Apr 27, 2009 6:43 AM

Re: Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:44:14 GMT

Hi,

Alright you can use a select query on DD07T table once you select the value on ZDOXX, and fill the value of ZXX with that select query

Regards,

Siddarth

Edited by: Siddharth Chordia on Apr 27, 2009 6:44 AM

Re: Get value range value from Domain

Former Member — Mon, 27 Apr 2009 04:55:02 GMT

Hi Siddarth,

This solve my issue.

Many thanks for your help!

Thanks Rani too.

Best Regards.

Xiang Li Heah