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

redundant data in query

Former Member

‎2008 Jun 20 10:12 PM

0 Likes
436

I have created a query with the master data tables. I am getting repititive data. For example If the data has to be displayed in one line its displaying the same line its displaying again and again for the length specified for the query. can anyone suggest where to look for

regards

I have created a query with the master data tables. I am getting repititive data. For example If the data has to be displayed in one line its displaying the same line its displaying again and again for the length specified for the query. can anyone suggest where to look for

regards

Reply
1 REPLY 1
Read only

Former Member

‎2008 Jun 20 11:35 PM

0 Likes
400

Hi,

If it is a master table with non-unique keys, then you will get only one record.

If it is an item data table like ekpo, vbap, you will have multiple entries .

If you are doin' a inner join and the item table is on the left side then you will get multiple matching entries.

See to it that the left side table is a master table, and you will get only single entry.

Hope this helps.

Regards,

Subramanian