Skip to Content
0
Former Member
Feb 26, 2009 at 07:27 PM

Performance of SELECT on Sales tables

143 Views

Hello Every one:

Could any one please help in fine tuning the following code snippet for better performance.

SELECT VBAKVBELN VBAKVBTYP VBAKAUART VBKDVBELN

VBKDGJAHR VBKDPOPER VBAPZMENG VBAPKZWI1

VBAPCMPRE VBAPVBELN VBAPPOSNR VBAPWERKS

INTO CORRESPONDING FIELDS OF TABLE I_SDOC

FROM ( VBAK

INNER JOIN VBKD

ON VBKDVBELN = VBAKVBELN

INNER JOIN VBAP

ON VBAPVBELN = VBAKVBELN )

FOR ALL ENTRIES IN I_ZZVDC

WHERE VBAP~WERKS = I_ZZVDC-WERKS

AND VBAP~WERKS IN S_WERKS

AND VBAK~AUART IN S_AUART

AND VBKD~POPER = P_POPER

AND VBKD~GJAHR = P_GJAHR.

Thanks in Advace:

Sravanthi.

Edited by: Rob Burbank on Feb 26, 2009 3:15 PM

Please pick a more informative title for your question. All questions in this forum are about performance tuning.