topic Re: Convert internal table to PDF send mail using oops abap in Application Development and Automation Discussions

Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 06:19:04 GMT

Hi Guru's,

I got a requirement to develop a report , i have done it, they want to send this report as excel attachment after clicking a button and pdf attachment after clicking a button. I have done excel attachment part, which is working fine. But when i tried below coding for sending PDF attachment i am getting error "adobe reader could not open because it is either not a supported file type or because file has been damaged(for example, it was sent as an email attachment and was'nt correctly decoded". Below is my code:

DATA: L_SEND_REQUEST TYPE REF TO CL_BCS,

L_DOCUMENT TYPE REF TO CL_DOCUMENT_BCS,

L_RECIPIENT TYPE REF TO IF_RECIPIENT_BCS,

L_SENDER TYPE REF TO IF_SENDER_BCS,

L_UNAME TYPE SALRTDRCPT,

L_BCS_EXCEPTION TYPE REF TO CX_DOCUMENT_BCS,

L_ADDRESS_EXCEPTION TYPE REF TO CX_ADDRESS_BCS,

L_SENDER_EXCEPTION TYPE REF TO CX_SEND_REQ_BCS.

DATA: L_TEXT(100) TYPE C,

WA_SUBJECT TYPE SO_OBJ_DES.

DATA: LT_OBJBIN TYPE STRING,

LT_OBJBIN1 TYPE SOLIX_TAB,

SIZE TYPE SO_OBJ_LEN,

I_CONTENT TYPE SOLI_TAB.

DATA: C_TAB(1) TYPE C VALUE CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB,

C_CR(1) TYPE C VALUE CL_ABAP_CHAR_UTILITIES=>CR_LF,

C_EXT TYPE SOODK-OBJTP VALUE 'PDF',

C_BODY TYPE STRING VALUE 'Packing Machine wise confirmation Vs Warehouse Receipt Report',

c_raw(3) type c value 'RAW',

C_X(1) TYPE C VALUE 'X',

C_U(1) TYPE C VALUE 'U'.

CONCATENATE 'ZPP01' ' '

S_BUDAT-LOW+6(2) '.' S_BUDAT-LOW+4(2) '.' S_BUDAT-LOW(4) '-'

S_BUDAT-HIGH+6(2) '.' S_BUDAT-HIGH+4(2) '.' S_BUDAT-HIGH(4) INTO WA_SUBJECT.

MOVE C_BODY TO L_TEXT.

APPEND L_TEXT TO I_CONTENT.

CLEAR L_TEXT.

WA_MAIL-BUDAT = 'Date'.

WA_MAIL-PLNBEZ = 'Material'.

WA_MAIL-MAKTX = 'Material Description'.

WA_MAIL-GMNGA = 'Packing Machinwise confirmation'.

WA_MAIL-GMEIN = 'UOM'.

WA_MAIL-MT = 'MT'.

WA_MAIL-MENGE = 'Warehouse Reciept'.

WA_MAIL-MEINS = 'UOM'.

WA_MAIL-MT1 = 'MT'.

WA_MAIL-DIF = 'Difference'.

WA_MAIL-MT2 = 'MT'.

APPEND WA_MAIL TO IT_MAIL.

CLEAR WA_MAIL.

LOOP AT IT_FINAL INTO WA_FINAL.

WA_MAIL-BUDAT = WA_FINAL-BUDAT.

WA_MAIL-PLNBEZ = WA_FINAL-PLNBEZ.

WA_MAIL-MAKTX = WA_FINAL-MAKTX.

WA_MAIL-GMNGA = WA_FINAL-GMNGA.

WA_MAIL-GMEIN = WA_FINAL-GMEIN.

WA_MAIL-MT = WA_FINAL-MT.

WA_MAIL-MENGE = WA_FINAL-MENGE.

WA_MAIL-MEINS = WA_FINAL-MEINS.

WA_MAIL-MT1 = WA_FINAL-MT1.

WA_MAIL-DIF = WA_FINAL-DIF.

WA_MAIL-MT2 = WA_FINAL-MT2.

APPEND WA_MAIL TO IT_MAIL.

CLEAR: WA_MAIL.

ENDLOOP.

LOOP AT IT_MAIL INTO WA_MAIL.

CONCATENATE LT_OBJBIN WA_MAIL-BUDAT C_TAB

