Skip to Content

Can we create secondary index for table BKPF

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 20, 2017 at 02:25 PM

    Look at the table BVOR to solve your requirement (JOIN it with BKPF)

    Add comment
    10|10000 characters needed characters exceeded