https://community.sap.com/t5/application-development-and-automation-discussions/redundant-data-in-query/m-p/3974743#M949343 <HTML><HEAD></HEAD><BODY><P>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</P><P></P><P>regards</P></BODY></HTML> Fri, 20 Jun 2008 21:12:11 GMT Former Member 2008-06-20T21:12:11Z https://community.sap.com/t5/application-development-and-automation-discussions/redundant-data-in-query/m-p/3974743#M949343 <HTML><HEAD></HEAD><BODY><P>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</P><P></P><P>regards</P></BODY></HTML> Fri, 20 Jun 2008 21:12:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/redundant-data-in-query/m-p/3974743#M949343 Former Member 2008-06-20T21:12:11Z https://community.sap.com/t5/application-development-and-automation-discussions/redundant-data-in-query/m-p/3974744#M949344 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If it is a master table with non-unique keys, then you will get only one record.</P><P>If it is an item data table like ekpo, vbap, you will have multiple entries .</P><P></P><P>If you are doin' a inner join and the item table is on the left side then you will get multiple matching entries.</P><P>See to it that the left side table is a master table, and you will get only single entry.</P><P></P><P></P><P>Hope this helps. </P><P></P><P>Regards,</P><P>Subramanian</P></BODY></HTML> Fri, 20 Jun 2008 22:35:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/redundant-data-in-query/m-p/3974744#M949344 Former Member 2008-06-20T22:35:57Z