Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Tabel alternative

Dear Experts

I have used the following query, but it takes long time to execute and affects the performance too.

How can i change this query, i tried the BSAK and BSIK tables also, but

KOART and NEBTR fields not available in those tables, so am supposed to use the table BSEG.

Please advise me to improve the performance of the coding.

Thanks in advance.

Regards

Rajaram

SELECT shkzg

skfbt

dmbtr

wskto

belnr

gjahr

bukrs

qbshb

lifnr

bschl

nebtr

FROM bseg

INTO TABLE ibseg

WHERE augbl = p_vblnr

AND bukrs = p_bukrs

AND koart = 'K'

AND auggj = p_gjahr

AND belnr NE p_vblnr.

Tags:
Former Member
Former Member replied

Can you change AUGGJ to GJAHR?? Check once if Fiscal year and fiscal year of posting document are same. this will save a lot of execution time.

ashish

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question