topic Re: Need to include Structures in SAP Query in Application Development and Automation Discussions

Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 10:51:51 GMT

Hi,

I need to extract data of material master from a 3.1 System, where there is a Structure which contains my required information.

How can i include the fields of the Strucutre into my query?

thanks,

Chintan

Re: Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 13:25:29 GMT

Structures do not contain any data therefore you cannot use them in a query.

The only items you can use in querys are tables and views.

Chris H.

Re: Need to include Structures in SAP Query

Former Member — Wed, 10 Oct 2007 14:34:21 GMT

Hi,

As Christopher mentioned, structures do not contain saved information. You must read the tables for getting the information.

I assume that you´re working with SAP Query (SQ00). If this is so, you need to create or modify an InfoSet (Environment --> Infosets), where you´re gonna declare the necessary table or view.

When that part is done, go back to your query and assign the infoset, so that you can use the fields that you need.