table name from structure

[Former Member]

Dear Experts,

how to find the table name from structure, most of the case when i press f1 and technicalsettings on a particular field, there i will see only structure...,,

Thanks and Regards,

Thirukumaran. R

[GauthamV]

Better use the data element and click the where used list and find out

the appropriate table.

[Former Member]

Hi,

Try using the where used list.

or use tcode se84.

regards,

Santosh

[Former Member]

Hi Thirukumaran,

Mpst of the times it is structure only. In run time they would have declared a TABLE of that structure type and use it. So, from that F1 structure, you cannot find what table it is...because it is not

Best Regards,

Ram.

[Former Member]

Can you explain with some example...

Thanks and Regards,

Thirukumaran. R

[former_member585060]

Hi,

Note the Field name in the structure,

Goto SE11, give table name DD03L

Click on Contents, give the field name

It will give you all the tables and structures used by that field.

Regards

Bala Krishna

[Former Member]

Thanks for you answer,

i'm trying like this i had created table type for the structure and using in my program it doesn't works..

data : it type standard table of zHRPE_PROFA.
data : wa like line of it.
SELECT * from ZHRPE_PROFA into TABLE it.
  loop at it into wa.
    wa-PLVAR.
    endloop.

[SuhaSaha]

Hello Thirukumaran,

What is the error you are getting? Just FYI to can extract data from DB Tables/ Views and not from table types.

BR,

Suhas

PS: Is ZHRPE_PROFA a transperant table or a table type?

Edited by: Suhas Saha on Jan 2, 2009 8:05 AM

[Former Member]

Hi it is table type...

[SuhaSaha]

Hello Thiru,

YOU CANNOT EXTRACT DATA FROM A TABLE TYPE

You need to create a transperant table for this.

BR,

Suhas

[Former Member]

enter the structure name r table type name in se11....

if table type then in that one line type will be assigned ,double click on that it will take u structure....

there select the field that u want and goto their data element...place the cursor on data element and press where used list....

u will get an pop up there select the checkbox table fields alone and press the pushbutton(INDIRECT APPLICATION)....again u will be get another popup there double click on database table....

here it will list out only tables ......from list select the correct table that is related to ur requirement...

[Former Member]

Hi

keep the cursor on the structure name and use where used list and select 'table' from the check box.

reg

Ramya

[Former Member]

Hi,

Use where usedlist to find table or any thing where the field is used

OR

Goto se15 in data dictionary >table fields>double click

enter ur field name and execute

it wil give all fileds in diff tables

it is Helpful

[Former Member]

Use SQL trace for finding it.

Activate trace in ST05 and run the transaction to create or change the entry. then go ST05 again, press 'deactivate trace' and display trace. it will show the list of tables and values which u updated.

tis is one way of finding it.

regards,

Pavan

[former_member222860]

Hi,

Place the structure in Se11, and click on 'where used list' icon for ur field, it will display the tables related to that field

thanks\

Mahesh

[Former Member]

use the data element and click the where used list and there u will get a pop up window in that select table fields and click the push button (indirect application) ..there u will get another pop-up there click on database table alone...there u can find the fields that are used in transparent table alone..