topic Re: error when selecting bkpf table in Application Development and Automation Discussions

error when selecting bkpf table

Former Member — Fri, 04 Sep 2009 09:13:50 GMT

select single belnr

into it_data-belnr

from bkpf

where awkey = it_vbrp1-vbeln and

blart = 'RV'.

above code i am using for selecting bkpf table , actually key field are not useful in this case & hws to use index.

plz reply.

Thanks,

Jyotsna

Former Member — Fri, 04 Sep 2009 09:19:30 GMT

Hi,

Create a Secondary index on the field AWKEY. Check this link as to how to create a secondary index.

[]

Regards,

Vikranth

Former Member — Fri, 04 Sep 2009 09:28:06 GMT

HI,

Atleast company code(BUKRS) & fiscal year(GJAHR) can be filled, which wont affect performance, along with AWKEY.

Regards,

Amit

Former Member — Fri, 04 Sep 2009 09:31:11 GMT

Hi,

select single belnr

into it_data-belnr

from bkpf

where awkey = it_vbrp1-vbeln and

blart = 'RV'.

In above query what is it_vbrp1-vbeln? if it is internal table you are missing some thing like For all entries in it_vbrp1.Check it once.