Alternative table for BKPF

[Former Member]

Hi

My report having poor performance with BKPF table.For that i am looking for alternative table of BKPF, at the same time which should contain STBLG(Reverse document number) field. i tried for BSID but it does not contain the STBLG field.

Can some one suggest me the alternative table for BKPF(performance wise) and whick contain STBLG.

Regards

Thiru.

[Former Member]

BKPF is the master table ... i used it in one of my reports and i don't think if it gives poor perfoamance... try to get everything in internal tables and then process .

it will be good if u use BKPF only bcuz iif anything comes up in future then it won't hinder to ur report.

hope this will help

Thanks

aShwani

[Former Member]

BKPF is the master table ... i used it in one of my reports and i don't think if it gives poor perfoamance... try to get everything in internal tables and then process .

it will be good if u use BKPF only bcuz iif anything comes up in future then it won't hinder to ur report.

hope this will help

Thanks

aShwani

[Former Member]

I am afraid STBLG is not present in any of the standard secondary index tables

BSAD

BSAK

BSAS

BSID

BSIK

BSIM

BSIS

You need to create a secondary index to BKPF for STBLG via SE11, that is only left as an option for performance in your query.