problem in table cluster

[Former Member]

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

[Former Member]

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

[Former Member]

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

[gouravkumar64]

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.

[Former Member]

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

[Former Member]

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

[gouravkumar64]

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.

[Former Member]

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

[Former Member]

Hi ,

Kindly check dd02l with the following parameters.

DD02L-MULTIPLEX = 'M'.

Also Chek the Package STSK.

Regards,

Amit

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi  Sabyasachi ,

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

Regards,

Amit

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Sabyasachi,

Please refer this

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

Just came across.

Regards,

Amit

[Former Member]

Hi amit,

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

Regards

Sabyasachi

[Former Member]

Hi Gourav,

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

Regard's

Smruti

[Former Member]

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

[Former Member]

Hi Amit,

          DD02L , DD16S has a field named SQLTAB. if i put table pool or table cluster name in SQLTAB field then i can get corresponding pooled or cluter table. You also provide this with a screen shot.

          if i know the table pool or table cluster then using where-used list i can find the pooled or cluster table.....

        but in case of VBLOG(Table cluster) its not possible to find out the cluster table name using above 2 processes....

according to SAP, there are more than one cluster table in r/3 system for one table (Table cluster) in database. So, VBLOG consists of some cluster table....Someone post that vbhdr, vbmod, vbdata are the cluster table of VBlog. 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.

So, i can say that Vblog is a table cluster but it has no cluster tables in R/3 system...hope i am right...but according to definition of Table cluster its not possible.....its wrong...Hope you and others Abapers understand my point.....  any idea about this?

Regards

Sabyasachi

[Former Member]

Hi Sabyasachi,

DD16s contains the table prersent in SQL not R/3 tables.

The entries in DD16s are Fields of SQL tables assigned to specific table types.

Here in your case VBLOG is not a R/3 Table ita an SQL TABLE, and we cannot see the SQL Details on the SAP Side.

Its showing here in SE11 because its assigned to a table type.

All the entries of DD16S are SQL TABLES i.e not visible in R/3.

Kindly contact a BASIS Guy in Order to know more about the SQL Table and their visibility on R/3 Side.

Please let us know if that answers your question.

Regards,

Amit

[Former Member]

Hi Amit,

       Thank you for your reply...... DD16S has 'sql tab' field.... if you see its description then there is mentioned that 'Name of Pool/Cluster in the Database'..... according to you vblog is not a R/3 Table ita an SQL TABLE, and we cannot see the SQL Details on the SAP Side. then RFBLG(Table cluster) , KAPOL(Table pool) are also SQL table?????????????? according to you all table pool and table cluster are SQL table not R/3 table...you also mention that All the entries of DD16S are SQL TABLES i.e not visible in R/3. VBLOG is a SQLTABLE..according to you we can not see in R/3. but in case of RFBLG and KAPOL, we can see details from R/3 side..... why??? and according to your logic RFBLG AND KAPOL also  go sqltab field of dd02l or dd16s table...and press f1 help and read the document. actually SQLTAB field contains the name of corresponding table pool or table cluster for pooled and cluster table.

Table pools and table clusters are tables in the database in which several tables are collected.

Regards

Sabyasachi

[Former Member]

Hi,

As per its definition suggest,

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

R3 environment does not support readable view of clustering.

Clustering concept is totally different then transparent table.

where transparent table contain exact name in R3 environment same as stores in database name.

while clustering does not.

you should refer couple of function modules for cluster operation (that is your current question / and productive).

(FYI :

Cluster table scattered in your physical database so accessing in that way is also not useful / not result orienter / HIghly risky...)

Rest is upon you, the way you go.

good luck !

Avirat

[Former Member]

Hi Avirat,

  RFBLG is a table cluster in database. we can find out the name of all cluster tables (bsec, bsed, bseg, bses, bset, bsseg)....my query is how can i find the name of all cluster tables in VBLOG table cluster????

regards

Sabyasachi

[Former Member]

Hello Sabyaschi,

What would you do with the info?. VBLOG is a table that is written whenever you want changes to happen in an Update task and the entries are deleted once the update is completed successfully.

All changes in a transaction, which are updated using the 'IN UPDATE TASK' addition or a Persistent object with update mode as OSCON_DMODE_UPDATE_TASK or a Synchronous update task will write data to this table.

Now , I am really interested to know why you would need this info, First of all almost all of your SAP tables ( VBAK,VBAP..) are updated using Update tasks .  The parameter data,the header and all other entries that pertain to a transaction ( Update Task)   are  written into VBLOG at some point in a program and are deleted once the Update Task ( SAVE ) is successfully completed. Once the Update task is started, the header and the actual parameter values for the Updates modules are read from the VBLOG cluster.

http://help.sap.com/abapdocu_70/en/ABAPCALL_FUNCTION_UPDATE.htm - Explains briefly on how and when the VBLOG table gets updated and deleted, and with what data.

Only the errored out Update's would remain in VBLOG.If you need to know the errored out one's you can use T code SM13 to see them.

To give you an answer on what are the tables in the cluster, as Manu had already pointed it out ,  it would be VBDATA,VBMOD,VBHDR and VBERROR. To know more on how these tables work and if you wonder how they belong to the cluster, have a look at the link below.

http://help.sap.com/saphelp_nw04/helpdata/en/e5/de86e135cd11d3acb00000e83539c3/frameset.htm

Note that all these tables have the same key VBKEY, and hence the cluster serves as a single container , to retrieve all info related to a transaction which is scattered across these tables.

I hope this helps

Thanks,

Venkat.

[Former Member]

Hi Venkat,

     i like your answer......its my query.....why we cant find out cluster table name in case of vblog??? but another case, we find out the cluster table name using dd02l table or where-used list......but in case of vblog its not possible...... why? manu already told that vbhdr vbmod vbdata vberror are the associate table.....but he dont provide any documentation on it.........but you provide some documentation.....thanks.

regards

Sabyasachi

[Former Member]

Hi Sabyasachi.

The example(VBLOG) that you are trying to explore is an exception. Most of the update task programming is outside of ABAP and controlled by Kernel modules. There is a good possibility, again I am not sure, that the table VBLOG is used by one of the Kernel programs and hence you could not find it related to any ABAP dictionary object such as a Table or an ABAP program.

Thanks,

Venkat.

[Former Member]

Hi Venkat,

                 but in SE11 tcode we find VBLOG table cluster..........

Regards

Sabyasachi

[Former Member]

Hi Sabyasachi,

Yes, you could find it, but a where used returns nothing. Thats why I had mentioned, the update's to the table are not controlled within the ABAP programming environment and might be controlled by Kernel modules.

Thanks,

Venkat.

[raymond_giuseppi]

Just for information (ref : DB Reconnect to the Same Database Instance)

The update queue is implemented as a cluster table (that is, VBLOG) in SAP Release 2.x, and as three transparent tables (that is, VBHDR, VBMOD and VBDATA) in SAP Release 3.x and 4.x.

Please let vblog rest in peace, if your release it at least 3.x of course.

Regards,

Raymond

[SuhaSaha]

My apologies for being the additional cook to spoil the broth .

But as per the lastest ABAP Documentation (Release 731): 

The actual execution is triggered by the statement COMMIT WORK. The formal parameters of the function module receive the values of the actual parameters from the database table VBLOG.

Refer.: http://help.sap.com/abapdocu_731/en/abapcall_function_update.htm

Please let vblog rest in peace, if your release it at least 3.x of course.

Imho SAP has somehow managed to confuse us royally.

BR,

Suhas

[raymond_giuseppi]

No problem, not too many cooks here Could it be that also at SAP, a "certain part" of the documentation is not up to date ...

Nevertheless, I checked VBLOG on my systems (from an awaken legacy 46c to Ecc6 ehp4) and no data in VBLOG even in quality assurance servers (where some errors are found in SM13) and no records in VBLOG, but records in VBDATA, VBHDR, VBMOD and VBERROR which are transparent tables.

But I like the text (can be found in my previous link)

We use the term VBLOG in the reminder of this section for either implementation of the update queue.

Let's say that VBLOG is now a concept and not a table

Regards,

Raymond

[Former Member]

thanks you Suhas saha..........

Regards

Sabyasachi

[Former Member]

thank you raymond   and atlast i am thinking thts really a confusing question......

Regards

Sabyasachi