topic SAP Note Performance: Customer developments in Application Development and Automation Discussions

SAP Note Performance: Customer developments

former_member217544 — Fri, 17 May 2013 09:54:04 GMT

Hi,

is there any snote or suggestions for fecthing BSEG, BKPF tables. I am aware that there are few SAP Notes for MM(Note 191492) and SD(Note 185530) customer developments. Likewise is there any note which tells us about the above tables

Thanks & Regards,

Swarna

Re: SAP Note Performance: Customer developments

FredericGirod — Fri, 17 May 2013 09:57:27 GMT

Have a look to the BSIS, BSID, BSAS ... tables to improve your performance

regards

Fred

Re: SAP Note Performance: Customer developments

ThomasZloch — Fri, 17 May 2013 13:19:54 GMT

Not aware of any. The basic stuff should be well known though, access BSEG only via primary key(s), use the tables mentioned by Frédéric for non-primary key access to the items, correctly use available indexes for BKPF to access the header (e.g. don't forget BSTAT...).

On the more advanced side, additional indexes or appended fields for BKPF or the BSxx tables might be considered if other options failed.

There is one important point about BSIS and BSAS, they only contain item data if the G/L account is flagged for line item display (SKB1-XKRES) or open item management (SKB1-XOPVW).

Thomas

Re: SAP Note Performance: Customer developments

former_member217544 — Mon, 20 May 2013 05:55:41 GMT

Hi Frédéric and Thomas,

Thanks for the inputs.

Regards,

Swarna Munukoti.