Can we call a bex query from result of another bex query?

[former_member210005]

we have a requirement wherein client has asked us for bex reports

in a BEX report

multiple queries needs to be executed and the querues are dependent on their parent query

i.e.

result of query 1 works as input for query 2 and result of query 2 works as input for query 3..

is it possible??

kindly help.

[KodandaPani_KV · Accepted solution]

Hi,

can you try with the report to report interphase- (RRI).

plese find the below doc it will help.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/607e63d5-b56f-2c10-718f-8e33a08ba...

Thanks,

Phani.

[former_member183012]

Hi Varun,

You will find lot of information on Google search with " RRI SAP BI"document shared by pani shows step by step method for report to report interface. Try this.

Regards,

Ganesh Bothe

[former_member210005]

Thanks to both of you for your help and prompt support.

thanks a lot.

[former_member194898]

Hi,

(If RRI is not exactly what you need)

Eg. for a scenario where we want to display all positions of documents where at least one position in a document fits given cretaria. You can try it using query/prequery construction.

In short:

Create two querries:

In the first query you set the criteria (the output will be a list of document nos that fits that criteria). For peformance reasons keep this query small.

In the second query give restriction on document number (replacement path with the first query as a parameter).

Regards, Leszek