KE30 Exclude one company code from report

[Former Member]

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!

[Former Member · Accepted solution]

Thank you, that appears to be the right track, however how do I show just the one hirarchy?  I don't want to see the "not assigned" in the report at all. 

Andrea

[Former Member · Accepted solution]

Hi..

You create sub group z003 of hierarchy group z001 and you assign company code 6040 to tree node of sub group
z003.

If you want to execlude 6040 company code in report, refer to below picture.

[Former Member · Accepted solution]

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

[ajaycwa1981 · Accepted solution]

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

[Former Member · Accepted solution]

Ajay,

Thank you for the response.  I tried option 2, however when I do that my report no longer rolls up by company code.  It looks like this:

I need it to look like this (just without the 6040 company code included).

[Former Member · Accepted solution]

Hi..

Sorry, You don't use variable selection.

Through changing form(t-code:ke35), You can change general data selection setting as below to exclude company code 6040.

[Former Member · Accepted solution]

I don't get the option to pick a group.  When I click on the hierarchy node I see this.  No option to select node.  Did I create the hierarchy incorrectly?

[Former Member · Accepted solution]

Hi..

You should select fist column, not second column.

[Former Member · Accepted solution]

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?

[Former Member · Accepted solution]

Hi..

Both my first replay and my last reply should be applied to your co-pa Report.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi..

To solve your issue, you can develop z-program using ce3xxxx and ce4 xxxx table.

[Former Member]

This message was moderated.

[ajaycwa1981]

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

[Former Member]

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.