Reg database view

[Former Member]

Hi all Gurus,

I am trying to create a database view for joining STKO, STPO, MAST.

I am getting duplicate records., How to avoid that ?

Very CRITICAL situation . If any one of u have view for these table, please gimme the TABLE JOIN CONDITIONS.

Hoping for the reply please

Regards

karthik.,,

[manubhutani]

Hi

i think u need to code some check

in the fn module.

Please reward points if useful.

[Former Member]

Hi karthikeyan pal...

Please check the Tables and Associated keys for that table.

Because check the Key fields and place these fields in Join

condition ,you want get any dublicate records.

so please check the Key fields for all the three tables.

Please reward points if found correct.

thanks and regards,

Rajeshwar.

[Adi_Bathineni]

Hi Karthikeyan Pal...

U can check the Key Fields of the tables in the data base view.

Once you entered the table names in the databse view,

select one table and click on relationships.It will show the respected tables with that table related with hte key fields. Sometimes it will give more than one key field.

Based on the Key Fields you can avoid duplicates.

Regards,

Adi.