Friday, 13 May 2022

Simple Out for ALV display or normal display.

DATA : lo_alv TYPE REF TO cl_salv_table. SELECT a~idnumber AS hq, a~partner AS rjl_bli, b~idnumber AS jpl_bli, SUM( c~betrh ) AS tot_inv FROM but0id AS a LEFT OUTER JOIN but0id AS b ON a~partner = b~partner AND b~type = 'Z00094' AND a~type = 'ZPARID' AND a~valid_date_to GE @lv_low_date INNER JOIN dfkkop AS c ON a~partner = c~gpart AND ( c~budat BETWEEN @lv_low_date AND @lv_date ) GROUP BY a~idnumber , a~partner, b~idnumber INTO TABLE @DATA(it_hq_bli1) . * WHERE a~type = 'ZPARID' * AND a~valid_date_to GE @lv_low_date . * TRY. CALL METHOD cl_salv_table=>factory * EXPORTING * list_display = IF_SALV_C_BOOL_SAP=>FALSE * r_container = * container_name = IMPORTING r_salv_table = lo_alv CHANGING t_table = it_hq_bli1. * CATCH cx_salv_msg . * ENDTRY. CALL METHOD lo_alv->display.