cancel
Showing results for 
Search instead for 
Did you mean: 

Consolidation report in COPA

Former Member
0 Kudos


Hi,

The requirement is more of Consolidation report for a
Company (including manufacturing and marketing).

 

The manufacturing company produces FG and sales it to its Marketing
Company.

 

Each company has its own G&A expenses.

 

The requirement is to draw a Consolidation report excluding
the intercompany sales and revenue and including G&A expenses from both.

 

Sales Qty               XXX

Sales Revenue      YYY

Less COGS           ZZZZ (This COGS corresponds to the Sales Qty. but valuation in Manufacturing Company)

Less G&A expenses AAA  (for both Companies)

How can it be achieved through COPA.

Kindly help.

Kami

former_member654515
Participant
0 Kudos

He wants to *exclude* intercompany profits. This is not answered, it is only answered how to report gross totals without elimination of intercompany profits.

I also would like to know how you go about this. If it's not possible CO-PA would be useless for multi-company situations who have 1 operating concern for all company codes. And the smartest designers @ SAP will have thought about this I think.

Accepted Solutions (0)

Answers (2)

Answers (2)

jose_reddy
Contributor
0 Kudos

Hi Kami,

As Waman right suggested, the report is prepared at operating concern level. If all your company codes are indirectly linked to one operating concern through controlling area, you can have consolidated report as you wish. Further more you can see the values at each company code, plant wise based on the parameter selections you make (this is the sweetest part of COPA reporting).

Don't worry, go ahead as Waman rightly suggested.

Regards..

Jose

waman_shirwaicar
Active Contributor
0 Kudos

Dear Kami,

    You need to use tcode KE31 to create your own report in COPA.

    But first check via tcode KE24 that the data you need is available.

    I assume that sales QTY (XXX), sakes revenue (YYY), COGS (ZZZ) and G&A expenses (AAA) would all be available in COPA value fields. Then its just a matter of creating your own keyfigures (formulas) to calculate the value in the KE30 report.

regards

Waman

Former Member
0 Kudos

Hi Waman,

Thanks for your reply. Yes the data might be available in KE24. But my worry is, Whether in report painter, the data from two separate company codes and separate plants can be clubbed or not.

Because we have to add lets say G&A expenses from two separate company codes to make the consolidation report.

Your view on this.

Regards

Kami

waman_shirwaicar
Active Contributor
0 Kudos

Hi Kami,

    The KE30 report is at an operating concern level. So all the company codes that belong to that operating concern should be available. So you should be able to club the data of two or more company codes in a single KE30 report.

regards

Waman