Sending Mail As Excel Attachment

834 Views

Dear ALL,

I have a requirement to send the output of ALV as excel attachment when the user clicks the button. I have written the complete code and the mail is also successfully send. But the issue is that all the ALV output is coming in 1 Column in excel attachement.

I have already searched in SDN and tried all the related posts. But could not succeed.

Here is my sample code which I have used for separating the contents:-

Here W_BELNR etc contains the Heading Used for Column.

CONCATENATE W_BELNR W_BUDAT W_BLDAT W_VBELN W_BLART W_BI_DESC W_UMSKZ W_WEVWV

W_DRAMT W_CRAMT W_CUMAMT W_ZUONR W_WRBTR W_WAERS W_AUGBL W_FLAG W_PRCTR

W_XBLNR W_SGTXT W_ZTERM W_ZTERMT W_VKAUS W_VKAUST W_BAANR

INTO W_LONGTEXT SEPARATED BY CON_TAB.

IT_OBJBIN = W_LONGTEXT.

APPEND IT_OBJBIN. CLEAR IT_OBJBIN.

LOOP AT ITAB_BSAD_TRN_NEW4 INTO W_ITAB_BSAD_TRN_NEW4.

DRAMT_NEW = W_ITAB_BSAD_TRN_NEW4-DRAMT.

CRAMT_NEW = W_ITAB_BSAD_TRN_NEW4-CRAMT.

CUMAMT_NEW = W_ITAB_BSAD_TRN_NEW4-CUMAMT.

WRBTR_NEW = W_ITAB_BSAD_TRN_NEW4-WRBTR.

CONCATENATE W_ITAB_BSAD_TRN_NEW4-BELNR W_ITAB_BSAD_TRN_NEW4-BUDAT

W_ITAB_BSAD_TRN_NEW4-BLDAT W_ITAB_BSAD_TRN_NEW4-VBELN

W_ITAB_BSAD_TRN_NEW4-BLART W_ITAB_BSAD_TRN_NEW4-BI_DESC

W_ITAB_BSAD_TRN_NEW4-UMSKZ W_ITAB_BSAD_TRN_NEW4-WEVWV

DRAMT_NEW

CRAMT_NEW

CUMAMT_NEW

W_ITAB_BSAD_TRN_NEW4-ZUONR

WRBTR_NEW

W_ITAB_BSAD_TRN_NEW4-WAERS

W_ITAB_BSAD_TRN_NEW4-AUGBL W_ITAB_BSAD_TRN_NEW4-FLAG

W_ITAB_BSAD_TRN_NEW4-PRCTR W_ITAB_BSAD_TRN_NEW4-XBLNR

W_ITAB_BSAD_TRN_NEW4-SGTXT W_ITAB_BSAD_TRN_NEW4-ZTERM

W_ITAB_BSAD_TRN_NEW4-ZTERMT W_ITAB_BSAD_TRN_NEW4-VKAUS

W_ITAB_BSAD_TRN_NEW4-VKAUST W_ITAB_BSAD_TRN_NEW4-BAANR

INTO I_DLOAD-DLOAD

SEPARATED BY CON_TAB.

IT_OBJBIN = I_DLOAD-DLOAD.

APPEND IT_OBJBIN. CLEAR IT_OBJBIN.

ENDLOOP.

CALL FUNCTION 'SO_RAW_TO_RTF'

TABLES

OBJCONT_OLD = IT_OBJBIN

OBJCONT_NEW = IT_OBJBIN.

Kindly guide me in this matter.

Thanks & Regards,

Bharti Jain

Edited by: Bharti Jain on Aug 25, 2011 7:23 AM