Function Modules to Read SAP Workflow Attachments

[Former Member]

We accidentally deleted 'links' to workflow attachments by running SAP Office program RSSODFRE (Delete Documents from Hidden Folder) because we checked the fields "Delete Documents from Hidden Folder" and "Delete unsent Documents". Now, from SWI1 we cannot read the attachments and get the message 'document does not exist'.

However, the workflow is intact with the attachments in a refreshed quality system and I was able to run a trace on selecting both the attached documents.

It gives me all the values for SOOD, SOFM, SOC3, SOFFCONT1 and based on this I was able to locate all the same documents on the tables in our production system - where we ran the RSSODFRE. Why are they still there is a mystery if they're supposed to have been deleted - but right now I'm not complaining!

I have tried a number of function modules to see if I can read the attachments but to no avail.

I tried SO_DOCUMENT_READ_API1, so_object_read, SWL_WI_ATTACHMENTS_READ, etc but to no avial - these were executed in the system where the workflow is still OK - I can't run SE37 in production.

Anybody have any ideas what function modules I can use to read these attachments?

I have SOOD values of FOL 26 000000000004 and EXT 37 000002711545.

SOFM: SELECT WHERE "MANDT"='028' AND "FOLTP"='FOL' AND "FOLYR"='26' AND "FOLNO"='000000000004 ' AND "DOCTP"='RAW' AND "DOCYR"='37'

SOC3: SELECT WHERE "MANDT"='028' AND "RELID"='DT' AND "SRTFD"='RAW37000004498126' AND "SRTF2">=0

SOFFCONT1: SELECT WHERE "RELID"='IR' AND "SRTF2"=0 AND "PHIO_ID"='4FEAB8B34CA447ACE1000000A3F1750B' AND "MANDT"='028'

It looks like the physical document is still in the database and my goal is to retrieve and download them to pc.

I can attach them back to the relevant SAP document or does anyone know how to re-build the link back to the workflow and therefore visible via SWI1.

Sorry for rambling but I'll really appreciate your help.

Thanks.

Soyab

[suresh_subramanian2]

Hello Soyab !

            Try with the following function modules which could be helpful : 

            SAP_WAPI_GET_ATTACHMENTS : Read Attachment for Work Item

            SO_ATTACHMENT_READ : Read an attachment

            SO_WIND_ATTACHMENT : SAPoffice: Display of Existing Attachments and Processing Possibilities

            SO_WIND_ATTACHMENT_DISP_API1 : Display an attachment to an object

            GOS_ATTACHMENT_LIST_POPUP : Display Attachment List                                              

            SWF_SWR_GET_ATTACHMENT : RFC-enabled module for reading attachments

            SWL_WI_ATTACHMENT_DISPLAY :  WLC: Get an attachment

            SAP_WAPI_GET_ATTACHMENTS : Workflow Interfaces: Read Attachment for Work Item

            SO_ATTACHMENT_READ_API1 : SAPoffice: Read attachment using RFC        

            SO_WIND_ATTACHMENT_LIST_API1 : SAPoffice: Attachment list for application objects

Regards,

S.Suresh.

[Former Member]

Hi Suresh,

Thanks - I'll try them out.

Soyab

[Former Member]

Hi Suresh,

I can use FM SO_DOCUMENT_READ_API1 to read the contents of the attachment (in table OBJECT_CONTENT).

I need to store a copy of these attachments to the archive server and need to know which function module to use. Any ideas please?

I know the details required to populate the TOA03 link table for these attachments.

Thanks.

Soyab