JOIN

[Former Member]

Hi all

In d below SELECT statement am comparing MATNR of S012 and MARA i also want to compare the P_WERKS with the WERKS of S012.Please Help

Vijay

PARAMETERS:p_werks type S026-WERKS OBLIGATORY.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE IT_S012

FROM ( S012 AS E

INNER JOIN MARA AS F ON F_{MATNR = E}MATNR ) .

[RaymondGiuseppi]

If you want to use a link on WERKS you cannot use table MARA but table MARC (primary keys : MATNR, WERKS)

Regards

[Former Member]

select * into corresponding fields of table IT_S012 from s012 as e inner join mara as f on e_{matnr = f}matnr where e~werks = p_werks.

[Former Member]

h