03-20-2017 2:05 PM
Hi Experts,
I have a requirement to fetch data from table BKPF based on some non key field filtration, below is the logic provided.
SELECT bukrs
belnr
gjahr
blart
budat
bvorg
xblnr
FROM bkpf
APPENDING TABLE t_bkpf_tmp
FOR ALL ENTRIES IN t_bkpf
WHERE gjahr = t_bkpf-gjahr
AND blart = c_zv
AND bvorg = t_bkpf-bvorg.
So here i have tried with open cursor method but still system giving time out error for this table,Can i created a secondary index for this filtration if i created secondary index whether it will impact to other's or not.
It will very help full for me if anybody give proper solution.
Thanks,
03-20-2017 2:25 PM
Look at the table BVOR to solve your requirement (JOIN it with BKPF)