01-18-2013 6:52 AM
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.
01-18-2013 7:02 AM
hi,
you have a option called rfc , bapi to access from third party appllications( two way).
google it for help,
hope it helps,
Vinoth
01-18-2013 8:05 AM
01-18-2013 8:56 AM
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
01-18-2013 10:26 AM
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
01-21-2013 9:52 AM
01-18-2013 9:08 AM
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.
01-18-2013 7:46 PM
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...:)
01-18-2013 8:34 PM
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