cancel
Showing results for 
Search instead for 
Did you mean: 

Output of One Query is input to other Query??

former_member188325
Active Contributor
0 Kudos

Hi All,

How to make output of one query as input to other Query and what are the points to be takeb care of to do it?

regards,

murali.

Message was edited by: Murali

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hallo

I suppose you can use a varible for Replacement path which is taking the result of one query and passing it to another variable in a second query.

What to take care? you are running two query at the end because when you have a Variable RP, the ssytem first run the first query.

I would say depends how havy (performance side) is your query.

Mike

former_member188325
Active Contributor
0 Kudos

Hi Mike,

thanks for u r reply.Suppose i am creating a variable with replacement path on 0date( in first Query)...and i have specified second Query name.what happens now?can pl explain me?

regards,

murali.

Message was edited by: Murali

Former Member
0 Kudos

Hallo

You got a second query where you also have 0date. Based on the selection on the second query, you get some value for 0date. this values are then passed in background to the first query which will show you the output based on the input date of the first query. You can also have othe variable in the query.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

I hope everything is fine.

Mike

former_member188325
Active Contributor
0 Kudos

Hi Mike,

yes...its clear now.thanks a lot.awarded points.

regards,

murali.