Sorry i answered too quickly
So BSEG is a cluster/pool table
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;
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
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.
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.