I have a select statement which takes an awful time to execute
the problem is that the only factor I know is the BUDAT
now I was looking if I could use an index. there is an index on the BKPF which contains the BUDAT, BSTAT and BUKRS
to make this index happen I have to add alt the available BSTATs into a range and all available BUKRS to a range and add it to the select
now I wonder if this would really enhance the performance of the select statement ??
SELECT bukrs belnr gjahr FROM bkpf
INTO CORRESPONDING FIELDS OF TABLE ta_bkpf
WHERE budat GE p_budat.
kind regards
arthur de smidt