1 SELECT likp~vbeln likp~lfart lips~werks likp~kunnr2 INTO CORRESPONDING FIELDS OF TABLE it_likps3 FROM likp INNER JOIN lips4 ON likp~vbeln = lips~vbeln5 FOR ALL ENTRIES IN it_ztmt2046 WHERE posnr = '000010'7 AND likp~vbeln = it_ztmt204-vbeln.
FOR ALL ENTRIES IN ,与 INNER JOIN 不要写在一个SQL上,
执行效率比想象的差很多,特别是FOR的内表大的时候……。