topic SAP BDS SOFFICEINTEGRATION in Application Development and Automation Discussions

SAP BDS SOFFICEINTEGRATION

Former Member — Mon, 06 Nov 2006 17:06:02 GMT

I am trying to print the sap variables into word but could not do so. i am using the following code. could you please tell me if i am doing something wrong.

after starting the link server i am passing the SAP variable 'TOPIC' using follwoing method to link server.

CALL METHOD LINK_SERVER->ADD_STRING_ITEM

EXPORTING ITEM_NAME = 'TOPIC' "#EC NOTEXT

ITEM_VALUE = GT_EKKO-EBELN

NO_FLUSH = 'X'

IMPORTING RETCODE = RETCODE.

In word document i am using the follwing links to retrive the variable.

{LINK SAP.OLELinkServer.Item.Object.1 SAPOLELinkServer TOPIC \t}

{LINK SAP.LinkItem.1 SAPOLELinkServer TOPIC \t}

i tried both of the above links but the word documents is not printing the variable and printing the above links as it is.

i would appreciate if someone could provide me any solution on how to achive it.?

Re: SAP BDS SOFFICEINTEGRATION

Former Member — Tue, 07 Nov 2006 16:40:24 GMT

Hello,

I had the same problem while using the link server for document management. Inserting manually the links into the word document had not worked.

Try the method EXECUTE_COPY_LINK_DIALOG as described in note 719219 and copy the links with this method. Maybe you need an variable to start this method only once or you try method COPY_LINK_ITEM_TO_CLIPBOARD.

Regards,

Christian Ebert

Re: SAP BDS SOFFICEINTEGRATION

Former Member — Fri, 10 Nov 2006 21:08:34 GMT

First of all Thank you for answering my question.

i got a 50% solution from what you have suggested. i used the method COPY_LINK_ITEM_TO_CLIPBOARD and copied one of the variables to the clipboard but when i try to do 'paste special' in the word document i could not paste the link as the radiobutton 'Link' is greyed out. would you please tell me if i am doing something wrong? or is there any other way i can create link in word.

Re: SAP BDS SOFFICEINTEGRATION

Former Member — Wed, 15 Nov 2006 13:04:49 GMT

Hello,

i am sorry, but I don't know what's going wrong. Obviously word cannot recognize the paste as a link. As the dialog box for the paste occurs there should be a source as "SAP....", otherwise a source "unknown".

If you like, i can check your ABAP source. Or you check first clipboard at all with FM CLPB_EXPORT and, after that, look if oi works correctly.