on 09-27-2013 3:22 PM
I have a requirement to exclue one company code from a KE30 report. This is a sister company that should be shown separately from the other company codes in the report.
The report I am using is a basic report, no form attached.
I tried creating a new variable for company code which allows me to select company codes when I run the report, however this then removes the roll up by company code in the report, which is also required.
Here is what the report looks like today with totals by company code.
When I change company code to a variable, the report looks like this, no longer rolled up by company code.
I tried reordering the characteristics and I tried several different output options but none worked as I need it too.
How can I restrict the company codes for which the report is run but still have the data roll up by company code? This is the first KE30 report I've had to deal with.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That didn't work for me. What am I missing.
I added the node to the hierarchy.
I updated the report with a variable.
But now when I run the report I have to select only one company code, I can't run it for all.
And the report brings back no data (there is data, if I remove the local variable I see all data, but for all company codes, including 6040).
Thanks so much for your help (and patience!)
Andrea
Hi
Don't use a local variable..
I would suggest 2 options
1. Just add the sub group Z003 and co code 6040 under it
2. (I prefer this) Create a Global Variable from KE3E for the Char BUKRS... CHoose replacement type as MANUAL ENTRY and choose SELECTION OPTION in the variable instead of PARAMETER
Assign this Global Variable in your report instead of local variable.. As soon as you click on variable check box, your global variable will appear there
Now you will be able to enter multiple values at the time of executing your report.. In local variable, you can enter only a single value.. But with GLOBAL variable, you can enter multiple and also exclude some values
Br, Ajay M
Oh, I have tried that. I only get the company codes I want, but I can no longer roll up by company code. Summarizing by company code is a requirement.
When I use the first checkbox the out put is this:
My requirement is for the output to look like this:
Is there a way to get both? Only the ccodes I want AND rolled up by company code?
Big Choi,
Thank you for your responses but they do not meet my requirement. If I use the hierarchy to remove the company code, I only see data for the company codes I want, however my report no longer summarizes by company code. Summarization by company code is a requirement. (see the screen shots in my last reply for examples).
It appears what I need is not possible.
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Try to create a char hierarchy for bukrs in kes3.
Add all co codes except the one in your hierarchy
Use this hierarchy in the report definition and see if it works
Ajay M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi..
1. You create characteristics hierarchy of company code using IMG MENU(Profitability
analysis->Information system->Report Components->Define characteristics hierarchy)
Refer to below pricture.
2. You set above characteristics hierarchy in company code characteristics of selection
haracteristics.
Refer to below picture.
3. After execute CO-PA Report, You display co-pa report as below picture.
User | Count |
---|---|
98 | |
8 | |
6 | |
5 | |
5 | |
4 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.