topic Re: abap query in Application Development and Automation Discussions

abap query

Former Member — Mon, 04 Oct 2004 10:47:03 GMT

how to make use of internal table in abap query (sq02) and how to display the fileds from the internal table

Re: abap query

Former Member — Mon, 04 Oct 2004 11:32:22 GMT

I am assuming you have not created a query and you have already created an infoset.

Every query has to be associated with an infoset. In the query, you need to specify, which fields will be used as selection fields and which fields are to be provided in the output.

This is done through SQ01 transaction.

While creating the query, there is a basic list, in which you specify the list of fields that need to be displayed in the layout.

If I am deviating from the problem you have, let me know.

Subramanian V.

Re: abap query

Former Member — Mon, 04 Oct 2004 13:19:14 GMT

no i have created the query .. but in that while creating functional area i need to retrieve some data into an internal table and i have to display from there ..... consider this scenario

Re: abap query

Former Member — Mon, 04 Oct 2004 14:01:40 GMT

In the definition of your Infoset position your cursor on a node and choose "Node extras". Here you can define additional fields for that level and some code to get the fields populated.

Hope this helps.

John.

Re: abap query

Former Member — Mon, 04 Oct 2004 15:38:01 GMT

The best way to use a internal table in a query.

First, create a Z structure with the fields you need.

Second, define a data in a query from this structure.

Third, fill up the structure with the information you need for each register.

Then, it´s is show in the report as a table.