topic Re: Remuneration statement to pdf in Application Development and Automation Discussions

Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 07:33:47 GMT

Hi Experts,

Pls post ur comments how to convert my PE51 Form into pdf format.

I've done my HR Remuneration Form via PE51 and it's executing fine through Tcode:PC00_M40_CEDT - Remuneration statement .

Now, the requirement is, My Client wants the same to execute as pdf format and take a print output as similar like PO/Invoice forms.

When I tried with FM:SSF_FUNCTION_MODULE_NAME is shwoing the ouput thru SF:ZHR_ESS_PAYSLIP_TO_PDF_T but the alignment and form size of PE51 form is standard and

This form is a std 132 column length size, so when i tried with FM "CONVERT_OTF", its not converting my form into pdf table format ( otf variable: tab_otf_final).

Pls advise how to resolve it.

Im asking ur help again clearly that I want to convert my PE51 HR Form to pdf convertion format.

>>>>CALL FUNCTION 'CONVERT_OTF'

>>>> EXPORTING

>>>> format = 'PDF'

>>>> max_linewidth = 132

>>>> * ARCHIVE_INDEX = ' '

>>>> * COPYNUMBER = 0

>>>> * ASCII_BIDI_VIS2LOG = ' '

>>>> IMPORTING

>>>> bin_filesize = bin_filesize

>>>> * BIN_FILE =

>>>> TABLES

>>>> otf = tab_otf_final

>>>> lines = pdf_tab

>>>> EXCEPTIONS

>>>> err_max_linewidth = 1

>>>> err_format = 2

>>>> err_conv_not_possible = 3

>>>> err_bad_otf = 4

>>>> OTHERS = 5

>>>> .

>>>> IF sy-subrc <> 0.

>>>> * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

>>>> * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

>>>> ENDIF.

thanks & regards

sankar.

Edited by: sankar babu on Sep 22, 2008 10:01 AM

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:14:41 GMT

Hi Sankar,

It happens because the main window is not sufficient for these details. So goto the form ZHR_ESS_PAYSLIP_TO_PDF and Click on Form painter button present on the Application toolbar. And now increase the main window size. Now take a print and see. This will definitely solve.

Regards,

Swapna.

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:22:50 GMT

HI,

You can Use these FMs

CONVERT_ABAPSPOOLJOB_2_PDF

CONVERT_OTF_2_PDF

This Might Help.

Regards

Sumit Agarwal

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:36:05 GMT

Hi Swapna,

thanks for ur prompt reply...

But i've tried it already the way u said.Its not working since the HR form is std upto 132 column length size.

Post me ur advise.

regards

sankar.

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:40:51 GMT

Ok...Try giving different page formats... like portrait or landscape in the form Attributes..

Regards,

Swapna.

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:47:16 GMT

Hi Sankar,

Refer this sample code.

DATA:
  form_name TYPE rs38l_fnam,
  wa_ctrlop TYPE ssfctrlop,
  wa_outopt TYPE ssfcompop.
DATA:
  t_otfdata TYPE ssfcrescl,
  t_pdf_tab LIKE tline OCCURS 0 WITH HEADER LINE.

DATA:
  t_otf TYPE itcoo OCCURS 0 WITH HEADER LINE,
  w_filesize TYPE i,
  w_bin_filesize TYPE i.


CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'
  EXPORTING
    formname           = 'z_form'
  IMPORTING
    fm_name            = form_name
  EXCEPTIONS
    no_form            = 1
    no_function_module = 2.


wa_ctrlop-getotf = 'X'.
wa_ctrlop-no_dialog = 'X'.
wa_outopt-tdnoprev = 'X'.

CALL FUNCTION '  '
  EXPORTING
    control_parameters = wa_ctrlop
    output_options     = wa_outopt
    user_settings      = 'X'
  IMPORTING
    job_output_info    = t_otfdata
  EXCEPTIONS
    formatting_error   = 1
    internal_error     = 2
    send_error         = 3
    user_canceled      = 4.
IF sy-subrc <> 0.
  MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
  WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

  t_otf[] = t_otfdata-otfdata[].

CALL FUNCTION 'CONVERT_OTF'
 EXPORTING
   FORMAT                      = 'PDF'
   MAX_LINEWIDTH               = 132
*   ARCHIVE_INDEX               = ' '
*   COPYNUMBER                  = 0
*   ASCII_BIDI_VIS2LOG          = ' '
*   PDF_DELETE_OTFTAB           = ' '
  IMPORTING
   BIN_FILESIZE                 = w_bin_filesize
*   BIN_FILE                    = BIN_FILE
  TABLES
    otf                         = t_otf
    lines                       = t_pdf_tab
 EXCEPTIONS
   ERR_MAX_LINEWIDTH           = 1
   ERR_FORMAT                  = 2
   ERR_CONV_NOT_POSSIBLE       = 3
   ERR_BAD_OTF                 = 4
          .
  .
  CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      bin_filesize            = w_bin_filesize
      filename                = 'D:\test.PDF'
      filetype                = 'BIN'
    IMPORTING
      filelength              = w_filesize
    TABLES
      data_tab                = t_pdf_tab
    EXCEPTIONS
      file_write_error        = 1
      no_batch                = 2
      gui_refuse_filetransfer = 3
      invalid_type            = 4
      no_authority            = 5
      unknown_error           = 6
      header_not_allowed      = 7
      separator_not_allowed   = 8
      filesize_not_allowed    = 9
      header_too_long         = 10
      dp_error_create         = 11
      dp_error_send           = 12
      dp_error_write          = 13
      unknown_dp_error        = 14
      access_denied           = 15
      dp_out_of_memory        = 16
      disk_full               = 17
      dp_timeout              = 18
      file_not_found          = 19
      dataprovider_exception  = 20
      control_flush_error     = 21.
  IF sy-subrc NE 0.
    MESSAGE 'file is not downloaded' TYPE 'E'.
  ELSE.
    MESSAGE 'file downloaded' TYPE 'S'.
  ENDIF.

Regards,

Sravanthi

Re: Remuneration statement to pdf

Former Member — Mon, 22 Sep 2008 08:54:48 GMT

Hi friends...

Im trying to fix it with ur guidances.....

will do and let u know my status...

thanks for ur prompt reply.

sankar.

Re: Remuneration statement to pdf

Former Member — Fri, 25 Sep 2009 09:49:09 GMT

Not resolved