Self Join mara

    SELECT d~yysuperdesign d~matnr
           c~matnr c~matkl c~yylaunch_id c~yymachine_type
           d~mstae d~yycommunication
           INTO TABLE gt_mara
           FROM mara AS c
           INNER JOIN mara AS d ON d~matnr  EQ c~yydesign
           WHERE c~matnr IN s_cmatnr[]
           AND   c~mtart = 'Z109'
           AND   c~matkl IN s_cmatkl
           AND   c~yylaunch_id IN s_launch
           AND   c~lvorm EQ space
           AND   d~matnr IN s_dmatnr
           AND   d~yysuperdesign IN s_smatnr
           AND   d~mtart EQ 'Y910'
           AND   d~lvorm EQ space.