How many Transparent tables..?

[Former Member]

Hi ,

How to get the following details

1. How many transparent tables approx hold by NGN in PRD?

2. What is the size of DBTABLOG table in PRD?

Regards,

Ravi

[Former Member]

Hi All,

Am sorry for the late respond.

How to find the number of transparent tables available in SAP system..?

In my question NGN is the SID of the system.

Regrads,

Ravi.

[former_member185954]

Hello,

I managed to dig up SE11 ABAP program and find this, honestly this was interesting for me too.

To list the different types of tables you have, you need to check this.

Login at the operating system level using ora<sid> as the userid.

And then run the command:

sqlplus "/ as sysdba"

Once you are on sqlplus, this should do the trick.

First find the different types of tables your SAP System can have using the followin sql query.

SQL> select distinct tabclass from sapngn.dd02v;

TABCLASS
--------
APPEND
CLUSTER
INTTAB
POOL
TRANSP
VIEW

6 rows selected.

Once that is done, you now simply count the type of table you want to count by this sql query:

SQL> select count(tabclass) from sapngn.dd02v where tabclass='TRANSP';

COUNT(TABCLASS)
---------------
          77215

SQL>

Hope that helps.

Regards,

Siddhesh

[Former Member]

You'll need to elaborate on the first question.

What is NGN? It isn't a table or logical database in standard SAP.

Michael

[Former Member]

Hi,

My question is how to find the number of transparent tables for the table I mentioned above

Regards,

Ravi.

[Former Member]

Hi,

>My question is how to find the number of transparent tables for the table I mentioned above

Your question is still not clear at all.

There is only one Database native table in one SAP transparent table because this is precisely the definition of the transparent table.

Regards,

Olivier

[former_member185954]

Hey olivier,

Where have you been ??

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

I was far way from SDN : 3 weeks vacation !

Regards,

Olivier

[former_member185954]

good to have you back.

[former_member185954]

Answers,

Question 1) your question is not CLEAR

Question 2) - Use DB02 transaction and click the details button.

Regards,

Siddhesh