ABAP Query using SQVI

[Former Member]

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?

Regards,

Thomas

[Former Member]

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

[Former Member]

hi,

try a SELECT SINGLE [FIELDS/*].... or a SELECT * INTO ITAB FROM XTABLE UP TO 1 ROWS.

Regards

[Former Member]

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