topic SAP connector to BSEG in QlikView

SAP connector to BSEG

lmonincx — Mon, 26 Jan 2026 21:26:37 GMT

Hi, the sap connector is to slow to pull the BSEG table into qlikview, i am now using ole db connection as a workaround on this problem. But I want to download now the BSEG table ( using the script of the connector) but this table is not present through the OLE db connection.

Does anyone experienced the same issue or knows how to pull down the BSEG data?

Any help is welcome.

Kind regards,

Linda Monincx

SAP connector to BSEG

Tue, 08 Dec 2009 05:09:26 GMT

hiLinda

Did you put a clause where in your select ?

regards

serge

SAP connector to BSEG

lmonincx — Fri, 11 Dec 2009 19:12:32 GMT

Hi serge, yes I think we had a where clause in the script, but we have it in the SQL select so putting it on the machine.

Regards,

Linda

Re. :Re: SAP connector to BSEG

Fri, 11 Dec 2009 19:25:55 GMT

Hi Linda

Sorry i answered too quickly

So BSEG is a cluster/pool table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

You can't read pool or cluster table directly on the database with an ODBC or other connection SQL from outside SAP. You have to use a sap connector.Other table, transparent table in SAP, no problem.

and be careful because BSEG may be several million input;

regards

serge

Re. :Re: SAP connector to BSEG

lmonincx — Fri, 11 Dec 2009 20:05:13 GMT

Thanks for the help, I will have a look at the site you provided

Have a nice weekend!

Regards,

Linda

SAP connector to BSEG

Sat, 19 Dec 2009 07:12:33 GMT

Hi,

The comments surrounding Cluster tables and the size of BSEG are correct. I will be upfront and commercial here-- our company makes a tool the Data Liberator that makes all SAP data including data in cluster and pool tables etc. continuously available in a SQL Server 2008 Database. The data is continuously updated in real time and we never call the SAP applicaiton server. It all occurs at the database level. In general we can output (depending on network speed etc.) about 1,000,000 rows of BSEG per minute (that is the full row -- if the number of fields is reduced then the speed increases accordingly.

Bypassing the entire SAP application stack for reporting reduces the load on the R/3 instance and gives you tremendous flexibilty in consuming the data. Typically you would create database views with Liberated data that you would then use as a regular SQL data source for Qlikview or any other tool that you are using. Since all data manipulation is outside of SAP there is no ABAP code nor RFCs, BAPIs or the like.

The real time nature of our software insures that any updates in SAP are availble for your analysis within about 5 seconds of posting in SAP.

We are big fans of in memory analytics and believe that with an adequate supply of data the need to build cubes is substantially reduced.

I hope this information is of use to you. We can be found at www.simplement.us

Regards,

Robert MacLean

SAP connector to BSEG

suniljain — Fri, 09 Jul 2010 17:49:03 GMT

Dear Linda,

BSEG is cluster talbe and cluster table does not have any physical identity and database level. so it is not present in OLE db connection. You can download BSEG table only through SAP Connector.

BESG is non indexed table so select query fetch data slowly. so you can select limited field to improve the extraction speed.

Regards,

Sunil Jain.

Does anyone experienced the same issue or knows how to pull down the BSEG data?

Any help is welcome.

Kind regards,

Linda Monincx

SAP connector to BSEG

lmonincx — Tue, 24 Aug 2010 13:03:48 GMT

Thanks for the info and the tip!

Linda Monincx

SAP connector to BSEG

Anonymous — Wed, 30 Mar 2011 00:53:02 GMT

Hi Everyone,

I am trying to connect BSEG to COSP to pull Plan @ Cost Center Level.

Can any one tell me How I can do this relationship.

SAP connector to BSEG

Wed, 30 Mar 2011 21:23:15 GMT

Hi Vinod,

Start a new thread so that you can get some help.

SAP connector to BSEG

suniljain — Fri, 01 Apr 2011 03:20:04 GMT

There is no direct link betwwen BSEG and COSP . it is like FI -> CO

can you give more details so that I can help you .?.