How to Find attachments in SAP documents…..!!!

* To check if the document contains any attachments. *

In many scenario we need to check if the document contains any attachments and I have also explored and found one function module which works for all documents types.

The name of function module is ARCHIV_GET_CONNECTIONS

1. To check if Purchase order contains any attachment.

• Execute Function module ARCHIV_GET_CONNECTIONS in transaction code SE37
• Pass Purchase order number 2454358315 as OBJECT_ID

• Press Execute (F8)
• You can see as shown in below snap shot marked in yellow color count is 1. It means that the document contains an attachment.

·  If you click on CONNECTIONS internal Table It will gives you the details about attached document type here it is word doc in purchase order as shown in below snap shot.

   2.  To check if Purchase Requisition contains any attachment.

• Execute Function module ARCHIV_GET_CONNECTIONS in transaction code SE37
• Pass Purchase Req number 2080014745 as OBJECT_ID

• Press Execute (F8)
• You can see as shown in below snap shot marked in yellow color count is 3. It means that the document contains three attachments.

• If you click on CONNECTIONS internal Table It gives the details about attached document type here it is word doc,xls and PDF in purchase requisition as shown in below snap shot.

If you want to find all the Purchase orders which have attachments then you can use the FM as shown in below snap shot.

Pass EKKO table name as OBJECTTYPE

Execte(F8). It will give all the PO which contains attachment.

In similar way you can pass the table name as OBJECTTYPE to this FM. It will give you that total attached documents.