Is there any method to do validation in database level.

[Former Member]

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

[Former Member]

Hi Guys,

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

Regards,

SRI

[former_member222860]

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

[Former Member]

Hi ,

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

Regards,

SRi

[Former Member]

Hi ,

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

Regards,

SRI

[Former Member]

Hi ,

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

Regards,

SRI

[Former Member]

Hi Guys,

Bringing to your notice again.

Regards,

Sri

[Former Member]

Hi ,

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

Regards,

SRI

[Former Member]

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.

[Former Member]

yes