make fields mandatory

[Former Member]

<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>

[Former Member]

Hi

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

[suresh_datti]

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

~Suresh

[Former Member]

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

[Former Member]

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

[Former Member]

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,

Vs

[anversha_s]

hi,

if u are entering data from screen.

then use

OBLIGATORY

statement.

rgds

anver