Skip to Content
0
Former Member
Apr 14, 2008 at 05:39 AM

Transaction ST05

23 Views

Hi all,

Under "Enter SQL statement" in ST05 when i use the below SQL statement i get a information message " Error received from Explain". It is because of the INNER JOIN iam using. If i remove the INNER JOIN it works fine.

SELECT *

FROM S725

INNER JOIN MARA ON S725MATNR = MARAMATNR

WHERE VRSIO = '000'

AND SPWOC IN (200152, 200153, 200152)

AND WERKS IN (0010, 0020, 0051, 0100, 0111, 0321, 0331, 0341)

AND MATNR IN (000000000000500000, 000000000000500001)

AND MATKL IN (M-01, M-02, M-03)

How can i use INNER JOIN in Explain SQL??

Thanks