topic Re: make fields mandatory in Application Development and Automation Discussions

make fields mandatory

Former Member — Thu, 23 Nov 2006 18:28:17 GMT

<b>hi

how we have to make fields as " mandatory fields",in a database tables for Ztables entry, like to make address and telephone fields to make mandatory.like the way we have lifnr and kunnr are mandatory while entering the data.</b>

Re: make fields mandatory

Former Member — Thu, 23 Nov 2006 18:39:33 GMT

Which program are you using to fill that ZTABLE?

The input/ouput fields of the screen have to be mandatories, but which screen? It depends on which program you need to use

Max

Re: make fields mandatory

suresh_datti — Thu, 23 Nov 2006 18:41:28 GMT

mke it a key field on the Ztable in SE11..

~Suresh

Re: make fields mandatory

Former Member — Thu, 23 Nov 2006 18:47:37 GMT

As I understood from your post that you want to make address and telephone no as mandatory field.

I suggest you create a Table Mataintenance for the table and modify the generated code to make these fields mandatory. Make the table attributes as 'Maintenance with restriction' so that no one can create an entry directly in the table.

Bye

Chandrasekar

Re: make fields mandatory

Former Member — Thu, 23 Nov 2006 18:48:54 GMT

You can not do that in the table itself.

It has to come from hte view or the GUI.

So go to your z table in se11.

Goto Utilitles > Table Maintenenace Generator.

Create a Maint View for your table, by specifiying a Funtion group, package, a screen number.

Now say create and save it.

Now, from the same screen, go to the menu, Environment >Modification > Maintenenace Screen.

Confirm the screen no u wantn to modify.,

Go to the layut of the screen.

Now if you double click on hte field u want to make mandatory.

In the properties, you will see a tab called Program. In this, yo will see an option "Input" which is currently set to "Possible".

Change thsi to "Requird".

Save and activate.

Reward suitable points.

Hope this helps

Re: make fields mandatory

Former Member — Fri, 24 Nov 2006 06:28:17 GMT

hi naveen,

i had d same problem once.....

the fields in the Ztables cannot be marked as mandatory directly in d databse

U hav this provision in other DB systems such as Access but not in Oracle

The fields can be made mandatory on screens while entering the data by following the procedures mentioned above....

Hope this answers the query....

Regards,

Re: make fields mandatory

anversha_s — Fri, 24 Nov 2006 06:33:01 GMT

hi,

if u are entering data from screen.

then use

OBLIGATORY

statement.

rgds

anver