topic Re: Regarding table pool/cluster in Application Development and Automation Discussions

Regarding table pool/cluster

Former Member — Thu, 03 Apr 2008 14:05:38 GMT

Hi,

can you please discribe me the the process by which we can find

how many pool/cluster table is attached to perticuler table pool/cluster.

thanks.

Former Member — Thu, 03 Apr 2008 14:13:39 GMT

hi jony ,

try this

DATA : BEGIN OF IT_TABLES OCCURS 0,

TABNAME LIKE DD02L-TABNAME,

END OF IT_TABLES.

SELECT TABNAME

FROM DD02L

INTO IT_TABLEs

WHERE SQLTAB EQ <CLUSTER/POOL NAME>.

Eg :

SELECT TABNAME

FROM DD02L

INTO IT_TABLEs

WHERE SQLTAB EQ 'AABLG'.

Former Member — Thu, 03 Apr 2008 14:18:16 GMT

Hi,

When you findout a table pool/cluster then click on its name and from the menu bar select where-used list .

A window will appear there select Tables and press Enter

you will find out all pool/cluster tables

your problem is resolved

So do reward points