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