查询MSEG表时,删除已被冲销的单据

REPORT ztest_xk10.

TABLES:mseg.

SELECT-OPTIONS:s_mblnr FOR mseg-mblnr,
               s_bwart FOR mseg-bwart.

START-OF-SELECTION.

  SELECT t1~mblnr,t1~mjahr,t1~zeile
    INTO TABLE @DATA(lt_mseg)
    FROM mseg AS t1
   WHERE t1~mblnr IN @s_mblnr
     AND t1~bwart IN @s_bwart
     AND NOT EXISTS ( SELECT * FROM mseg AS t2
                       WHERE t2~sjahr = t1~mjahr
                         AND t2~smbln = t1~mblnr
                         AND t2~smblp = t1~zeile ).

  cl_demo_output=>display( lt_mseg ).
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容