WA_MAIL-PLNBEZ C_TAB

WA_MAIL-MAKTX C_TAB

WA_MAIL-GMNGA C_TAB

WA_MAIL-GMEIN C_TAB

WA_MAIL-MT C_TAB

WA_MAIL-MENGE C_TAB

WA_MAIL-MEINS C_TAB

WA_MAIL-MT1 C_TAB

WA_MAIL-DIF C_TAB

WA_MAIL-MT2 C_TAB

C_CR INTO LT_OBJBIN.

ENDLOOP.

TRY.

CALL METHOD CL_BCS_CONVERT=>STRING_TO_SOLIX

EXPORTING

IV_STRING = LT_OBJBIN

IV_CODEPAGE = '4103'

IV_ADD_BOM = 'X'

IMPORTING

ET_SOLIX = LT_OBJBIN1

EV_SIZE = SIZE.

CATCH CX_BCS .

ENDTRY.

TRY.

L_SEND_REQUEST = CL_BCS=>CREATE_PERSISTENT( ).

L_DOCUMENT = CL_DOCUMENT_BCS=>CREATE_DOCUMENT(

I_TYPE = C_RAW

I_SUBJECT = WA_SUBJECT

I_TEXT = I_CONTENT[] ).

L_DOCUMENT->ADD_ATTACHMENT(

I_ATTACHMENT_TYPE = C_EXT

I_ATTACHMENT_SUBJECT = WA_SUBJECT

I_ATTACHMENT_SIZE = SIZE

I_ATT_CONTENT_HEX = LT_OBJBIN1 ).

CALL METHOD L_SEND_REQUEST->SET_DOCUMENT( L_DOCUMENT ).

L_UNAME = SY-UNAME.

L_SENDER = CL_SAPUSER_BCS=>CREATE( L_UNAME ).

CALL METHOD L_SEND_REQUEST->SET_SENDER

EXPORTING

I_SENDER = L_SENDER.

l_recipient = CL_DISTRIBUTIONLIST_BCS=>GETU_PERSISTENT(

I_DLINAME = 'ZPP01'

I_PRIVATE = SPACE ).

CALL METHOD L_SEND_REQUEST->ADD_RECIPIENT

EXPORTING

I_RECIPIENT = l_recipient

* I_EXPRESS =

I_COPY = ' '

I_BLIND_COPY = ' '

I_NO_FORWARD = ' '.

CLEAR: WA_MAIL.

L_SEND_REQUEST->SET_SEND_IMMEDIATELY( C_X ).

CALL METHOD L_SEND_REQUEST->SEND( ).

COMMIT WORK.

IF SY-SUBRC EQ 0.

MESSAGE 'Mail sent successfully' TYPE 'S'.

ENDIF.

CATCH CX_DOCUMENT_BCS INTO L_BCS_EXCEPTION.

CATCH CX_ADDRESS_BCS INTO L_ADDRESS_EXCEPTION.

CATCH CX_SEND_REQ_BCS INTO L_SENDER_EXCEPTION.

ENDTRY.

same code instead of 'PDF' extension i have used as 'XLS' extension it is working fine, it is send attachment as excel, but it is not working for PDF. Please tell me whether am missing any formatting for PDF.

Regards,

Rithika.

Re: Convert internal table to PDF send mail using oops abap

Former Member — Thu, 07 Feb 2013 07:06:32 GMT

Hi,

Go to SU01, Go Default->Spool control. Then select output device and put any printer preference. If this spool request is empty, the pdf will show it corrupt.

Please check the below link related to your problem

http://scn.sap.com/thread/3188924

Thanks

Mani

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 07:17:33 GMT

Dear Nagamani,

Thanks for the reply but my output device is not empty, and the link which you have provided explains about converting smartforms to pdf, my case is converting internal table to pdf and send mail.

Regards,

Rithika.

Re: Convert internal table to PDF send mail using oops abap

Former Member — Thu, 07 Feb 2013 07:27:33 GMT

Hi Rithika ,

I just gave you the hint not exact solution.

May be this problem is because of settiings only as per above thread i mention it's not a matter of Smartform or Report.

Please Do Some R&D and check.

Thanks

Mani

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 07:32:21 GMT

