Skip to Content
0

Can we create secondary index for table BKPF

Mar 20, 2017 at 02:05 PM

114

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Mar 20, 2017 at 02:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded