topic Re: Determine Fields from a Structure in Application Development and Automation Discussions

Determine Fields from a Structure

Former Member — Wed, 04 Nov 2009 18:40:14 GMT

If I pull up the technical information on a field in R/3 and it tells me that the field is in a structure, how can I look at a structure and determine which underlying tables it consists of?

For example, in the Sales Area data of a Customer Master, on the Partner Functions tab, I want to know the source of the field "Number of an SD business partner," which is stored in RF02D-KTONR. However, RF02D is a structure.

How can I determine which tables RF02D consists of?

Re: Determine Fields from a Structure

Former Member — Wed, 04 Nov 2009 20:38:49 GMT

You can go to SE84 and call up your structure and do a where used on the field and it will tell you all the programs it is used in, but finding what actual table is harder. You can repeat the process on the Domain and it will tell you every table that is used which would help.

Re: Determine Fields from a Structure

Former Member — Thu, 05 Nov 2009 05:34:37 GMT

Hi Friend ,

There is no direct way to find screen strcuture fields consist in which database table. because the strcuture are created for screen deising , if you want to see the exactly where the value is stored in the underlying table ,it is sum time striaght forward ,some times quckly your will understand the underlying table,and some time it is tough to Under stand.

But there are so many ways to find the table .

Using Whereuer list of the structure or field or data element.

Using the check table of the field in the structure

using the F4 help of the field we can see the primary storing table.

etc

Regards,