SAP-FICO: Overview of EC-CS Consolidations

PuzzleConsolidating multiple companies into a unified, consolidated set of financial statements is an art form. In SAP, two common ways of producing consolidated financials are EC-CS (Enterprise Controlling – Consolidation System) and through reporting in BW (Business Warehouse). This post deals primarily with EC-CS.

EC-CS gives you a means of rolling up multiple company codes into a unified set of books. If you use multiple charts of accounts, the best option is to create Group Chart of Accounts and map your other charts to it. Your Group Chart of Accounts can then feed into your Consolidation Chart of Accounts.

Features of EC-CS

  • Consolidate multiple company codes
  • Import data from the General Ledger to cons units
  • Manual and automatic eliminations between Consolidation Units (cons units are tied to a Company, which is tied to a Company Code(s))
  • Eliminations within a cons unit
  • Reclassifications
  • Database viewer to view imported records, elimination/reclass records, and manual journal entry records
  • Upload data from Non-SAP systems (set up this feature in: CXCC). I’m not familiar with the capabilities of this function
  • Report Painter reporting (GR55)

You can report your consolidated financials either through BW or through Report Painter reports (T-code: GR55). For Report Painter, you will need to create a reporting Library (T-code: GR21), utilizing table FIMC. You’ll also need to specify your consolidations ledger while building your reports in GRR1 (or GR52).

Basic T-codes for EC-CS

  • CX16 – Consolidation Chart of Accounts – Hierarchy Change
    CX16 allows you to build your Consolidation Chart of Accounts within a hierarchy. Unfortunately, you can’t just copy one of your regular charts of accounts. You have to build the cons chart of accounts from scratch in CX16 (they can also be upload from PC file through T-code: CX1I0 & CX1I2…path: SPRO -> Enterprise Controlling -> Consolidation -> Master Data -> Financail Statement Items -> Copy FS Items from PC File by means of Flexible Upload). You can create multple hierarchies of your FS Items within this t-code. Right-click on the top node and select Create in order to start a new hierarchy.SAP: CX16
  • CXCD – Data Montior
    The data monitor allows you transfer financial data from the SAP General Ledger into the consolidations ledger. The balances come in by cons unit, which is mapped to a company. A company can be made up of one or more company codes and will carry in the balances of its constituent company codes.The Data Monitor does the following thing:

    • You can run the various actions at the total level or individual cons units
    • Shows overall status
    • Carryforward status
    • Data entry
    • Retained earning/Item substitutions
    • Validate reported data
    • Manual standardizing
    • Curency translation
    • Validate standardized data

    SAP: CXCD

  • Database Listing of Records
    In CXCD, click Goto/Database Listing of Records. This allows you to view the items imported from the General Ledger as well as manually posted items. You can limit by Posting Level which indicates the type of record being viewed.
    SAP: CXCD - Database viewer path
  • CX20 – Consolidation Monitor
    The Consolidation Monitor allows you to:

    • Eliminate inter-unit payables and receivables
    • Eliminate inter-unit sales
    • Eliminate investment income
    • Perform manual eliminations
    • Consolidate investment income
    • Perform manual reclassifications
    • Validate consolidated data

    Automatic eliminations must be set up in Implementation Guide (SAP IMG). You can configure tasks and task groups and assign these to consolidation groups.
    SAP: CX20 Consolidation Monitor

