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.