Select Question

[Former Member]

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

[Former Member]

HI

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

Regards

SAB

[Former Member]

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