REPORT demo_select_for_all_entries_1.

DATA: BEGIN OF line,
        carrid   TYPE spfli-carrid,
        connid   TYPE spfli-connid,
        cityfrom TYPE spfli-cityfrom,
        cityto   TYPE spfli-cityto,
      END OF line,
      itab LIKE TABLE OF line.

line-cityfrom = 'FRANKFURT'.
line-cityto   = 'BERLIN'.
APPEND line TO itab.

line-cityfrom = 'NEW YORK'.
line-cityto   = 'SAN FRANCISCO'.
APPEND line TO itab.

SELECT  carrid connid cityfrom cityto
  INTO  CORRESPONDING FIELDS OF line
  FROM  spfli
  FOR ALL ENTRIES IN itab
  WHERE cityfrom = itab-cityfrom AND cityto = itab-cityto.

  WRITE: / line-carrid, line-connid, line-cityfrom, line-cityto.

ENDSELECT.

这种方法是SAP最常用的也是最实用的一种查询方法。

恐龙 wrote:

不错,学会了"FOR ALL ENTRIES IN itab" 的用法