pooled table performance

[Former Member]

I have a statement like this , which is taking a lot of time.

SELECT MATNR DATAB KNUMH

FROM A005

APPENDING TABLE IT_COND

FOR ALL ENTRIES IN IT_ZCOSTHISTFINAL

WHERE KAPPL = 'V'

AND KSCHL = 'PR00'

AND MATNR = IT_ZCOSTHISTFINAL-MATNR.

how can i improve the performance of this statement

[Former Member]

Hi,

Try to pass the sales org VKORG and distribution channel VTWEG also..

Thanks,

Naren

[Former Member]

there is not one sales organization

[Former Member]

Its like i have a ztable for storing the material prices , one row in the table per one condition record. I am trying to compare the prices stored in the ztable with the prices in vk13 . so for every record in the ztable, i am getting the conditon record number in the access tables , and then taking price from KONP based on the condition record number. In that process i am accessing A005 also.

[Former Member]

Hi,

Are you saying you have many sales organizations..

Then build a range for the sales organzations and use it in the where clause..

Thanks,

Naren