topic Re: Domain and Value table in Application Development and Automation Discussions

Domain and Value table

Former Member — Thu, 01 Oct 2009 08:04:55 GMT

Hi gurus!

I need to create a domain that have Fix Values and Description. I created the table for them.

But I can't see the values in F4 what's wrong?

In domain I have values 1,2,3 and description A,B,C

So in my table I created the same fields Value & Description. Anything else?

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:19:07 GMT

Hello

You do not need create table for that.

When you create domain go to tab 'Value range' and enter values (1,2,3 - Fix.val and A,B,C - Short text).

In report declare parameters type domain. F4 will be work.

Re: Domain and Value table

venkat_o — Thu, 01 Oct 2009 08:23:39 GMT

Hi, <li>After creating that table, assign that as VALUE table in DOMAIN maintenance screen. Thanks Venkat.O

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:32:11 GMT

open the domain.(se11)

goto the value range tab.

put all the 6 values one after the other in the 'single vals' area.

work done.

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:33:09 GMT

Hi!

I need a table for maintenance, the values should be changed in the future.

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:33:52 GMT

Hi!

I did all that. F$ isn't work.

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:34:26 GMT

I did it but F4 is not working.

Edited by: Dani_K on Oct 1, 2009 10:34 AM

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:36:10 GMT

Hi,

You don't say where the field is that doesn't have F4 help. Is it on a screen painter screen? The selection screen of a report? The maintenance screen for a table?

It may be you need to define your check table as a foreign key to the field that uses the domain.

Also, you presumably have added the table to the 'Value table' field of the domain?

Regards,

Nick

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 08:44:08 GMT

Hi!

Yes the field is in the selection screen.

Yes, I added the table name to the 'Value table' field of the domain.

Can you please explain, how can I do this:

"need to define your check table as a foreign key to the field that uses the domain."

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 09:22:14 GMT

Hi,

If you are in the table definition in SE11 select your field. Select the field and press the 'Foreign key' button (it's the one with an arrow and a key on it). It may propose your check table as the foreign key, if so accept this, if not enter the name of your check table and the field.

Regards,

Nick

Re: Domain and Value table

MarcinPciak — Thu, 01 Oct 2009 09:30:42 GMT

As Nick have noticed, value table at domain level doesn't provide F4 functionality (input help). This is beacuse it is purerly for foreign key relationship. Providing value table doesn't perform any input check. It is used when you define [Foreign Keys|http://help.sap.com/saphelp_nw2004s/helpdata/EN/cf/21ea77446011d189700000e8322d00/frameset.htm] for secondary tables. The foreign key realationship is then proposed based on that value table .

Value table is sometimes misinterpreted by developers as input help provider.

If you want to use that domain in several places I suggest to maintain Single values in it - especially when you predict to have a few of them. You can later add/deleted/change them whenever necessary. There is no direct benefit in this case of using value table instead of single values.

Regards

Marcin

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 09:31:32 GMT

I've got the message:

Check table of the domain is current table (FK maintenance not possible)

Edited by: Dani_K on Oct 1, 2009 11:39 AM

Re: Domain and Value table

former_member185874 — Thu, 01 Oct 2009 09:56:22 GMT

Hi Dani,

If you have created the values in the Value Range tab of the domain of the field then those values can be accessible via F4.

Just to be simple I am writing what I have done to achive this:

Step1: Go to value Range tab in the domain of the field and put the entries(1,2,3 in this csae) in the Fix Value column and A,B,C(in this case) in the short text. save and activaste the domain.

Step 2: Now to verify about the F4 functionality on that field, you can use it in any parameters or in select-options.

Please let me know if I have not answered your question.

Thanks,

Anurag Singh Rathore

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 10:06:21 GMT

Hi,

I can understand why you would want a config table rather than a value range. I've tried some things with a similar table in my own system and I;ve found the following;

If my table is called ZCONF_TAB and the field is OFFICE, the data element ZOFFICE.

If I define the paramer in my program as;


PARAMETERS: p_office type ZOFFICE.

I don't get a drop-down. However if I define it as;


PARAMETERS: p_office type ZCONF_TAB-OFFICE.

I get the drop down.

You could try the second option to see if this works.

Regards,

Nick

Re: Domain and Value table

Former Member — Thu, 01 Oct 2009 10:14:04 GMT

Hi!

This works but it is fixed values, I need the possibility to maintain the values in the table, so the Domain will take the value and the description from table.