Issue in XLS attachment : FM : SO_DOCUMENT_SEND_API1

[Former Member]

Dear All,

I am facing an issue with sending the XLS attachement by using FM : SO_DOCUMENT_SEND_API1 .

The XLS attachment is triggering successfuly with the mail.

The issue is with the content .

Only Header data is coming in the xl sheet i.e column names.

The row having the data is appearing blank .

Interestingly, the same code is working perfectly fine in the development environment.

But in QA this issue is happening . Is it some BASIS issue or something else.

The same program is working fine in other servers also .

Kindy provide suggestions.

Regards,

Hemant

[Former Member]

Dear All,

I am facing an issue with sending the XLS attachement by using FM : SO_DOCUMENT_SEND_API1 .

The XLS attachment is triggering successfuly with the mail.

The issue is with the content .

Only Header data is coming in the xl sheet i.e column names.

The row having the data is appearing blank .

Interestingly, the same code is working perfectly fine in the development environment.

But in QA this issue is happening . Is it some BASIS issue or something else.

The same program is working fine in other servers also .

Kindy provide suggestions.

Regards,

Hemant

[Former Member]

Hi,

There could be two possibilities

1.Your Internal table which contains item  doesnt contain any data.

2. concatenation  problem  with c_tab or c_ret

ex:

  DATA: c_tab TYPE c VALUE cl_abap_char_utilities=>horizontal_tab,
            c_ret TYPE c VALUE cl_abap_char_utilities=>cr_lf.

    LOOP AT it_po into wa_po.
    CONCATENATE wa_po-cre_dat wa_po-file_nam wa_po-po_no
    INTO objbin_final SEPARATED BY c_tab.
    CONCATENATE c_ret objbin_final INTO objbin_final.
    APPEND objbin_final.
    clear objbin_final.
  ENDLOOP.

[Former Member]

Dear Raghu,

Have used the same logic for filling the data .

Issue is, exactly same code is working on 3 different machines, Dev , QA and PRD .

Only on this particluar instance QA server of a particular landscape this issue is coming.

Even on development its perfectly fine.

Regards,

Hemant

[Former Member]

Dear Jain,

Execute  SCOT tcode quality server may be your mailsl are in waiting status.

Schedule program RSCONN01. in Quality server

[Former Member]

Hi Raghu,

Thats not the case. Mails are not in the waiting status .

Only the Data is not coming .

Anyhow, issue is resolved now .

As seen and suggested in wiki, have used the CLS_BCS class to redesign the code .

SO_DOCUMENT_SEND_API1 has been obsolete since version 6.10 so used the class method approach and it worked.

Somehow issue came only in QA instance of one server,

Good Moral learnt is to try using latest FM, Classes and methods for any task.

Thanks & Regards,

Hemant