Inner Join in sap abap programming language



SELECT a~vbeln a~erdat a~waerk a~vkorg a~vtweg a~kunnr a~vkgrp a~spart b~posnr
         b~matnr  b~matkl b~arktx   b~abgru  b~werks  b~kwmeng b~kzwi1 b~netwr
          b~kzwi2   b~kzwi3   b~kzwi4
                                     FROM vbak AS a
                                     INNER JOIN vbap AS ON a~vbeln   b~vbeln )
                                     INTO TABLE gt_vbak_vbap
                                     WHERE a~erdat IN s_erdat
                                     AND   b~werks IN s_werks
                                     AND   a~vkgrp IN s_vkgrp.

Comments

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

MB_MIGO_BADI THIS BADI USED TO POSTING DATA IN MIGO

Long Text in input and output field in module pool