Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert the screen output to PDF of a report?

former_member182426
Active Contributor
0 Kudos
1,581

hi friends,

I am displaying the data in my report using screens.

After displaying the all data on screens, Then when i click a button 'CONVERT TO PDF' ,then the screen output to PDF file and save it to local disk.

I created a button. when i clicked it's showing no spool request generated.

I know converting output list (normal output) to PDF file. But i am unable to convert the screen output to PDF format.

Any helps will be appreciate..............

Regards,

Shankar.

5 REPLIES 5

Former Member
0 Kudos
232

Hello,

This can help you.

[http://www.sapdevelopment.co.uk/reporting/rep_spooltopdf.htm]

Have been answered many times in SCN.

Thanks,

Jayant

0 Kudos
232

hi,

here my output is not simple output in screen.

I used SCREEN PAINTER.

CALL SCREEN 100.

In this screen i am displaying data. this i want to convert to PDF and save it to local hard disk.

Regards,

Shankar.

Former Member
0 Kudos
232

Hi.

I don't think we can convert gui screen direct to PDF because we need an OTF format to convert to PDF formart.

What I am going to suggest you is?

You need to pass all data on the screen to Smartform after you get

OTF output for calling smart form then pass OTF to function CONVERT_OTF_2_PDF. Last step

call function GUI_DOWNLOAD to download PDF to local computer.

Sayan.

Former Member
0 Kudos
232

hi

run the RSTXPDFT4

This report convert output into PDF file

also see this example:

&----


*& Report Z_CREATE_PDF_ABAPLIST

&----


*& Description: Simple Program to generate PDF from ABAP List Output

&----


REPORT Z_CREATE_PDF_ABAPLIST NO STANDARD PAGE HEADING.

  • PF-status containing a PDF button in the report Output to generate

  • PDF form

SET PF-STATUS 'Z_PDF'.

-


*Table Declarations

-


TABLES: MARA, MARC, MAKT.

-


  • Internal Table Declarations

-


DATA: BEGIN OF TS_MARA OCCURS 0,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

MATKL LIKE MARA-MATKL,

LVORM LIKE MARA-LVORM,

WERKS LIKE MARC-WERKS,

MAKTX LIKE MAKT-MAKTX,

END OF TS_MARA.

-


  • Selection Screen Parameters

-


SELECTION-SCREEN BEGIN OF BLOCK B1.

SELECT-OPTIONS: S_MATNR FOR MARA-MATNR OBLIGATORY,

S_WERKS FOR MARC-WERKS OBLIGATORY.

SELECTION-SCREEN END OF BLOCK B1.

-


TOP-OF-PAGE.

-


write: 40 'Generating PDF from List Output' color 1 intensified on.

skip 1.

write: /1 'Date :', SY-DATUM,

/1 'User ID :', SY-UNAME,

/1(112) SY-ULINE.

-


START-OF-SELECTION.

-


  • Perform for Basic Selection

PERFORM GET_MARA.

  • Perform to Display Data

PERFORM DISPLAY_MARA.

-


AT USER-COMMAND.

-


  • User Command to generate PDF Form

AT USER-COMMAND.

CASE SY-UCOMM.

WHEN 'PDF'.

DATA: L_PARAMS TYPE PRI_PARAMS,

L_VALID TYPE STRING,

W_SPOOL_NR LIKE TSP01-RQIDENT.

  • TO GET PRINT PARAMETERS

CALL FUNCTION 'GET_PRINT_PARAMETERS'

IMPORTING

OUT_PARAMETERS = L_PARAMS

VALID = L_VALID.

IF SY-SUBRC <> 0.

ENDIF.

  • Internal table for Selection Screen

DATA: BEGIN OF I_RSPARAMS OCCURS 0.

INCLUDE STRUCTURE RSPARAMS.

DATA: END OF I_RSPARAMS.

  • Store the current selection screen details

CALL FUNCTION 'RS_REFRESH_FROM_SELECTOPTIONS'

EXPORTING

CURR_REPORT = SY-REPID

  • IMPORTING

  • SP =

TABLES

SELECTION_TABLE = I_RSPARAMS

  • EXCEPTIONS

  • NOT_FOUND = 1

  • NO_REPORT = 2

  • OTHERS = 3

.

IF SY-SUBRC <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

  • SUBMIT TO GET THE SPOOL NUMBER

SUBMIT Z_CREATE_PDF_ABAPLIST WITH SELECTION-TABLE I_RSPARAMS

TO SAP-SPOOL

SPOOL PARAMETERS L_PARAMS

WITHOUT SPOOL DYNPRO

AND RETURN.

  • SELECT THE RECENTLY CREATED SPOOL

SELECT MAX( RQIDENT ) INTO W_SPOOL_NR FROM TSP01

WHERE RQCLIENT = SY-MANDT

AND RQOWNER = SY-UNAME.

*REPORT TO GENERATE SPOOL NUMBER FOR PDF CONVERT

SUBMIT RSTXPDF5 WITH SPOOLNO = W_SPOOL_NR

WITH DSTDEVIC = 'LOCL' AND RETURN .

IF SY-SUBRC EQ 0.

CLEAR W_SPOOL_NR.

  • SELECT THE RECENTLY CREATED SPOOL FOR PDF

SELECT MAX( RQIDENT ) INTO W_SPOOL_NR FROM TSP01

WHERE RQCLIENT = SY-MANDT

AND RQOWNER = SY-UNAME.

*REPORT TO DOWNLOAD PDF SPOOL TO GUI

SUBMIT RSTXPDFT5 WITH SPOOLID = W_SPOOL_NR

AND RETURN.

ENDIF.

ENDCASE.

&----


*& Form GET_MARA

&----


  • text

-


  • --> p1 text

  • <-- p2 text

-


FORM GET_MARA .

CLEAR : TS_MARA.

REFRESH: TS_MARA.

  • To select Materials based on Selection Criteria

SELECT A~MATNR A~MTART A~MATKL A~LVORM B~WERKS INTO CORRESPONDING

FIELDS OF TABLE TS_MARA FROM MARA AS A

INNER JOIN MARC AS B ON A~MATNR EQ B~MATNR

WHERE A~MATNR IN S_MATNR

AND B~WERKS IN S_WERKS.

LOOP AT TS_MARA.

SELECT SINGLE * FROM MAKT WHERE MATNR EQ TS_MARA-MATNR

AND SPRAS EQ SY-LANGU.

MOVE MAKT-MAKTX TO TS_MARA-MAKTX.

MODIFY TS_MARA INDEX SY-TABIX.

ENDLOOP.

ENDFORM. " GET_MARA

&----


*& Form DISPLAY_MARA

&----


  • text

-


  • --> p1 text

  • <-- p2 text

-


FORM DISPLAY_MARA .

CLEAR : TS_MARA.

WRITE: /1 '|', 2(18) 'Material Number' COLOR 7,

21 '|', 22(5) 'Plant ' COLOR 7,

28 '|', 29(13) 'Material Type ' COLOR 7,

42 '|', 43(14) 'Material Group ' COLOR 7,

57 '|', 58(13) 'Deletion Flag ' COLOR 7,

71 '|', 72(40) 'Description ' COLOR 7,

112 '|'.

WRITE: /1(112) SY-ULINE.

LOOP AT TS_MARA.

WRITE: /1 '|', 2(18) TS_MARA-MATNR,

21 '|', 22(5) TS_MARA-WERKS,

28 '|', 29(13) TS_MARA-MTART,

42 '|', 43(14) TS_MARA-MATKL,

57 '|', 58(13) TS_MARA-LVORM,

71 '|', 72(40) TS_MARA-MAKTX,

112 '|'.

WRITE: /1(112) SY-ULINE.

ENDLOOP.

ENDFORM. " DISPLAY_MARA

Edited by: krupa jani on Nov 20, 2008 11:34 AM

0 Kudos
232

hi,

plz here my output is not simple list output.

I am using screen painter. i.e dialogmodules.

I used SCREEN PAINTER.

CALL SCREEN 100.

In this screen i am displaying data. this i want to convert to PDF and save it to local hard disk.

Regards,

Shankar.