topic Re: pooled table performance in Application Development and Automation Discussions

pooled table performance

Former Member — Mon, 05 Mar 2007 16:22:14 GMT

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

Re: pooled table performance

Former Member — Mon, 05 Mar 2007 16:27:22 GMT

Hi,

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

Thanks,

Naren

Re: pooled table performance

Former Member — Mon, 05 Mar 2007 16:35:18 GMT

there is not one sales organization

Re: pooled table performance

Former Member — Mon, 05 Mar 2007 16:37:47 GMT

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

Re: pooled table performance

Former Member — Mon, 05 Mar 2007 16:48:02 GMT

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.