topic Re: Structure - Table (Urgent) in Application Development and Automation Discussions

Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 02:34:59 GMT

Hi All,

A structure contains a few fields & this gets populated when we it is called. In SE11 / SE12, i can view this structure. I would like to know, from which table is a particular field being taken from. Is there anyway i can link the field in the structure to the table from which it is being taken? Hope my question is clear, await inputs.

Vivek

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 02:37:35 GMT

Hi Vivek,

There is no other easy way except doing where used list to get the details about the fields in the structure.

Regards,

Atish

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 02:50:11 GMT

Hi Atish,

A where-used list is checking for the Structure, but not the particular field. I am checking for Structure SZA1_D0100, Field AD_SMTPADR. When i select this line & click where-used, it is checking for the entire structure & not this field. Is there anyway i can only check for this particular field?

Vivek

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 03:01:37 GMT

Hi Vivek,

Double click on the data element of the field. It will take you to the data element, now do the where used list and select table-fields.

Regards,

Atish

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 03:03:20 GMT

Hi Vivek,

Table ADR6 is the table for E-mail ID,

Regards,

Atish

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 03:22:15 GMT

Hi Atish,

Thanks for that input. I hope an outer join between LFA1-ERDAT & ADR6-DATE_FROM, will give me all the email id's of Vendors stored in Vendor Master or should i make it an inner join?

Vivek

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 03:34:01 GMT

Hi Vivek,

You can't query using date only. To query ADR6 you need address number and personnel number, first get that based on the vendor number.

I am not sure as what is the link between them.

Post another query on SDN regarding this and someone will definately help you.

Regards,

Atish

Re: Structure - Table (Urgent)

Former Member — Mon, 20 Aug 2007 05:10:49 GMT

Hi Atish,

Managed to solve the problem with your assistance. As mentioned by you, i need to link the address number in both the tables & that gives me the result.

But about the Structure - Table, when I double click on a particular field & do a where-used, it does not give me an option for checking in database tables, I only get [Programs, Screens, Function module interfaces, Classes (definition, implementation), interfaces] as options for selecting.

Vivek