topic Re: Problem while using KEKO(Product Costing - Header Data) table in the report in Application Development and Automation Discussions

Problem while using KEKO(Product Costing - Header Data) table in the report

Former Member — Fri, 22 Jan 2010 04:49:58 GMT

hi,

below is the slect query i have written.

while accessing the table KEKO( Product Costing - Header Data ) .more time is taken.

is there any alternative other than KEKO table when using in my report.

SELECT FEH_STA VBELN POSNR FROM KEKO

INTO TABLE IST_KEKO FOR ALL ENTRIES IN IST_VBAP_KEKO

WHERE KALNR = IST_VBAP_KEKO-KALNR.

regards,

DILIP.

Re: Problem while using KEKO(Product Costing - Header Data) table in the report

Former Member — Fri, 22 Jan 2010 04:55:19 GMT

Hi Dilip,

Before going for any other table,

As Kalnr is only one of the primary keys of table KEKO, You can try creating secondary index on KEKO, which might help in improving your report performance.

Also, you can add more conditions in where clause if possible, which will also help in improving performance.

Thansk,

Archana

Re: Problem while using KEKO(Product Costing - Header Data) table in the report

Former Member — Fri, 22 Jan 2010 05:07:09 GMT

Thanks Archana,

i think it works .