select unique records from the table

Hi,

Again question 😊

In the table BSIS there is in field ZOUNR populated with the same value a few times.

I would like to select unique records. and check them in the another table.

The result of the select centence below is, that I get multiple lines for one record. How to enter the select sentence just for unique records?

SELECT * FROM BSIS INTO LW_BSIS

WHERE ( HKONT IN HKONT ) AND

( AUGBL IN AUGBL ).

IF SY-SUBRC = 0.

MOVE-CORRESPONDING lw_bsis TO INT.

ENDIF.

SELECT * FROM EKPO INTO LW_EKPO

WHERE ( EBELN EQ LW_BSIS-ZUONR+0(10) ) AND

( EBELP EQ LW_BSIS-zuonr+10(5) ).

IF SY-SUBRC = 0.

MOVE-CORRESPONDING LW_EKPO TO INT.

ENDIF.

ENDSELECT.

ENDSELECT.