読み方のヒント

矢印ボタン(または ← → キー)でページを移動できます。

第5節 通し課題:得意先の名前付きの注文一覧

5.2 解答例

ZMN_ALV_LIST_01
REPORT zmn_alv_list_01.
TYPES: BEGIN OF ty_list,
order_id TYPE c LENGTH 10,
customer_name TYPE string,
quantity TYPE i,
END OF ty_list.
DATA lt_list TYPE STANDARD TABLE OF ty_list WITH DEFAULT KEY.
DATA lo_alv TYPE REF TO cl_salv_table.
DATA lo_columns TYPE REF TO cl_salv_columns_table.
DATA lo_sorts TYPE REF TO cl_salv_sorts.
DATA lo_aggr TYPE REF TO cl_salv_aggregations.
START-OF-SELECTION.
SELECT o~order_id, c~name AS customer_name, o~quantity
FROM zmn_order AS o
INNER JOIN zmn_customer AS c
ON o~customer_id = c~customer_id
INTO CORRESPONDING FIELDS OF TABLE lt_list.
TRY.
cl_salv_table=>factory(
IMPORTING r_salv_table = lo_alv
CHANGING t_table = lt_list ).
CATCH cx_salv_msg.
WRITE / '一覧を作れませんでした。'.
RETURN.
ENDTRY.
lo_alv->get_functions( )->set_all( abap_true ).
lo_columns = lo_alv->get_columns( ).
lo_columns->get_column( 'ORDER_ID' )->set_long_text( '注文番号' ).
lo_columns->get_column( 'CUSTOMER_NAME' )->set_long_text( '得意先の名前' ).
lo_columns->get_column( 'QUANTITY' )->set_long_text( '数量' ).
lo_columns->set_optimize( abap_true ).
lo_sorts = lo_alv->get_sorts( ).
lo_sorts->add_sort( columnname = 'CUSTOMER_NAME' ).
lo_aggr = lo_alv->get_aggregations( ).
lo_aggr->add_aggregation( columnname = 'QUANTITY' ).
lo_alv->display( ).

25 / 27