Skip to Content
0
Former Member
Aug 17, 2009 at 05:37 AM

for all entires with join

27 Views

experts, help needed

itab has following fields,

vbeln erdat erzet vkorg vtweg

kunnr posnr matnr bmeng.

i have written like this

if itab is not initial.

SELECT avbeln aerdat aerzet avkorg a~vtweg

akunnr bposnr b~matnr

FROM vbak AS a INNER JOIN vbap AS b

ON avbeln = bvbeln

INTO TABLE itab1

FOR ALL ENTRIES IN itab

WHERE a~vbeln = itab-vbeln.

endif.

i need to fetch confirm quantity from vbep ie bmeng filed for the items in vbap into table itab1.

so do i need to add this as well in the above join or seperately i need to select it after the above select query.

pls suggest the modifications in the above select query accordingly.