topic Re: Reg database view in Application Development and Automation Discussions

Reg database view

Former Member — Thu, 15 May 2008 05:53:57 GMT

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.,,

Re: Reg database view

manubhutani — Thu, 15 May 2008 06:49:17 GMT

i think u need to code some check

in the fn module.

Please reward points if useful.

Re: Reg database view

Former Member — Thu, 15 May 2008 10:51:25 GMT

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.

Re: Reg database view

Adi_Bathineni — Thu, 15 May 2008 14:48:13 GMT

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.