topic JOIN in Application Development and Automation Discussions

JOIN

Former Member — Thu, 03 Jan 2008 07:42:00 GMT

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 — Thu, 03 Jan 2008 07:52:12 GMT

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

Regards

Former Member — Thu, 03 Jan 2008 08:46:24 GMT

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 — Thu, 03 Jan 2008 09:29:08 GMT