how to export master data from SAP B1

[former_member557763]

Hi all,

I want to export all the business partner master data, item master data from SAP Business One to Excel

[former_member557763]

answered

[zal_parchem2]

Hello Nagaraju - you can run an SQL on OCRD and OITM to get some of the master data, but there might be other tables to use such as CRD1, ITM1, etc (the list can go on and on)...when you say you want to put all the master data into Excel, there could be quite a few tables involved - I am not sure how much you want to export from your original posting...

To get a list of all tables that are on SAP B1, take this path Tools > Queries > Query Generator. In the upper left hand field enter an asterick "*" and then hit the "Tab" key. Another window will pop up which shows a list of tables on SAP B1. Export the results of that pop up to Excel and then you can sort the spreadsheet by Name or by Description depending upon your needs. You can then see all the other tables which you might consider exporting to Excel with SQL.

Regards - Zal

[former_member312729]

Hi Nagaraju,

You can export directly from the list of business partner into excel.

In Business Partner table enter " * " in code field , it will display the list.

Regards:

Balaji.S

[Former Member]

As expert is saying,

go to Tools->Quires->Query generator

Type OCRD-> give tab and then execute

At the top from left, 6th menu is MS-Excel->Click on that and save excel file in your desired location.

Do similar for OITM

Regards,

RS

[Former Member]

Hi,

You can run a query as easy as

SELECT * FROM OCRD

SELECT * FROM OITM

Then select Export to EXCEL.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I wanted to export all data from all the tables from SAP Business One to excel on the basis of schedule. Means wanted to automatically refresh my exported data into excel. I also wanted to know that is there any ODBC driver for SAP Business One as i have one option to export all the data to excel through PENTAHO or some other ETL tool, so that i will schedule all the export.

Please help me on this as this is URGENT & i am new to this.

Thanks in Advance.