bseg logic

[Former Member]

Dear All,

Since BSEG can not be accessed by native SQL, and I read

that data from BSEG came from BSIS, BSAS, BSIK, BSAK,

BSAD, BSID tables, I would like to know how BSEG is populated

from the said transparent tables.

Any help is greatly appreciated.

Regards,

Rayel

[Former Member]

Dear All,

Since BSEG can not be accessed by native SQL, and I read

that data from BSEG came from BSIS, BSAS, BSIK, BSAK,

BSAD, BSID tables, I would like to know how BSEG is populated

from the said transparent tables.

Any help is greatly appreciated.

Regards,

Rayel

[SuhaSaha]

Hello Rayel,

I read that data from BSEG came from BSIS, BSAS, BSIK, BSAK, BSAD, BSID tables 

Actually its the other way round

Anyways why do you say?

Since BSEG can not be accessed by native SQL

Got any proof?

BR,

Suhas

[Former Member]

Hi Suhas,

BSEG is a cluster table, as I understand it only by ABAP

can you read data because it uses open sql. My requirement

is to extract data from bseg table using an ETL tool.

Regards,

Rayel

[Former Member]

BSEG is a cluster table .It will be populated using the primary keys of the tables in cluster. you need to compare the same to get the resultant data.

[Former Member]

>

> BSEG is a cluster table .It will be populated using the primary keys of the tables in cluster. you need to compare the same  to get the resultant data.

so i guess it will take lots of work. thanks for the info.

Regards,

Rayel

[Former Member]

These tables also include data from BKPF. You should be able to access them using native SQL.

Rob