How to construct such SELECT

[Former Member]

I simplify my problem as much as it is possible.

I have two tables TABLE1 and TABLE2. In both table key look:

key1 key2.

I have also an internal table INT_TABLE2 which is of type of TABLE2 which have some entries.

I want to select from TABLE1 all not existing pairs (TABLE1.key1 = TABLE2.key1 AND TABLE1.key2 = TABLE2.key2) for all entries in INT_TABLE2.

I tried

     SELECT T2~key1
       INTO CORRESPONDING FIELDS OF TABLE et_not_pairs
       FOR ALL ENTRIES IN INT_TABLE2
       FROM ( TABLE1 AS T1 OUTER JOIN TABLE2 AS T2
                ON T1~KEY1  = T2~KEY1 AND
                      T1~KEY2 =  T2~KEY2 )
           WHERE T2~KEY1 = INT_TALBE2-KEY1 AND
                        T2~KEY2 = INT_TALBE2-KEY2.

but without effect (error)

[Former Member]

Hi!

Always check, is the internal table empty or not, because with an empty internal table, SAP will read ALL entries from T1 and T2, and this will cause bad performance, and/or abap dump (due to the long runtime).

  IF NOT INT_TABLE2 IS INITIAL.
     SELECT T2~key1
       INTO CORRESPONDING FIELDS OF TABLE et_not_pairs
       FROM  TABLE1 AS T1 OUTER JOIN TABLE2 AS T2
                ON T1~KEY1  = T2~KEY1 AND
                   T1~KEY2 =  T2~KEY2 
       FOR ALL ENTRIES IN INT_TABLE2
        WHERE T2~KEY1 = INT_TABLE2-KEY1 AND
              T2~KEY2 = INT_TABLE2-KEY2.
  ENDIF.

Regards

Tamá

[Former Member]

I know I check it is empty, but I didn't paste this checking here

[Former Member]

Hello

Try with this code.

SELECT T2~key1

INTO CORRESPONDING FIELDS OF TABLE et_not_pairs

FROM ( TABLE1 AS T1 INNER JOIN TABLE2 AS T2

ON T1_{KEY1 = T2}KEY1 AND

T1_{KEY2 = T2}KEY2 ).

Regards

shibino sooryan.k

[Former Member]

But INNER JOIN return existing pairs, I need not existing pairs

[Former Member]

Found solution myself. I replaced OUTER JOIN with two selects