子查询

• 文章

  abap下open sql使用子查询

  ABAP

  REPORT ztest02. DATA: itab TYPE TABLE OF usr21 WITH HEADER LINE. SELECT bname INTO CORRESPONDING FIELDS OF TABLE itab UP TO 10 ROWS FROM usr21 WHERE persnumber NOT IN ( SELECT persnumber FROM adrp WHERE name_last = '000' ). LOOP AT itab. WRITE : / itab-bname. ENDLOOP.

  1 2 3 4 5 6 7 8 9 10 11 12 13

  REPORT  ztest02. DATA: itab TYPE TABLE OF usr21 WITH HEADER LINE.   SELECT   bname   INTO CORRESPONDING FIELDS OF TABLE itab   UP TO 10 ROWS   FROM usr21   WHERE persnumber NOT IN ( SELECT persnumber FROM adrp WHERE name_last = '000' ).   LOOP AT itab.   WRITE : / itab-bname. ENDLOOP.

  ag

  2019.05.08

  4.8K000