需求:
统计XX工厂下物料数。
代码实现:
*&---------------------------------------------------------------------*
*& Report YZB_DEMO_01
*&---------------------------------------------------------------------*
***$ 功能描述:
** 1. 统计XX工厂下物料数
***$ 关键字:
** 1. COUNT、DISTINCT 结合使用
*--------------------------------------------------------------------*
REPORT yzb_demo_01.
DATA: go_alv TYPE REF TO cl_salv_table.
*--------------------------------------------------------------------*
***$取数:
SELECT
werks
,COUNT( DISTINCT matnr ) AS matnr_cnt
FROM marc
GROUP BY werks
INTO TABLE @DATA(lt_werks_matnr_cnt).
*--------------------------------------------------------------------*
***$显示:
TRY .
cl_salv_table=>factory(
IMPORTING
r_salv_table = go_alv
CHANGING
t_table = lt_werks_matnr_cnt ).
CATCH cx_salv_msg.
ENDTRY.
go_alv->get_columns( )->get_column( 'MATNR_CNT' )->set_long_text( '物料数' ).
go_alv->display( ).
运行结果: