topic Re: Finding structure types with certain attribute types (more than one) in Application Development and Automation Discussions

Finding structure types with certain attribute types (more than one)

monika_eggers — Mon, 17 Jul 2017 18:41:39 GMT

Is there a way to search for structure types that use two or more simple data types, e.g. all structures that contain an attribute of type BCA_DTE_BPARE and an attribute of type BCA_DTE_ACEXT? I couldn't find a way in se11 or se80.

Re: Finding structure types with certain attribute types (more than one)

former_member235395 — Mon, 17 Jul 2017 20:02:40 GMT

Hi Monika,

Find your fields or data elements checking tables that begin with DD* in SE11 --> Database Table.

I.E. In DD03L put EBELN in FIELDNAME and got all tables that use EBELN field.

Regards,

Re: Finding structure types with certain attribute types (more than one)

matt — Tue, 18 Jul 2017 04:53:15 GMT

She wants by TYPE not by NAME.

Re: Finding structure types with certain attribute types (more than one)

matt — Tue, 18 Jul 2017 04:59:50 GMT

There is no built in functionality that allows you to find which structures hold which common sets of data elements. A few possibilities spring to mind that might help.

1. Use DD03L to search for structures that contain either of your desired data elements, using field ROLLNAME. Any structure that appears twice will have two entries in the results.

2. Do a where-used on each data element. Download the results and merge into one in, e.g. Excel

3. Identify the table which where-used uses . Query that directly.

You could of course write a small program to do any of these..

Re: Finding structure types with certain attribute types (more than one)

monika_eggers — Tue, 18 Jul 2017 12:58:05 GMT

That option 1 works really well. After sorting by the first column one can easily spot the duplicate results because the second occurrence will be shown as empty. (Just sometimes one is tricked by one of the types occurring twice in the same structure, as it is typical for the LOW and HIGH field in range structures.)