Skip to Content
avatar image
Former Member

How to get condition record

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 29, 2009 at 09:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2009 at 05:33 AM

    Hi Venkat,

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

    regrds,

    Lokesh

    Add comment
    10|10000 characters needed characters exceeded