SELECT mit Bedinung aus zweiter Tabelle performant gestalten

Code: Alles auswählen.

  IF ( i_iban IS INITIAL OR NOT p_bupa IS INITIAL )
    AND p_up IS INITIAL.
    SELECT * FROM (i_table) AS b
      UP TO p_maxl ROWS
      INTO TABLE <table>
      FOR ALL ENTRIES IN gt_cntry
      WHERE (l_where)
        AND NOT EXISTS ( SELECT iban FROM tiban
                          WHERE (l_wher2) ).

Code: Alles auswählen.

TYPES: BEGIN OF t_knbk,
  kunnr LIKE knbk-kunnr,
  banks LIKE knbk-banks,
  bankl LIKE knbk-bankl,
  bankn LIKE knbk-bankn,
  END OF t_knbk.

DATA: gt_knbk TYPE STANDARD TABLE OF t_knbk,
      wa_knbk LIKE LINE OF gt_knbk.

"der Join liest auch Kunden ohne Bankverbindung. Falls nicht geünscht --> Inner Join anwenden
SELECT kna1~kunnr knbk~banks knbk~bankl knbk~bankn
  FROM kna1 LEFT OUTER JOIN knbk ON kna1~kunnr = knbk~kunnr
  APPENDING TABLE gt_knbk
  WHERE kna1~loevm = ''.

Code: Alles auswählen.

SELECT knbk~kunnr 
  FROM kna1 JOIN knbk ON kna1~kunnr = knbk~kunnr
  APPENDING TABLE gt_knbk
  WHERE kna1~loevm = ''
  GROUP BY knbk~kunnr.

Code: Alles auswählen.

  CASE p_table.               " Festlegen der Hilfsvariablen
    WHEN 'KNBK'.
      lw_htab = 'kna1'.
      lw_hval = 'kunnr'.
    WHEN 'LFBK'.
      lw_htab = 'lfa1'.
      lw_hval = 'liefnr'.
    WHEN OTHERS.
  ENDCASE.

* And now... SELECT
  IF ( i_iban IS INITIAL OR NOT p_bupa IS INITIAL )
    AND p_up IS INITIAL.
    SELECT * FROM (i_table) AS b
      UP TO p_maxl ROWS
      INTO TABLE <table>
      FOR ALL ENTRIES IN gt_cntry
      WHERE lw_hval IN ( SELECT lw_hval
                           FROM (lw_htab)         
                          WHERE LOEVM = '' )      
      AND   (l_where)
      AND   NOT EXISTS ( SELECT iban
                           FROM tiban
                          WHERE (l_wher2) ).

Code: Alles auswählen.

    SELECT * FROM (i_table) AS b
      UP TO p_maxl ROWS
      INTO TABLE <table>
      FOR ALL ENTRIES IN gt_cntry
      WHERE lw_hval IN ( SELECT lw_hval          
                           FROM (lw_htab)         
                          WHERE LOEVM = '' )      
      AND   (l_where)
      AND   NOT EXISTS ( SELECT iban
                           FROM tiban
                          WHERE (l_wher2) ).