Skip to Content
0
Former Member
Oct 06, 2009 at 09:33 AM

ST05 doesn't allow to run my SELECT

89 Views

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 mvkevkorg mvkevmsta marcmatnr marcwerks marccuobj marcstdpd mara~mtart

FROM ( mvke INNER JOIN marc ON mvkematnr = marcmatnr INNER JOIN mara

ON maramatnr = marcmatnr )

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 ( MARCWERKS EQ 'RU03' OR MARCWERKS EQ 'RU04' OR MARC~WERKS EQ 'RU05' )

AND ( MVKEVKORG EQ 'RU60' OR MVKEVKORG EQ 'RU60' OR MVKE~VKORG EQ 'RU60' )

Thanks

Kami