Structure into a Query

[Former Member]

Is it possible to extract data in a structure into a Query instead of a table.

Moreover is it possible to do thsi without coding as i am a functional developer.

Any clarification will be appreciated.

Thank you

[Former Member]

Hi,

Structures are used for the purpose of passing data to the screen, the actual data has been retrieved from underlying table(s). So I'm afraid you won't be able to select from the structures, you will have to trace the data back to the original tables and select it from there.

You'd need to use tools such as ABAP Query or Report Painter to achieve this without coding it yourself.

Regards

Darren

[Former Member]

So is it necessary all the structure fields refer a field in a table ... if yes where should I get the reference table fields

Thank you

[Former Member]

Some may be calculated by the program that populates the structure. One way of tracing the underlying tables is to run the transaction that displays the data, i.e. XD03 to display a customer.

Prior to running the transaction start a trace using transaction ST05. Once you see the data that you want on the screen, go back to the ST05 session, stop & display the trace. You will see a list of all the database tables that have been accessed.

Cheers,

Darren