REPORT z17_21.
TYPES: BEGIN OF g_type_itab.
INCLUDE STRUCTURE zemplist.
TYPES : count TYPE p LENGTH 3, " 자격증 개수 필드 추가
exception TYPE char1,
END OF g_type_itab.
DATA gt_itab TYPE TABLE OF g_type_itab.
DATA gs_itab TYPE g_type_itab.
DATA gr_table TYPE REF TO cl_salv_table.
SELECT a~empcd, a~depcd, a~pstion, a~ename, a~email, a~tel, b~empcd,
COUNT( b~certid ) AS count
FROM zemplist AS a
LEFT OUTER JOIN zempcert AS b ON b~empcd EQ a~empcd
GROUP BY a~empcd, a~depcd, a~pstion, a~ename, a~email, a~tel, b~empcd
INTO CORRESPONDING FIELDS OF TABLE @gt_itab.
LOOP AT gt_itab INTO gs_itab.
IF gs_itab-count >= 3. " Green.
gs_itab-exception = '3'.
ELSEIF gs_itab-count = 2. " Yellow.
gs_itab-exception = '2'.
ELSEIF gs_itab-count = 1. " Blue.
gs_itab-exception = '1'.
ENDIF.
MODIFY gt_itab FROM gs_itab.
ENDLOOP.
cl_salv_table=>factory(
IMPORTING
r_salv_table = gr_table
CHANGING
t_table = gt_itab ).
DATA: lr_columns TYPE REF TO cl_salv_columns_table,
lr_column TYPE REF TO cl_salv_column_table.
lr_columns = gr_table->get_columns( ).
lr_columns->set_exception_column( 'EXCEPTION' ).
lr_column ?= lr_columns->get_column( 'EXCEPTION' ).
lr_column->set_short_text( 'MY EXCEPT' ).
DATA: lr_functional_settings TYPE REF TO cl_salv_functional_settings.
lr_functional_settings = gr_table->get_functional_settings( ).
DATA: lr_tooltips TYPE REF TO cl_salv_tooltips.
lr_tooltips = lr_functional_settings->get_tooltips( ).
lr_tooltips->add_tooltip(
type = cl_salv_tooltip=>c_type_exception
value = '1' ).
lr_tooltips->add_tooltip(
type = cl_salv_tooltip=>c_type_exception
value = '2' ).
lr_tooltips->add_tooltip(
type = cl_salv_tooltip=>c_type_exception
value = '3' ).
gr_table->display( ).
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
» | REPORT Z17_21 | 가능 | 2025.09.22 | 0 |
482 | REPORT Z17_20 | 가능 | 2025.09.22 | 2 |
481 | INCLUDE Z17_19_0100_PAII01 | 가능 | 2025.09.22 | 0 |
480 | INCLUDE Z17_19_0100_PBOO01Z17_19_0100_PBOO01 | 가능 | 2025.09.22 | 2 |
479 | REPORT Z17_19 | 가능 | 2025.09.22 | 2 |
478 | REPORT Z17_18 | 가능 | 2025.09.22 | 2 |
477 | REPORT Z17_17 | 가능 | 2025.09.22 | 1 |
476 | REPORT Z17_16 | 가능 | 2025.09.22 | 1 |
475 | REPORT Z17_15 | 가능 | 2025.09.22 | 0 |
474 | REPORT Z17_14 | 가능 | 2025.09.22 | 1 |
473 | REPORT Z17_13 | 가능 | 2025.09.22 | 0 |
472 | REPORT Z17_12 | 가능 | 2025.09.22 | 0 |
471 | REPORT Z17_11 | 가능 | 2025.09.22 | 0 |
470 | REPORT Z17_10 | 가능 | 2025.09.22 | 0 |
469 | REPORT Z17_09 | 가능 | 2025.09.22 | 0 |
468 | REPORT Z17_08 | 가능 | 2025.09.22 | 0 |
467 | REPORT Z17_07 | 가능 | 2025.09.22 | 0 |
466 | REPORT Z17_06 | 가능 | 2025.09.22 | 3 |
465 | REPORT Z17_05 | 가능 | 2025.09.22 | 1 |
464 | INCLUDE Z17_04_0100_PAII01 | 가능 | 2025.09.22 | 0 |