Skip to Content
0
Former Member
Jan 20, 2008 at 10:09 AM

Performance tuning

70 Views

Hi...

It may sound absurd pasting the whole select query but I could not help out. Please guide if the following select query can be corrected.

SELECT t1matnr t1werks t4charg t1fevor t1dispo t1lzeih

t7berid t2mhdhb t2mhdrz t3maktx t3spras t4hsdat t4vfdat t4cuobj_bm

t5lgort t6aufnr

FROM marc AS t1 INNER JOIN mara AS t2

ON t2matnr = t1matnr

INNER JOIN makt AS t3

ON t3matnr = t1matnr

INNER JOIN mcha AS t4

ON t4matnr = t1matnr AND

t4werks = t1werks

INNER JOIN mchb AS t5

ON t5matnr = t4matnr AND

t5werks = t4werks AND

t5charg = t4charg

LEFT OUTER JOIN mdlg AS t7 " MKA

ON t7werks = t5werks " MKA

AND t7lgort = t5lgort " MKA

LEFT OUTER JOIN afpo AS t6

ON t6matnr = t4matnr AND

t6charg = t4charg

INTO CORRESPONDING FIELDS OF TABLE t_data

WHERE <select options>.

I tried by splitting all the select queries using <for all entries>. But its causing incorrect and incomplete data to be fetched.

Kindly guide if the above can be corrected without losing data.

Points for sure

Regards

Dinesh