I'd like to use one sql to select MATNR from MARA and WERKS from MARC.
select MATNR MARC~WERKS
into corresponding fields of itab
where exists ( select * from MARC where MATNR = MARA~MATNR ).
But I got a syntax error saying that wrong table name for MARC. How should I correct the SQL ?