Query Designer中模式匹配排除

最新推荐文章于 2021-02-28 22:18:29 发布

LINGO_Tecco

最新推荐文章于 2021-02-28 22:18:29 发布

阅读量1.2k

点赞数

分类专栏： SAP BW 文章标签： query processing table header input io

本文链接：https://blog.csdn.net/blog0668/article/details/7988399

版权

SAP BW 专栏收录该内容

123 篇文章 1 订阅

订阅专栏

如排除一个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.