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