Skip to Content

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

select with Inner joins not fetching data

Hello All,

There is a select which has some inner joins as below:

select **some fields***

INTO CORRESPONDING FIELDS OF TABLE ITAB_MAT

FROM MARA

LEFT OUTER JOIN MAKT

ON MARAMATNR = MAKTMAKTX

LEFT OUTER JOIN MARC

ON MARAMATNR = MARCMATNR

LEFT OUTER JOIN MARD

ON MARAMATNR = MARDMATNR

LEFT OUTER JOIN MBEW

ON MARAMATNR = MBEWMATNR

LEFT OUTER JOIN MARM

ON MARAMATNR = MARMMATNR

LEFT OUTER JOIN MLGT

ON MARAMATNR = MLGTMATNR

WHERE MARA~MATNR IN S_MATNR.

The material has entries in the tables that are used above but still this query is not fetching any record.

what is wrong in this query?

Thanks,

Rakesh.

Helpful Answer

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