how to select data from struture

[Former Member]

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

[Former Member]

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

[Former Member]

Hey Amit,

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

Regards,

Atish

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.