Application Development 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: 

How to avoid duplicate entries from a view

Former Member

‎05-26-2009 11:51 AM

0 Kudos

Hi All,

In one of my created view I am getting some duplicate values.

How can I avoid these duplicate entries?

There is no selection condtion and join condition is feasible for this criteria!

Is any way to prevent the display of these repeated values (Duplicate values)?

Regard,

Amba.

3 REPLIES 3

Former Member

‎05-26-2009 12:17 PM

0 Kudos

Hi,

Your join must have some issue. What tables are you joining on? What conditions did you specify?

Regards,

Abdullah

former_member555112
Active Contributor

‎05-26-2009 12:18 PM

0 Kudos

Hi,

Please check your join conditions properly.

Include the MANDT field in the join conditions and also in the output.

Regards,

Ankur Parab

Former Member
In response to former_member555112

‎05-26-2009 12:28 PM

0 Kudos

Thanks for the replay.

I have used mandt field while joining.

Issue is like that for one set of values from table T1 is passing to table T2 and joining condtion is like that and in T2 there is two set of values and one field is changing, But we are not considering that field in view thats why its repeating.

I think all of you got a clear idea.