1REPORT zmn_alv_list_01.
2
3TYPES: BEGIN OF ty_list,
4 order_id TYPE c LENGTH 10,
5 customer_name TYPE string,
6 quantity TYPE i,
7 END OF ty_list.
8
9DATA lt_list TYPE STANDARD TABLE OF ty_list WITH DEFAULT KEY.
10DATA lo_alv TYPE REF TO cl_salv_table.
11DATA lo_columns TYPE REF TO cl_salv_columns_table.
12DATA lo_sorts TYPE REF TO cl_salv_sorts.
13DATA lo_aggr TYPE REF TO cl_salv_aggregations.
14
15START-OF-SELECTION.
16 SELECT o~order_id, c~name AS customer_name, o~quantity
17 FROM zmn_order AS o
18 INNER JOIN zmn_customer AS c
19 ON o~customer_id = c~customer_id
20 INTO CORRESPONDING FIELDS OF TABLE lt_list.
21
22 TRY.
23 cl_salv_table=>factory(
24 IMPORTING r_salv_table = lo_alv
25 CHANGING t_table = lt_list ).
26 CATCH cx_salv_msg.
27 WRITE / '一覧を作れませんでした。'.
28 RETURN.
29 ENDTRY.
30
31 lo_alv->get_functions( )->set_all( abap_true ).
32 lo_columns = lo_alv->get_columns( ).
33 lo_columns->get_column( 'ORDER_ID' )->set_long_text( '注文番号' ).
34 lo_columns->get_column( 'CUSTOMER_NAME' )->set_long_text( '得意先の名前' ).
35 lo_columns->get_column( 'QUANTITY' )->set_long_text( '数量' ).
36 lo_columns->set_optimize( abap_true ).
37
38 lo_sorts = lo_alv->get_sorts( ).
39 lo_sorts->add_sort( columnname = 'CUSTOMER_NAME' ).
40
41 lo_aggr = lo_alv->get_aggregations( ).
42 lo_aggr->add_aggregation( columnname = 'QUANTITY' ).
43
44 lo_alv->display( ).