While linking Documents via DMS to BW for reporting purposes, the major issue faced by the client is not being able to open all the documents linked to BW line items.
Where there can be many issues with respect to design, data availability and other, one peculiar issue is the registry settings.
Documents relevant to invoices and purchase order were to be displayed when accessed from their relevant invoice or PO numbers respectively. Our solution for displaying customer invoice documents in form of images, mail attachments, pdf, xls and so on, is by using this function module “ALINK_RFC_DOCUMENT_URLS_GET”.
With the above mentioned FM we can open the documents directly or after download, in general all the documents of the type file will be downloaded when link generated by FM opens in browser further we have to open these documents, whereas other types like images open directly in the browser and further you can choose to download them.
We choose the above mentioned FM from BEx query to access the Content repository (Server which holds the documents) via RFC call to display the document in the web browser.
While the issue we faced was not able to open few of the document types, where these documents of the type ‘file’ which goes for download doesn’t open in client’s system. Below are the types,
|DOCUMENT TYPE||REGISTRY EDIT|
Registry edit was the option to match the MIME type of the above mentioned document type and add a system registry in Windows. This option can be done on the Windows 7 and higher versions.
In order to do this setting change, administrator access will be required in the system in which we are making the change. The same is explained below in detail.
REGISTRY SETTING FOR DOCUMENT DISPLAY (MSG files)
Open ‘Start’ -> Run -> Type ‘Regedit’, Registry editor will open.
In Registry editor, drill down to the folder ‘HKEY_CLASSES_ROOT’
From there, further drill down to ‘MIME’ -> ‘Database’ -> ‘Content type’.
Right click on the ‘Content type’ -> choose ‘New’ -> ‘Key’ as shown below,
Then add the value ‘application/vnd.ms-outlook’ for the key.
Then create new string value for above key, as shown below
Name the String value as ‘Extension’,
Then right click the ‘Extension’ and click ‘Modify’,
Add “.msg’ in the value text box and press ‘OK’.
Similarly do the above necessary steps to create additional registry for the below mentioned Document types,
|KEY||STRING VALUE||VALUE DATE|