03-19-2008 8:30 AM
Hi all,
when calling standard function module 'Matrix_graph' ,this function module itself calling function 'graph_receive' , at that time it is firing an error * " table $opts, line 8, row 6, Value: 'SET MAIL=X' E 018: undefined Value : $Data ".
i populated internal tables and passing to table parameters to function ,pls see below code.
DATA: BEGIN OF DATA0 OCCURS 1,
P TYPE P,
END OF DATA0.
DATA: BEGIN OF OPTS OCCURS 1,
C(80) TYPE C,
END OF OPTS.
DATA: BEGIN OF TDIM1 OCCURS 1,
C(80) TYPE C,
END OF TDIM1.
DATA: BEGIN OF TDIM2 OCCURS 1,
C(80) TYPE C,
END OF TDIM2.
DATA: BEGIN OF TDIM3 OCCURS 1,
C(80) TYPE C,
END OF TDIM3.
DATA : GNTITLE(30),GTITLE(60).
.....
.....
CLEAR : TDIM1.
MOVE : ITAB6-GROUP TO TDIM1-C.
APPEND TDIM1.
CLEAR : DATA0.
MOVE : ITAB6-QTY TO DATA0-P.
APPEND DATA0.
CLEAR : DATA0.
MOVE : ITAB6-PEND TO DATA0-P.
APPEND DATA0.
.......
....
...
REFRESH OPTS.
WRITE 'FIFRST = 2D' TO OPTS-C. APPEND OPTS.
WRITE 'TISIZE = 1' TO OPTS-C. APPEND OPTS.
WRITE 'P2TYPE = VB' TO OPTS-C. APPEND OPTS.
CLEAR : GNTITLE.
REFRESH TDIM2.
MOVE 'Completed' TO TDIM2.
APPEND TDIM2.
MOVE 'Pending' TO TDIM2.
APPEND TDIM2.
REFRESH TDIM3.
......
......
CLEAR : GTITLE.
CONCATENATE '' ITAB-POST1 INTO GTITLE.
IF NOT GNTITLE IS INITIAL.
CONCATENATE GTITLE '(' GNTITLE ')' INTO GTITLE SEPARATED BY SPACE.
ENDIF.
CALL FUNCTION 'GRAPH_MATRIX'
EXPORTING
TITL = GTITLE
VALT = 'Detail'
DIM1 = 'Activity'
DIM2 = 'Quantity'
TABLES
DATA = DATA0
TDIM1 = TDIM1
TDIM2 = TDIM2
TDIM3 = TDIM3.
OPTS = OPTS.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
please tell me , if i made any mistake while passing table parameter OPTS.
Regards,
Prakash
03-19-2008 8:38 AM
Hi,
Try This...
REPORT ZMATRIX.
DATA: BEGIN OF ITAB_DATA OCCURS 0,
DATANAME(15),
QUANTITY1 TYPE I,
QUANTITY2 TYPE I,
QUANTITY3 TYPE I,
END OF ITAB_DATA,
BEGIN OF ITAB_OPTIONS OCCURS 0,
OPTION(20),
END OF ITAB_OPTIONS.
ITAB_DATA-DATANAME = 'Electricity'.
ITAB_DATA-QUANTITY1 = 55.
ITAB_DATA-QUANTITY2 = 62.
ITAB_DATA-QUANTITY3 = 59.
APPEND ITAB_DATA.
ITAB_DATA-DATANAME = 'Gas'.
ITAB_DATA-QUANTITY1 = 35.
ITAB_DATA-QUANTITY2 = 52.
ITAB_DATA-QUANTITY3 = 44.
APPEND ITAB_DATA.
ITAB_DATA-DATANAME = 'Water'.
ITAB_DATA-QUANTITY1 = 18.
ITAB_DATA-QUANTITY2 = 22.
ITAB_DATA-QUANTITY3 = 19.
APPEND ITAB_DATA.
CALL FUNCTION 'GRAPH_MATRIX_3D'
EXPORTING
COL1 = 'Jan'
COL2 = 'Feb'
COL3 = 'Mar'
TITL = 'Utility Expenses in US$.'
TABLES
DATA = ITAB_DATA
OPTS = ITAB_OPTIONS
EXCEPTIONS
OTHERS = 1.
Reward points if useful.....
Regards
AK
03-19-2008 8:38 AM
hi check this example..
REPORT ZZ__GRAPH .
DATA: BEGIN OF ITAB_DATA OCCURS 0,
DATANAME(15),
QUANTITY1 TYPE I,
QUANTITY2 TYPE I,
QUANTITY3 TYPE I,
END OF ITAB_DATA,
BEGIN OF ITAB_OPTIONS OCCURS 0,
OPTION(20),
END OF ITAB_OPTIONS.
ITAB_DATA-DATANAME = 'Electricity'.
ITAB_DATA-QUANTITY1 = 55.
ITAB_DATA-QUANTITY2 = 62.
ITAB_DATA-QUANTITY3 = 59.
APPEND ITAB_DATA.
ITAB_DATA-DATANAME = 'Gas'.
ITAB_DATA-QUANTITY1 = 35.
ITAB_DATA-QUANTITY2 = 52.
ITAB_DATA-QUANTITY3 = 44.
APPEND ITAB_DATA.
ITAB_DATA-DATANAME = 'Water'.
ITAB_DATA-QUANTITY1 = 18.
ITAB_DATA-QUANTITY2 = 22.
ITAB_DATA-QUANTITY3 = 19.
APPEND ITAB_DATA.
CALL FUNCTION 'GRAPH_MATRIX_3D'
EXPORTING
COL1 = 'Jan'
COL2 = 'Feb'
COL3 = 'Mar'
TITL = 'Utility Expenses in US$.'
TABLES
DATA = ITAB_DATA
OPTS = ITAB_OPTIONS
EXCEPTIONS
OTHERS = 1.
regards,
venkat.