topic Re: problem in table cluster in Application Development and Automation Discussions

problem in table cluster

Former Member — Mon, 31 Dec 2012 10:50:17 GMT

Hi Abap ers,

vblog is a table cluster. i want to find the name of cluster table in vblog. any ways to find the name of pool and cluster table???

Thanks

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 12:03:08 GMT

Hi Sabyaschi,

Q1 : cluster table in vblog ?

Use where used list for the cluster.

Q 2 : find the name of pool and cluster table ?

i) Go to SE11

ii) Enter table name 'DD02L' and click on Display.

iii) Pass field Tabclass =

'TRANSP'	Transparent table
'INTTAB'	Structure
'CLUSTER'	Cluster table
'POOL'	Pooled table
'VIEW'	General view structure
'APPEND'	Append structure

Regard's

Smruti

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 12:18:52 GMT

Hi smruti,

according to you, can i find out cluster table name in vblog (Table cluster). that means this the way to find out cluster table name in table cluster??? will it work properly in VBLOG???

Regards

Sabyasachi

Re: problem in table cluster

gouravkumar64 — Mon, 31 Dec 2012 12:27:03 GMT

Hi SMRUTI,

u r right,but r u sure that ur reply will work in this case?

I am also trying to finding out the answer...

It is not working.

Thanks

Gourav.

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 12:37:53 GMT

DD02L- TABCLASS = 'CLUSTER' finding "Cluster Table"

DD06L-SQLCLASS = 'CLUSTER' finding "Table cluster"

Example: KONV is a Cluster Table u can Check in DD02L where TABCLASS EQ 'CLUSTER'

also check in SE11 -->KONV -->delivery and maintenance tab -->

double click on "Pool/cluster" field ---> you find "Table cluster" i.e KOCLU

Now you check in DD06L table -->SQLCLASS = 'CLUSTER' , here you find Table Cluster Name , as per my example "KOCLU" Table Cluster of "KONV" (Cluster table)

Regard's

Smruti

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 12:47:44 GMT

Hi smruti, i only ask in case of VBLOG?????

Re: problem in table cluster

gouravkumar64 — Mon, 31 Dec 2012 12:49:47 GMT

Hi SMRUTI,

One thread i read also

http://scn.sap.com/thread/1825848

for the DD02L & other information ..

but DD06L. it is not helpful.

Here is the screen shot

Do u have any other reply ?

Thanks

Gourav.

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 13:14:32 GMT

Hi smruti,

hope you understand my question.....its already known to me that how to findout pool and cluster table...but in case of VBLOG, am unable to find out the name of cluster table... any idea??????

regards

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 13:32:33 GMT

Hi ,

Kindly check dd02l with the following parameters.

DD02L-MULTIPLEX = 'M'.

Also Chek the Package STSK.

Regards,

Amit

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 14:03:45 GMT

Hi Amit,

yesss i check it...this is for multiplex table like vbhdr, vbmod, vbdata...but my question was how to find cluster table name in vblog????

Regards

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 14:13:49 GMT

Hi,

Well you just named them (vbhdr, vbmod, vbdata,...) so ?

You can find them by going to the package STSK as Amit suggested...

What is your issue exactly?

Kr,

Manu.

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 14:29:36 GMT

Hi,

i want to know the cluster tables name in VBLOG(Table cluster)??? how to find out the name of cluster tables in vblog???

Hope you understand my question...

Regards

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 15:05:21 GMT

Hi,

The tables within cluster VBLOG in a standard system are VBHDR, VBMOD and VBDATA. However, in order to avoid issues of memory allocation for one cluster record, those tables are set as transparent tables on most systems... In this case VBLOG will remain empty and and becomes useless.

Kr,

Manu.

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 15:16:59 GMT

Hi Sabyasachi ,

I cant find any other way than to look for the table in the same Package.

Regards,

Amit

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 16:05:01 GMT

Hi amit,

BSEG is a cluster table it placed in RFBLG (Table cluster).package name is FBAS. if we see in this package then many tables are present...... it does not mean that all tables in FBAS package are cluster tables of RFBLG. my question is how to find cluster tables in vblog table cluster.

Regards

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 16:24:43 GMT

Hi manu,

How can you tell that vbhdr, vbdata, vbmod(only 3 tables ) are in table cluster vblog. how to find out this??

Regards

Sabyasachi

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 16:53:47 GMT

Hi Sabyasachi,

Please refer this

http://scn.sap.com/message/8546528#8546528

Just came across.

Regards,

Amit

Re: problem in table cluster

Former Member — Mon, 31 Dec 2012 18:54:02 GMT

Hi amit,

thank you........but in case of vblog its not so easy to find the cluster table name.........

Regards

Sabyasachi

Re: problem in table cluster

Former Member — Tue, 01 Jan 2013 05:16:49 GMT

Hi Gourav,

If you have better solution Please ....Suggest to Sabyasachi ...., i think he is looking for that Only...

Regard's

Smruti

Re: problem in table cluster

Former Member — Tue, 01 Jan 2013 08:40:57 GMT

Hi Sabyasachi,

The table VBLOG that you have chosen is a SQL TABLE.

You'll Not find any information of the internal tables contained in it.

Please refer the below screen shot of the SQL TABLE DD16S.

Secondly , to find the tables of the cluster for eg BSEG.

We'll follow the below approach .

Kindly Refer the screen shots.

Goto Cluster table eg BSEG->Delivery and maint.-> take the name of Pool/Cluster.

Pass this Pool/Cluster in DD02l-SQLTAB You'll get all the table involved.

Here in case of BSEG DD02l-SQLTAB = RFBLG.

Hope this answers your question.

Regards,

Amit