topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Wed, 03 May 2006 10:17:49 GMT

Hello all.

I created a query with an infoset that i also created wich is based on VAV.

What i would like to know is if its possible to jump from to query result to the document in the selected line. Is there a way to do this or is there a place to code this?

Thank you

Nuno Silva

Re: Query

Former Member — Wed, 03 May 2006 10:54:33 GMT

Hello Nuno,

I a not sure if I have understood ur question but based on what I have understood I believe u are asking if it is possible to jump to display document from the query output? The ans to this is Yes.

Please confirm if my understanding is correct and I will give u the way fwd.

Re: Query

Former Member — Wed, 03 May 2006 10:58:51 GMT

Hello.

Your understanding is correct. I need to jump to display the document from the query output.

Thank you

Nuno Silva

Re: Query

Former Member — Wed, 03 May 2006 11:25:43 GMT

Hello Nuno,

Ok this is how u do it...

Go to Sq01 (query) select the query and goto change mode.Then GOTO->Report assignement. Click insert row, this will throw a popup, click on other report type. select the transaction TR, enter the Tcode. Save and now when u execute the query, u will c a button for Call up report, when u click on this it will take u the the desired transaction.

Re: Query

Former Member — Wed, 03 May 2006 11:33:50 GMT

Hello

Thank you for the answer.

It does call the transaction i need but there is still one problem....it wont insert the document number and it will say the document number does not exist.

How do i make the association.

Thank you

Re: Query

Former Member — Wed, 03 May 2006 12:04:03 GMT

Hello Nuno,

Where are u inserting the document number and which transaction code u r calling?

Re: Query

Former Member — Wed, 03 May 2006 12:31:17 GMT

I am calling transaction VA23.

The document number comes in the query result and i want to open the document in the selected line.

Thank you

Nuno Silva

Re: Query

Former Member — Wed, 03 May 2006 13:30:52 GMT

Hello Nuno,

U use document category also in your query and select only those records from the query where category is B. Then if u hit on the report assignment button during execution u will be able to display the document using VA23.

Re: Query

Former Member — Wed, 03 May 2006 14:43:20 GMT

Hello

It works fine if i call va03 but not for va23.

Actually i need to be able to call both and it would be great to have a way to distinguish wich one thru the document type. I putted both transactions and it gives an option on wich one to call, it works fine for va03 but not for va23.

I am trying an ABAP report but i dont really know how to get the data from the selected line. Any insights on this?

Thank you

Nuno Silva

Re: Query

Former Member — Thu, 04 May 2006 09:50:32 GMT

Hello Nuno,

The only reason why VA23 is not working is if the document selected by you is not a quotation.

If you want to ceate a report, then I would suggest u can copy the query into Z report and use Hide stmt to do the job.

Re: Query

Former Member — Thu, 04 May 2006 10:24:12 GMT

Hello

The document types are Z.

I associated with a report instead of transaction.

In the report i use the function RSTI_SELECTION_IMPORT to read the selected line from the query and from here i use set parameter to set the document number to the corresponding parameter of both trasactions and then use call transaction. Its acttually a quite simple report.

I'm awarding you the points since u did solve my first problem.

Thank you

Nuno Silva