validating a field in a custom table

[Former Member]

Hi guys,

I have a custom table with 4 fields.In that i have a field USER.When the user enters the data in SM30in the field USER it has to be validated with list of users in table USR01.How can I do it?Can anyone please give me the steps to do it.

Thanks.

[Former Member]

for that particular field, assign check table as usr01 in your custom table

[JozsefSzikszai]

hi d p,

in Se11 you have to define a foreign key for the field USER.

hope this helps

ec

[Former Member]

Hi Eric,

Thanks for the reply.Can u please give me the steps to assign a foreign key for the field USER.

[Former Member]

Hi,

Enter the field and corresponding Data Element.

Slect the field-->click on Foreign Key(Beside Scrh help button).

It will give one modal box where u have to mention the check table

Then say copy..mean time it will give a box for proposal(say yes).

Check table: The table that contains valid set of values.

Sri

[Former Member]

in SE11,

click on the button foreign keys near the search help.

you will get a pop-up which will ask for the check table.

give the check table as usr01 and assign the proper cardinality for the same. also make sure the 'Check Required' check box is checked.

[Former Member]

Hi Nazim,

Can u tell me what is the check table anme for all the sap users?There is no check table with name usr01.So what checktable name i need to assign for validating the users?

[Former Member]

Assign the check table as USR01 for your field 'USER' in the table.

I guess that should solve the problem. If you don't get it, regenerate the maintenance.