topic Re: Finding Table Name from Structure Name in Application Development and Automation Discussions

Finding Table Name from Structure Name

Former Member — Fri, 07 Dec 2007 05:50:24 GMT

Hi All,

Can someone tell me,whats the best/fastest way to find out the Table name where a data gets stored actually,when we know a structure name

Bhavin P Shah

Re: Finding Table Name from Structure Name

former_member188829 — Fri, 07 Dec 2007 05:54:49 GMT

Hi,

Goto Se11,And Select Data Type Radio Button,and Enter Structure Name,And Press On Where Used List Button on Top(Application Toolbar),and Select Only Data Base Table Check Box,and the enter..Then it Shows the all tables..

Message was edited by:

Vishnu Reddy

Re: Finding Table Name from Structure Name

Former Member — Fri, 07 Dec 2007 05:56:55 GMT

Hi Bhavin,

The fastest way would be to use the " WHERE USED " option that you find on the application toolbar.

Step:

1. Go to SE11.

2. Enter the Structure Name.

3. Press the " WHERE USED " button.

4. Select "Dictionary Tables.

After that you should get the list of all the Dictionary Tbales that use your structure.

Kindly Reward points if you found the reply helpful.

Cheers,

CHAITANYA.

Re: Finding Table Name from Structure Name

Former Member — Fri, 07 Dec 2007 06:06:09 GMT

Hi Vishnu/Chetan,

I followed the steps you have specified but it says that this structure was not found.

I will give you an example structure "RQEVA".

Please tell me how to find the table for this?

-Bhavin P Shah

Re: Finding Table Name from Structure Name

uwe_schieferstein — Sun, 09 Dec 2007 21:58:10 GMT

Hello Bhavin

The structure RQEVA is used in user-exit EXIT_SAPMQEVA_010 which uses data from table QAVE.

A similar "linkage" is there if you look at the package QV to which the structure is assigned. The package contains (on ECC 5.0) only 5 tables of wich QAVE and TQ07M may be related to RQEVA as judged from their short descriptions.

Regards,

Uwe