topic Re: Transparent table and cluster table ? in Application Development and Automation Discussions

Transparent table and cluster table ?

yjiang — Wed, 15 Aug 2012 08:30:37 GMT

hi expert,

through my learning, i know the different kind of tables.

For cluster table, it is stored physically in different transparent table parts, although the table can be viewed with se16 the same as transparent table.

i wonder to know how to configure the connections between these trans. tables and the cluster table, or how to see the setup of cluster table BSEG with trans. tables, or any clue on this issue??

thanks a lot!~~

best wishes,

yang

Re: Transparent table and cluster table ?

ThomasZloch — Wed, 15 Aug 2012 08:59:26 GMT

Transparent and cluster tables are two technically different things, different in the way the data is stored inside the underlying database. Please read the available SAP documentation.

So I don't understand what the problem is, what do you mean with "configure the connections" and "setup of cluster table with transparent tables", is there any practical relevance to an issue that you are working on?

Thomas

Re: Transparent table and cluster table ?

SuhaSaha — Wed, 15 Aug 2012 09:19:59 GMT

Hello Yang,

In case of cluster tables e.g., BSEG the data is stored as part of the table cluster i.e., RFBLG in the underlying DB.

If you check the Database Object utility for the table BSEG & cluster RFBLG, you'll see the difference:

BR,

Suhas

Re: Transparent table and cluster table ?

yjiang — Wed, 15 Aug 2012 09:20:36 GMT

thanks thomas.

you are right, and i was mislead by the information on internet.

>>" is there any practical relevance to an issue that you are working on?"

yes, there is. I will start my project on FI part soon after my training, so i am investigating the tables of FI.

i found there are table cluster RFNLG, cluster tables BSEG, BSEC,,,and trans. tables BSID/k/s, BSaD/K/s, and i am try to clear the relations of these tables.

I already knew the relationship between table cluster and cluster table, so questioning for the possible link between cluster table and trans. table.(based on your answer, they are different things, and i need to guarantee the link of both of them in program, but not system auto-adaption)

Re: Transparent table and cluster table ?

former_member544878 — Wed, 15 Aug 2012 09:30:25 GMT

Hi Yang,

It is not possible to join cluster or pool table with Transparent table. Therefore you have to use other tables provided by SAP insetaed of BSEG.

BSEG table contains data which are also present in

(Customer Side)

BSAD-Clear Items

BSID-open Items

(G/L Accounts)

BSAS-Clear Items

BSIS-open Items

(Vendor Side Data)

BSAK - Clear Items

BSIK - Open Items

When a document is cleared, its clearing docuement number AUGBL is maintained in BSAK.

Thanks,

Rehan

Moderator message: do not copy other peoples replies to make them look like your own!

http://scn.sap.com/message/5590577

Message was edited by: Thomas Zloch

Re: Transparent table and cluster table ?

yjiang — Wed, 15 Aug 2012 09:47:35 GMT

that is very impressive, thanks a lot, Rehan.

are you working on FI?

best wishes,

yang