Finding Table Name from Structure Name

[Former Member]

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

[former_member188829]

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

[Former Member]

Hi Bhavin,

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

Step:

1. Go to SE11.

2. Enter the Structure Name.

3. Press the <b> " WHERE USED "</b> button.

4. Select "Dictionary Tables.

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

<b>Kindly Reward points if you found the reply helpful</b>.

Cheers,

CHAITANYA.

[Former Member]

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

[uwe_schieferstein]

Hello Bhavin

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

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

Regards,

Uwe