Performance Issue: Select From BSEG & BKPF

[Former Member]

Hi experts,

Performance issue on the select statements; how can I improve the performance?

Select Company Code (BUKRS)

Accounting Document Number (BELNR)

Document Type (BLART)

Posting Date in the Document (BUDAT)

Document Status (BSTAT)

Reversal Document or Reversed Document Indicator (XREVERSAL)

From Accounting Document Header (BKPF)

Into I_BKPF

Where BKPF-BUKRS = I_VBAK-BUKRS_VF

BKPF-BLART = ‘KI’

BKPF-BUDAT = SY-DATUM – 2 days

BKPF-BSTAT = Initial

BKPF-XREVERSAL <> ‘1’ or ‘2’

Select Company Code (BUKRS)

Accounting Document Number (BELNR)

Assignment Number (ZUONR)

Sales Document (VBEL2)

Sales Document Item (POSN2)

P & L Statement Account Type (GVTYP)

From Accounting Document Segment (BSEG)

Into I_BSEG

Where BSEG-BUKRS = I_VBAK-BUKRS

BSEG-VBELN = I_VBAK-VBEL2

BSEG-POSN2 = I_VBAP-POSNR

BSEG-BELNR = I_BKPF-BELNR

P & L Statement Account Type (GVTYP) = ‘X’

[Former Member]

Instead of BSEG use its secondary index table BSIK aur BSAK

[Former Member]

Hi,

to improve the performance, you can use the secondary indices viz., BSIK / BSAK, BSID / BSAD, BSIS.

Hope this helps.

Best Regards, Murugesh AS

[Former Member]

Can you show me the selects from the secondary indexes tables BSIK,BSAK,BSID,BSAD,BSIS?