Question Re: Attach Invoice document in FB03- Attachment list from Archive link in Enterprise Resource Planning Q&A

Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Fri, 19 Feb 2016 07:48:35 GMT

I am new to GOS. Kindly help me with the following requirement.

I need to develop a code to attach the invoice document in FB03 Attachment list. The invoice document will be present in Archive link. I have archive document id for the invoice from TOA01 table.

I want to using the archive document id, retrieve the PDF stored against the Archive document id and populate it to the attachment list of FB03 screen.

How to link the archive document with GOS?

Re: Attach Invoice document in FB03- Attachment list from Archive link

former_member192467 — Sun, 21 Feb 2016 12:32:19 GMT

This message was moderated.

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Tue, 01 Mar 2016 18:26:11 GMT

Harinay,

If the original document is already stored via ArchiveLink and you want that same document to appear as Business Document in another related transaction, you don't need to retrieve the document at all. Just go to TOAxx table, grab ArchiveID, Document ID, Document type, Document class from existing link and use them in ARCHIV_CONNECTION_INSERT to create another link table entry

In your case FB03 is Accounting document (SAP_OBJECT for posted accounting document is BKPF & Object ID - combination of company code, document number, fiscal year).

Make sure you have OAC3 configured appropriately with BKPF and document type/repository id before you try to insert link table entry using ARCHIV_CONNECTION_INSERT.

Hope it helps.

Cheers,

Sanjeev Gupta

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Wed, 02 Mar 2016 08:15:13 GMT

I have solved it by myself.

Thanks for the suggestions.

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Wed, 02 Mar 2016 11:02:11 GMT

Would you care to share your resolution?

Re: Attach Invoice document in FB03- Attachment list from Archive link

matt — Wed, 02 Mar 2016 11:56:58 GMT

Since you wanted other people to assist you, why don't you return the favour and assist everyone else by sharing your solution?

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Wed, 02 Mar 2016 14:05:28 GMT

Exactly my point Matthew. When it comes to asking question, nobody mind gaining from others knowledge/experience, but then if they find solution (one way or another) they keep it close to their chest.

Re: Attach Invoice document in FB03- Attachment list from Archive link

matt — Wed, 02 Mar 2016 17:00:35 GMT

I've reached out to him - let's hope he does the decent thing.

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Wed, 02 Mar 2016 20:00:29 GMT

Hi All,

First of all Sorry for not replying to your messages. Since my deliverable is time bound, I am unable to view the post then and there.

Coming to the solution, I will definitely share. Since this will help many people. I have searched alot but I found few which could help me in this issue. Also some solutions were not clear. So I will definitely post the one I did with my coding. I want to draft the steps with clear explanations.

Also,my coding is in testing phase. I want to confirm the working so that the solution will be perfectly working.I don't want to give a half baked solution, which will mislead the one who is looking for. I have posted here that I found the solution because, I don't want to waste other's precious time.

Once testing is completed, I will prepare a detailed solution and will post it. I know the value of sharing the knowledge.

Just posting the FM alone will not help. So, I thought of giving the steps to arrive it.

I will post the solution in a day or two.

Thanks .

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Mon, 07 Mar 2016 07:32:41 GMT

Solution :

1. Get the object_id from TOA01 table according to the selection criteria. In my case it is a billing document so, sap_object = VBRK. ( You can filter further according to ar_object according to your requirement.)

2. Use the FM ARCHIVOBJECT_GET_URI to get the URL related to the Object_Id.

CALL FUNCTION 'ARCHIVOBJECT_GET_URI'
       EXPORTING
         objecttype               = 'VBRK'
         object_id                = l_wa_output-object_id " Object Id fetched from TOA01 table
       TABLES
         uri_table                = fp_i_uri_table
       EXCEPTIONS
         error_archiv             = 1
         error_communicationtable = 2
         error_kernel             = 3
         error_http               = 4
         error_dp                 = 5
         OTHERS                   = 6.

3. Create Object Key for BKPF . Object key is combination of <Company Code><FI Docnumber><Fiscal year> Eg. IN0094000000172016 . Object type is BKPF.

4. User below FMto get Folder Id.

CALL FUNCTION 'SO_FOLDER_ROOT_ID_GET'" Gets root id
           EXPORTING
             region    = 'B'
           IMPORTING
             folder_id = l_wa_folder_id
           EXCEPTIONS
             OTHERS    = 1.

