SAP Note Performance: Customer developments

[former_member217544]

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

[FredericGirod]

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

regards

Fred

[ThomasZloch]

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

[former_member217544]

Hi Frédéric and Thomas,

Thanks for the inputs.

Regards,

Swarna Munukoti.