topic Re: table name from structure in Application Development and Automation Discussions

table name from structure

Former Member — Fri, 02 Jan 2009 06:23:12 GMT

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

Re: table name from structure

GauthamV — Fri, 02 Jan 2009 06:24:28 GMT

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

the appropriate table.

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:25:23 GMT

Hi,

Try using the where used list.

or use tcode se84.

regards,

Santosh

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:25:40 GMT

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.

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:25:49 GMT

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

reg

Ramya

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:26:15 GMT

Hi,

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

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

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:28:48 GMT

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

Re: table name from structure

former_member222860 — Fri, 02 Jan 2009 06:29:20 GMT

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

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:30:15 GMT

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..

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:35:00 GMT

Can you explain with some example...

Thanks and Regards,

Thirukumaran. R

Re: table name from structure

former_member585060 — Fri, 02 Jan 2009 06:39:19 GMT

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

Re: table name from structure

Former Member — Fri, 02 Jan 2009 06:54:04 GMT

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.

Re: table name from structure

SuhaSaha — Fri, 02 Jan 2009 07:05:37 GMT

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

Re: table name from structure

Former Member — Fri, 02 Jan 2009 09:00:11 GMT

Hi it is table type...

Re: table name from structure

SuhaSaha — Fri, 02 Jan 2009 09:02:21 GMT

Hello Thiru,

YOU CANNOT EXTRACT DATA FROM A TABLE TYPE

You need to create a transperant table for this.

BR,

Suhas

Re: table name from structure

Former Member — Fri, 02 Jan 2009 09:20:00 GMT

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...