Hi reg fetch from View CAUFV

[Former Member]

Hi Experts,

below query is taking a long time, what is the fix to tune this,

SELECT aufnr auart kdauf FROM caufv

INTO TABLE tl_caufv

WHERE kdauf EQ i_viqmel-vbeln.

[Former Member]

Hi

try to some more condtions in where clause

Regards

Shiva

[Former Member]

Your problem is that the SELECT cannot use any index. I don't think you can fix this as it stands

But since KDAUF is the sales order number, you might try to approach it from the sales document flow perspective (VBFA).

Rob