58 Responses to SAP-FICO: Overview of EC-CS Consolidations

  1. chaps_online August 19, 2008 at 12:33 pm #

    Hi Byron,

    Greetings

    We are doing a prototype for a Client with Consolidation functionality. There are 6 Company Codes to consolidate.
    We had tested some data in the prototype, and at a later stage we configured the Consolidation setup.

    My problem is how we can bring the old data into the consolidation setup..??

    Thanks in advance for your help in this regard.

  2. byron August 21, 2008 at 8:47 am #

    Hi Chaps,
    Sorry for the delay in answering your question…my email notification didn’t come through for some reason.

    Unlike GL or PCA, it is a bit easier to go back in time and reload prior period consolidations data. You should be able to unlock those prior periods and run through the Data Monitor and Consolidations Monitor tasks for each period. We had to do this a year or so ago. Ended up going back 12 months and running through it again.

    Byron

  3. sesh December 22, 2008 at 6:00 am #

    HI,

    I wanted to know the difference between SEM-BCS and EC-CS. Can we have EC-CS in SAP ERP 5. Does SAP supports, does it work the same way as SAPR/3 4.7. is there any difference.

    Client does not want to go for BW.

    Thanks in advance.
    sesh.

  4. Byron Bennett December 22, 2008 at 8:45 am #

    Hi sesh,

    I couldn’t say for sure, but I don’t see any reason that EC-CS wouldn’t operate the same in ERP 5 as it does in R/3 4.7.

    We are upgrading from 4.6c to ECC6 with EC-CS, and we aren’t having to do anything special to keep it running. I SAP has done a great job of keeping most things pretty stable across the different versions.

    Maybe someone else out there knows of critical differences with EC-CS in 4.7 versus ERP 5???

    Cheers!
    Byron

  5. Peter Okay December 23, 2008 at 8:03 am #

    Hi Byron,

    Great article!

    We are in the process of creating report painter reports for EC-CS using table FIMC. Everything seems fine, except when viewing the figures in the report it looks like the consolidated financial statement only shows figures that were posted in the period selected. The problem here is that if you compare it with the normal Financial Statement for one company code (transaction F.01) the balance sheet items are not cumulative for the period. This means if I run a consolidated report for 2008, the balance sheet does not include the 2007, 2006, etc figures.

    By the way, in response to Sesh’s question, we use ERP 5 for ECCS and it works exactly 4.7.

    Thanks

    Peter

  6. Byron Bennett December 23, 2008 at 8:45 am #

    Hi Peter,
    Thanks for dropping by!

    It’s been a year and a half since I left Accounting for IT and now I can’t back into production to see what I did in my FIMC reports in Report Painter, so I’m going to be guessing here (that’s a long way to apologize for not having a black and white answer)….

    1) Are you showing any beginning balances? If your beginning balances are missing, make sure your prior year has data, then make sure the roll forward is correct (I think there’s a roll forward t-code for EC-CS, but I can’t be sure).
    2) In GR52, I think I recall having to create add all the balances together for all periods + period 0 (beginning balances) to get good balance sheet figures.

    Sounds like your issue could be either of those items unless I’m misunderstanding your question.

    Let me know if that doesn’t help and I’ll think on it some more.

    Cheers and Merry Christmas!

    Byron

  7. Peter Okay December 24, 2008 at 2:28 pm #

    Hi Byron,

    Nice memory for a year-and-a-half hiatus 😉

    It was the period 0 option that made it work.

    Thanks and Merry Christmas!

    Peter

  8. Byron Bennett December 28, 2008 at 11:03 pm #

    Peter,
    Excellent! Glad I was able to help.

    Byron

  9. john January 9, 2009 at 11:34 pm #

    hi byron

    could please send me a complete document for the consolidation

    thanks

  10. Byron Bennett January 10, 2009 at 9:29 am #

    John,

    Sorry, I’m not sure what you’re looking for.
    BB

  11. Sharon January 10, 2009 at 12:09 pm #

    Hi Byron –

    I have a question that is kind of related to Peter’s from December. I have a number of 13 month rolling trend balance sheet reports created in Report Painter. I have used period 0 in my column definitions and they have always worked fine. But a few days ago, the header text in the columns stopped appearing on these reports. After digging into things, it looks like the period 0 is just being ignored in the column definitions. However, the actual balance sheet values are correct – it’s only the column header definitions. I tried creating a value variable to represent 0 rather than just the value 0 in the column definitions, but that’s not working either. We are currently in period 12 and have not yet closed for 2008. Any ideas why I would be having this issue? I just stumbled onto your site on Google looking for help anywhere I can!

    Thanks – Sharon

  12. Byron Bennett January 10, 2009 at 9:20 pm #

    Hi Sharon,

    That’s a weird one, but weird is sort of standard SAP as far as I can tell. Without being able to see what you’re working on, here’s how I would approach the problem:

    1. I would ask if anything has changed in your report definitions over between the time they were last working and when the headers stopped working.

    If yes, then you might try undoing the change and see if you can get back to a working state, and then take your changes step by step, checking at each step to see what’s breaking it.

    If no, then 2.

    2. If nothing changed in your report definition you have to start looking at what other environmental changes may have occurred. 1) Did IT change something? 2) Did this stop working after the year flipped over?

    If nothing’s changed with your report definitions, my guess would be that it is related to the period changing over. Did everything get rolled forward? If roll forward didn’t occur properly, then period 0 will be blank.

    That’s all I can come up with right now…feel free to ping me again if your still stuck…I’ll think on it from a different angle.

    Cheers!
    Byron

  13. sunny January 13, 2009 at 2:48 pm #

    whats the best way to get a good overall view on all sub modules of FI AND CO.

    Please advise me on this.

    i know all configuration steps but i am not getting how to work with them.

    Any advises would be appreciable,.

  14. sunny January 13, 2009 at 2:52 pm #

    Hello Byron,

    what are the main configuration steps that most companies are following in their project.

    How do we have to analyse any configuration in FI or CO.

    What things we have to consider to get the right flow any module.

    Regards
    Sunny.

  15. Byron Bennett January 13, 2009 at 5:43 pm #

    Hi sunny,

    I hope that someone else will jump in and help out with your question, as I really don’t have a good answer. But I would suggest that the ASAP methodology probably has some pretty good documentation on FICO configuration steps.

    I will take a look to see if I can find any links that would point you to the ASAP documentation. If someone else has any pointers, please jump in!

    Cheers,
    Byron

  16. Veena January 14, 2009 at 7:47 am #

    Byron,

    Love your site & the articles you have posted here.

    Just curious about your switch in carrier. I am an IT individual (did custom applications in .net & java) trying to get into SAP. However you seem to have done the reverse.

    Could you share your thoughts on why?

  17. Byron Bennett January 14, 2009 at 8:25 am #

    Hi Veena,

    My career has been pretty fluid, even though I’ve been with the same company for over 12 years now. I enjoy a change of pace every few years, and my company has offered me some great opportunities to do different things over the years. I’ve worked in Accounting, IT (for SAP implementation), back to Accounting (to administer the FICO system and reporting), back to IT (where I currently work on various projects, some of which touch SAP).

    My latest projects have been leading our implementation and ramp up of automated testing of SAP using a product from Worksoft called Certify. I’ll be posting about how that has gone in the next month or so after our upgrade to ECC6 completes.

    One of my next major projects will be the implementation of Clarity 6 budgeting and planning software. I’m really excited about this one as it will replace an application that I wrote in VB6, which is really showing its age.

    Overall, I try to stay connected to SAP because of the value it has held for my career.

    Anyway, thanks for asking.

    Cheers!
    Byron

  18. John January 15, 2009 at 5:28 pm #

    Byron

    Can we make a manual entry in the ECCS to two different Cons Unit. When I make a manual entry using doc type 11 from data entry side it shows up in the report but using doc type 11 I can not make a two sided entry to two different Cons unit. I was able to post with the document type in consolidation function to two different cons unit but that does not shows up in the report. I would appreciate your help on this.

    Also, Do we need to activate scenario FIN_CONS in New GL or not if I am using ECCS for consolidation. As far as my understanding goes FIN_CONS is only required if we are doing consolidation in BCS. Any thought on this will be appreciated.

    Thank you
    John

  19. Byron Bennett January 16, 2009 at 2:42 pm #

    Hi, John,

    Thanks for dropping in….You should be able to post between two different Cons Units. That would be a manual elimination of sorts. As to your reporting issue, I probably can’t tell you anything you don’t already know. Make sure that you are including both of the Cons Units in your report definition and make sure that you are including that document type as well. I don’t know if what you’re doing actually allows you to specify those items, so that may not apply, but it would be something to check.

    I am not sure about the FIN_CONS scenario in the New GL. We are currently upgrading from 4.6C to ECC6, but we are not implementing the New GL at this time. We plan to do it in a couple of years, so I’d be interested in hearing if that is something you need to do or not.

    Byron

  20. Ram January 19, 2009 at 9:06 am #

    hi Byron,

    when i am creating consolidation unit.In the Data collection tab,i had chosen data transfer method as Roll up method.but i am not able to assign the company information.

    How to assign the company information to the consolidation unit.

    Thanks
    Ram

  21. Emily February 5, 2009 at 9:49 pm #

    Hi Byron,

    We need to support a client with this module but I don’t have any background in Consolidation module of SAP.

    Do you have any documentation on how to set-up ECCS, Step by step configuration and application manual?

    Thanks in advance,
    Emily

  22. Byron Bennett February 6, 2009 at 8:49 am #

    Hi Emily,

    Here’s a link to a PDF that has ECCS help in it: ECCS Help Doc

    Unfortunately I don’t have anything on ECCS. You might also try searching SDN.

    Byron

  23. Dhimbak May 28, 2009 at 2:51 pm #

    Byron,

    Great site. I’m post graduate in accounting but switched to IT right after my studies(wierd… but happened for good), worked in diff. technologies and finally landed back into my home turf, SAP FICO recently. I’m learning/struggling but still enjoying.

    Your inputs to questions here is really wonderful for people like me, and i thank you. I’ll be visiting you here quite frequently 🙂

  24. Byron Bennett May 28, 2009 at 8:26 pm #

    Hi Dhimbak,

    Thanks for dropping by! I too switched from Accounting to IT and back to Accounting and now back to IT 😛 That’s really a pretty good combination in the world of SAP, or any ERP for that matter.

    Putting these tutorials on a blog gives me some incentive to be clear and…hopefully…coherent. I need to capture much of this stuff for my own future reference, but thinking that someone else might read it gives me the extra little kick to do it.

    Best of luck with your career! And thanks again for dropping in.
    Byron

  25. Jatin Patel June 2, 2009 at 1:53 pm #

    Hi Byron [Genius Brain of SAP]

    myself jatin Patel, i am working for one company. i am reading your all answers its excellent. and now i m in a que,my company gave me littel bit criticle assignment so i am not able to figure it out how to do it so please take a look on my problem may be you can help me.
    they would like to arrange to receive a daily ACH file from their bank, which contains customer remittance advice data. By importing this data into SAP as Payment Advices, it will allow us to more efficiently clear customer payments.

    now i dont have any idea how to solve this so please if u have any idea regarding this then please help me

    thanks

    J Patel

  26. Manohar July 29, 2009 at 1:56 pm #

    Hi: How do we close and open periods in EC-CS?

  27. Byron Bennett July 29, 2009 at 2:26 pm #

    Hi Manohar,

    In the Edit menu item in CX20, there is a selection for Close Period.

    Byron

  28. Alviar August 22, 2009 at 12:32 pm #

    Hi Byron,

    Congratulations …. your comments or advice are very good.

    First all, I want to say my English is so so, because my native language is Spanish. Sorry if I mistakes.

    I’m new (6 months) in SAP’s world but with a lot of experience in IT (20 years). I found your community looking for something about consolidation.

    I’m a little confused with FI-LC, EC-CS, SEM-BCS, BCP (business objects). I know this modules or products are due to new releases and/or acquisitions by SAP, but I understand all of them are working even. Is that correct?

    This year as a result of economics crisis I was fired from the company where I worked for 10 years. I thought this is a good opportunity and I started my own company as a independent IT consultant, mainly to help CIO make good decisions.

    I need your recomendations about the next company scenario, thinking in accomplish IFRS:

    I have a client who has SAP ECC 6.0 (new-gl is not activated) and BW 7.0, they have account approach to manage differents accountant principles (Local, GAAP, IFRS), 27 company codes (1 client), 3 business areas (they using by segment reporting), working currency is dollar for headquarter and other countries (local currency).
    The changes for accomplish IFRS (fixed asset, ex-change currency , etc) are ready since beginning this year.

    They are requiring consolidate and reporting using XBRL to corporation like SEC (US).
    I understand it’s possible consolidate in ERP (OLTP) or in BW (OLAP) and then to extract the data, and depend of product to use. Is that correct?

    My other question is: In this case, what could be the best strategy for consolidate and reporting? and What is the best product, thinking in the opportunity and faster extract the information? If you need more information, please ask me.

    Thanks a lot.

    AAlvarez

  29. Raffy September 1, 2009 at 2:44 am #

    Hi Byron,

    Good article.

    I am configuring EC-CS and have even tested the upload from non-SAP data (this is easy).

    My issue is I am having difficulties in creating the appropriate roll up. I am using company consollidation. What would be the most appropriate roll up sender / receiver table? What is the nearest delivered roll up that I should copy from.

    Thanks for sharing.

    Raffy

  30. Byron Bennett September 1, 2009 at 7:23 am #

    Raffy,

    I’m not sure right off hand on that (we implemented back in 2001 and I’m in a different position now). I will see if I can see anything, and will let you know if I do. Hopefully someone else will be able to chime in on the roll up config.

    Byron

  31. M.E September 22, 2009 at 2:08 pm #

    Hello All;

    I am trying to implement EC-CS in our existing SAP system. I went through all the configuration steps. Now I need to uplaod the begging balances from FI into EC-CS as of 12/31/2006. so when I copy data from 2007 2008 2009 my ending balances tie.

    Can anybody please provide a step by step way to do it?
    Do I have to downoad Data from FI put it in certain format and then load it back up to ECCS? if yes? wat fields and what Tcodes?
    is there a simple way of doing this?

    I am new to this and Thank you in advace for the help.

  32. Casper October 2, 2009 at 1:27 am #

    Hi Byron,

    I may have yet another issue for you to punish your brains on – though reading the above I get the impression that you know your way around ECCS very well.

    We are considering implementing an indirect cashflow calculation in ECCS, but since I have no experience with the technical side of ECCS, I have no idea whether this is feasible or that we are going down a dead-end street.

    Can you give me your feedback on whether ECCS is capable of calculating a (custom) indirect cashflow, that would take its data from a combination of P&L data, balance sheet data, and data from movement schedules? Or would this require other (perhaps more flexible) BI packages such as BusinessObjects or Oracle Hyperion?

    Note that our ECCS environment is getting its data from a combination of data sources, so not only SAP FI but also decentralised ledger systems such as Exact, Scala, and Concord.

    Many thanks in advance for your input
    Casper

  33. hc November 9, 2009 at 4:36 pm #

    Hello,

    a great forum – thanks!

    Two questions: a) How does one avoid all kinds of required field entries which are not relevant (eg all of those goodwill-amortization related entries which are not needed that way after FAS 142)?

    b) Inspite of having set up all accounts in FI-GL (op CoA, cons CoA), and all FS items in “Specifiy Items to be carried forward” (in the carryforward data collection task), I still get an error message in the Cons monitor: “The item ‘Item for retained earnings on the balance sheet’ has not been maintained” (message GK660) – where is that setting made?

    Thanks

    HC

  34. Mp November 12, 2009 at 2:13 pm #

    Compare EC-CS, SEM-BCS and SAP BPC.

    How long is each valid? When does SAP stop supporting these?

  35. Murali November 23, 2009 at 10:41 am #

    Hi Experts,

    I am FI-CO, Currently working on EC-CS module. Some how many to do Basic config in ec. nOW I was trying to test scnarios like manual posting, IU elimination and COI.(Since we are limited one country and single currency no Currency translation) 🙂 But i am facing issues with testing. 1 after 1 throughing errors..
    1. I was trying to post manual entry in i am getting below error.

    Item__________________ 000000 — Balance 10.000,000 AED –> posting not possible. I was trying to enter 2 FS items with value of 5000 each .. can any one tell em ..hw does debit and credit will identified as there is no P key..(wht is going to act as P key in EC-CS– FS items ??)\

    2. while executing the IU elimination for Receivables and paybles, i am getting message: No data exists or already eliminated – even though there is data and no elimination happend.

    Can any body through some light on this or share some user manual or configuration docs.

    Rgds
    Murali

  36. Satya December 11, 2009 at 10:40 am #

    Hi Murali

    I am only a beginner in EC – CS but I think I can answer the first part of your questions.
    Debit and Credit are identified by signs you put in along with the amounts when doing manual entry.
    So for debit you enter the amount without any sign but for credit enter with negative sign and it should balance and post without errors.

    Thanks
    Satya

  37. Satya December 11, 2009 at 10:50 am #

    Hi Byron

    I am new to EC CS and came across your site which was very focussed on ECCS discussion.

    My question is we have are using a fiscal year variant which is year dependent but was maintained same as calendar year with only 1 special period.

    When I enter period 13 in Global parameters for T Code CXCD, I get a message that 13 is not a valid period for version.

    How are postings in spl periods dealt with in Consolidation? What config is needed to be done in ECCS to deal with postings in spl periods?

    Appreciate your response.

    Thanks
    Satya

  38. Byron Bennett December 11, 2009 at 4:19 pm #

    Hi Satya,

    I took a look, but didn’t see anything special for configuring the periods with versions in EC-CS. I was able to select period 13 in Global Parameters for CXCD in our dev system…not sure what the difference might be.

    Does anyone else have an idea on this?

    BB

  39. Murali December 12, 2009 at 12:54 am #

    Hi Satya,

    Thanks for your inputs. I got the logic for manual posting. Does any body has test data or test scenarios.

    Rgds
    Murali

  40. Morgan December 17, 2009 at 2:24 pm #

    Bryon

    Great discussions!!

    I have been tasked to come up with a solution for Consolidating two Company Codes. As of now it is one Company splitting off one of its segments to create a seperate Company (legal Entity).

    The following has been proposed, that Set up a third Company with the same chart of accounts as the other company codes. If you use a group currency, the consolidating entry company code must have the same group currency. Once it is set up, just post your consolidating entries in this new company code. Examples are: intercompany sales elimination (debit intercompany sales and credit intercompany cost of sales), elimination of intercompany profit in inventory (credit inventory and debit cost of sales), etc. When you do your reporting, just include this company code along with all of the others when you want consolidated financial information. Adding more company codes for other business operations can be done as many times and as often as necessary. Just remember to add these new company codes into any consolidated report you run.

    Based on that information I am not sure how to get the Consolidating entries to post to the Third Company. Would they be rule based?

  41. yagnesh January 8, 2010 at 5:44 am #

    Hi. Byron

    Found it very nice. Would like to share my problem what I am facing. Any help will be much appreciated. My issue

    Holding Co. A local & Group currency USD
    Subsidiary Co. B local currency GBP

    In F.Y 2006 it had 15% holding in co. B and F.y 2007 increased by 40% and next year other 45%.

    We are going on EC CS from F.Y 2009. So 1st maintained 1st consolidation. Then Step acquistion. For the first consolidation getting translation reserve and % of holding in local currency correct. But when trying to maintain data for step acquisition have to maintain the % of new acquisition and amt paid in local currency. But where to maintain the amount paid in foreign currency i.e in GBP what I paid for the purchase of the 40% of acquisition so that I can get Translation reserve.

    Also the increase in the General Reserves also where to maintain so that can calculate correct goodwill as we are using purchase method.

    for any doubt can contact on my mail.

    Thanks

  42. hal February 17, 2010 at 4:10 pm #

    Hi Byron,

    I’m trying to create a consolidation report in EC-CS using SAP Query. I want the report to look like what is shown in CX34 but with additional columns; such as a column for prior period data and variance field for comparison purposes. Do you know what the logical database source I could use for such a report? Please help…

    Thanks,

    Hal

  43. Byron Bennett February 17, 2010 at 4:14 pm #

    Hi Hal,

    You might try a custom library containing table FIMC. You should be able to pull in other fields into the library as needed.

    Hope I’m understanding the question correctly…

    BB

  44. Paul March 17, 2010 at 8:07 am #

    Hello Byron,

    Great Forum!!!! Needless to say…

    I have one question for you, I have not worked in EC-CS till now but I am sure that this function of SAP is very good. I have heard of SAP BPC so much that I am very confused on where does SAP R/3 fails and where SAP BPC comes into effect and provide solution.

    In other words how does SAP BPC superior than SAP EC- CS?

    Also do think SAP BPC as a product has a good future?

    Regards
    Paul

  45. Javaid April 6, 2010 at 3:20 pm #

    Hi Byron,

    I am going to implement EC-CS module…Could you please send me the configuration steps document for EC-CS?

    My email id is javaidak123@hotmail.com

    Many thanks in advance.

    Regards,

    Javaid

  46. Byron Bennett April 6, 2010 at 8:47 pm #

    Sorry, Javaid,

    I don’t have access to anything that is a good complete guide.

    Does anyone have a link to a Best Practices document?

    BB

  47. Javaid April 10, 2010 at 4:12 am #

    Hi guys,

    I am going to implement EC-CS module…Is anybody help me to provide the configuration steps document in this regard?

    My email id is javaidak123@hotmail.com

    Many thanks in advance.

    Regards,

    Javaid

  48. Consol Data April 19, 2010 at 1:16 am #

    I have a task to set up consolidation for a Corporate group that has only the corporate office running on SAP and the other 18 subsidiaries are on other systems . Within the 18 subsidiaries there are 2 companies that are assoicates.The corporate group also does limited accounting transactions approx 4 invoices per month for 3 discontinued companies but not yet divested.

    The 18 subsidiaries are also broken down into sub groups by type of operations e.g. Retail, Financial services, Investments, Property etc and these also groups need to be reported in a separate report over and above the Main Group Financial reports and the report must show each group (segment) on its own. — Is there a Standard report that helps me achieve this kind of reportring

    The 2 companies that are assoicates should they be created as a group if they are to be reported as a separate subgroup. The client wants to be able to produce a report which shows segments – Retail, Financial services, Investments, Property and Asscociates.

    How best can i set up my consolidation structures ..

    Please advise
    Sk

  49. ALEEM May 13, 2010 at 1:01 pm #

    Hi,

    I am an MBA student, interested to learn SAP – FICO, I am not good with accounts.
    My Q : Is it easy to learn SAP FICO and understand in 6 months.
    Could you tell me what it takes to learn this .

    Thank u

  50. madhavan May 13, 2010 at 4:12 pm #

    HI Byron
    Can you tell me the possibilities of doing Reclass and T codes for the same
    1. Like Changing cost booking form COst center to another cost center
    2. Asset to Cost center

    I want to know the possiblities and T code for Process.
    Rgds
    Madhavan

  51. liungz June 16, 2010 at 3:29 am #

    dear byron,

    i am glad can find your article. currently i try to implement EC-CS in a prototype.
    but i am still do not understand, how consolidation unit be linked as a company code to be consolidated.

    hope you can help me.

    best regard,

    liungz

  52. Paul P June 16, 2010 at 8:29 am #

    Has anyone used ECCS with Public Sector (Funds Management)? We have a single company code but need to perform eliminations between funds.

    Thanks!
    Paul P

  53. Ajay Gupte August 15, 2010 at 4:00 am #

    Hi Byron,

    Your article & answers to various questions are great. I need your help on ECCS. I have never worked on ECCS before & hence getting it very difficult to configure the system. Can you please pass on configuration steps / documents to me on the same. Your help would really be life saving for me.

    Thanks & Regards,
    Ajay Gupte

  54. bon August 30, 2010 at 11:46 pm #

    Hi Byron,

    We are doing kind of reimplementation of SAP. We already have Consolidation module implemented. As part of reimplementation which in the same instance meaning we will still have the old company codes and data associated with it in the system. I have configured a new Dimension and a new chart of accounts for the new company codes. When I post journal entries, I keep getting an express error message in my inbox saying that the new company codes does not exist in the old dimension and the new chart of accounts does not map to the old one. We really dont need these message since the new company codes does not have to be in the old dimension and the new chart of accounts does not have to be mapped to the old chart of accounts. can you give any suggestion.

  55. Pra_Pat August 31, 2010 at 4:25 am #

    Hi Byron,

    I need your help on ECCS. I have never worked on ECCS before. But I have done some customisation in ECCS. I have defined 2 legder with 2 different currencies with 7 consolidation unit and 5 consolidation group. While running currency translation tasks for 4 Cons. Group having same ledger(USD), there is no error. But after running currency translation tasks 4 conso. Group(same Ledger), I am trying to run currency translation for last Cons. Group (highest Node) INR, getting error “Ledger X2 is not equal to Ledger X1 of starting consolidation Group” Please help me this out.

    Regds,

    Pra_Pat

  56. Naidu9 September 8, 2010 at 1:17 pm #

    Hi Byron,
    Great site & very good stuff.

    I am new to ECCS.
    In our compnay we use Ex rate type “M” – Avg rate for both Bal Sheet & PL accounts for translations.

    1), I see with in ECCS we have option to change it.
    CX01n -> Currency Transaltion -> Curr transaltion Methods -> Method Entries ->
    I see diffent “FS Item Sets” here.

    Z_INCOME_STATEMENT
    Z_ASSETS_AND_LIAB etc etc.

    2), Here we define the Ex Rate Indicators “ERI” & these ERI’s are in turn tied to a specific
    Ex Rate Type. (B001, M and so on).

    My question is:
    A), where do we define the FS Item Sets. How to see what it is made up of.
    Is it a set for group of the G/L accounts. for ex Z_INCOME_STATEMENT is it tied to all the PL accounts ??

    B), if I want to set up a new Ex rate type.. Say “Z”.. Can I set I one and use it in the Step 2.

    Thanks for your time & advise.

    rdgs
    Naidu

  57. ECCS GURU September 30, 2010 at 4:19 am #

    I have an issue .. This message is popping up when i try to validate reported data Reported equity data: Subitem not defined. and i cant seem to figure out where the problem is .. this is working well in my Dev but not in QAS and PRD

  58. Pra_Pat October 5, 2010 at 5:42 am #

    Hi Naidu9,

    For Question A) Answer is:

    We define FS item set in CXSC. It is made of FS item. e.g. if you want to translate P & L Fs item set, here we define range of FS item to translate in group currency.

    Regds,

    Pra_Pat

Powered by WordPress. Designed by Woo Themes