Skip to Content
-6

what is abap inner join syntax?

Nov 23, 2017 at 09:23 AM

89

avatar image
Former Member

inner join syntax in abap ?

10 |10000 characters needed characters left characters exceeded
Former Member

See the ABAP documentation

1

see that DEMO_JOINS sample progarm.

first check abap doc (f1 press) before post question

1
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jörgen Lindqvist Nov 23, 2017 at 09:40 AM
2

Please see the ABAP documentation in your system. (You can ommit the INNER keyword, as INNER joins are the default)

SELECT scarr~carrid, scarr~carrname,
       spfli~connid
  FROM scarr
    INNER JOIN spfli ON scarr~carrid   EQ spfli~carrid
                    AND spfli~cityfrom EQ 'NEW YORK'
  INTO TABLE @DATA(lt_itab).

cl_demo_output=>display( lt_itab ).
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you

0