Skip to Content
0
Former Member
Jun 29, 2009 at 09:42 AM

select statement from vbak - optimization technique

689 Views

Hello,

I need to modify the select statement due to the performance issue, related to the SQL Trace Performance sheet

SELECT vbeln

vkorg

vtweg

spart

kunnr

erdat

FROM vbak

INTO TABLE t_vbak

WHERE vkorg IN s_vkorg

AND vtweg IN s_vtweg

AND spart IN s_spart

AND kunnr IN s_kunnr

AND erdat IN s_erdat

AND erzet IN s_erzet

AND vsbed IN s_vsbed

AND bsark IN s_bsark.

This is the select statement, I need to modify.

I tried with the index, which is available in our dev system. Still the issue is not resolved.

Select in accordance with the Index,

SELECT vbeln

erdat

erzet

vkorg

vtweg

spart

vsbed

bsark

FROM vbak

INTO CORRESPONDING FIELDS OF TABLE t_vbak

WHERE vkorg IN s_vkorg

AND vtweg IN s_vtweg

AND erdat IN s_erdat.

Please note that in these select statements, I cannot use VBELN in the where clause, since I need to fetch the orders based on the selection screen criteria.

Kindly sugest me, is there any FM, which I can use to fetch the orders.

Regards,

dinesh