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