topic Select * from ... in Application Development and Automation Discussions

Select * from ...

Former Member — Tue, 12 Jun 2007 09:40:47 GMT

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.

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

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 09:44:31 GMT

data: itab type table of t023 occurs 0 with header line,

itab1 like ekko occurs 0 with header line.

select * from t023 into table itab.

if not itab[] is initial.

SELECT * FROM ekko into table itab1

for all entries in itab

where matkl = itab-matkl.

endif.

Itab1 will have all PO no's with all Material groups of t023 table

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 09:49:24 GMT

hi,

try this code,

select * from t023 into table itab.

SELECT * FROM ekpo where matkl ne itab-matkl.

reward points if helpful,

ragards,

seshu.

Re: Select * from ...

alex_m — Tue, 12 Jun 2007 09:53:23 GMT

Change the code like below.

Select * from t023 into table itab.

if not itab[] is initial.

SELECT * FROM ekko into table itab1

for all entries in itab

where matkl = itab-matkl.

endif.

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 09:55:18 GMT

Hi Anji,

the problem is, that i will see all POs wich have an MATKL

who is NOT in T023.

Any idea?

Regards, Dieter

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 09:58:52 GMT

Hello,

Change the code like this.


SELECT * FROM ekpo into it_ekpo for all entries in itab 
where matkl ne itab-matkl.

Vasanth

Re: Select * from ...

alex_m — Tue, 12 Jun 2007 09:59:26 GMT

The resultant table will have all the entries matching with T023-MAKTl, r u getting the same result or u want some other way.

Re: Select * from ...

S0025444845 — Tue, 12 Jun 2007 10:03:44 GMT

Hi,

try this

TABLES: T023.

TABLES: ekpo.

data: itab type table of t023,

it_ekpo type table of ekpo .

select * from t023 into table itab.

SELECT * into table it_ekpo FROM ekpo where matkl not in ITAB-maktl.

regards,

sudha

Re: Select * from ...

dev_parbutteea — Tue, 12 Jun 2007 10:06:20 GMT

hi,

try this:

select * from t023 into table itab.

SELECT * FROM ekpo into table it_ekpo.

sort itab by matkl.

sort it_ekpo by matkl.

delete adjacent dupilcates from itab comparing matkl.

select * from it_ekpo

into it_ekpo2

for all entries in itab

where matkl = itab-matkl.

delete it_ekpo2 from it_ekpo.

Regards,

Sooness

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 10:12:36 GMT

Hi Dieter ,

You will have to create a range to acheive the desired result.

Here is a sample code which does some thing similar.

Data : Begin of it_1 occurs 0 ,

MATKL type MATKL ,

End of it_1.

data : begin of it_2 occurs 0 ,

EBELN type EBELN ,

EBELP type EBELP,

End of it_2.

select MATKL

into table it_1

from T023.

data : r_MATKL type range of MATKL,

w_MATKL like line of r_MATKL.

loop at it_1.

<b>w_MATKL-sign = 'E'.

w_MATKL-option = 'EQ'.

w_MATKL-low = it_1-MATKL.

append w_MATKL to r_MATKL.</b>

endloop.

select EBELN EBELP

into table it_2

from EKPO

where MATKL in r_MATKL.

Hope this helps.

Reward point if reply is helpful.

Regards

Arun

Message was edited by:

Arun R

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 10:13:24 GMT

Hi sudha,

i get an syntax-error with yout code.

regards, Dieter

Re: Select * from ...

former_member378318 — Tue, 12 Jun 2007 10:25:13 GMT

Hi,

The following will give you all entries from EKPO where MATKL does not exist in T023:

DATA: t_ekpo TYPE STANDARD TABLE OF ekpo.

SELECT *

INTO TABLE t_ekpo

FROM ekpo

WHERE NOT EXISTS ( SELECT *

FROM t023

WHERE matkl EQ ekpo~matkl ).

Hope it helps.

Re: Select * from ...

Former Member — Tue, 12 Jun 2007 10:42:07 GMT

Hi,

i make it in this way and works very good:

TABLES: T023.

TABLES: EKPO.

DATA: R_MATKL TYPE RANGE OF MATKL.

DATA: W_MATKL LIKE LINE OF R_MATKL.

W_MATKL-SIGN = 'E'.

W_MATKL-OPTION = 'EQ'.

SELECT * FROM T023.

W_MATKL-LOW = T023-MATKL.

APPEND W_MATKL TO R_MATKL.

ENDSELECT.

SELECT * FROM EKPO WHERE MATKL IN R_MATKL.

WRITE: / '##', EKPO-EBELN, EKPO-EBELP, EKPO-MATKL.

ENDSELECT.

thanks for your help.

surbjeet your answer works also very good.

thanks for your help.

Regards, Dieter