3030305.WHERE 条件

DATA: grt_matnr TYPE RANGE OF mara-matnr ,
      grs_matnr TYPE able_range..
grs_matnr-sign    = 'I'."I 正向 E 反向
grs_matnr-option  = 'BT'.
"EQ 等于
"CP 包含
"GE 大于等于
"LE 小于等于
"GT 大于
"LT 小于
"NE 不等于
"BT 范围
grs_matnr-low     = '000000000000000001'."单值，或者下限
grs_matnr-high    = '100000000000000001'."上限
APPEND  grs_matnr TO grt_matnr.
CLEAR lt_makt.
SELECT mara~matnr makt~maktx
  INTO CORRESPONDING FIELDS OF TABLE lt_makt
  FROM mara
 INNER JOIN makt ON mara~matnr = makt~matnr
 WHERE makt~spras = '1'
   AND ( mara~matnr = '000000000000000001' OR mara~matnr = '000000000000000002' )
   AND mara~matnr LIKE '%2%'
   AND mara~matnr IN  grt_matnr.