ST05 doesn't allow to run my SELECT

[Former Member]

Hi Guys,

trying to trace the following SELECT but if I press the button "Explain" it provides the error message "Error received from Explain SQL"

Does anybody know why.

SELECT mvke_{vkorg mvke}vmsta marc_{matnr marc}werks marc_{cuobj marc}stdpd mara~mtart

FROM ( mvke INNER JOIN marc ON mvke_{matnr = marc}matnr INNER JOIN mara

ON mara_{matnr = marc}matnr )

WHERE marc~matnr LIKE 'D%'

AND mara~mtart EQ 'CDES'

AND marc~stdpd EQ '000000070000001031'

AND mvke~vtweg EQ '20'

AND mvke~prodh LIKE '7369%'

AND mvke~vmsta NE 'IC'

AND ( MARC_{WERKS EQ 'RU03' OR MARC}WERKS EQ 'RU04' OR MARC~WERKS EQ 'RU05' )

AND ( MVKE_{VKORG EQ 'RU60' OR MVKE}VKORG EQ 'RU60' OR MVKE~VKORG EQ 'RU60' )

Thanks

Kami

[former_member404244]

hI,

Check the below link

Regards,

Nagaraj

[Former Member]

Thanks for your hint.

Cheers

Kami