Skip to Content
avatar image
Former Member

Query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    May 04, 2006 at 09:50 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    May 03, 2006 at 11:25 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    May 03, 2006 at 10:54 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello.

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

      Thank you

      Nuno Silva

  • avatar image
    Former Member
    May 03, 2006 at 12:04 PM

    Hello Nuno,

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    May 03, 2006 at 01:30 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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