topic Re: calling standard function module matrix_graph in Application Development and Automation Discussions

calling standard function module matrix_graph

Former Member — Wed, 19 Mar 2008 08:30:37 GMT

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

Re: calling standard function module matrix_graph

ak_upadhyay — Wed, 19 Mar 2008 08:38:16 GMT

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

Re: calling standard function module matrix_graph

Former Member — Wed, 19 Mar 2008 08:38:51 GMT

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.