Skip to Content
0
Former Member
Jun 12, 2007 at 09:40 AM

Select * from ...

53 Views

Hi,

i try to select all POs wich MATKL are not declared.

I use this code:

TABLES: T023.

TABLES: ekpo.

*

data: itab type table of t023.

*

select * from t023 into table itab.

*

SELECT * FROM ekpo where matkl not in TABLE T023.

or

SELECT * FROM ekpo where matkl not in TABLE ITAB.

but i get an systax error.

Wich Select-statement can i use?

Any idea?

Thanks.

Regards, Dieter