topic Re: Mandatory field in table in Application Development and Automation Discussions

Mandatory field in table

Former Member — Thu, 14 Aug 2008 06:33:36 GMT

I have created a table with three fields, the requirement is to make it mandatory for the user to fill values in all the three fields for any entry in the table.

I want steps to do this. Detail description.

Re: Mandatory field in table

Former Member — Thu, 14 Aug 2008 06:41:22 GMT

HI,

make those 3 fields as primary keys...

it will work i think..

Re: Mandatory field in table

Former Member — Thu, 14 Aug 2008 06:43:11 GMT

No its not working with that arrangement

Re: Mandatory field in table

Former Member — Thu, 14 Aug 2008 06:47:56 GMT

Hi,

cant u do it with a program...

what exactly is ur requirement.????

Re: Mandatory field in table

naveen_inuganti2 — Thu, 14 Aug 2008 07:14:46 GMT

Hi.. Adnan...

Create TMG for your table and goto screen painter of that screen, make the all fields as input required....

Steps for your requirement..

1. Create One table with three fields.
2. Create Table maintainance genarator for that.
3. Now Open screen, to create entreis(utilities - > create entries- > view).
4. There system -> status -> program name and screen name.
5. Go to SE80 -> enter above program name for program object
6. expand screens
7. Find your screen number (above) and double click on it & and enter into layout of that screen.
8. In edit mode... click on field column -> attribute -> program tab -> input -> select 'required' from drop down.
9. save , activate.

Thanks,

Naveen.I

Re: Mandatory field in table

Former Member — Thu, 14 Aug 2008 08:00:54 GMT

In SE11 open you table and in the FIELDS tab

Check the third column which is "Initial values"

This is NOT NULL column and once checked the fields wont be allowed to ne NULL..

I hope this solves you doubt

Re: Mandatory field in table

Former Member — Thu, 14 Aug 2008 10:17:59 GMT

In SE11 open your table and mark the checkbox "Initial values" against the FIELDS that are mandatory according to your requirement .

I am sure this would satisfy your requirement ..

Regards ,

Ashish