topic Re: select distinct field in Application Development and Automation Discussions

select distinct field

Former Member — Thu, 31 May 2007 15:09:31 GMT

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 — Thu, 31 May 2007 15:11:06 GMT

Hi,

You can use SELECT DISTINCT

Try this..


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

Thanks,

Naren

former_member582701 — Thu, 31 May 2007 15:11:16 GMT

SELECT DISTINCT <fields>

FROM <table>

INTO TABLE i_tab

WHERE <conditions>

Regards.

Reward all helpful answers

Former Member — Thu, 31 May 2007 15:12:49 GMT

U can use SELECT DISTINCT

Max

Former Member — Thu, 31 May 2007 15:13:56 GMT

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 — Thu, 31 May 2007 15:15:28 GMT

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