ABAP JOIN使用习惯

1. 使用JOIN 时，两个表的字段都能作为查询条件，只要两个表有关联就OK 。
   SELECT
   *
   INTO CORRESPONDING FIELDS OF TABLE gt_alv
   FROM z06pmt0210a
   INNER JOIN z06pmt270 ON z06pmt0210a~wfnum = z06pmt270~wfnum
   WHERE z06pmt0210a~wfnum IN s_wfnum
   AND z06pmt0210a~iwerk IN s_iwerk
   AND z06pmt0210a~workno IN s_workno
   AND z06pmt0210a~worktype IN s_workty
   AND z06pmt0210a~appler IN s_appler
   AND z06pmt0210a~ernam IN s_ernam
   AND z06pmt0210a~erdat IN s_erdat
   AND z06pmt0210a~status IN s_status

   AND z06pmt270~SFWHP IN s_SFWHP
   AND z06pmt270~JKRDW IN s_JKRDW
   AND z06pmt270~TSWHP IN s_TSWH1
   AND z06pmt270~CFSC IN s_CFSC
   AND z06pmt270~CFQXS IN s_CFQX1
   AND z06pmt270~CFQXZ IN s_CFQX2
   AND z06pmt270~workshop IN s_work_1
   AND z06pmt270~workroom IN s_room_1