List of Text tables

[former_member192842]

Hi Experts,

As per the requirement, I need find the list of all Text tables in SAP and based on the list I need to find the whether the text tables has been used in our custom programs(more than 1000 objects are there).

Is there an way to find the list of text tables and also can I use RS_ABAP_SOURCE_SCAN to find the text tables in the custom programs

Regards

Anand

[Former Member]

Hi,

Use this FM  DDUT_TEXTTABLE_GET

Pass the table name and you will get the text table with the relevant field!

[former_member195402]

Hi Anand,

to get a list of tables with language fields as key fields (without structure types) you can use a code like the following:

REPORT  zstest_text_table.

DATA: xt_tables TYPE TABLE OF tabname.

START-OF-SELECTION.

   SELECT DISTINCT l~tabname    FROM  dd02l AS t

                         INNER  JOIN  dd03l AS l

                                  ON  l~tabname = t~tabname

                                INTO  TABLE  xt_tables

   WHERE  t~tabclass              NE  'INTTAB'

   AND    l~keyflag               EQ  'X'

   AND    l~languflag             EQ  'X'.

   BREAK-POINT.

But I think the result is too large to scan ...

Regards,

Klaus

[former_member195402]

Additional if you have an active where-used-list you can read informations directly from tables WBCROSSGT and WBCROSSGTI ...

[former_member192842]

What about the table D010TAB, I passed the text tables(fetched as above) and the list of my programs as input. Will it be sufficient.

Regards

Anand

[former_member195402]

Hi,

if I'm looking in table WBCROSSGT I'll find 172 entries for table E07T in our system, while in table D010TAB 16167 entries can be found for it.

Please check, which one is the right for your issue.

Regards,

Klaus

[nabheetscn]

Hi Anand

You can get list of tables as mentioned by Klaus above. Now to check whether they are used in your list of program you should use RS_ABAP_SOURCE_SCAN only as a where used list if you do on each table it will degarde the performance

Nabheet