Yes i checked in Default tab of SU01, output device is there so conifigwise it is correct.

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 07:39:50 GMT

Hii Rithika ,

May i know is it classical means - basic list report or ALV ????

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 07:42:37 GMT

Dear Ashish,

It is ALV Grid Report.

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 07:59:43 GMT

Hiii Rithika,

See my below example code - RUN it and see SBWP

Note : In below code is my temp code so that's why it contain some unused variable soo please remove it and also page size also set as per your requirement .

Still you face any problem than you can ask again

TYPE-POOLS:slis.
 
 DATA: lv_buffer TYPE string,
       lt_mess_att TYPE TABLE OF solisti1 ,
       ls_mess_att TYPE solisti1.
 CONSTANTS c_container TYPE c LENGTH 30 VALUE 'CC'.
 CONSTANTS c_col1 TYPE c LENGTH 2 VALUE ' ~'.
 CONSTANTS c_col2 TYPE c LENGTH 2 VALUE '~ '.
 CONSTANTS c_255 TYPE i VALUE 255.
 data p_recpnt TYPE sy-uname .
 
  p_recpnt = sy-uname.
 
 DATA : l_ref_bcs TYPE REF TO cl_bcs,
 l_ref_document TYPE REF TO cl_document_bcs,
 l_ref_recipient TYPE REF TO if_recipient_bcs,
 l_ref_bcs_exception TYPE REF TO cx_bcs,
 lv_sent_to_all TYPE os_boolean,
 lv_filesize TYPE so_obj_len,
 lv_doclines TYPE i,
 lv_last_line TYPE i,
 lv_text TYPE so_obj_des,
 lv_data TYPE bcsy_text,
 lv_size TYPE i,
 gt_fcat TYPE lvc_t_fcat.
 
 TYPES: ty_t_pdf TYPE STANDARD TABLE OF tline.
 DATA: lt_pdf_output TYPE ty_t_pdf,
       ls_pdf_output TYPE tline.
 
 DATA:i_t001 TYPE t001 OCCURS 0,
      g_spool   TYPE tsp01-rqident,
      g_program TYPE sy-repid VALUE sy-repid.
 
 DATA: w_print TYPE slis_print_alv,
       w_print_ctrl TYPE alv_s_pctl.
 
 
 START-OF-SELECTION.
   SELECT * FROM t001 INTO TABLE i_t001 UP TO 100 ROWS.
 
     CALL FUNCTION 'SET_PRINT_PARAMETERS'
     EXPORTING
       destination = 'LOCL' " Printer
       layout      = 'X_65_512/2' "Format
       line_count  = '65' "Line Count
       line_size   = '1024'. "Line Size
 
   w_print-print = 'X'.
 
   CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
     EXPORTING
       i_callback_program = g_program
       i_structure_name   = 'T001'
       is_print           = w_print
     TABLES
       t_outtab           = i_t001.
   IF sy-subrc <> 0.
     MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
             WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
   ELSE.
 
 
  data: GET_SIZE_FROM_FORMAT VALUE 'X'.
 
     g_spool = sy-spono.
 
   CALL FUNCTION 'CONVERT_ABAPSPOOLJOB_2_PDF'
     EXPORTING
       src_spoolid                    = g_spool "Spool Number
       no_dialog                      = space
       dst_device                     = 'LOCL' "Printer Name
       GET_SIZE_FROM_FORMAT           = GET_SIZE_FROM_FORMAT
       importing
       pdf_bytecount         =        lv_size "Output Size
 
       tables
         pdf                      = lt_pdf_output "Spool data in PDF Format
       exceptions
         err_no_abap_spooljob = 1
       err_no_spooljob                = 2
       err_no_permission              = 3
       err_conv_not_possible          = 4
       err_bad_destdevice             = 5
       user_cancelled                 = 6
       err_spoolerror                 = 7
       err_temseerror                 = 8
       err_btcjob_open_failed         = 9.
   IF sy-subrc EQ 0.
     LOOP AT lt_pdf_output INTO ls_pdf_output.
       TRANSLATE ls_pdf_output USING c_col1.
       CONCATENATE lv_buffer ls_pdf_output INTO lv_buffer.
       CLEAR ls_pdf_output.
     ENDLOOP.
     TRANSLATE lv_buffer USING c_col2.
     DO.
       ls_mess_att = lv_buffer.
       APPEND ls_mess_att TO lt_mess_att.
       SHIFT lv_buffer LEFT BY c_255 PLACES.
       IF lv_buffer IS INITIAL.
         EXIT.
       ENDIF.
       CLEAR ls_mess_att.
     ENDDO.
   ENDIF.
 *--create reference object
   TRY.
       l_ref_bcs = cl_bcs=>create_persistent( ).
       lv_text = 'Mail Subject' .
       APPEND 'Mail Content' TO lv_data.
       l_ref_document = cl_document_bcs=>create_document(
       i_type = 'RAW'
       i_text = lv_data
       i_subject = lv_text ).
 * *--create document reference
       lv_filesize = lv_size.
       CALL METHOD l_ref_document->add_attachment
         EXPORTING
           i_attachment_type    = 'PDF'
           i_attachment_size    = lv_filesize
           i_attachment_subject = lv_text
           i_att_content_text   = lt_mess_att[].
 * set the document
       l_ref_bcs->set_document( l_ref_document ).
 * create recipient
 *      p_recpnt = sap INBOX user ID to WHICH the ATTACHMENT is SENT.
       l_ref_recipient = cl_sapuser_bcs=>create( p_recpnt ).
 *adding recipient in to section
       l_ref_bcs->add_recipient( l_ref_recipient ).
 
 * send mail
       CALL METHOD l_ref_bcs->send(
       EXPORTING i_with_error_screen = 'X'
       RECEIVING
       result = lv_sent_to_all ).
       IF lv_sent_to_all = 'X'.
       ENDIF.
     CATCH cx_bcs INTO l_ref_bcs_exception.
       IF l_ref_bcs_exception IS NOT INITIAL.
         CLEAR l_ref_bcs_exception.
       ENDIF.
   ENDTRY.
 
   COMMIT WORK.
 
   endif.

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 08:19:10 GMT

