topic Re: Is there any method to do validation in database level. in Application Development and Automation Discussions

Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 02:09:44 GMT

Hi ,

I am having Z-table around 10-Million recods .I need to do validation from various table like plant from t* and mantr from mara and marc etc .I am looking for --> without fetching 10 million record into internal table can i do validation in data base level itself. Please tell me the possiblity .....

Regards,

SRI

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 03:23:47 GMT

Hi Guys,

wether native sql. exec...endexec will help me out ...can any one come out with some possiblities ?

Regards,

SRI

Re: Is there any method to do validation in database level.

former_member222860 — Tue, 19 May 2009 04:38:57 GMT

Hi,

What do you mean by validation at the database level.

You can fetch the records as per your selection, simply by specifiying in the where clause.

select matnr into table  itab from mara where matnr in s_matnr.

thanks\

Mahesh

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 05:35:36 GMT

Hi Guys,

Bringing to your notice again.

Regards,

Sri

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 05:37:25 GMT

Hi ,

Instead of fetching into internal table , do validation in database level.

Regards,

SRi

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 05:44:20 GMT

Hi,

I dont think is there any way(as far as my knowledge) except selecting all data and validating with MARA-MATNR etc.

For future,if u are updating this Z table by SM30 then use table events to check the data or you r using any program to update this u can easily write the code in that program itself.

Thanks & Regards,

Rock.

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 06:15:17 GMT

Hi ,

But the record is huge volume for me .more than 10 million record ...performance wise it may hit ...

Regards,

SRI

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 06:16:20 GMT

Hi ,

But the record is huge volume for me .more than 10 millio . so performance wise it will be hitting .

Regards,

SRI

Re: Is there any method to do validation in database level.

Former Member — Tue, 19 May 2009 06:18:04 GMT

Hi ,

But the record volume is too huge ...So it may hit performance issue ..

Regards,

SRI

Re: Is there any method to do validation in database level.

Former Member — Wed, 20 May 2009 08:43:03 GMT

yes