topic Re: Reg: Develop an interface system in Application Development and Automation Discussions

Reg: Develop an interface system

Former Member — Fri, 22 May 2009 06:28:01 GMT

Hi every one,

I have a requirement to develop an interface system, based on my requirement; I want to post GL balance for every month end (sap t-code F-02).

My GL balance will come from, external system, itu2019s developed in dot.net, and I have to take this data from this system and need to post in F-02.

Here I found that, BAPI u2018BAPI_ACC_GL_POSTING_POSTu2019 is satisfied my requirement,

Here my question is how to integrate external application with sap.

How to get data, from external system to sap internal table.

Regards,

Sreenu.

Re: Reg: Develop an interface system

Former Member — Fri, 22 May 2009 06:35:42 GMT

Hi,

The data from external system is mainly imported to SAP using XI. And then the ABAP processing starts

Re: Reg: Develop an interface system

Former Member — Fri, 22 May 2009 06:48:01 GMT

Hi Sreenu,

You can think of few techniques and check the feasibility from your point of view too.

In you case you have an external system and a SAP system, you can try out for the following possibilities:

- Use XI to integrate these two systems. Feasible if you have a XI system in the landscape.

- You can otherwise save the GL data to a flat file a server space. This file can be read by writing a report and calling the BAPI to post the GL items, by polling the file at regular interval. This program can be scheduled as per requirement.

Regards,

George

Re: Reg: Develop an interface system

Former Member — Fri, 22 May 2009 09:40:33 GMT

Mr. George biswal

Thanks for your answers.

As per your second comment, flat file concept is suitable for my requirement.

Can you please give me some more details regarding this issue?

1. External GL items are available in XL format, and my admin people are ready for giving authorization to push the file into application server.

2. I have developed program for posting the GL amounts by using the bapi.

3. My requirement is to run this in background; I need to schedule every month end. Here if I use FM u2018ALSM_EXCEL_TO_INTERNAL_TABLEu2019, to get data into my internal table, its giving error.

Please give me some suggestions to solve this issue.

Regards,

Sreenu.

Re: Reg: Develop an interface system

Former Member — Fri, 22 May 2009 09:46:11 GMT

Hi,

Instead of FM ALSM_EXCEL_TO_INTERNAL_TABLEu2019 you can use function module

TEXT_CONVERT_XLS_TO_SAP

Hope it helps

Sample code



TYPE-POOLS: truxs

DATA : it_raw TYPE truxs_t_text_data.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
        EXPORTING
          i_field_seperator    = ' '
          i_line_header        = 'X'
          i_tab_raw_data       = it_raw
          i_filename           = file_excel"Excel file name
        TABLES
          i_tab_converted_data = itab "table of your type
        EXCEPTIONS
          conversion_failed    = 1.

      IF sy-subrc <> 0.
        MESSAGE 'Please select a proper input file' TYPE 'I'.
        EXIT.
      ENDIF.

Re: Reg: Develop an interface system

Former Member — Fri, 22 May 2009 10:13:17 GMT

You can use to get the data from XLS to internal table : BAPI_ACC_GL_POSTING_POST

you have to check all data is correct : BAPI_ACC_GL_POSTING_CHECK

you can post the gl data to sap : BAPI_ACC_GL_POSTING_POST

regards,

Munibabu.K