SAP Chart

 

*&---------------------------------------------------------------------*
*& Report  Z_LHS_CHART                                               *
*&                                                                     *
*&---------------------------------------------------------------------*
*&   SAP Chart,如果需要Excel方式的图表，可以使用DOI、OLE                   *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  Z_LHS_CHART                           .

DATA: BEGIN OF itab_data OCCURS 0,
        dataname(15),
        quantity1 TYPE i,
        quantity2 TYPE i,
        quantity3 TYPE i,
        quantity4 TYPE i,
END OF itab_data,

BEGIN OF itab_options OCCURS 0,
        option(20),
END OF itab_options.

itab_data-dataname = '电'.
itab_data-quantity1 = 55.
itab_data-quantity2 = 62.
itab_data-quantity3 = 59.
APPEND itab_data.

itab_data-dataname = '气'.
itab_data-quantity1 = 35.
itab_data-quantity2 = 52.
itab_data-quantity3 = 44.
APPEND itab_data.

itab_data-dataname = '水'.
itab_data-quantity1 = 18.
itab_data-quantity2 = 22.
itab_data-quantity3 = 19.
APPEND itab_data.

itab_data-dataname = '米'.
itab_data-quantity1 = 8.
itab_data-quantity2 = 22.
itab_data-quantity3 = 9.
itab_data-quantity4 = 19.
APPEND itab_data.

itab_options-option = 'P2TYPE = LN'.
append itab_options.

CALL FUNCTION 'GRAPH_MATRIX_3D'
  EXPORTING
    col1   = '一月份'
    col2   = '二月份'
    col3   = '三月份'
    col4   = '四月份'
    titl   = '水电气使用情况'
  TABLES
    data   = itab_data
    opts   = itab_options
  EXCEPTIONS
    OTHERS = 1.