GR55 reports - How to include multiple selection of Orders in input screen

[Former Member]

Dear Experts

We r stuck at the simple step in report writer, by which I could select multiple orders in selection screen.

I am using report liabrary 7KOJ and have used a copy of Std report (7KOJ_001) making a Z one.

I have comipled everything in this report with many formule to get the required output.

Now I want to execute thsi report, but I can execute it "only" for one order in selection.

I tried using another set ( same name) making it repeat at selection scren, but it does not work.

Is it possible to use multiple orders as selection criterion in this report library 7KOJ?

Pls guide me if I can use any other liabrary in which I can get

1. Actual line item costs

2. Actual line item Qty

3. Target costs per line item

4. Target Qty per line iem.

I am using this particular liabrary becuase I want to get following coloums in my report with an additional couple of coloumns which I had make some formulae.

1. Actual cost ( At the time of any line item posting in an order)

2. Variance ( target Qty valued at actual costs) - * I know that is something strange when you calculate variances, but this is how the requirement is , to calculate variance)

Pls help. Thanks in advance, as always..

Regards

Dhiraj

[Former Member · Accepted solution]

Please proceed as follows. By the way you were doing the right thing just that you did not create the sets correctly.

1. Create two value variables using transaction code GS11. For example: OR-AUFN and OR-AUF2 and give default value for both as zero. The table to use for both is KKBC and the field name as AUFNR

OR-AUFN - From Order

OR-AUF2 - To Order

2. Create a basic set. For example: OR-S-AUFNR in the basic set, under from value click on variable tab and enter the first variable (OR-AUFN) and then under to value, again click on variable and select the second variable (OR-AUF2) and save.

3. Now change the report in transaction code GR32. Click on General Data Selection and enter the set you've just created above. Make sure no other set for Order exists besides the new one and save your report.

Alternatively, you could also create two value variables for Order Item Number using table KKBC and field POSNR as follows:

7K-POS1 = Item from as description and give default value as 0.

7K-POS2 = Item To as description and give default value as 1000

Next, create a basic set and specify the above two variables. Change your report and include this set under General Data Selection. In this scenario, leave your original order set as well.

That should solve your problem. Refer back for any further clarification. By the way, everything I wrote here was tested fully and is working.

Regards,

Elias

Edited by: Elias Akorli on May 5, 2010 4:03 PM

Edited by: Elias Akorli on May 5, 2010 4:11 PM

[Former Member · Accepted solution]

Dear Elias

Thanks a lot for your reply.It is helping me out...

My issue is littlebit solved on input side...now with these new set, I am able to get 2 fields in Input screen.It also works fine for the given orders

( time being , I just put only 10001 to 10002 to get order results...I am still to run it for a bigger range as it gave me dump 3 times

But any ways thsi is a separate issue.

What I am not able to get is out put now

The orders I input , are comming in different screens for which I have to make a scroll manually from left to right

( You know what I mean ? I can have order results only ONE order per page)

I would like to have it like I could get in report painter, where on the left hand side, you get a huge list of orders ( Based on your input) , and on right hand side ( I call it Reading Pane) you get all the output details when you put cusor on any order from left pane.

Would it be possible by doing the trick you mentioned ? Or do I need to modify a little to achieve it the way client wants ?

Sorry to bother you more...but you look like the only one on CO forum who have really hands on it I got no other reply !!

Thanks a lot in advance

Client is insisting the output like this -

Left Pane Right Pane

Order 1

Order 2

Order 3 In this entire right pane, I would see my selectied order details ( Here Order 3 for eg.

[Former Member · Accepted solution]

Normally, that is set through something called Variation where for instance you will have to check the radio button expand for Order.

In transaction code GR32, click on General Data Selection tab then next to Order, you will see IBV eliminatn Vary Frm To I , enter from 1 to 99 and check the box I .

The above should surely make your manager happy. Also do you know you can branch straight into multiple selection screen from GR55? In GR55, enter the report group and click on Multiple Selection.

Let me know if it helps.

Regards,

Elias

Edited by: Elias Akorli on May 7, 2010 3:14 PM

[Former Member · Accepted solution]

Hi

Most of the things which you suggested works fine. Thanks a lot for your inputs.

Full marks to you

BTW, the multiple selection TAB in GR55 does not work...I don't the reason, but it shows me the only output list information saying " No items processed"

But the one with GR32 ..works, although I can only put there " From Order" and " To order"

It would have been nice to have the extended selection ( so that I can select wihcih order type from whcih plant etc etc etc - like what we get in normal se16 input parameters, where instead of putting any manual value, I can directly upload an excel file having orders there-in..But any ways, that is a luxury for my client So just in case you know easily, let me know.

Otherwise, you have given me sufficiant inputs..and valuable too !

Thanks

Dhiraj

[former_member323719]

Hello All,

Can some one tell me how to change the display value currency. Meaning right now the report is showing values Group currency I need to see the values in Co Code currency.

Please note I do not have much understanding of report painter reports and is exploring possible solution to my problem.

Regards