Description

Customer has a need to extract data from SAP using Query, but the data is not contained in a table. It is contained in a Structure.

Applies To

10.x, 11.x, 12.x

Cause

Unfortunately since they are structures and not tables they cannot be queried even in SAP; this is by design. Structures are made up of many fields which can be used in a vast array of tables. Therefore you cannot see the data contained in a structure using any of the transaction codes. These are values which are available only during run-time and cannot be accessed in database tables.

Solution

You would need to locate these fields, for example in other tables where they are being used, and query that table which would take some investigating on your end through SAP. You SAP or ABAP team could help you in this search as well. You can possibly try to use transaction SE15 to see if there are some additional tables which can be joined as part of the query.