메뉴 건너뛰기

SAP 한국 커뮤니티

report zsalv_043 .

sapjoy 2010.08.20 11:01 조회 수 : 2978

 

report  zsalv_043                                 .

include <color>.

types: begin of g_type_itab.
include type sflight.
types : t_color     type lvc_t_scol,
end of g_type_itab.

data gt_itab    type table of g_type_itab.
data gr_table   type ref to cl_salv_table.

select * from sflight into corresponding fields of table gt_itab
up to 25 rows.


field-symbols: <ls_outtab> type g_type_itab.

data :  lt_color     type lvc_t_scol,
        ls_color     type lvc_s_scol.

clear lt_color.
clear ls_color.


loop at gt_itab assigning <ls_outtab>.
  clear : ls_color, lt_color.
  if <ls_outtab>-seatsocc >= 90.
    ls_color-fname     = 'SEATSOCC'.
    ls_color-color-col = col_negative.
    ls_color-color-int = 0.
    ls_color-color-inv = 0.
    append ls_color to lt_color.      
  elseif <ls_outtab>-seatsocc >= 50.
    ls_color-fname     = 'SEATSOCC'.
    ls_color-color-col = col_normal.
    ls_color-color-int = 0.
    ls_color-color-inv = 0.
    append ls_color to lt_color.       
  else.
    ls_color-fname     = 'SEATSOCC'.
    ls_color-color-col = col_positive.
    ls_color-color-int = 0.
    ls_color-color-inv = 0.
    append ls_color to lt_color.         
  endif.

    <ls_outtab>-t_color = lt_color.
  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_color_column( 'T_COLOR' ).


  gr_table->display( ).
이 게시물을
수정 삭제 목록
번호 제목 글쓴이 날짜 조회 수
630 REPORT Z09_005 sapjoy 2006.12.18 2514
629 REPORT Z09_006 [1] sapjoy 2006.12.18 2839
628 DBZF1SSEL sapjoy 2006.12.19 2842
627 REPORT Z09_010 sapjoy 2006.12.19 2523
626 PUT_SPFLI PUT_SFLIGHT PUT_SBOOK sapjoy 2006.12.19 2614
625 REPORT Z11_001 sapjoy 2006.12.20 2976
624 REPORT z11_004 . sapjoy 2006.12.22 2465
623 REPORT Z11_005 sapjoy 2006.12.22 2273
622 REPORT Z11_008 sapjoy 2006.12.22 2496
621 REPORT Z11_010 sapjoy 2006.12.22 2358
620 module f4_drum_S101 input. sapjoy 2006.12.26 2541
619 MODULE f4_drum_s101 INPUT. 2 sapjoy 2006.12.26 2375
618 REPORT z12_002 sapjoy 2006.12.28 2629
617 REPORT Z13_002 sapjoy 2007.01.03 2309
616 REPORT Z12_004 sapjoy 2007.01.03 2256
615 FORM set_field_catalogs_grid USING lt_fieldcat TYPE lvc_t_fcat. sapjoy 2007.01.03 2875
614 REPORT Z13_003 sapjoy 2007.01.05 2437
613 REPORT Z13_001 sapjoy 2007.01.08 2362
612 REPORT Z13_012 sapjoy 2007.01.08 2282
611 REPORT Z13_013 sapjoy 2007.01.08 2634
쓰기 태그