03-08-2007 7:14 AM
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.
03-08-2007 7:18 AM
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
03-08-2007 7:21 AM
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.