Utilities: Determine Attachments

this section provides tips and tricks to determine what links exist in your sap system there are 2 main types of links (outside of sap dms dir krpo) archivelink (external repository) gos (sap database) archivelink (external repository) archivelink links are stored in the sap table toa01 however, via transaction oac3 (table toaom), you can specify other link tables at the sap object and archivelink doctype level some customers will have other link tables such as toa02, toa03, or may have copied this table to zoa01 referenced in oac3 one additional table toaat will contain the filename and created by not this table has not always been available in the sap landscape, therefore if you have very old entries in a link table such as toa01 you might not have a corresponding entry in toaat this table is referenced by field arc doc id there are a couple options to determine how many links you have and potentially group these by sap object and/or archivelink doctype manual method enter transaction oac3 (or view table toaom) and determine what link table are potentially being used export each one of those tables to excel using transaction se16 or se17 group by sap object and if desired, ar object (archivelink doctype) the other fields are self explanatory script method enlist your sap basis team to write scripts on the backend agains your database for a sample of sap hana scripts please reach out to your versafile representative docuflow migrator if you have docuflow ecm installed in your sap system you can run the transaction /dflow/migrator to analyze your archivelink attachments abap you can create a small basic abap program in dev and promote to your sap production instance and execute for a sample of sap abap code please reach out to your versafile representative gos (sap database) sap office content (often known as gos content) links and attachment content are stored in three primary tables, two with the binary relationship (ie link) srgbtbrel for business object links and soffphio for the physical content relation, if no external repository is used, the physical content will reside in soffcont1 one additional table sood will contain the filename, size, and storage date for entries linked in srgbtbrel this table is referenced by fields of the composite key objtp, objyr, and objno there are a couple options to determine how many links you have and potentially group these by sap object and/or archivelink doctype manual method export each one of the tables above to excel using transaction se16 or se17 for a count of attachments, srgbtbrel can be used and the sap object column is tyepid a be aware of column reltype that determines if the entry is an attachment or a note for size and storage date, lookup against sood script method enlist your sap basis team to write scripts on the backend agains your database docuflow migrator if you have docuflow ecm installed in your sap system you can run the transaction /dflow/migrator to analyze your archivelink attachments abap you can create a small basic abap program in dev and promote to your sap production instance and execute for a sample of sap abap code please reach out to your versafile representative