Manual consolidación sap

Consolidation (EC-CS)

Release 4.6C

HELP.ECCS

Consolidation (EC-CS)

SAP AG

Copyright
© Copyright 2001 SAP AG. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG andits distributors contain proprietary software components of other software vendors. Microsoft , WINDOWS , NT , EXCEL , Word , PowerPoint and SQL Server are registered trademarks of Microsoft Corporation. IBM , DB2 , OS/2 , DB2/6000 , Parallel Sysplex , MVS/ESA , RS/6000 , AIX , S/390 , ® ® ® AS/400 , OS/390 , and OS/400 are registered trademarks of IBM Corporation. ORACLE is a registered trademarkof ORACLE Corporation. INFORMIX -OnLine for SAP and Informix Dynamic Server Informix Software Incorporated.
® ® ® ® ® ® TM ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ®

are registered trademarks of

UNIX , X/Open , OSF/1 , and Motif are registered trademarks of the Open Group. HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C , World Wide Web Consortium, Massachusetts Institute ofTechnology. JAVA is a registered trademark of Sun Microsystems, Inc. JAVASCRIPT is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. SAP, SAP Logo, R/2, RIVA, R/3, ABAP, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.com are trademarks or registeredtrademarks of SAP AG in Germany and in several other countries all over the world. All other products mentioned are trademarks or registered trademarks of their respective companies.
® ® ®

2

April 2001

SAP AG

Consolidation (EC-CS)

Icons
Icon Meaning Caution Example Note Recommendation Syntax Tip

April 2001

3

Consolidation (EC-CS)

SAP AG

Contents
Consolidation(EC-CS)
Consolidation Execution of a Consolidation Data Monitor Executing Tasks in the Data Monitor Consolidation Monitor Master Data Dimension Organizational Units Consolidation Unit Consolidation Group Maintenance of Organizational Units Consolidation Chart of Accounts Financial Statement Item (and Its Subassignments) Maintenance of Financial Statement Items Subitem Category and Subitem VersionLedger Custom Characteristics Custom Subassignments of the Financial Statement Item Custom Subassignments in Consolidation Functions Custom Attributes of the Consolidation Unit Custom Attributes in Consolidation Functions Data Collection Online Data Entry in the SAP System Data Entry Layout Data Entry Using Flexible Layouts Entry of Different Currencies, Entry of Quantities Entry of Data MeetingLocal and Group Requirements Entry of Periodic or Cumulative Data Entry of Data with Financial Statement Item Breakdowns Examples of Financial Statement Item Breakdowns Online Entry of Reported Financial Data in the SAP System Entering Reported Financial Data Online Offline Data Entry with Interactive Excel Offline Data Entry with Interactive Excel Data Matrix Opening a New Workbook with InteractiveExcel Interactive Database Connection Connecting Interactive Excel to an Access Database Creation of a Data Matrix Making Global Settings for a New Data Matrix Definition of a Matrix Specifying Single Values Specifying Sets

10
11 13 20 31 32 34 35 37 38 40 43 45 47 52 54 56 62 63 64 67 69 71 72 76 77 79 80 81 82 83 85 87 89 92 94 97 100 101 102 103 106 108 112 114

4

April 2001

SAP AGConsolidation (EC-CS)

Specifying Hierarchies Specifying Attributes Working with Structures Changing Characteristic Values Additional Settings Determination of Values for Characteristics Specifying a Value/Value Reference for Characteristics Identifying the Area for Data Input/Output Entry of Specific Data Categories Creation of Further Matrices Deleting a Matrix Entry of Data in a Matrix...