Skip to Content
0
Former Member
Jan 03, 2008 at 07:42 AM

JOIN

20 Views

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 FMATNR = EMATNR ) .