Hi,
SELECT vgbel
FROM vbak INTO TABLE t_order
FOR ALL ENTRIES IN t_contract
WHERE auart IN r_odrtyp
AND vgbel = t_contract-vbelv.
The above select statement is causing a performance issue because it is not using an index.If the index VBAK-AUD which is having AUDAT field is used in the where condition of the select statement the performance can be improve.
Is it feasible to use audat field in the where condition?By using this field in the where condition will filter the entries from vbak table still further?