Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regarding the perfomance of a join .

Hi,

I have a join with tables MARD,MVKE,MAKT,MARA .

Is it a bad habit to join more than 3 tables , is it inversely affect the perfomance.

SELECT dmatnr AS material dwerks AS plant dlgort AS slocation dumlme dlabst rmeins k~maktx AS descr

INTO CORRESPONDING FIELDS OF TABLE it_data2 FROM mard AS d INNER JOIN mvke AS m

ON dmatnr = mmatnr

INNER JOIN mara AS r

ON rmatnr = dmatnr

INNER JOIN makt AS k

ON kmatnr = dmatnr

WHERE

d~matnr IN r_matnr

AND d~werks IN r_plant

AND m~vkorg IN r_sales.

Thanks & Regards,

Ratheesh BS

Former Member
Not what you were looking for? View more on this topic or Ask a question