Skip to Content
author's profile photo Former Member
Former Member

Value from another query

Hi,

One of the fields in a query should be populated from another query. But the selection criteria should be sent from the first query result.

Eg.

InObj1      InObj2       InObj3  InObj4          InObj5
1        01/10/2009      2     04/01/2009         ?

InObj5 should be obtained from the second query based on the selection of InObj3 and InObj4. All are characteristics.

How to achieve this?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 02:04 PM

    Hi,

    one thing that comes to my mind is using virtual characteristics for this.

    This will not allow you to determine "InObj5" as a result of some other query, but it will still allow you to determine the value for InObj5 based on the respective values of InObj3 and InObj4 in an ABAP routine.

    Details can be found here: Documentation in transaction SMOD for enhancement RSR00002 (BI: Virtual Characteristics and Key Figures in Reporting)

    Hope this helps!

    Best regards

    Christian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2009 at 03:04 PM

    Hi PR,

    I can think of Report to Report Interface to acheive your requirement.

    We can also paa the value of IO and jump to another Query,however we cant jump in the same query.

    The jump wil be from One Query to another query and may be u may have to jump from one to another 3 times.

    The steps to create RRI

    1)Goto T code RSBBS

    2)In the Sender Query -give the Query name

    3)Press Create tab which is there on the Right Top

    4)It will as for a list select the Query name in the Bottom

    5)and Press OK.

    6)Come back to the main Screen os RSBBS and Select the Receiver Query and click Assignments.

    7)Make them objects as Delete.

    8)Save and Execute the Query ,Sender Query.

    9)Right Click on the Query ,we will find GOTO Tab ,Drill down further

    we can view the Second Query.

    10)we can view the Second Query through first query

    Check this out

    http://help.sap.com/saphelp_nw04/helpdata/en/99/08629bd3e41d418530c6849df303c9/frameset.htm

    https://forums.sdn.sap.com/click.jspa?searchID=6435760&messageID=3353440

    https://forums.sdn.sap.com/click.jspa?searchID=6435760&messageID=2762562

    https://forums.sdn.sap.com/click.jspa?searchID=6435760&messageID=1846978

    https://forums.sdn.sap.com/click.jspa?searchID=6435760&messageID=180080

    Hope it Helps

    Get bak if u have any issues

    Rgds

    SVU

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2009 at 05:14 PM

    maybe...you can use RRI jumps

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.