Inner join in inline code



 SELECT a~MATNR,a~WERKS,b~bmein,b~bmeng,c~idnrk,c~meins,c~menge
                                     FROM mast as a INNER JOIN stko as on b~stlnr a~stlnr
    and a~stlal b~stlal INNER JOIN stpo as on b~stlty c~stlty and b~stlnr c~stlnr INTO TABLE @data(gt_mast)
                                      FOR ALL ENTRIES IN @gt_item
                                     WHERE a~matnr eq @gt_item-matnr
                                     and   a~werks eq @gt_item-werks.

Comments

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

How to Give Dropdown in alv report in sap abap programming Language

Long Text in input and output field in module pool