selecting document list by gsber

[former_member493206]

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..

[former_member493206]

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..

[Former Member]

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

[ThomasZloch]

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

[Former Member]

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