Select Statement

[Former Member]

Hi Experts,

How can I write a select Statement to select all the fields from REGUP.

With distinct Vendor no’s ( LIFNR ) and the condition must check the Addition field LAUFI = ‘XXXX’.

Thanks & Regards

Rajendra

[srinivas_akiri]

Hi

Try as below.

select distinct *

from REGUP

into table itab

where LAUFI = ‘XXXX’.

[Former Member]

select * from REGUP into itab where LAUF1 = 'XXXX'.

Sort itab by LIFNR.

delete adjacent duplicates from itab comparing LIFNR.

[Former Member]

SELECT DISTINCT * FROM REGUP INTO TABLE ITAB WHERE LAUF1 = 'XXXX'.

Message was edited by:

chandrasekhar jagarlamudi

[Former Member]

hi,

u can use select distinct.

performance wise.

select * from regup into table t_regup where lauf1 = 'XXXX'.

DELETE ADJACENT DUPLICATES FROM t_regup comparing lifnr.

santhosh

[Former Member]

Hi,

you can use a select distinct statement (check abap help for examples)

But this would probably be performance unfriendly for the database.

It's probably faster to just select into table.

and place the logic for finding unique lifnrs in the loop.

Or what I always do is download the content of the table to excel and use excel to search for unique records.

Kind regards, Rob Dielemans

[Former Member]

Rajendra,

you have no other way. you have to select all the data and use Delete adjacent duplicates. don't forget to sort before using delete adjacent duplicates.

and Option DISTINCT is ruled out on Pooled and cluster tables. since REGUP is not transparent table.

Regards

Vijay

[Former Member]

Hi Rajendra,

I think there is no way to have this in a single statement.

The simplest way is to select all rows with condition LAUFI = ‘XXXX’.

& thereafter DELETE ADJACENT DUPLICATES...

[Former Member]

Hi,

Use this statement

select * from REGUP into table t_regup where lauf1 = 'XXXX'.

Sort itab by lifnr.

delete adjacent duplicates from t_regup comparing LIFNR.

Regards,

Kumar