Dear Ashish,

I have used your code, it says error "spool request does not exist" , i am not storing my report as background job, there will not be spool request rite.

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 08:39:08 GMT

Hiii,

it is not for background job, btw When you run this code in foreground mode one popup will come (printer popup) please enter printer name (ex. - LP01 or take from F4 ) and (have you press ok ?) press enter or ok than you can see status bar PDF conversion is running and you can see in SBWP . t just put break point after REUSE_ALV_GRID_DISPLAY debugg it and see it sy-spono.

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 09:54:39 GMT

It is not showing any popup, First i commented 'REUSE_ALV_GRID_DISPLAY' because i already displayed the alv grid using set_table_first_display, now i just uncommented and tested whether popup is coming or not, i got dump error that fiedcat is not assigned.

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 10:29:33 GMT

Hiii,

Yes definitely dump will occur , as you told me you have separate button for sending alv as PDF ok , so on click event of that button

ex. -

if sy-ucomm = 'PDF'.

w_print-print = 'X'.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' " Call this function again
          EXPORTING
            i_callback_program = g_program
            i_structure_name   = 'T001'
           is_print           = w_print       " but this time with print

TABLES
t_outtab = i_t001.

" rest of process i have already mentioned

perform send_email.

endif.

" Hope now you got it

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 10:57:06 GMT

Thanks for your efforst Ashish,

But still am getting the dump error "NO_FIELDCATALOG_AVAILABLE", for your better understanding i will explain what i did.

1) After giving input in the selection screen, am displaying the ALV GRID.

2) I have two buttons "Send as excel" and "Send as PDF"in top of the alv, which i created using 'toolbar' event of cl_gui_alv_grid class.

3) When i click send as excel i call subroutine inside that i wrote the coding which i told above in my first post, extension is 'XLS'.

4) Same i tried for PDF it is not working, these process happens after alv is displayed, so if call the FM REUSE_ALV_GRID_DISPLAY again without using fiedcat with using w_print, than also it is showing error.

Please help

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 11:00:07 GMT

Hiii,

ok use this code - just make PF status ZOF other wise no PF status will set ok

Try hope this time you will get success

