data element - check table

[Former Member]

Hi all

I am looking at a structure KOMG and a field(component) KUNNR in it. This field KUNNR has a component type(data element) KUNNR_V. When I double click on field KUNNR I get a pop-up with some information. In this information I see that the check table is KNA1 and the Foreign Key exists box is checked.

My question is where exactly we specify this check table and foreign key information.

PLease help. Waiting........

[RichHeilman]

In SE11, you assign the check table/foriegn key by selection the field an clicking the foriegn key button. Doing so will set the check table value.

REgards,

Rich Heilman

[Former Member]

Where exactly in SE11? Do you mean while including the fields and data elements in a structure specifying these values? Correct me if I am worng.

[RichHeilman]

Yes, in SE11, say you enter a new field, then enter the data element and hit enter. So you have your field there now, select it and click the "Foreign Keys" button(it has a key on it), here you get the dialog for setting the key/check table. Fill in the info. When complete, this will tie the check table to your field.

Regards,

RIch Heilman

[Former Member]

Rich

One more question is I also see details like Origin of the INput help and Search help name. Where do we specify these details?

Thanks

[RichHeilman]

The search help should be tied to the data element. In newer releases(webas 7.0) it appears that you may be able to directly tie search helps to the field in the table, by passing the data element. But in my 46c system, I don't remember being able to do that.

Double click on the data element for your field, you see the section for search help, here is where you enter it.

Regards,

Rich Heilman

[Former Member]

hi raju,

if there is any forign check then by default it will take domain's value table is taken as check table(check the domain of that data element). even for search help it will take from dataelement

for value table go to domain and click on value range tab.

for search help go to dataelement and click on furter charecterstics.

these will come by default and if you want you can change...