topic Re: Passing values between 3rd party application? in Application Development and Automation Discussions

Passing values between 3rd party application?

Former Member — Fri, 18 Jan 2013 06:52:42 GMT

Hi all i am thinking of creating a plugin for MS word to connect sap pass>-<and retrieve data from sap.I am new to this .Please share your suggestions and idea on to access sap data from MS word through a plugin.

Re: Passing values between 3rd party application?

vinoth_aruldass — Fri, 18 Jan 2013 07:02:59 GMT

hi,

you have a option called rfc , bapi to access from third party appllications( two way).

google it for help,

hope it helps,

Vinoth

Re: Passing values between 3rd party application?

former_member491621 — Fri, 18 Jan 2013 08:05:57 GMT

Hi,

Maybe you could search for OLE.

Re: Passing values between 3rd party application?

Former Member — Fri, 18 Jan 2013 08:56:31 GMT

Using the OLE we can control the MS Excel and using BAPI's you can control the word document or doc files some web dynpro API properties are there using you can handle the ms word docu and ms excel files .

Regards

Mahesh

Re: Passing values between 3rd party application?

Nawanandana — Fri, 18 Jan 2013 09:08:16 GMT

Hi,

you can export the data in to SAP from excel file. kindly see the sample program given bellow

PARAMETERS

: fupload TYPE ibipparms-path.

CONSTANTS : c_bcol TYPE i VALUE 1,

	c_brow TYPE i VALUE 3,
	c_ecol TYPE i VALUE 52,
	c_erow TYPE i VALUE 65000.

TYPES : BEGIN OF ty_tab,

	cell_0001 TYPE alsmex_tabline-value,
	cell_0002 TYPE alsmex_tabline-value,
	cell_0003 TYPE alsmex_tabline-value,
	cell_0004 TYPE alsmex_tabline-value,
	cell_0005 TYPE alsmex_tabline-value,
	cell_0006 TYPE alsmex_tabline-value,
	cell_0007 TYPE alsmex_tabline-value,
	cell_0008 TYPE alsmex_tabline-value,
	cell_0009 TYPE alsmex_tabline-value,
	cell_0010 TYPE alsmex_tabline-value,
	cell_0011 TYPE alsmex_tabline-value,
	cell_0012 TYPE alsmex_tabline-value,
	cell_0013 TYPE alsmex_tabline-value,

	END OF ty_tab.

DATA : it_tab TYPE STANDARD TABLE OF ty_tab WITH HEADER LINE,

it_upload_data LIKE alsmex_tabline OCCURS 0 WITH HEADER LINE,

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

	EXPORTING
	filename	= fupload
	i_begin_col	= c_bcol
	i_begin_row	= c_brow
	i_end_col	= c_ecol
	i_end_row	= c_erow
	TABLES
	intern	= it_upload_data
	EXCEPTIONS
	inconsistent_parameters = 1
	upload_ole	= 2
	OTHERS	= 3.

IF sy-subrc NE 0.

	MESSAGE i999(zttl) WITH 'Error in uploading the file!'.
	LEAVE LIST-PROCESSING.

ENDIF.

SORT it_upload_data BY row col.

LOOP AT it_upload_data.

	w_col_no = it_upload_data-col.
	CONCATENATE 'WA_TAB-cell_' w_col_no INTO w_field.
	ASSIGN (w_field) TO <fs>.
	IF sy-subrc = 0.
	<fs> = it_upload_data-value.
	ENDIF.
	AT END OF row.
	APPEND wa_tab TO it_tab.
	CLEAR wa_tab.
	ENDAT.

ENDLOOP.

Re: Passing values between 3rd party application?

former_member491621 — Fri, 18 Jan 2013 10:26:05 GMT

Hi Mahesh,

Thanx for your reply!! We can surely control MS Excel using OLE.

But you can also control MS Wrod using OLE.

You might want to check these links

http://wiki.sdn.sap.com/wiki/display/ABAP/Download+Data+into+Word+Document+using+OLE+Automation

http://scn.sap.com/thread/841085

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+-+OLE+Automation+using+MS-Word

Hi X MAstree,

You can refer to these links

Also, see this link

http://scn.sap.com/docs/DOC-31015

The above link is about excel but you could use it as a reference

Re: Passing values between 3rd party application?

Former Member — Fri, 18 Jan 2013 19:46:37 GMT

Thanks all looks interesting i will explore these areas.Untill now what i have understood is like to create a plugin for MS applications

1.>create plugin using VB .net ..etc

2.>Connection to sap server (say on click of button in excel to connect to sap and pass the data without seeing sap screen and get output n display it back )

thanks all...:)

Re: Passing values between 3rd party application?

former_member491621 — Fri, 18 Jan 2013 20:34:32 GMT

Hi X,

You can check these links too

https://scn.sap.com/thread/2090988

http://scn.sap.com/message/10541147#10541147

http://scn.sap.com/docs/DOC-31015

Maybe your requirement will be fulfilled

Re: Passing values between 3rd party application?

Former Member — Mon, 21 Jan 2013 09:52:14 GMT

Thank you for sharing this information

Regards

Mahesh