Not getting the desired result in RRI.....

[Former Member]

Hi,

I have query1 which has material code and batch.

I jump from query1 to query2. query2 has some additional details for a batch.

when I execute query1 I get a material code MAT1 and two batches Batch1 and Batch2.

when I jump from MAT1 to query2 to get additional details of batches , it displays me the details

of these two batches but also another 20 batches for this material dode.

I just want to Jump from query1 to query2 for MAT1 and the BATch1 and Batch2 , I dont want other batches from query2 in my result.

Is there anyway to do this? I have already tried all the basic functions of RRI , but not getting the desired result.

Thanks.

[Former Member · Accepted solution]

Dont jump from MAT1..rather jump from Batch1 or Batch2 This should work.

Thanks...

Shambhu

[Former Member · Accepted solution]

when I try to jump from Batch1 to query2 , it dislplays all the batches and the result remains same.

Is there any other idea / suggestion.

Thanks.

[Former Member · Accepted solution]

Hi,

Change the assignment of the RRI.

Try using the variable/infobject only for batch and mat. rest mark as delete.

Regds,

Shashank

[Former Member · Accepted solution]

Hi Dighe,

Thanks , I have tried that , but its not working.

What is happening that , with every setting system is unable to filter batch .

For each material it selects all the batches in query2 .

If I try to jump from batch1 still it displays all the batches.

If I use only the Batch in the assignment it dispalys all the rows of the query so its evident that there is no filter applied at the batch level , I tried all the combination , single value , P , E , Infoobject etc. But it remains same.

Any guess???

Thanks.

[Former Member]

Batch number used was different in source and target. It has to be same.

[Former Member]

Hi,

While trying to Jump from Query1 to query2, 1st you should have MAT as well as Batch in rows, not as free characteristics. Now you put your pointer in Batch1 or batch2 & try to jump. It will give you details related to only that batch in which your pointer is. Like if you will jump from Batch1 it will show only Batch1 details.

Also make sure that you had msde correct settings in RSBBS.

Sangita