topic Re: validating a field in a custom table in Application Development and Automation Discussions

validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:03:55 GMT

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.

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:05:24 GMT

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

Re: validating a field in a custom table

JozsefSzikszai — Thu, 11 Oct 2007 15:06:48 GMT

hi d p,

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

hope this helps

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:06:50 GMT

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.

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:19:16 GMT

Hi Eric,

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

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:22:42 GMT

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

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:22:56 GMT

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.

Re: validating a field in a custom table

Former Member — Thu, 11 Oct 2007 15:36:35 GMT

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?