07-20-2007 11:11 AM
Does anybody know how can we make fields in SM30 as mandatory. If we have 4 fields in some Z-table, i want to make 2 of the fields mandatory...Pls help me out.
07-20-2007 11:28 AM
Two methods for this
1. Put code in table maintenance
You have to put some code in while generating table maintenance screen from table maintenace generator which will validate the field when user try to enter data using SM30..
Goto table maintenace generator follow menu path
Enviroment->Modification->Event
Add a event there (01 Before saving the data in the database) and code to validate data... this code will be called before saving data in database via transaction SM30.
2 .Modify screen
Follow menu path Enviroment->Modification->Maintenance Screen
And make the field require field
07-20-2007 11:24 AM
hi,
for ordinary fields in ztable...
use OBLIGATORY for making it mandatory..
PARAMETERS q1(10) TYPE c OBLIGATORY.
thanks
jaideep
if useful reward points
07-20-2007 11:24 AM
Hello Mavreck
Go to se11-> Z_table->menu utilities->table maintenance generator->maintian screen ->click ->goto the field attributes->at the INPUT ->select "Required"
Hence the field turns to be a obligatory field in sm30.
Revert if any questions and reward points if useful.
Regards
Reema.
07-20-2007 11:27 AM
Hi,
SM30 is nothing but the maintaince of the table that you have created in se11.
To add new primary key in Z table.. first add it in SE11 and create table maintanence Generator from Utility.
You can find primary key in SM30 after creating table maintanence generator in SE11.
<b>Rewards if useful</b>
Regards,
Kinjal
07-20-2007 11:28 AM
Two methods for this
1. Put code in table maintenance
You have to put some code in while generating table maintenance screen from table maintenace generator which will validate the field when user try to enter data using SM30..
Goto table maintenace generator follow menu path
Enviroment->Modification->Event
Add a event there (01 Before saving the data in the database) and code to validate data... this code will be called before saving data in database via transaction SM30.
2 .Modify screen
Follow menu path Enviroment->Modification->Maintenance Screen
And make the field require field
07-20-2007 7:32 PM
Were you able to do as below?
Hello Mavreck
Go to se11-> Z_table->menu utilities->table maintenance generator->maintian screen ->click ->goto the field attributes->at the INPUT ->select "Required"
Hence the field turns to be a obligatory field in sm30.
Revert if any questions and reward points if useful.
Regards
Reema.