topic Performance (Select at BKPF) in Application Development and Automation Discussions

Performance (Select at BKPF)

Former Member — Tue, 13 Mar 2007 05:38:04 GMT

is there a better way to select at BKPF?

currently I am selecting at BKPF using all of the primary key and using for all enties.

but it is still taking a loong time to finish the select.

below is my select statement:

ct_scdoc contains 500,000 line items. (huge! internal table)

IF NOT ct_scdoc IS INITIAL.

SELECT bukrs

belnr

gjahr

bvorg

hwaer

bktxt

usnam

FROM bkpf

INTO TABLE i_bkpf

FOR ALL ENTRIES IN ct_scdoc

WHERE bukrs = ct_scdoc-bukrs

AND belnr = ct_scdoc-belnr

AND gjahr = ct_scdoc-gjahr.

ENDIF.

Re: Performance (Select at BKPF)

Former Member — Tue, 13 Mar 2007 05:42:12 GMT

Hi,

Select statement looks good.

All the data pertains to single fiscal year(GJAHR).

if you wants you can restrict it .

Regards,

Anji

Re: Performance (Select at BKPF)

Former Member — Tue, 13 Mar 2007 05:43:12 GMT

Marco,

Another better way to extract the data efficiently from DB is using Indicies. But here your case if different, you are using FOR ALL ENTRIES, ie, using a driver internal table, u are extracting data. so you cant use secondary index in this case.

Regards,

Sujatha.

Re: Performance (Select at BKPF)

Former Member — Tue, 13 Mar 2007 05:55:58 GMT

Hi Marco,

This can be optimized breaking the CT_STDOC table into sets of lesser records and use APPENDING TABLE I_BKPF.

Eg: if CT_STDOC has 6000 entries the for every 1500 entries of CT_STDOC perform a SELECT with the APPENDING TABLE form.