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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks Archana,

i think it works .