SubQuery Doubt

Former Member — Wed, 03 Dec 2008 07:48:54 GMT

Moderator message: Please use meaningful subject in future

Initially i'm doing likes this:-

SELECT MATNR FROM MARA AS F

INTO CORRESPONding Fields of TABLE ITAB

WHERE MATKL IN MATGRP.

LOOP AT ITAB

SELECT *

FROM ( ( MSEG AS A

INNER

JOIN MKPF AS B

ON B~MBLNR = A~MBLNR ) " Material Documber Number

INTO CORRESPONding Fields of TABLE ITAB

WHERE A~WERKS IN PLANTS

AND A~MATNR = MATNR.

MODIFY the ITAB where ITAB-MBLNR = MBLNR. " Updating only if Material Documber Number matches.

END LOOP

Combing two select statement into Subquery:-

SELECT *

FROM ( ( MSEG AS A

INNER

JOIN MKPF AS B

ON B_{MBLNR = A}MBLNR )

INTO CORRESPONding Fields of TABLE ITAB

WHERE A~WERKS IN PLANTS

AND A~MATNR IN (

SELECT MATNR FROM MARA AS F WHERE MATKL IN MATGRP ).

Will subquery return the same as above.

Should i use EXISTs or IN for every Materinal NO which returns mutiple material number.

Please advise on this.

Edited by: Matt on Dec 3, 2008 10:06 AM

Re: SubQuery Doubt

Former Member — Wed, 03 Dec 2008 08:41:33 GMT

using " for all entries in ITAB " in second SELECT statement would be a safer .

Former Member — Wed, 03 Dec 2008 08:47:03 GMT

you mean in the subquery? is it EXIST or IN, i should use in the subquery