topic Re: selecting document list by gsber in Application Development and Automation Discussions

selecting document list by gsber

former_member493206 — Tue, 12 Aug 2008 14:37:37 GMT

I want to display document list from BKPF..but there is not GSBER field..it exists in BSEG table.but the table is not indexed table.when i use it,performance will be horrible.

How can i select data according to GSBER?

Best regards..

Re: selecting document list by gsber

Former Member — Tue, 12 Aug 2008 14:42:31 GMT

Just try... create a secondary index over BSEG table with belnr and gsber fields... Using secondary index will improve performance while fetching data.

Re: selecting document list by gsber

ThomasZloch — Tue, 12 Aug 2008 15:42:40 GMT

not possible to create secondary index on BSEG (cluster table).

Anything else you could narrow down the selection with?

posting date, CPU date, document type? -> use the indexes on BKPF then select BSEG with "for all entries"

account number? -> use the index tables BSIS, BSAS etc.

Company code should always be part of the selection.

Last exit would be to create a secondary index on BUKRS and GSBER on the aforementioned index tables.

Thomas

Re: selecting document list by gsber

Former Member — Tue, 12 Aug 2008 23:12:36 GMT

I deleted your other cross-post of this question. Please read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement].

Cheers,

Julius