topic Re: ALV - print - create spool request in Application Development and Automation Discussions

ALV - print - create spool request

Former Member — Sat, 17 Jul 2010 21:01:53 GMT

Hi all,

We have made SAP Query (The majority and 'was written in ABAP code), a report using ALV grid (function 'REUSE_ALV_GRID_DISPLAY'). There is a 'Print' button on the grid. If the user presses this button the system will send a screen where the user can choose print parameters (name of printer, printing, direct or not, etc..) If the user presses 'Continue' a spool request is then created.

But the users do not want to see the screen parameters.

After pressing the button 'Print' on the grid, the spool request should be immediately created using the parameters seted in the ABAP program, the same program that creates ALV.

Any idea how to do this?

Thanks in advance

Re: ALV - print - create spool request

JerryWang — Sun, 18 Jul 2010 02:46:56 GMT

Hello Friend,

see this post.

Best Regards,

Jerry

Re: ALV - print - create spool request

Former Member — Mon, 19 Jul 2010 06:26:18 GMT

Hi,

Instead of using the standard 'Print' button on the ALV toolbar, create your own button on the ALV toolbar and when the user selects this button, write your code to display the ALV in spool.

This can be done by writing the FM for ALV within the NEW-PAGE PRINT ON (NO DIALOG) and NEW-PAGE PRINT OFF statements. This will also require use of FM GET_PRINT_PARAMETERS.

Regards,

Aparna Alashe.

Re: ALV - print - create spool request

Former Member — Mon, 19 Jul 2010 07:46:50 GMT

Thank you. Please, could give the ABAP code to do this?

Re: ALV - print - create spool request

Former Member — Mon, 19 Jul 2010 08:46:33 GMT

Hi,

Please refer to the link to add button in the ALV tool bar:

[http://www.sapalv.net/2009/07/sap-alv-tutorial-4-%E2%80%93-add-button-to-toolbar/]

For creating spool on click of this pushbutton you can use the following:

* Set the Spool Parameters
  DATA: lwa_params TYPE pri_params,
        lv_valid TYPE c.

  CLEAR: lwa_params, lv_valid.

  CALL FUNCTION 'GET_PRINT_PARAMETERS'
    EXPORTING
      in_parameters          = lwa_params
      layout                 = 'X_65_132'
      line_count             = 65
      line_size              = 132
      no_dialog              = 'X'
    IMPORTING
      out_parameters         = lwa_params
      valid                  = lv_valid
    EXCEPTIONS
      archive_info_not_found = 1
      invalid_print_params   = 2
      invalid_archive_params = 3
      OTHERS                 = 4.

  IF sy-subrc EQ 0.
    NEW-PAGE PRINT ON PARAMETERS lwa_params NO DIALOG.

*                  Write code for displaying the ALV here......

    NEW-PAGE PRINT OFF.
  ENDIF.

Regards,

Aparna Alashe.

Re: ALV - print - create spool request

Former Member — Mon, 19 Jul 2010 09:27:00 GMT

Thank you.

One more question;). In cases where the format 'X_65_132' does not exist, should be created? How? Perhaps with T. SPAD?

Re: ALV - print - create spool request

Former Member — Tue, 20 Jul 2010 05:37:56 GMT

Hi,

You can set the line size to the value that your require. Maximum is 1023 characters.

Regards,

Aparna Alashe.

Re: ALV - print - create spool request

vishal_sharda2 — Tue, 20 Jul 2010 06:23:11 GMT

Hi,

Use FM GET_PRINT_PARAMETERS and pass 'X' for NO_DIALOG parameter.

BR,

Vishal.

Re: ALV - print - create spool request

Former Member — Wed, 21 Jul 2010 05:39:25 GMT

Thanks

Re: ALV - print - create spool request

pankaj_mittal — Fri, 16 Sep 2011 11:50:05 GMT

hi serenaaa,

Can you please send me the code to supress the dialog box with printer parameter.

Regards

Pankaj Mittal