SQ01

[Former Member]

Hello all.

I want to know how to put a transaction code in SQ01.

I explain :

I created a report with a query SQ01 to have a ALV grid.

I've the sales order number and others data.

I want to go directly to the sales order when I click onto the line of this ALV grid.

I know it's possible because i always made it but I don't remember !

Does somebody can help me ?

Regards.

[Former Member]

Hello all.

I want to know how to put a transaction code in SQ01.

I explain :

I created a report with a query SQ01 to have a ALV grid.

I've the sales order number and others data.

I want to go directly to the sales order when I click onto the line of this ALV grid.

I know it's possible because i always made it but I don't remember !

Does somebody can help me ?

Regards.

[Former Member]

Hi,

While editing your query in SQ01, use the menu path Goto -> Report Assignment. Press F6 or click the insert row button. On the popup that follows, click the "Other report type" button. Choose 'TR' type and then enter your transaction code. Save the settings on the "Assign Reports" popup and you are good to go.

Regards,

Jamie

[Former Member]

Thanks a lot Jamie, It's ok !

[Former Member]

Hi Jamie,

Though this Thread is pretty old by now, but since I am facing a similar problem, thought would seek your advice.

I have to create a TCode for a SQ01 Query created in Standard Area. Since I was not aware of the TCode creation process from within SQ01, I used SE93 to create the TCode. However, when the TCode is executed, the selection screen of the Query is displayed and when I try executing that, it comes back to SAP Easy Access screen.

I found in Debugging mode that the SY-UCOMM value is CRET for my TCode, where as in the code somewhere, there is a check,

IF SY-UCOMM <> 'ONLI'

EXIT.

ENDIF.

This issue does not come up when SAP List Viewer is selected, it comes only when ABAP List is selected in Output format.

When I tried following the steps as you had mentioned, After putting in the name of the TCode, I get an error saying, The TCode does not exist in TSTC, and if I try on an existing TCode, the problem does not go away. Could you please advice.

[Former Member]

Hello Every one,

I am getting issues like in SQ01 query chnages

* Output sequence of lines does not correspond to database structure
  Line 01 (contains fields from table ANLB) cannot appear before
  line 05 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 01 (contains fields from table ANLB) cannot appear before
  line 06 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 02 (contains fields from table ANLCV) cannot appear before
  line 05 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 02 (contains fields from table ANLCV) cannot appear before
  line 06 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 03 (contains fields from table ANLCV) cannot appear before
  line 05 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 03 (contains fields from table ANLCV) cannot appear before
  line 06 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 04 (contains fields from table ANLCV) cannot appear before
  line 05 (contains fields from table ANLAV)

* Output sequence of lines does not correspond to database structure
  Line 04 (contains fields from table ANLCV) cannot appear before
  line 06 (contains fields from table ANLAV)

any one can help me how to rectify this warnings