select distinct field

[Former Member]

Hi all,

I have this question:

How to select records from a table to an itab choosing distinct values of a certain field (not the key) ?

Thanks,

Massimo

[Former Member]

SELECT DISTINCT <fields>

FROM <table>

INTO TABLE i_tab

WHERE <conditions>

Regards.

Reward all helpful answers

[Former Member]

Hi,

You can use SELECT DISTINCT

Try this..

SELECT DISTINCT( MATNR ) FROM VBAP INTO TABLE T_VBAP
             WHERE ....

Thanks,

Naren

[former_member582701]

SELECT DISTINCT <fields>

FROM <table>

INTO TABLE i_tab

WHERE <conditions>

Regards.

Reward all helpful answers

[Former Member]

Hi

U can use SELECT DISTINCT

Max

[Former Member]

Hi

Give ur select statement like this.

select distinct <field name> from <Database table name> into <internal table name>

Eg: select distinct land1 from lfa1 into table it_lfa1.

Regards

Haritha.

[Former Member]

Hi Massimo,

Select all required data into internal table.suppose u want to remove duplicates of field2 .then use the below statement.

delete adjasent duplicates from itab comparing field2.

reward points if helpful.

Thanks,

Suma