How to get condition record

[Former Member]

Hi Experts

I am calcutating rebate percentage for delivery for which I am writing one query which is below and taking more time to execute.

select single

knumh

from

konh

into

l_cond_rec

where

knuma_bo = IS_BIL_INVOICE-hd_gen-KNUMA.

Can I get KNUMH using any other fuction module or from any other table which will increase the speed of execution. FM Condition_Record_Read is not applicable for me. Please reply.

With Regards

Venkat, IBM

[Former Member]

Hi Venkat,

I think you make a table index for the keys you are using to retrieve data from KONH table.

regrds,

Lokesh

[Former Member]

go for VBAP for knumh , based on this you can get condition record from KONV table

you can try this way

VBAP-KNUMV = KONV-KNUMV