Best performance

[Former Member]

Hi,

I have :

select BUKRS BELNR GJAHR BUZEI KOKRS HKONT BSCHL WRBTR SHKZG LIFNR

from BSEG

into corresponding fields of table itab

for all entries in ZBKPF

where BUKRS = zbkpf-bukrs

and BELNR = zbkpf-belnr

and GJAHR = zbkpf-gjahr

and KOART in ('S','K','D')

and HKONT in ZCOUNT.

append itab.

Is there a best way as 'packing' or something that helps to do it with best performance to copy the data to itab? Exeption using BSIS,BSAS.

thanks a lot

[Former Member]

Hi,

I have :

select BUKRS BELNR GJAHR BUZEI KOKRS HKONT BSCHL WRBTR SHKZG LIFNR

from BSEG

into corresponding fields of table itab

for all entries in ZBKPF

where BUKRS = zbkpf-bukrs

and BELNR = zbkpf-belnr

and GJAHR = zbkpf-gjahr

and KOART in ('S','K','D')

and HKONT in ZCOUNT.

append itab.

Is there a best way as 'packing' or something that helps to do it with best performance to copy the data to itab? Exeption using BSIS,BSAS.

thanks a lot

[Former Member]

Hi Marc,

To improve performance using packing and other cases won't be helpful.

The best suggestion I can give is do not use that table at all.If it is such a necessity than kindly create indexes on the fields that u r using.in where clause.

That will help but my personal struggle against BSEG tells me it will be of little help.

Thanks and Regards,

Saurabh

[Former Member]

well what i can tell you is: that the statement "For all entries" is wideley known to have a BAD influence on your performance.