Currently my code is as below:
SELECT * FROM bkpf INTO CORRESPONDING FIELDS OF TABLE zbkpf
WHERE bukrs = pbukrs
AND gjahr = pgjahr
AND belnr IN belnr
AND bstat = space
AND monat = period.
these paramaters are the indexs...
Still its taking a long time...
any idea to share?