topic Re: Select Question in Application Development and Automation Discussions

Select Question

Former Member — Mon, 21 May 2007 19:14:36 GMT

Hello,

I need to select all the matnrs from MARC and I need to check whether these materials exist in A383. If not then I shud display this material. How do I do this.

Please Help.

Thanks

Viky

Re: Select Question

Former Member — Mon, 21 May 2007 19:17:11 GMT

SELECT MARC_{MATNR INTO TABLE ITAB FROM MARC INNER JOIN A383 ON MARC}MATNR NE A383~MATNR.

Regards

SAB

Re: Select Question

Former Member — Mon, 21 May 2007 19:24:28 GMT

Hi Vicky,

Try this.....

data: tab1 like a383 occurs 0 with header line.

data: tab2 like marc occurs 0 with header line.

ranges: r_matnr for mara-matnr.

select * from a383 into table tab1.

loop at tab1.

r_matnr-sign = 'I'.

r_matnr-option = 'NE'.

r_matnr-low = tab1-matnr.

append r_matnr.

clear: r_matnr.

endloop.

select * from marc into table tab2

where matnr in r_matnr.

loop at tab2.

<< display all the records.

endloop.

Pavan Kothapalli