Read Excel File attachment from Business Workplace Inbox through ABAP program

[Former Member]

Hi,

   I need to read an excel file attachment from Business Work place(SBWP) Inbox and then move the data to internal table .

Below FM's are used for get the data from inbox

SO_FOLDER_READ_API1

SO_DOCUMENT_READ_API1

SO_ATTACHMENT_READ_API1

SCMS_BINARY_TO_XSTRING / SCMS_BINARY_TO_TEXT --> to convert Binary to String.

But i could not get correct Excel data into internal table. I am getting some special character in my internal table.

To find other possibilities to read attachment content i tried this Function module SO_KPRO_OBJECT_READ, it gives url . I dont know how to proceed futher..

How to get data from this url ?

Is there any other way to get SAP inbox attachment data into internal table.

Please help.

Regards,

Sankavi

[Former Member]

You are using the right function modules. check this WIKI

http://wiki.sdn.sap.com/wiki/display/ABAP/Reading+PDF+attachment+from+sap+inbox+through+ABAP

[Former Member]

Hi Malik,

          Thank you.. I have to read Excel file from SBWP transacation.

Function module SO_ATTACHMENT_READ_API1 give the binary data in my internal table. If i convert Binary to string /Binary to text the result is some junk character (####? " * ) in my internal table.

    So i tried to get data from Content server / DB. the table SOFF* are used .

  Am getting some url in SO_KPRO_OBJECT_READ function module. How to get data from content server.

Regards,

Sankavi

[Former Member]

Its not related to workflow workitem.. Its related to Inbox and shared folder attachment .

can we create name for inbox in SBWP tcode

Regards,

Sankavi