Skip to Content
author's profile photo Former Member
Former Member

Passing values between 3rd party application?

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2013 at 07: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2013 at 08:05 AM

    Hi,

    Maybe you could search for OLE. 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 18, 2013 at 09: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_erowTABLES intern = it_upload_dataEXCEPTIONS 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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2013 at 07: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...:)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.