topic Re: ABAP Query using SQVI in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042690#M86981 <HTML><HEAD></HEAD><BODY><P>You might be able to write additional code in the infoset Component of SQL Query, Of course nothing beats the suggestion of using a select single or select up to 1 rows</P></BODY></HTML> Fri, 28 Oct 2005 10:30:19 GMT Former Member 2005-10-28T10:30:19Z ABAP Query using SQVI https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042688#M86979 <HTML><HEAD></HEAD><BODY><P>I've created a query to identify approver from linking several tables. The result data show several duplicate record because I only want to retrieve the User ID. Is there a way to select only Unique Record?</P><P></P><P>Regards,</P><P></P><P>Thomas</P></BODY></HTML> Fri, 28 Oct 2005 07:51:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042688#M86979 Former Member 2005-10-28T07:51:26Z Re: ABAP Query using SQVI https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042689#M86980 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try a SELECT SINGLE [FIELDS/*].... or a SELECT * INTO ITAB FROM XTABLE UP TO 1 ROWS.</P><P></P><P>Regards</P></BODY></HTML> Fri, 28 Oct 2005 08:56:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042689#M86980 Former Member 2005-10-28T08:56:57Z Re: ABAP Query using SQVI https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042690#M86981 <HTML><HEAD></HEAD><BODY><P>You might be able to write additional code in the infoset Component of SQL Query, Of course nothing beats the suggestion of using a select single or select up to 1 rows</P></BODY></HTML> Fri, 28 Oct 2005 10:30:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-query-using-sqvi/m-p/1042690#M86981 Former Member 2005-10-28T10:30:19Z