validation on fields in a data base table

[Former Member]

Hi all,

I have to create a database table with 4 fields.Here my requirement is i have to do some validation on 3rd field.If it is successful then only the user has the chance to enter data in the 4th field means 4th field should be enabled.If the validation is not successful the user has no chance to enter data in the 4 th field. How can i approach to do this...pls help me out..........

Thanks & Regards.

Laxman.P

B'lore.

[Former Member]

it is there to achieve your logic & thing ...

create 2 tables ...

first table with 3 fields

second table with 4 fields

first 3 fields are primary key in both table's .......now make the second table as foreign key relation to first table with all 3 primary key ... so that second table's check table is first table ...

4 fields are

<b>sino

name

education

status</b>

if you make entries in thr first table like example

<b>1 girish BE

2 harish ME

3 kavith BTECH.</b>

now if you make entry in the second table with other<b> si & name</b> like

<b>4 BOND </b>

it will give you error and in disable mode ... becuase<b> 4 BOND</b> is not there

<b>suppose if you make entry like</b>

<b>2 harish ME Married</b> it will accept Because <b>2 harish ME</b> is there

reward points if it is usefull ..

Girish

[Former Member]

Hi Girish,

What ever you told is correct. But i have to it in only one table itself. For this we have to work with table maintainence genertaor.In that we have to use events options. But there how can i approach i don't know. This is the problem.....

Thanks&Regards.

Laxmn.P

[Former Member]

Hi Laxman,

You need to make the changes using Events as well as you may require to do the modification in screen layout.

You can get the lot of material on help.sap.com for this. It is better if you understand first how Events work and other stuff related to table maintainence generator then it will be easier for you to code.

Reward points if useful.

Regards,

Atish

[Former Member]

hi laxman,

I have one document that will surly help you out.

send me mail on neo_1982u@yahoo.com

Reward points if document is helpful

neo S.

[Former Member]

hi laxman....

here is the link for writing the validation in the table maintainance generator <b>with screen shots</b>...

<a href="http://">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc</a>

reward points if it is usefull ..

Girish

[Former Member]

Hi,

you can do the validation on table fields using table maintenance generator.