Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to make table fields mandatory

Go to solution
Former Member

‎2006 Oct 10 6:18 PM

0 Likes
1,266

Hi

I am designing a Ztable where i have 20 fields.

Among them i want to make all fields mandatory.That means when the user will enter records to this table he should fill every fields otherwise system will give the error the filed is required and record will not save.

What is the procedure for that.

Any can help me.

Regs

Manas Ranjan Panda

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2006 Oct 10 6:26 PM

0 Likes
916

Hi,

If you using the table maintenance for maintaining the records..Then you can goto SE51 for the screen you generated and make all the fields as required in the attributes..

If you are not populating through SM30..Then in your update program you have to check if the field is populated or not..

Thanks,

Naren

Hi

I am designing a Ztable where i have 20 fields.

Among them i want to make all fields mandatory.That means when the user will enter records to this table he should fill every fields otherwise system will give the error the filed is required and record will not save.

What is the procedure for that.

Any can help me.

Regs

Manas Ranjan Panda

Reply
4 REPLIES 4
Read only

Go to solution
Former Member

‎2006 Oct 10 6:22 PM

0 Likes
916

Check the <b>Key</b> check box for all the fields for this table.

If the user needs to enter values, create a table maintanence generator.

But if the initial values are updated through modify/update/insert command and initial will be get upload.

Reagrds,

Prakash.

Read only

Go to solution
Former Member

‎2006 Oct 10 6:26 PM

0 Likes
917

Hi,

If you using the table maintenance for maintaining the records..Then you can goto SE51 for the screen you generated and make all the fields as required in the attributes..

If you are not populating through SM30..Then in your update program you have to check if the field is populated or not..

Thanks,

Naren

Read only

Go to solution
Former Member

‎2006 Oct 10 6:29 PM

0 Likes
916

Hi

But how does the user fill your ZTABLE?

By SM30 or your Z-program?

Max

Read only

Go to solution
Former Member

‎2006 Oct 10 6:34 PM

0 Likes
916

If you don't wish to make all fields key, then you can make them required using the Screen Painter.

After you have generated table maintenance, go back into Table Maintenance Generator screen. Double-click on the words Overview Screen. Click the green arrow to accept the Information message about setting the compare flag. Screen Painter opens. Switch to the Element tab. From the Element tabs, switch to the Special attr. tab. In the Input column, set each I/O field to Required. Save and Activate.

Now when the table is maintained using SM30 all fields are required.