where will the attachments created in fb02 or fb03 get stored?

[Former Member]

Hi Everybody,

I have a doubt regarding the attachments we create in FB02 / FB03. Where will those attachments get

stored? (in tables or any folder or directory in application server)? I would like to know if there is any table name or transaction code where I can get the information about those attachments.

I searched the forum, but I couldn't find any thread related to this.

Thanks & Regards

Sunny

[Former Member]

Hi

you can view your attachment(s) at anytime by using FB03. Once youu2019ve selected your document, you can use the Services for Object button >> Attachment List to view the attachment list, or from the menu bar, you can click System >> Services for Object, and select the Attachment list button from the little tool bar that pops up (see screenshot).

They are stored in the SAP database as object.

Regards

Raj

[Former Member]

Hi Raj,

Thanks for your reply. But I would like to know the table name where the information

about the attachments get stored (name, link to the document number, etc). In general,

I would like to know if I have been given a list of documents, if they have attachments or not (and if possible I would like to know how to access the contents).

Regards,

Aditya

[Former Member]

Hello,

1. Get bukrs belnr from BKPF

2. Select from toa01 with object = BKPF

object_id like bukrsbelnr%

archive = your_archive id

3.Use FM ARCHIVOBJECT_GET_TABLE

with the infor that you got from toa01

4 You can write the table returned from this FM to the app server

5. Copy the file from the app server to your desktop and read with Windows Pic and Fax viewer.

Regards

Greg Kern

[Former Member]

Hi Greg,

Thanks for your reply. Sorry for the delay. I tried your approach. I couldn't find any entries (attachments I made) in the table TOA01.

I found the following thread when I searched again if there are any other tables, where the information is

maintained.

[;

I used the information in that thread and found out the table SRGBTBREL, which contains the link between

the document and attachments.

But I would like to know where the attachments (contents) get stored? (in database table / or as a file in any server)

Regards,

Aditya

[Former Member]

Hello Sunny,

Sorry but the short answer is that I do not know.

Good luck in your search

Regards

Greg Kern

[GauthamV]

Check these tables.

SOFFCONT1,SRGBTBREL.

The data will be stored in raw format.

[former_member622551]

Do anyone knows how to send in the same email all the attached files of this kind of document?

Thanks.

[Former Member]

Hello

I found this thread and after investigating my self I found that attachment in FB03 were stored in table SOFFPHF.

I did a trace in ST05 (marked all) and created the attachment. Analyzing the trace showed me following: INSERT

INTO

"SOFFPHF"

So when checking SE16 and table SOFFPHF I had a few entries. And when checking the entries I found one entry containg the filename I used as an attachment

Other suggestions from colleagues are that tables SOOD, SOFM, SOFD, SOFFCONT* are involved with the process. But doing the trace showed me SOFFPHF. Hopefully this could be to some use for others

//Pelle

[Former Member]

I see attachment info in SOFFPHF that includes their sizes. How do I relate the info in SOFFPHF back to an actual financial document? It is identified by PHIO_ID, but I cannot figure out where to go to link PHIO_ID to the

[former_member182040]

CALL FUNCTION 'GOS_ATTACHMENT_LIST_POPUP

Example:

st_object0-instid = '1200000060'.
st_object0-typeid = 'LFA1'.
st_object0-catid = 'BO'.
CALL FUNCTION 'GOS_ATTACHMENT_LIST_POPUP'
EXPORTING
is_object = st_object0
ip_mode = 'C'.

Edited by: Krupaji on Jan 22, 2011 7:16 AM

[Former Member]

Every document that is attached to a FB03 document appears on table

SOOD

here you can look by Document Tile (the one from the document you have attached)
Owner name (person who uploaded the file)
Created on (when the document was uploaded)