topic Re: validation on fields in a data base table in Application Development and Automation Discussions

validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 04:53:57 GMT

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.

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 05:21:14 GMT

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

sino

name

education

status

if you make entries in thr first table like example

1 girish BE

2 harish ME

3 kavith BTECH.

now if you make entry in the second table with other si & name like

4 BOND

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

suppose if you make entry like

2 harish ME Married it will accept Because 2 harish ME is there

reward points if it is usefull ..

Girish

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 05:33:32 GMT

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

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 05:37:10 GMT

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

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 05:57:51 GMT

hi laxman....

here is the link for writing the validation in the table maintainance generator with screen shots...

<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

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 10:09:04 GMT

Hi,

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

Re: validation on fields in a data base table

Former Member — Wed, 13 Jun 2007 20:50:24 GMT

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.