TYPE-POOLS:slis.
 
      DATA: lv_buffer TYPE string,
            lt_mess_att TYPE TABLE OF solisti1 ,
            ls_mess_att TYPE solisti1.
      CONSTANTS c_container TYPE c LENGTH 30 VALUE 'CC'.
      CONSTANTS c_col1 TYPE c LENGTH 2 VALUE ' ~'.
      CONSTANTS c_col2 TYPE c LENGTH 2 VALUE '~ '.
      CONSTANTS c_255 TYPE i VALUE 255.
      data p_recpnt TYPE sy-uname .
 
       p_recpnt = sy-uname.
 
      DATA : l_ref_bcs TYPE REF TO cl_bcs,
      l_ref_document TYPE REF TO cl_document_bcs,
      l_ref_recipient TYPE REF TO if_recipient_bcs,
      l_ref_bcs_exception TYPE REF TO cx_bcs,
      lv_sent_to_all TYPE os_boolean,
      lv_filesize TYPE so_obj_len,
      lv_doclines TYPE i,
      lv_last_line TYPE i,
      lv_text TYPE so_obj_des,
      lv_data TYPE bcsy_text,
      lv_size TYPE i,
      gt_fcat TYPE lvc_t_fcat.
 
      TYPES: ty_t_pdf TYPE STANDARD TABLE OF tline.
      DATA: lt_pdf_output TYPE ty_t_pdf,
            ls_pdf_output TYPE tline.
 
      DATA:i_t001 TYPE t001 OCCURS 0,
           g_spool   TYPE tsp01-rqident,
           g_program TYPE sy-repid VALUE sy-repid.
 
      DATA: w_print TYPE slis_print_alv,
            w_print_ctrl TYPE alv_s_pctl.
 
 
      START-OF-SELECTION.
        SELECT * FROM t001 INTO TABLE i_t001 UP TO 100 ROWS.
 
          CALL FUNCTION 'SET_PRINT_PARAMETERS'
          EXPORTING
            destination = 'LOCL' " Printer
            layout      = 'X_65_512/2' "Format
            line_count  = '65' "Line Count
            line_size   = '1024'. "Line Size
 
        w_print-print = 'X'.
 
        CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
          EXPORTING
            i_callback_program = g_program
            i_structure_name   = 'T001'
             i_callback_pf_status_set          = 'PF'
             i_callback_user_command           = 'USER_COMMAND' " for User-Command
 *           is_print           = w_print
          TABLES
            t_outtab           = i_t001.
        IF sy-subrc <> 0.
          MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
                  WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
 
        endif.
 
 FORM pf USING rt_extab TYPE slis_t_extab.
   SET PF-STATUS 'ZOF'.
 ENDFORM.                    "pf
 
 FORM user_command USING lv_okcode LIKE sy-ucomm l_selfield TYPE slis_selfield.
 
 * assign the function code to variable v_okcode
   lv_okcode = sy-ucomm.
 
 * handle the code execution based on the function code encountered
   CASE lv_okcode.
 
     WHEN 'PDF'. "<--to handle user actions
 w_print-PRINT = 'X'.
 
             CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
          EXPORTING
 *           i_callback_program = g_program
            i_structure_name   = 'T001'
             i_callback_user_command           = 'USER_COMMAND' " for User-Command
            is_print           = w_print
          TABLES
            t_outtab           = i_t001.
        IF sy-subrc <> 0.
          MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
                  WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
        ELSE.
 
 
       data: GET_SIZE_FROM_FORMAT VALUE 'X'.
 
          g_spool = sy-spono.
 
        CALL FUNCTION 'CONVERT_ABAPSPOOLJOB_2_PDF'
          EXPORTING
            src_spoolid                    = g_spool "Spool Number
            no_dialog                      = space
            dst_device                     = 'LOCL' "Printer Name
            GET_SIZE_FROM_FORMAT           = GET_SIZE_FROM_FORMAT
            importing
            pdf_bytecount         =        lv_size "Output Size
 
            tables
              pdf                      = lt_pdf_output "Spool data in PDF Format
            exceptions
              err_no_abap_spooljob = 1
            err_no_spooljob                = 2
            err_no_permission              = 3
            err_conv_not_possible          = 4
            err_bad_destdevice             = 5
            user_cancelled                 = 6
            err_spoolerror                 = 7
            err_temseerror                 = 8
            err_btcjob_open_failed         = 9.
        IF sy-subrc EQ 0.
          LOOP AT lt_pdf_output INTO ls_pdf_output.
            TRANSLATE ls_pdf_output USING c_col1.
            CONCATENATE lv_buffer ls_pdf_output INTO lv_buffer.
            CLEAR ls_pdf_output.
          ENDLOOP.
          TRANSLATE lv_buffer USING c_col2.
          DO.
            ls_mess_att = lv_buffer.
            APPEND ls_mess_att TO lt_mess_att.
            SHIFT lv_buffer LEFT BY c_255 PLACES.
            IF lv_buffer IS INITIAL.
              EXIT.
            ENDIF.
            CLEAR ls_mess_att.
          ENDDO.
        ENDIF.
 *--create reference object
        TRY.
            l_ref_bcs = cl_bcs=>create_persistent( ).
            lv_text = 'Mail Subject' .
            APPEND 'Mail Content' TO lv_data.
            l_ref_document = cl_document_bcs=>create_document(
            i_type = 'RAW'
            i_text = lv_data
            i_subject = lv_text ).
 * *--create document reference
            lv_filesize = lv_size.
            CALL METHOD l_ref_document->add_attachment
              EXPORTING
                i_attachment_type    = 'PDF'
                i_attachment_size    = lv_filesize
                i_attachment_subject = lv_text
                i_att_content_text   = lt_mess_att[].
 *     * set the document
            l_ref_bcs->set_document( l_ref_document ).
 *     * create recipient
 *     *      p_recpnt = sap INBOX user ID to WHICH the ATTACHMENT is SENT.
            l_ref_recipient = cl_sapuser_bcs=>create( p_recpnt ).
 *     *adding recipient in to section
            l_ref_bcs->add_recipient( l_ref_recipient ).
 
 *     * send mail
            CALL METHOD l_ref_bcs->send(
            EXPORTING i_with_error_screen = 'X'
            RECEIVING
            result = lv_sent_to_all ).
            IF lv_sent_to_all = 'X'.
            ENDIF.
          CATCH cx_bcs INTO l_ref_bcs_exception.
            IF l_ref_bcs_exception IS NOT INITIAL.
              CLEAR l_ref_bcs_exception.
            ENDIF.
        ENDTRY.
 
        COMMIT WORK.
 
        endif.
 
   ENDCASE.
 
 ENDFORM.                    "USER_COMMAND

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 11:06:10 GMT

