SQL remote query and data-dictionary

[Former Member]

Hi,

We are considering the implementation of SAP Business One 2005. I've installed a demo version but in order for it to continue to support some business functions I need to perform a number of SQL queries against the data. Unfortunately I'm having difficulties in getting the answer from our reseller.

Does anyone know the answers to the following question. I'd very much appreciate some help.

1) Is there a data-dictionary document showing which tables perform which roles and the associated joins/associations.

2) Is it 'advised' to open the SAP datasource directly to perform a SELECT query to obtain the results or should a third-party tool be used?

3) Do I need the SDK if I want to perform direct SELECT queries or if I want to automate posting invoices to SAP? We have competent programmers in the company - I believe they use VB6 and VB.net.

4) Is there an example if I simply wanted to query all suppliers within SAP? (e.g. SELECT NAME FROM Supplier_tbl...etc..etc)

Any help would be very much appreciated - it's a huge application and I'm struggling a little.

Many thanks,

Gavin Russell.

[Eneveux]

Gavin,

The forum that you have posted your questions in is or questions related to the SAP Business One Integration for SAP NetWeaver. Your questions seem to be along the line of general data access to SAP Business One. You should typically post those types of questions in the SAP Business One Discussion Forum or the SAP Business One SDK Discussion Forum.

As to your questions ...

1. The definition of the SAP Business One table schema is part of the SAP Business One SDK Help Center documentation. You simply need to install the SAP Business One SDK Help and you will have it. There is not a "data dictionary" other than this documentation.

2. Typically any direct access to SAP Business One data using SQL is discouraged as if data corruption occurs as a result of it, the environment would not then be supported by SAP.

3. If you want to push data into SAP Business One, as stated, direct access to the Business One database is forbidden. You would use the SAP Business One SDK for this.

4. You can use the SAP Business One Query Manager/Wizard in the SAP Business One product which in essence is performing SQL type SELECTS for data on Business One tables.

HTH,

Eddy