Problem with Archive Link and User ID

[Former Member]

Dear Experts,

Currently we are attaching documents to business object using archive link feature through T code OAWD.

when user uploaded documents & when we try to search documents with Tr. code OAAD, we are not able to find from whcih User id documents got uploaded.

As per client requirement, we had to find from which user id documents got uploaded as around 10 user id's got authorization of uploading documents against same business object.

Even in individual Tcodes other than tr. code OAAD of business objects where documents are seen, we don't find User Id/Creator name.

any suggestions will be much useful...

Thanks in advance...

[janosdezsi]

Hi Sam,

you might find this also helpful:

http://scn.sap.com/people/juanpablo.barcenas/blog/2011/05/05/archivelink-document-description-in-the...

Best Regards,

Janos

[Former Member]

The standard archivelink tables (TOA*) do not gather this data. If this is a must have requirement then using single step workflow may give you the ability to capture this data within the workflow logs.

To create this scenario you would enable only the storage scenario "storing for subsequent entry" within the document presettings via OAWS. Then when a document was uploaded it would create a "workitem" that is sent to the agent id. Default will be user if no setting was created in OAWS.

The user would then have to go to their SAP workplace inbox to execute the work item and "link" the document to the transaction.

This scenario is sometimes referred to as "early archiving" by old timers like myself.

It is most often used in Accounts Payable scenarios where a central shared scanner is passing out many work items to a larger group.

From TAO* Tables we can use SAP_OBJECT to Identify Invoices with PO by object BUS2081 or invoices without PO by object FIPP. From the field OBJECT_ID we can match a specific invoice number. BUS2081 shows invoice number + fiscal year as the Object id. FIPP shows Company code + invoice number + fiscal year. The ARC_DOC_ID field gives us the unique document identification string for the scanned image. AR_DATE = the date the work item is completed. This is when the invoice document is “parked”.

A selection from table SWWLOGHIST searching for METHOD SWW_WI_STATUS_TO_COMPLETED and METH_EDATE = to AR_DATE from TOA* Table (26.06.2012) and  PARA_VAL_1 = *ARC_DOC_ID* (*aaaakkjdx1ce6yn3e3aacaerb12zi*) will provide output from which you can gather the work item ID.

Select WI_ID then query table SWWWIHEAD for overview status of item.

From table SWWWIHEAD you can gather such information on the work item as the work item creator WI_CREATOR, the work item status WI_STAT, creation date WI_CD,  completion date WI_AED, and work item agent WI_AAGENT.

The WI_CREATOR will be the user who "created the workflow item" for your report.

This a the "long way around" to overcome this lack of data being gathered by ArchiveLink documents.

I hope this late answer is helpful for someone.