How attachment files are saved .

Attachments are one of the most important requirements in today’s industries. This is one of the few dependent objects which you will find in all root objects.

The below article will explain the concept how the attachments look like in SAP CRM and how & where they get stored in Database.

 

1. In SAP CRM Web UI, the attachments look like as follow :
   
2. The DB entry for the above opportunity can be extracted from CRMD_ORDERADM_H as follow :
   
3. Put the Guid of the business object in table SKWG_BREL in field INSTID_A and it will give you the LOIO ID as field INSTID_B.
   LOIO ID = L/CRM_L_ORD/504310B435BB1E80E1008000C68D0C06
   
4. LOIO ID is stored in CRMORDERLOIO as follow :
5. From table CRMORDERPHIO we can fetch PHIO ID corresponding to LOIO ID
   LOIO ID – 504310B435BB1E80E1008000C68D0C06
   PHIO ID – 504310B535BB1E80E1008000C68D0C06
6. Other properties of the document get stored in the CRMORDERPHF as follow :
   
7. This is how the entry got stored on FILENET side :