Skip to Content

how to select data from struture

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:46 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 04:59 AM

    Hey Amit,

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

    Regards,

    Atish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:07 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 05:36 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.