topic Re: pie chart in Application Development and Automation Discussions

pie chart

Former Member — Mon, 03 Mar 2008 06:09:02 GMT

Hi,

I want to display the Pie Chart in a report .

So Plz give me the details of it.

Regards,

Rani.

Re: pie chart

Former Member — Mon, 03 Mar 2008 09:11:43 GMT

Hi!

You can use FM 'GFW_PRES_SHOW' with PRESENTATION_TYPE = GFW_PRESTYPE_PIE_CHART. You can check documentation of the FM or the where-used list to see how to use it. Below is one sample code:

TYPE-POOLS: GFW.

DATA: VALUES TYPE TABLE OF GPRVAL WITH HEADER LINE,

COLUMN_TEXTS TYPE TABLE OF GPRTXT WITH HEADER LINE.

REFRESH VALUES.

REFRESH COLUMN_TEXTS.

VALUES-ROWTXT = ''.

VALUES-VAL1 = 10.

VALUES-VAL2 = 35.

VALUES-VAL3 = 45.

VALUES-VAL4 = 8.

VALUES-VAL5 = 2.

APPEND VALUES.

COLUMN_TEXTS-COLTXT = 'Test1'.

APPEND COLUMN_TEXTS.

COLUMN_TEXTS-COLTXT = 'Test2'.

APPEND COLUMN_TEXTS.

COLUMN_TEXTS-COLTXT = 'Test3'.

APPEND COLUMN_TEXTS.

COLUMN_TEXTS-COLTXT = 'Test4'.

APPEND COLUMN_TEXTS.

COLUMN_TEXTS-COLTXT = 'Test5'.

APPEND COLUMN_TEXTS.

CALL FUNCTION 'GFW_PRES_SHOW'

EXPORTING

CONTAINER = 'CONTAINER'

PRESENTATION_TYPE = GFW_PRESTYPE_PIE_CHART

X_AXIS_TITLE = 'Pie1'

Y_AXIS_TITLE = 'Pie2'

TABLES

VALUES = VALUES

COLUMN_TEXTS = COLUMN_TEXTS

EXCEPTIONS

ERROR_OCCURRED = 1

OTHERS = 2

Cheers!

Re: pie chart

Former Member — Mon, 03 Mar 2008 09:19:21 GMT

Hi,

To create a basic Excel pie chart from SAP data, you follow these steps:

1. Open any report output screen that displays an SAP report. It can be an SAP query, a custom ABAP report, an SAP standard-delivered report, or any other format.

2. You have multiple options for how to get your SAP data into Excel, each of which varies depending on your installation version of SAP R/3 and your installation version of Excel. Because there are multiple options for different versions, the menu path and buttons vary for each. It is a good idea to save your SAP report output into an Excel worksheet, which you will use as your mail merge data file. The most popular way to do this is to click the Excel button on your report output toolbar. Excel launches and displays the SAP report in an Excel worksheet. Next, save the report in Excel (for example, as c:\employee_data_chart.xls). Close and exit SAP and Excel.

Note

It is not required that you exit Excel to continue, but it is recommended that you do so from a resource perspective (how much memory your PC is using to run SAP and Excel simultaneously) and because, depending on your versions of SAP and Microsoft Office, it may be easier.

3. Launch Excel and open your saved data source file (for example, c:\employee_data_chart.xls). For this example, create a custom pie chart that charts each position and the annual salary associated with it. Use your mouse to highlight the appropriate columns (for example, Position and Annual Salary). With the columns selected, click the Chart Wizard button on the Application toolbar. A Chart Wizard dialog box appears, enabling you to create pictorial graphs of your SAP data.

4. On the Chart Wizard - Step 1 of 4 dialog, select the Custom Types tab, and then select Pie Explosion from the Chart Type list (see Figure 21.12). Click Next.

5. Click the Next button on each of the next two wizard dialogs without making any changes.

