Query Designer中模式匹配排除

fog911811發表於2012-09-17

     如排除一個IO的AB*值。

   

Lets assume your infoobject is ZIO. and you customer exit variable for this infoobject isZCE_IO.

 

 

Type of Variable: Characteristic Value.

 

 

    Processing By: Customer Exit.

 

 

    Variable Represents: Multiple Single Values.

 

 

    Variable Entry is: Mandatory, Not Ready for Input and Cannot be changed in Query Navigation 

 

 

WHEN 'ZCE_IO'.
        IF I_STEP = 1.
          DATA: ITAB1 TYPE STANDARD TABLE OF /BIC/SZIO WITH HEADER LINE.

          SELECT * FROM /BIC/SZIO INTO TABLE ITAB1 WHERE /BIC/ZIO LIKE 'AB%' .

          CLEAR: L_S_RANGE.
          L_S_RANGE-SIGN = 'E'.
          L_S_RANGE-OPT = 'EQ'.
          LOOP AT ITAB1.
            L_S_RANGE-LOW = ITAB1-/BIC/ZIO.
            APPEND L_S_RANGE TO E_T_RANGE.
          ENDLOOP.
          CLEAR L_S_RANGE.
        ENDIF.

 

You can restrict the infoobject on a customer exit variable(ZVAR) and try with following sample code.

 

WHEN 'ZVAR'.

 

l_s_range-sign = 'E'.

l_s_range-opt = 'CP'.

l_s_range-low = 'AB*'.

APPEND l_s_range TO e_t_range.

相關文章