topic Re: Table field validation in table maintenance in Application Development and Automation Discussions

Table field validation in table maintenance

Former Member — Mon, 22 Dec 2008 06:52:16 GMT

Hi all,

I have the following requirement.

I created a Z table with 3 fields Zfield1, Zfield2, Zfield3 and key as Zfield1 and Zfield3.

If Zfield1 is filled, then I need to make the rest of the fields as mandatory.

How to do this? Can we use the table maintenance event 05-Creating a new entry for this?

A sample code would be appreciated.

Thanks Alka

piyush_mathur — Mon, 22 Dec 2008 06:55:24 GMT

Yes Dear, You have to write the code under Events in table mainetnance generator. Write code Under ''Before Saving' event.

First chk your first columns,if its not filled then populate the error message.

Thanks

Piyush

Former Member — Mon, 22 Dec 2008 09:27:26 GMT

hi alka,

go to the table in SE11 -> click on tab utilities -> table maintenance generator -> click on environment -> modification -> events .

mention here the event 01 - before saving the data in database.

write there the code

FORM

put a check on ur field

error MESSAGE

LEAVE TO SCREEN screen number.

ENDFORM.