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

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 05, 2010 at 07:48 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • Posted on Apr 22, 2011 at 06:33 PM

    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

    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.