Below ABAP Syntax is ABAP Inner Join example.

START-OF-SELECTION.

* ASSUMPTION: All quantities are in sales units. Since quantities

* are summed to the material group level, it is assumed that all

* materials within a material group have the same sales unit of

* measure.

  select a~kunag a~vbeln a~fkdat a~bukrs a~vbtyp

         b~matkl b~matnr b~arktx b~fkimg b~kzwi2 b~wavwr

         c~name1

         d~kunn2

     into corresponding fields of table replines

        from vbrk as a

          inner join vbrp as b

             on a~vbeln = b~vbeln

          inner join kna1 as c

             on a~kunag = c~kunnr

          left outer join knvp as d

             on a~kunag = d~kunnr and

                a~vkorg = d~vkorg and

                a~vtweg = d~vtweg and

                d~spart = ‘71′ and

                d~parvw = ‘CO’ and

                d~parza = ‘000′

          where a~vkorg = ‘7100′ and

                a~vbtyp in r_vtyp and

                a~fkdat in s_date and

                a~kunag in s_cust and

                b~matkl in s_mgrp and

                b~autyp in r_atyp.

END-OF-SELECTION.

posted on 2009-01-13 22:38  沧海-重庆  阅读(3867)  评论(1编辑  收藏  举报