Domain and Value table

[Former Member]

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?

[Former Member]

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.

[Former Member]

Hi!

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

[venkat_o]

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

[Former Member]

I did it but F4 is not working.

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

[Former Member]

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.

[Former Member]

Hi!

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[MarcinPciak]

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

[Former Member]

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

[Former Member]

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

[former_member185874]

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

[Former Member]

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.