Skip to Content
0
Former Member
Apr 22, 2008 at 05:08 AM

Is this a performence issue?

13 Views

Hi,

I have to join 4 tables with the single key.

Can i write my select querry like this.........

SELECT amatnr algort awerks aspmon amagbb awagbb aazubb aaagbb

bmaktx cekgrp dmbwbest dwbwbest

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( ( s031 AS a

INNER JOIN makt AS b ON bmatnr = amatnr )

INNER JOIN marc AS c ON cmatnr = bmatnr )

INNER JOIN s032 AS d ON dwerks = cwerks ) WHERE a~matnr IN s_matnr.

Thanks in advance,

Regards,

kk.