Hiiii,

ok no problem if you use cl_gui_alv_grid method set_table_for_first_display it also contain is_print parameter either you can set it and when you press toolbar button handle function code of button in method handle_user_command (for ex. see - BCALV_GRID_05 ) and call set_table_for_first_display again but with is_print parameter

or you can use REUSE_ALV_GRID_DISPLAY it depends on you .

if you told earlier than i gave my last replay with cl_gui_alv_grid anyways you can try this with my last reply

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Thu, 07 Feb 2013 11:26:07 GMT

Sorry Ashish,

Again same error

Exception condition "NO_FIELDCATALOG_AVAILABLE" raised, i have did exactly what you told, it is not accepting reuse_alv_grid_display without fieldcat.

Regards,

Rithika

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 11:33:16 GMT

Hiiii,

Hiiii have you run my code in separate program ????? Please can you show your code ????

Re: Convert internal table to PDF send mail using oops abap

Aashish28 — Thu, 07 Feb 2013 11:52:55 GMT

Hiiii,

I have checked with cl_gui_alv_grid it is working fine on my system , in debugg mode check your field catalog will be empty when you call this alv again with print on click event . one thing you do

open program - BCALV_GRID_05 make copy ZBCALV_GRID_05 ok and on ok_code BOOKINGS

comment code and write below code

w_print = 'X'.

          CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
          EXPORTING
*           i_callback_program = g_program
            i_structure_name   = 'SFLIGHT'
            is_print           = w_print
          TABLES
            t_outtab           = gt_sflight.

you can see spool will generate and this alv is not overwrite on previous one , than check what mistake you are doing .

after this code you can write send email code also .

Re: Convert internal table to PDF send mail using oops abap

former_member224444 — Fri, 08 Feb 2013 03:37:29 GMT

Ashish, Same error coming for set_table_for_first_display also, it will also not allow without fieldcat.

Re: Convert internal table to PDF send mail using oops abap

surajarafath — Fri, 08 Feb 2013 03:42:17 GMT

This message was moderated.