Explain SQL in SQL trace.

Hi All,

I have a doubt with regards to the 'Explain one SQL request option' in ST05 SQL trace transaction.This option displays a screen where an SQL statement could be given and analysed.

This works fine when a staright forward & simple SQL statements like below are given :

SELECT VBELN

FROM VBEP

WHERE VBELN = 0000000001

AND POSNR = 00010

AND MBDAT <= 20060830

AND "J_3AABGRU" = ' '

But, when a bit complex SQL (like the one given below) with JOINs are given, its gives out an error with message "An error in Explain SQL. Change UPDATE/DELETE to SELECT if possible."

SELECT A~VBELN "Sales order document

FROM VAKPA AS A

INNER JOIN VBUK AS B

ON A_{VBELN = B}VBELN

INTO TABLE RT_SO_ALL

FOR ALL ENTRIES IN RT_KNKK

WHERE A~KUNDE = RT_KNKK-KUNNR

AND A~PARVW = C_PAYER

AND A~VKORG = RV_VKORG

AND ( B~GBSTK <> C_COMPLETE

OR ( B~GBSTK = C_COMPLETE AND

B~LFSTK = C_PARTIALLY_PROCESSED ) ).

Would appreciate any help in this regard.

Warm Regards,

Partha.