topic Re: how to select data from struture in Application Development and Automation Discussions

how to select data from struture

Former Member — Fri, 08 Jun 2007 04:57:41 GMT

hello experts,

here i stuk am in smart forms where i want to populate the data from struture.

here in our comp there is no functional guy so i face bit problem to find a perticuler table but at last i found

a struture from where my problem can be resolve so can u tell me if i want to select data from struture

so how it is possible...

thanks in advance....

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 04:59:32 GMT

Hey Amit,

You can't select data from structure as they don't contain any data.they are just the defination.

Regards,

Atish

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:00:15 GMT

Hi,

You can select from a strcuture..

do one thing..

Go to ST05..Switch on the SQL trace..

Execute the transaction where the structure is used..

Swich off the SQL trace.

List the trace to check for the table that is behind the structure..

Thanks,

Naren

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:00:40 GMT

let us know which all fields you require and the structure you found. We may give you the table name.

Reward points to all useful answers.

Regards,

Atish

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:07:52 GMT

Structure dosent have memory to hold the data, if it wont handle the data then how can u select the data form structure...........

find out the table used that structure......... by using the tcode ST05 (sql trace).

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:29:37 GMT

nareadra gratful and from u..but plz guide me little bit more.....what i have to do in st05..plz..guide..me....what statment i have to write there..

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:32:58 GMT

nareadra gratful and from u..but plz guide me little bit more.....what i have to do in st05..plz..guide..me....what statment i have to write there..

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:36:45 GMT

Hi,

ST05 is the transaction used for tracing the SQL...for the particular time between Swtich on and Switch off..

If it is still difficult for you..

Then use this approach..

Go to the structure in SE12.

Then double click on the data element of the field you are looking for.

Then whereused list of the data element and search in tables..

You might get the tables that is using this data element..

Thanks,

Naren

Re: how to select data from struture

Former Member — Fri, 08 Jun 2007 05:46:56 GMT

Hi,

structures contain data at runtime only.

Go to SE15->select Structures->Enter Structure name->Check All in Additional Selections-> Execute it.

It will show you the corresponding Table for that structure. You can search as feild wise as well.

Reward Marks. Let me know whether you can or not.