Skip to Content

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

Performance issue

Hi All

How to inclue the below statement in the select query

/*+

LEADING(VBAK) USE_NL(VBEP)

*/

Select query

SELECT vbak~kunnr

vbak~vbeln

vbak~ernam

vbap~posnr

vbak~vkorg

vbap~matnr

vbap~arktx

vbap~werks

vbak~auart

vbep~wmeng

vbep~j_3anetw

vbap~aufnr

vbak~erdat

vbep~j_3asize

FROM vbak inner join vbap

ON vbakvbeln = vbapvbeln

inner join vbep

ON vbepvbeln = vbapvbeln

and vbepposnr = vbapposnr

INTO CORRESPONDING FIELDS OF TABLE gt_so

FOR ALL ENTRIES IN gt_so_nbr

WHERE vbak~vbeln = gt_so_nbr-vbeln

and vbep~j_3aabgru = space.

Please advice.

Thanks

giri

Edited by: girinadha reddy on Sep 25, 2008 12:14 AM

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