6. In the Chart Wizard - Step 4 of 4 dialog, select the In a New Sheet option, and then click the Finish button. A new Microsoft worksheet is created, with your pie chart inserted in it (see Figure 21.13).

Cheers,

vasavi.

kindly reward if helpful.

Re: pie chart

Former Member — Mon, 03 Mar 2008 09:23:42 GMT

Hi,

Go to TCODE --->SE83 ~~>expand Graphics~~> You will find lot programs on pie chart.

(OR)

Below are the Fm to create pie chart.

Check the fun modules

GRAPH_2D Calling up the 2D business graphics

GRAPH_2D_MENUE DO NOT USE (use 'GRAPH_2D' and 'GRAPH_BUSG_MENU_SET')

GRAPH_3D Calling up the 3D presentation graphics

GRAPH_BUSG_COLOR_SET Definition of color pallets for business graphics

GRAPH_BUSG_MENU_SET Pushbutton menu (tool bar) for all BUSG modules

GRAPH_MATRIX Calling up SAP Business Graphics (2D, 3D and 4D)

GRAPH_MATRIX_2D Calling up the 2D graphics (user-friendly version)

GRAPH_MATRIX_3D Structure of 3D graphics (user-friendly version)

GRAPH_MATRIX_4D Calling up a 3D graphic (4th dimension stacked representation)

check the report GRAPHICS_IGS_CE_TEST

Re: pie chart

Former Member — Mon, 03 Mar 2008 09:25:05 GMT

hi,

you can check this follwoing program and code.

Report program: DEMO_GFW_PRES_SHOW

data: VALUES TYPE TABLE OF GPRVAL WITH HEADER LINE,

COLUMN_TEXTS TYPE TABLE OF GPRTXT WITH HEADER LINE.

data: gfw_prestype_lines TYPE i VALUE 17,

REFRESH VALUES. REFRESH COLUMN_TEXTS.

VALUES-ROWTXT = CO_GFW_PROG_ROW1. VALUES-VAL1 = 1. VALUES-VAL2 = 5.

APPEND VALUES.

VALUES-ROWTXT = CO_GFW_PROG_ROW2. VALUES-VAL1 = 2. VALUES-VAL2 = 6.

APPEND VALUES.

VALUES-ROWTXT = CO_GFW_PROG_ROW3. VALUES-VAL1 = 3. VALUES-VAL2 = 7.

APPEND VALUES.

COLUMN_TEXTS-COLTXT = CO_GFW_PROG_SAUSAGE. APPEND COLUMN_TEXTS.

COLUMN_TEXTS-COLTXT = CO_GFW_PROG_CHEESE. APPEND COLUMN_TEXTS.

CALL FUNCTION 'GFW_PRES_SHOW'

EXPORTING

CONTAINER = 'CONTAINER'

PRESENTATION_TYPE = GFW_PRESTYPE_LINES

PRESENTATION_TYPE = GFW_PRESTYPE_PIE_CHART
orientation = gfw_orient_columns

TABLES

VALUES = VALUES

COLUMN_TEXTS = COLUMN_TEXTS

EXCEPTIONS

ERROR_OCCURRED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

...add your error handling here

LEAVE PROGRAM.

ENDIF.

FIRST_CALL = 1.

ENDIF. "//firstcall initial

I hope you will get some idea to achieve your requirements.

Reward points, if its helpful

sekhar

Re: pie chart

Former Member — Mon, 03 Mar 2008 09:54:32 GMT

Refer program

GFW_PROG_PIE

Thanks

Vijay

Re: pie chart

dinakar_rayasam — Tue, 13 May 2008 10:06:02 GMT

Dear Vijay,

Here I a using the same program fror printing the graph but i don't find the print option here to take the printout .Please help me if you have any solution for this .

Thanks in advance .

Dinakar

Re: pie chart

dinakar_rayasam — Fri, 16 May 2008 06:54:56 GMT

Hi Abapers,

Please help me to solve this issue.

Please treat it as urgent and replayme.

Regards

Dinakar