error when selecting bkpf table

[Former Member]

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]

Hi,

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

[]

Regards,

Vikranth

[Former Member]

HI,

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

Regards,

Amit

[Former Member]

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.