topic faster processing for bkpf? in Application Development and Automation Discussions

faster processing for bkpf?

Former Member — Tue, 28 Nov 2006 06:24:24 GMT

Currently my code is as below:

SELECT * FROM bkpf INTO CORRESPONDING FIELDS OF TABLE zbkpf

WHERE bukrs = pbukrs

AND gjahr = pgjahr

AND belnr IN belnr

AND bstat = space

AND monat = period.

these paramaters are the indexs...

Still its taking a long time...

any idea to share?

Re: faster processing for bkpf?

Sandeep_Panghal — Tue, 28 Nov 2006 06:29:45 GMT

Hi ,

Instead of using INTO CORRESPONDING FIELDS OF TABLE zbkpf

declare a type like types: begin of itab ,

field1

field2

end of itab.

this table should include all the required fields .

After that :

SELECT * FROM bkpf INTO table itab

WHERE bukrs = pbukrs

AND gjahr = pgjahr

AND belnr IN belnr

AND bstat = space

AND monat = period.

Hope this helps.

Re: faster processing for bkpf?

dani_mn — Tue, 28 Nov 2006 06:30:20 GMT

HI,

don't use INTO CORRESPONDING FIELDS.

declare zbkpf with same structure as bkpf and then use.

SELECT * FROM bkpf <b>INTO TABLE zbkpf</b>

WHERE bukrs = pbukrs

AND gjahr = pgjahr

AND belnr IN belnr

AND bstat = space

AND monat = period.

Re: faster processing for bkpf?

Former Member — Tue, 28 Nov 2006 06:31:13 GMT

Hi,

Do you need all the fields of BKPF table in your internal table ZBKPF. You can just declare your internal table with only those fields which you require for your processing & then select them in the same order from BKPF.

In this manner you can remove the usage of INTO CORRESPONDING FIELDS OF TABLE construct as well as select *.

This would reduce the time drastically.

Regards,

Chetan.

PS:Reward points if this helps.

Re: faster processing for bkpf?

Former Member — Tue, 28 Nov 2006 06:37:56 GMT

instead declare an internal table itab with the fields required....

then as the table is BKPF...the best way is

select <fields> from bkpf

where <conditions>.

move data from bkpf to itab.

endselect.

This process is faster for FI related tables...

Re: faster processing for bkpf?

Former Member — Tue, 28 Nov 2006 06:50:35 GMT

Hi,

Can you swap the positions of GJAHR and BELNR positions in the statement. There are chances that it is not going thru the index rather going for a full table scan.

Use the fields which are required instead of * and use INTO TABLE rather than INTO CORRESPONDING FIELDS OF

Hope this helps.

Thanks

Naresh