2 Replies Latest reply: Jun 13, 2010 3:48 PM by Karl Pover RSS

    SAP connector to SAP Business one

    anils123

      We are using SAP Business One for our financial reporting. We would like to generate some critical financial reports using qlikview. But identifying different tables from SAP database for this reporting is very difficult. There are different modules like AP, AR , Journal entry. That's why we would like to use SAP connector . To use SAP connector do we need any SAP specialists or any end user can connect to SAP business one and start generating the reports. Please suggest

       

      Best Regards,

        • SAP connector to SAP Business one
          Ashfaq Mohammed

          hi

          for installing sap connector no expert is required all steps are mentioned.

          but as sap's data base is parameterised data base you need some expert to tell you what does each data base fields mean.

           

          Thanks and Regards

           

          Ashfaq

          • SAP connector to SAP Business one
            Karl Pover

            The SAP Connector is specifically designed for SAP R/3 and will not work on SAP Business One since the table structure is completely different.

            The secret of the SAP Connector Scriptbuilder template is that its loads the data dictionary tables, so that you can use QlikView to navigate the tables and columns. I have never investigated to see if there is something similar in SAP BO, but I have attached the SAP BO SDK Reference Guide (change the file extension to .chm in order to open the file) which describes all the tables and columns in SAP BO. It is about 5 years old, but since SAP has given up hope on growing the SAP BO market that SAP BO is not going to change very much anymore.

            The financial tables you can start with are:

            OJDT - GL Entry Header
            JDT1 - GL Entry Line
            OACT - GL Accounts
            OITR - GL Reconciliation Header (New in 2007)
            ITR1 - GL Reconciliation Line (New in 2007)

            With those tables you can go a long way.

            Regards.