Three tables inner join in SAP

Go down

Three tables inner join in SAP

Post  Uma_ABAP on Thu May 03, 2012 4:47 pm

SELECT a~matnr INTO TABLE lt_mat
FROM mara AS a INNER JOIN marc AS c ON c~matnr = a~matnr
INNER JOIN mard AS d ON d~matnr = a~matnr
WHERE ( c~werks = p_werks AND d~lgort IN s_lgort ) AND matkl IN lt_mgreg AND
a~lvorm = ' ' AND c~lvorm = ' ' .


Posts : 56
Join date : 2012-03-31

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum