Skip to Content
avatar image
Former Member

problem in table cluster

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 02, 2013 at 03:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 01, 2013 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Dec 31, 2012 at 12:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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