5. Append the URL with &KEY&.

6. User FM SO_OBJECT_INSERT to insert the object. and use BINARY_RELATION_CREATE to create the Binary Relation ship.

Code :

READ TABLE fp_i_uri_table INTO l_wa_uri_table INDEX 1.
       IF sy-subrc IS INITIAL.
         l_wa_object-objkey = l_var2." Object key
         l_wa_object-objtype = c_bkpf." Object type
         l_title = l_wa_output-object_id."Attachment description as per your wish
         l_wa_url_id = l_wa_uri_table-uri." Url of the attachment.

         CALL FUNCTION 'SO_FOLDER_ROOT_ID_GET'" Gets root id
           EXPORTING
             region    = 'B'
           IMPORTING
             folder_id = l_wa_folder_id
           EXCEPTIONS
             OTHERS    = 1.
         IF sy-subrc <> 0.
* Exception handler as you wish.
         ENDIF.

         WHILE NOT l_wa_url_id IS INITIAL.
           CONCATENATE '&KEY&' l_wa_url_id INTO l_wa_objcont.
           APPEND l_wa_objcont TO fp_i_objcont.
           SHIFT l_wa_url_id LEFT BY 250 PLACES.
         ENDWHILE.

         l_wa_obj_data-objsns = 'O'.
         l_wa_obj_data-objla = sy-langu.
         l_wa_obj_data-objdes = l_title.

         CALL FUNCTION 'SO_OBJECT_INSERT'
           EXPORTING
             folder_id             = l_wa_folder_id
             object_type           = c_url1
             object_hd_change      = l_wa_obj_data
           IMPORTING
             object_id             = l_wa_obj_id
           TABLES
             objhead               = fp_i_objhead
             objcont               = fp_i_objcont

         IF sy-subrc = 0.
           l_wa_document_id-foltp = l_wa_folder_id-foltp.
           l_wa_document_id-folyr = l_wa_folder_id-folyr.
           l_wa_document_id-folno = l_wa_folder_id-folno.
           l_wa_document_id-doctp = l_wa_obj_id-objtp.
           l_wa_document_id-docyr = l_wa_obj_id-objyr.
           l_wa_document_id-docno = l_wa_obj_id-objno.

         ENDIF.

         IF NOT l_wa_object-objkey IS INITIAL.
           IF NOT l_wa_document_id IS INITIAL.
             CLEAR l_wa_rel_doc.
             l_wa_rel_doc-objkey = l_wa_document_id.
             l_wa_rel_doc-objtype = 'MESSAGE'.

             CALL FUNCTION 'BINARY_RELATION_CREATE'
               EXPORTING
                 obj_rolea    = l_wa_object
                 obj_roleb    = l_wa_rel_doc
                 relationtype = 'URL'
               EXCEPTIONS
                 OTHERS       = 1.
             IF sy-subrc = 0.
               l_ep_url = l_wa_document_id.
             ENDIF.
           ENDIF.
         ELSE.
           l_ep_url = l_wa_document_id.
         ENDIF.
         COMMIT WORK.

Actually this code works fine an it is attaching the url in FB03.

Cons: if you are going to attach for multiple FI document at one go, you need to loop this function. And inside the loop COMMIT WORK has to be given. So it will affect the performance.

If volume is less, you can prefer this method.

I got this solution by debugging the Method CREATE_URL of the class CL_GOS_DOCUMENT_SERVICE. .

In this class, you can find many methods for creating attachment, notes, and deleting the attachments created. This class will be really helpful.

Still searching a way to avoid performance issues for bulk uploading. If I get any, I will post it for sure.

Thanks

Re: Attach Invoice document in FB03- Attachment list from Archive link

Former Member — Tue, 03 Dec 2019 10:30:21 GMT

I know that this post has been almost 4 years old now. Just wanted to know if I can use the same procedure to add attachments to FBL5N.

Re: Attach Invoice document in FB03- Attachment list from Archive link

FredericGirod — Tue, 03 Dec 2019 10:33:30 GMT

best is to create a new question and make a link to this post.

you have to check the key of the object (VBRK) is still valid, check table TOA01 (or sometimes, it is more easy to check GOS SELECT statement used in your transaction)

Re: Attach Invoice document in FB03- Attachment list from Archive link

former_member1359414 — Tue, 07 Sep 2021 12:41:07 GMT

Kindly share the source code which got implemented.