Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Reg database view

Former Member

‎2008 May 15 6:53 AM

0 Likes
448

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

3 REPLIES 3
Read only

manubhutani
Active Contributor

‎2008 May 15 7:49 AM

0 Likes
428

Hi

i think u need to code some check

in the fn module.

Please reward points if useful.

Read only

Former Member

‎2008 May 15 11:51 AM

0 Likes
428

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.

Read only

Adi_Bathineni
Participant

‎2008 May 15 3:48 PM

0 Likes
428

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.