AC660_EN_Col51_FV_Part_A4 (第1页) | ERP软件技术分享

第 1 页 / 共 429 页

AC660

EC-CS Consolidation Functions

mySAP Financials

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 2005 Q1

Course Duration: 5 Day(s)

Material Number: 50071531

An SAP course - use it to learn, reference it for work

第 2 页 / 共 429 页

Nopartofthispublicationmaybereproducedortransmittedinanyformorforanypurpose

withouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechanged

withoutpriornotice.

SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftware

componentsofothersoftwarevendors.

Trademarks

• Microsoft®,WINDOWS®,NT®,EXCEL®,Word®,PowerPoint®andSQLServer®are

registeredtrademarksofMicrosoftCorporation.

• IBM®,DB2®,OS/2®,DB2/6000®,ParallelSysplex®,MVS/ESA®,RS/6000®,AIX®,

S/390®,AS/400®,OS/390®,andOS/400®areregisteredtrademarksofIBMCorporation.

• ORACLE®isaregisteredtrademarkofORACLECorporation.

• INFORMIX®-OnLineforSAPandINFORMIX®DynamicServerTMareregistered

trademarksofInformixSoftwareIncorporated.

• UNIX®,X/Open®,OSF/1®,andMotif®areregisteredtrademarksoftheOpenGroup.

• Citrix®,theCitrixlogo,ICA®,ProgramNeighborhood®,MetaFrame®,WinFrame®,

VideoFrame®,MultiWin®andotherCitrixproductnamesreferencedhereinaretrademarks

ofCitrixSystems,Inc.

• HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C®,World

WideWebConsortium,MassachusettsInstituteofTechnology.

• JAVA®isaregisteredtrademarkofSunMicrosystems,Inc.

• JAVASCRIPT®isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefor

technologyinventedandimplementedbyNetscape.

• SAP,SAPLogo,R/2,RIVA,R/3,SAPArchiveLink,SAPBusinessWorkflow,WebFlow,SAP

EarlyWatch,BAPI,SAPPHIRE,ManagementCockpit,mySAP.comLogoandmySAP.com

aretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountries

allovertheworld. Allotherproductsmentionedaretrademarksorregisteredtrademarksof

theirrespectivecompanies.

Disclaimer

THESEMATERIALSAREPROVIDEDBYSAPONAN"ASIS"BASIS,ANDSAPEXPRESSLY

DISCLAIMSANYANDALLWARRANTIES,EXPRESSORAPPLIED,INCLUDING

WITHOUTLIMITATIONWARRANTIESOFMERCHANTABILITYANDFITNESSFORA

PARTICULARPURPOSE,WITHRESPECTTOTHESEMATERIALSANDTHESERVICE,

INFORMATION,TEXT,GRAPHICS,LINKS,ORANYOTHERMATERIALSANDPRODUCTS

CONTAINEDHEREIN.INNOEVENTSHALLSAPBELIABLEFORANYDIRECT,

INDIRECT,SPECIAL,INCIDENTAL,CONSEQUENTIAL,ORPUNITIVEDAMAGESOFANY

KINDWHATSOEVER,INCLUDINGWITHOUTLIMITATIONLOSTREVENUESORLOST

PROFITS,WHICHMAYRESULTFROMTHEUSEOFTHESEMATERIALSORINCLUDED

SOFTWARECOMPONENTS.

第 3 页 / 共 429 页

About This Handbook

Thishandbookisintendedtocomplementtheinstructor-ledpresentationofthis

course,andserveasasourceofreference. Itisnotsuitableforself-study.

Typographic Conventions

American English is the standard used in this handbook. The following

typographic conventions are also used.

Type Style Description

Example text Wordsorcharactersthatappearonthescreen. These

includefieldnames,screentitles,pushbuttonsaswell

asmenunames, paths, andoptions.

Alsousedforcross-referencestootherdocumentation

bothinternal(inthisdocumentation)andexternal(in

other locations, such asSAPNet).

Example text Emphasizedwords or phrases in bodytext, titlesof

graphics, and tables

EXAMPLETEXT Names of elements in the system. These include

reportnames,programnames,transactioncodes,table

names, andindividualkey wordsof aprogramming

language,whensurroundedbybodytext,forexample

SELECT and INCLUDE.

Example text Screenoutput. Thisincludesfileanddirectorynames

and their paths, messages, names of variables and

parameters, and passages of the source text of a

program.

Example text Exactuserentry. Thesearewordsandcharactersthat

youenterinthesystemexactlyastheyappearinthe

documentation.

<Example text> Variableuserentry. Pointedbracketsindicatethatyou

replacethesewordsandcharacterswithappropriate

entries.

Icons in Body Text

The following iconsareused in thishandbook.

iii

Type Style	Description
Example text	Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation bothinternal(inthisdocumentation)andexternal(in other locations, such asSAPNet).
Example text	Emphasizedwords or phrases in bodytext, titlesof graphics, and tables
EXAMPLETEXT	Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkey wordsof aprogramming language,whensurroundedbybodytext,forexample SELECT and INCLUDE.
Example text	Screenoutput. Thisincludesfileanddirectorynames and their paths, messages, names of variables and parameters, and passages of the source text of a program.
Example text	Exactuserentry. Thesearewordsandcharactersthat youenterinthesystemexactlyastheyappearinthe documentation.
<Example text>	Variableuserentry. Pointedbracketsindicatethatyou replacethesewordsandcharacterswithappropriate entries.

第 4 页 / 共 429 页

AboutThisHandbook AC660

Icon Meaning

Formoreinformation,tips,orbackground

Noteorfurtherexplanationofpreviouspoint

Exception or caution

Procedures

Indicatesthattheitemisdisplayedintheinstructor’s

presentation.

Icon	Meaning
	Formoreinformation,tips,orbackground
	Noteorfurtherexplanationofpreviouspoint
	Exception or caution
	Procedures
	Indicatesthattheitemisdisplayedintheinstructor’s presentation.

第 5 页 / 共 429 页

Contents

Course Overview......................................................... vii

Course Goals...........................................................vii

Course Objectives .....................................................vii

Unit 1: Positioning.........................................................1

Consolidation Strategy Requirement.................................2

Enterprise Controlling ..................................................5

Unit 2: Master Data ...................................................... 17

Consolidation Interface...............................................19

Consolidation Structure ..............................................24

Consolidation Chart of Accounts....................................46

Unit 3: Data Collection.................................................. 71

Overview of Data Collection.........................................73

Status Management..................................................82

Data Entry..............................................................96

Validation and Postings .............................................126

Unit 4: Currency Translation.........................................151

Currency Translation Methods and Keys.........................152

Translation and Rounding Differences............................159

Unit 5: Interunit Elimination & Consolidation of Investments 201

Interunit Elimination..................................................203

Consolidation of Investment........................................232

Customizing Settings................................................272

Sequence of Activities...............................................284

Equity Method........................................................290

Reclassification.......................................................310

Unit 6: Balance Carry Forward.......................................325

Execution of Carry Forward ........................................326

Appropriation of Carry Forward....................................346

Unit 7: Information System...........................................353

Reports for Consolidation...........................................354

Drilldown Reporting..................................................363

第 6 页 / 共 429 页

Contents AC660

Unit 8: Versions .........................................................399

Version Concept......................................................400

Appendix 1: Appendix ..............................................411

Index .......................................................................419

第 7 页 / 共 429 页

Course Overview

ThecourseintroducestheapplicationandIMGsettingsfortheSAPConsolidation

component. You learn about the main consolidation functions with SAP

Consolidation,aswellastherequiredcustomizingsettings. Thecourseintroduces

the straight-line case across the entire SAP Consolidation component which

includes business workflows and customizing.

Target Audience

Thiscourseisintendedforthefollowing audiences:

• Staff of consolidationaccounting departments

• Project team membersof theIT department

Course Prerequisites

Required Knowledge

• Understanding of theprinciplesofconsolidation

Recommended Knowledge

• SAP01 - SAP R/3 Overview

• AC010- Financial Accounting &Reporting

Course Goals

This course will prepare you to:

• Represent your corporate group using objects in the SAP Consolidation

application

• UseSAPConsolidationtoconsolidatedataforyourcorporategroup

Course Objectives

After completingthiscourse, youwillbeable to:

• Define consolidation groups and units

• Createanduseaconsolidationchart of accounts

• Collect individual financial statement data in SAP Consolidation and

translate it into group currency as required

• Customizeandexecutevariousconsolidationfunctions

vii

第 8 页 / 共 429 页

CourseOverview AC660

SAP Software Component Information

TheinformationinthiscoursepertainstothefollowingSAPSoftwareComponents

and releases:

viii

第 9 页 / 共 429 页

Unit 1

Positioning

Unit Overview

TheunitprovidesanoverviewofSAP’sR/3solutionforEnterpriseControlling

and its functionality. You will learn about the demands placed on modern

consolidation software. You will also learn about the functionality of SAP

ConsolidationanditsintegrationwithotherSAPapplications.

Unit Objectives

After completing thisunit, you will beableto:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline therequirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

Unit Contents

Lesson: Consolidation Strategy Requirement .................................2

Lesson: Enterprise Controlling...................................................5

第 10 页 / 共 429 页

Unit1: Positioning AC660

Lesson: Consolidation Strategy Requirement

Lesson Overview

This lesson will help you to understand the economic necessity of global and

extensivemonitoringofaglobalcompany. Forthisreason,thelessonwillcover

the need for consolidated software. Next, the lesson will introduce you to the

businessstrategytodeveloptheconsolidatedsoftware. Thelessonwillalsocover

theroleof externalfactorstosettheenterprisegoals.

Lesson Objectives

After completingthislesson, you will beable to:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

Business Example

Basedonitseconomicsuccess, thecorporategroup, G1, decidestoimplement

the R/3 component, SAP Consolidation, by the end of this year to secure its

marketposition. Corporatemanagementwantstoprepareconsolidatedfinancial

statementsfortheendofDecemberusingtheR/3Enterprise.

Experienced consultants are required to implement the SAP Consolidation

componentinsuchashortspaceoftime. Yourfirmistryingtowintheconsulting

contract. Youarerequiredtoassesstherequirementsoftheconsolidationstrategy.

Managing a Global Enterprise

Figure 1: Managing a Global Enterprise

第 11 页 / 共 429 页

AC660 Lesson: Consolidation Strategy Requirement

Complex group structures have to be managed effectively. At the same time,

increasingglobalizationrequiresdecentralizedgroupmanagementforindependent

organizational units. Business units that are close to the market have to be

manageddecentrallytoleveragetheirfullmarketpotential.

Decentralization of Responsibility

Figure 2: Strategy - Decentralization of Responsibility

Globalprocessoptimizationallowssynergies(know-how,corecompetencies)to

bedetectedmorequicklyandusedmoreefficientlyinthegroup. Newbusiness

conceptscan betransferred fromoneunittoanother.

Enterprisegoalsareincreasinglybeingset“fromtheoutside”-byshareholders,

forexample. Theexecutiveboardnowhasthetaskofimplementingthesegoals

internally.

Thecorporategroupheadofficecalculateskeyfiguresanddefinesgoalsforthe

strategic business entities. Here, non-monetary success factors also have an

influence: thegrouphastherelevantinformationearlier,andnolongerhastowait

until effects are seen in the income statement.

Formerly, externaland internalaccountingwereusuallyseparate(for example,

duetodifferentvaluationmethods). Nowadays,thegoalistouniteexternaland

internalaccounting,sincetherequirementsforlegalconsolidationalsocomprise

a certain amount of information relevant to cost accounting. The company is

managed in accordance with internal enterprise structures, which can be very

detailed. Thismeansthatextremelyflexiblestructuresarenecessary. Therefore,

SAPConsolidationisnot onlybasedoncompanies.

第 12 页 / 共 429 页

Unit1: Positioning AC660

Lesson Summary

You should now be able to:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

第 13 页 / 共 429 页

AC660 Lesson: Enterprise Controlling

Lesson: Enterprise Controlling

Lesson Overview

This lesson will giveyou an overviewof enterprise controllingand theroleof

StrategicEnterpriseManagement(SEM)tooptimizeenterprisecontrolling. You

willalsolearnabouttherequirementsandfunctionsofSAPConsolidationandits

integration with other SAP applications.

Lesson Objectives

After completingthislesson, youwillbeable to:

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline therequirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

Business Example

Based on its economic success, the corporate group G1 decides to implement

theSAPConsolidationbytheendofthisyeartosecureitsmarketposition. The

corporate management wants to prepare consolidated financial statements for

theendofDecemberusingtheSAPConsolidation. Experiencedconsultantsare

requiredtoimplementtheSAPConsolidationcomponentinsuchashortspanof

time. Your firm is one of the firms trying to win the consulting contract. The

corporatemanagementwantsyoutoexplorethefunctionsofSAPConsolidation.

第 14 页 / 共 429 页

Unit1: Positioning AC660

Strategic Enterprise Management

Figure 3: Strategic Enterprise Management

Successismeasuredbythespeedwithwhichabusinessstrategycanberealized.

To optimize process of enterprise controlling, SAP has developed Strategic

Enterprise Management (SEM).

OneofthemainadvantagesoftheSAPSEMisthesupportitofferstostrategic

managementprocessesbylinkingstrategicandoperationalactions.

Internal control of an enterprise can be carried out using value-oriented

management principles.

Requirements, Functionalities, and Integration of SAP

Consolidation

• Internalandexternalgroupreporting/consolidation

– Projectionofanynumberofparallelhierarchies

– Differentdatacategories,suchasactualdata,budget,andforecast

• Completeautomationofactivities-evencomplexones

– Divestitures,transfers,andchangesinindirectinvestment

• Comprehensive reporting

• International accounting rules

– US GAAP, IAS, and HGB, ...

Automaticcreationofconsolidatedfinancialstatements.

第 15 页 / 共 429 页

AC660 Lesson: Enterprise Controlling

Flexible definition of consolidation methods.

In legal consolidation, the consolidation units are the legally independent

companies. They report their individual financial statementsto the group that

computes the consolidated financial statement.

In management consolidation, the consolidation areas can be profit centers or

business areas.

In an SAP system, the integrated data can be transferred directly from the

transactionsystemstoconsolidation. Duringdatatransfer,youcanworkwiththe

planned andbudget valuesor executesimulations.

Thestandardsystemincludesalltheinternationalconsolidationmethodsthatare

commonly used.

Figure 4: SAP Consolidation: Function

Applications of SAP Consolidation:

• Company consolidation

• Management consolidation

第 16 页 / 共 429 页

Unit1: Positioning AC660

Characteristics:

• Flexible hierarchies of consolidation units

• SAPintegrationforcompanies,businessareas,andprofitcenters

• Toolsforonlineandofflinedataentry: Onlinedataentryfornon-integrated

consolidation units, Microsoft ACCESS PC data entry program for

subsidiarieswithoutSAPsoftware,andflexibleuploadfordatafromexternal

systems or through Web Access

• Statusmonitorsfordatacollectionandconsolidation

• Powerful reporting functions and drilldown to the transaction SAP

components

• InteractiveExcellinktotheconsolidationdatabaseforreporting

• International rulesfor reporting(US-GAAP, IAS)

• Versionsfordatacategories,simulation,andplanning

Figure 5: Integration of SAP Consolidation

SAPConsolidationisintegratedwithintheSAPsystemintwoways:

• Applicationsthat handleday-to-daybusinesstransactionstransfer datato

SAPConsolidationinasummarizedform. Consolidationreportingsupports

a drilldown back to these applications.

• ConsolidateddataistransferredtotheExecutiveInformationSystem,which

collects highly summarized data from all the enterprise areas, including

logisticsandhumanresources,foronecompanyorthegroupasawhole.

SAP Consolidation supports the consolidation of any “consolidation units”,

providedtherequiredfinancialdataissupplied. UsingSAPintegration,datacan

bemadeavailablefortheconsolidationofcompanies(legallyindependentunits),

第 17 页 / 共 429 页

AC660 Lesson: Enterprise Controlling

businessareas(subdivisionsofcompaniesfor thepurposeof external segment

reporting),andprofitcenters(areasofresponsibilityinsideoracrosscompanies).

IfthetransactionapplicationsandtheConsolidationsystemareallinthesame

client of the same system, data can be transferred to the Consolidation system

onlineinreal-time. Additionally, datacanbetransferredbyperiodicextractor

rollup from other SAP systems.

第 18 页 / 共 429 页

Unit1: Positioning AC660

Lesson Summary

You should now be able to:

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline the requirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

第 19 页 / 共 429 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline therequirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

第 20 页 / 共 429 页

UnitSummary AC660

第 21 页 / 共 429 页

AC660 Test Your Knowledge

Test Your Knowledge

1. Businessunitsclosetothemarkethavetobemanaged tobe

able to achieve their complete potential.

Fillintheblankstocompletethesentence.

2. Whatistheneedtounifyinternalandexternalaccounting?

3. Howisdatafromthevariouspartialinformationsystemsinsideandoutside

ofthecompanygroupedtogethertoformauniformdimension?

4. StrategicEnterpriseManagement(SEM)consistsofBPS,CPM,SRM,BCS,

and BIC components.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

5. Theconsolidationgroupsformanagementconsolidationcanbeprofitcentres

or .

Fillintheblankstocompletethesentence.

6. Which of the following statements is incorrect with regard to the

characteristics of SAP Consolidation?

Choosethecorrectanswer(s).

□ A Flexiblehierarchiesofconsolidationunitsarepossible.

□ B SAPintegrationforcompanies,businessareas,andprofitcenters.

□ C No statusmonitorsfor datacollection.

□ D InteractiveExcellinktoconsolidationdatabaseforreporting.

□ E Powerful reporting function.

第 22 页 / 共 429 页

TestYourKnowledge AC660

7. ConsolidateddataistransferredtotheExecutivInformationSystem,which

highlysummarizeddatafromall enterpriseareasfor one

company or the group as a whole.

Fillintheblankstocompletethesentence.

第 23 页 / 共 429 页

AC660 Test Your Knowledge

Answers

1. Business units close tothe market haveto bemanaged locally to be able

to achieve their complete potential.

Answer: locally

2. Whatistheneedtounifyinternalandexternalaccounting?

Answer: As the legal consolidation requirements sometimes include

informationrelevanttocostaccounting,itisrequiredtounifyexternaland

internal accounting.

3. Howisdatafromthevariouspartialinformationsystemsinsideandoutside

ofthecompanygroupedtogethertoformauniformdimension?

Answer: Dataisheterogeneously structured. Asa result, thedatabaseis

dividedintodataareasthatareself-containedfromthebusinesspointofview.

4. StrategicEnterpriseManagement(SEM)consistsofBPS,CPM,SRM,BCS,

and BIC components.

Answer: True

SEM optimizes enterprise controlling using BPS, CPM, SRM, BCS and

BIC components.

5. Theconsolidationgroupsformanagementconsolidationcanbeprofitcentres

or business areas.

Answer: business areas

6. Which of the following statements is incorrect with regard to the

characteristics of SAP Consolidation?

Answer: C

Statusmonitorsareprovidedfordatacollectionandconsolidation.

7. ConsolidateddataistransferredtotheExecutivInformationSystem,which

collectshighlysummarizeddatafromallenterpriseareasforonecompany

or the group as a whole.

Answer: collects

第 24 页 / 共 429 页

Unit1: Positioning AC660

第 25 页 / 共 429 页

Unit 2

Master Data

Unit Overview

The focusof this unit istoprovidean overviewof theuser interface. You will

learnhowtodefineconsolidationunitsandgroups,inordertomodelthecorporate

structure in the SAP System Consolidation. You will also learn how to work

with theconsolidation chart of accounts, its financial statement items, and the

breakdowncategory, tocharacterizethedifferentsubitems.

Unit Objectives

After completing thisunit, you will beableto:

• Explainhowglobalsessionparametersenableauser-friendlyenvironment

• DescribetheuseofhierarchicaldisplaysintheSAPConsolidationinterface

• ExplainthefunctionoflistprocessorintheConsolidationinterface

• State the role of the SAP standard functions and multilevel customizing

for a user-friendly interface

• Describethe purposeand use of Dimension

• Explain how dimension can be used

• Explainhowtoworkwithaledgerforaconsolidationgroup

• Evaluateandstatetheadvantageofusingaversionforconsolidation

• Describeaconsolidationunitandaconsolidationgroup

• Specifythepurposeanduseofconsolidationchartsofaccounts

• Describe the financial statements items

• Explain the breakdowncategoryand subitems

• Explainhowcharacteristicsstructurethetransactiondataofconsolidation

• Describe the function of user-definedattributes for providing additional

information about the consolidation unit

• Create customer-specific sub-assignments as custom characteristics and

assign an item

Unit Contents

Lesson: Consolidation Interface ...............................................19

第 26 页 / 共 429 页

Unit2: MasterData AC660

Lesson: Consolidation Structure...............................................24

Exercise 1: Consolidation Structure ......................................33

Lesson: Consolidation Chart of Accounts ....................................46

Exercise 2: Exercises for Financial Statement Chart of Accounts,

Financial Statement Items..................................................55

第 27 页 / 共 429 页

AC660 Lesson: Consolidation Interface

Lesson: Consolidation Interface

Lesson Overview

Thislessonwillgiveyouanoverviewof theConsolidationuser interface. You

willlearnabout globalsessionparameters, hierarchicaldisplays, listprocessor,

andtheuseoftheSAPstandardtoolinSAPConsolidation.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Explainhowglobalsessionparametersenableauser-friendlyenvironment

• DescribetheuseofhierarchicaldisplaysintheSAPConsolidationinterface

• ExplainthefunctionoflistprocessorintheConsolidationinterface

• State the role of the SAP standard functions and multilevel customizing

for a user-friendly interface

Business Example

ThegroupG1planstoconsolidatebytheendofthisyear. Youhavetopresentthe

basicworkingsoftheConsolidationinterfacetothemanagement.

Working with Consolidation Interface

• Global session parameters for each user

• Accesstomanytransactionsfromhierarchicaldisplays

• Identicalpresentationtechniquesforalllists,includingdrilldownfunctions

(list processor)

• Use of standard SAP tools

– Planning processor

– Validation

– Report Writer/Painter

– Drilldown Reporting

• Multi-levelCustomizingkeepstheunnecessaryfunctionsoutofsight

Global parameters are important settings for SAP Consolidation that typically

remain the same for a work session.

Both the enterprise structure and the consolidation chart of accounts used are

builtupinamulti-level. Examplesofitemhierarchiesareincomestatementand

cash flow statement.

Withthehelpofthelistprocessor,youreceiveclearlyarrangedlists,thedisplays

of which you can explain in stages (Drilldown).

第 28 页 / 共 429 页

Unit2: MasterData AC660

The SAP standard tools are used:

• Youcanstructurethedataentrylayoutswiththeplanningprocessor.

• Validationruleschecktheconsistencyoftransferreddata,theaccuracyofthe

currencytranslation,andtheconsolidationactivities.

• You can create reports quickly and evaluate any data with the Report

Writer/Painter and drilldown reporting tools.

TheunnecessaryCustomizingfunctionsarehidden. Forexample,whenyouselect

theaccountingtechnique,purchasemethod,thefurtherconfigurationsettingsfor

the equity method are hidden.

Figure 6: Global Session Parameters

GlobalparametersareimportantsettingsforConsolidationthattypicallyremain

the same for a work session.

These parameters are saved for a particular user when the user logs off. The

parameters are automatically used when the user logs back on. However, the

parameters can bechanged asand when required.

Whenyouruna function, theinformation savedasyour global parametersare

either proposed by default or set in the background in which they cannot be

specified directly for the function.

Theglobalparametersaredisplayedinastatusrowatthetopofeveryscreenin

Customizing and the consolidation functions.

In Customizing, the parameters that are relevant for the current maintenance

appearinadifferentcolor. Forexample,themaintenanceoffinancialstatement

itemsisdependentontheconsolidationchartofaccounts,butnotontheversion.

第 29 页 / 共 429 页

AC660 Lesson: Consolidation Interface

Figure 7: Hierarchical Displays

YoucanaccessallfunctionsfromtheSAPConsolidationapplicationmenu.

Within these hierarchies, you can perform such functions as maintain master

data, start andmonitor datacollection, consolidationfunctions(monitors), and

generate reports.

Manycomplexfunctions,suchastheentryofadditionaldatafortheconsolidation

ofinvestments,andtheassignmentofconsolidationofinvestmentsmethods,also

usehierarchical displayswithsimplenavigation.

第 30 页 / 共 429 页

Unit2: MasterData AC660

Figure 8: The List Processor

The list processor is a reporting tool available for consolidation purpose. It is

used to display and print information and for interactive drilldown reporting

from a generated list.

Theexpandandcollapsefunctionsinthelistheadercanbeusedforalltheareasin

themainbodyofthelist. Youcandrilldownstep-by-steporskiplevels.

Theexpandandcollapsefunctioninthemainbodyalsoenablesyoutodrilldown

step-by-step or skip levels.

F1Helpisavailableforallthefieldsinthelistheaderandthemainbodyofthelist.

Youcanusethefilterfunctiontorestrictthelisttocertaincharacteristicvalues.

For example, if you have runinterunit elimination for the entire consolidation

groupandwanttoseetheresultsforonlyoneconsolidationunitinspecial,you

can use the filter function.

Thereport-reportinterfaceenablesyoutoaccessotherreportsinConsolidation.

Severallinksarepredefined. Theotherscanbedefinedbyusers.

ThesearchfunctionisidenticaltothestandardSAPlistsearch. Aspecialfunction

isavailabletosearchforerrormessages. Thedateandtimeareaddedwhenalist

isprinted. Afunctiontodefinepagebreaksisavailableaswell.

第 31 页 / 共 429 页

AC660 Lesson: Consolidation Interface

Lesson Summary

You should now be able to:

• Explainhowglobalsessionparametersenableauser-friendlyenvironment

• DescribetheuseofhierarchicaldisplaysintheSAPConsolidationinterface

• ExplainthefunctionoflistprocessorintheConsolidationinterface

• State the role of the SAP standard functions and multilevel customizing

for a user-friendly interface

第 32 页 / 共 429 页

Unit2: MasterData AC660

Lesson: Consolidation Structure

Lesson Overview

Thislessonshowsyouhowtodefinetheconsolidationunitandhowindividual

unitscanbegroupedtogetherinconsolidationgroups. Youwilllearnaboutthe

purposeanduseof dimension. Thislessonwillalsoexplain howto workwith

a ledger and versions.

Lesson Objectives

After completingthislesson, you will beable to:

• Describethepurpose and useof Dimension

• Explain how dimension can be used

• Explainhowtoworkwithaledgerforaconsolidationgroup

• Evaluateandstatetheadvantageofusingaversionforconsolidation

• Describeaconsolidationunitandaconsolidationgroup

Business Example

Thegroup,G1,planstointroducethecomponentConsolidationoftheSAPsystem

bytheendofthisyear. Youarerequiredtodefineconsolidationunitsandgroups

torepresentthestructureofyourcorporategroupintheSAPsystem.

Dimensions

Figure 9: Consolidation Units and Groups

第 33 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Dimensionsarespecificviewson groupreporting. Theyincludeconsolidation

types,suchascompanyconsolidation,businessareaconsolidation,orprofitcenter

consolidation.

Inadimension,youdefinethegroupstructureasahierarchyofconsolidationunits

andgroups. Youcanmanageseveraldimensionsinparallelinthesystem.

Thecompanyformsthebasisforthegenerationofconsolidationunits.

Theconsolidationunitisthesmallestelementofthegroupstructureforwhicha

complete consolidation can take place.

Thebusinessobjectconsolidationgroupisauser-definedgroupofconsolidation

unitscreatedforconsolidationandreportingpurposes.

Figure 10: Parallel Hierarchies

In a dimension, hierarchies are structured sets of consolidation units and

consolidationgroups. Theyaredefinedbytheirtop-mostconsolidationgroup. As

aresult,agivendimensioncanrepresentoneormoreconsolidationtypes.

Anyconsolidationunitorgroupcanexistinanynumberofhierarchies.

第 34 页 / 共 429 页

Unit2: MasterData AC660

Figure 11: Variable Hierarchy Depth

You can create anynumber of hierarchy levels.

The number of hierarchy levels can vary in the different branchesof the same

hierarchy.

IntheabovescenariowithdatafromProfitCenterAccounting,consolidationunits

arecombinations of company and profit center.

WhenyouusetheconsolidationwithintegrationtoProfitCenterAccounting,then

yougeneratetheconsolidationunitsandgroupsfromtheorganizationalunitsof

operational applications.

Theconsolidationgroupsarederivedfrom the profit centersandthehierarchy

nodes. Theconsolidationunitisformedfromtheprofitcenterandthecompany.

第 35 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Ledger

Figure 12: Ledger

Contains the transaction figures and documents that show the changes in the

valuesandquantitiesthataretheoutcomeofaccountingtransactions. Thevalues

ofthetransactionfiguresaresavedin16periodsandinoneperiodforthebalance

carriedforward. Youassignaledgertoeachconsolidationgroupinthemaster

recordoftheconsolidationgroup. ThedataintheECMCTtotalstablecanbe

managed in three currencies:

ThedataintheECMCTtotalstablecanbemanagedinthreecurrencies:

• Transaction currency

• Currency of the consolidation unit

• Ledger currency: The ledger currency indicates the currency of the

consolidation group.

Example:

YouwanttoconsolidatetwoconsolidationgroupsinUSDandEURO.Youneed

two ledgersfor this purpose. At the grouplevel, youcopy the valuesfrom the

EURO ledger into the USD ledger.

SAPdeliversthestandard ledger"1C"for consolidation. Thisledger isnot for

usein alivecustomersystem. Pleasecreateanewledger usingledger"1C"as

a copy template.

第 36 页 / 共 429 页

Unit2: MasterData AC660

Versions

Figure 13: Versions

Valuationscandifferdependingonwhethertheyarecarriedoutfromthepointof

viewoflocaltradelaworforthecorporatevaluationofthegroupdata.

In Consolidation, the versions serve to maintain separate datasets in the

consolidationdatabasesothatalternativeconsolidationscanbemanaged. This

meansthatvariousdatacategories,suchasactual,plan,andbudgetdata,canbe

maintained and consolidated.

You can also carry out simulations on the basis of different exchange rates or

changes in the group structure.

Aconsolidationversioniscomposedofspecialversions,whicharemethodsand

tasksthat cover thevariousareasof consolidation. This enables you to define

variousconsolidationversionsthatdifferinonlyoneorafewareas,butotherwise

indicate the same special version.

第 37 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Figure 14: Consolidation Group, Ledger, Version

You assign a ledger to each consolidation group in the master record of the

consolidation group.

The system saves the assignment in a special ledger version. This means that

you can assign different ledgers, and similarly different consolidation group

currencies,toaconsolidationgroupindifferentconsolidationversions.

第 38 页 / 共 429 页

Unit2: MasterData AC660

Consolidation into Units and Groups

Figure 15: Consolidation Unit

Theconsolidationunitisthesmallestelementofthegroupstructureforwhicha

complete consolidation can take place.

This Business Object is dimension-dependent and can have different

characteristics, such as company, business area within a company, and profit

center within a company.

Someofthemasterdataandcontrolparametersarevalidonlyinconjunctionwith

otherdata. Thelocalcurrencyandthefinancialdatatypesaredependentonthe

fiscalyear effective, andthetranslationmethodisdependentonthetranslation

version.

第 39 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Figure 16: Consolidation Group

Aconsolidation groupisauser-defined combinationofmultiple consolidation

units or consolidation groups for consolidation and reporting purposes. It

represents the structure of the group.

Consolidationgroupsandconsolidationunitsaredependentonthedimension.

Each consolidationunit can beincluded indifferent consolidationgroups, and

eachconsolidationgroup,inturn,canbeincludedindifferenthierarchies.

Sinceconsolidationgroupsaredimension-dependent,themasterdatacreatedfor

theconsolidationgroupsisvalidonlyintherelevantdimension.

第 40 页 / 共 429 页

Unit2: MasterData AC660

第 41 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Exercise 1: Consolidation Structure

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define the global parameters

• Check the global system settings

• Createmasterrecordsforconsolidationgroups/consolidationunits

• Define a consolidation group hierarchy

• Insert master data in a hierarchy

Business Example

ThegroupG1planstointroducethecomponentConsolidationoftheSAPsystem

by the end of 2002.

Corporate management wantsto prepareconsolidated financial statements for

December 2002 using the SAP system.

GroupG1requiressupportfromexperiencedSAPconsultants. Themanagement

of your company creates a prototype for a presentation to be presented to the

steering committee of group G1.

The competitors will be judged on the outcome of this presentation, and the

contractforimplementationofSAPConsolidationawardedaccordingly.

You have been asked by the management of your consulting firm to build a

prototypewithacolleaguewithinthenext5days.

Task 1:

Define a dimension

1. Define a dimension using the code, XY.

XY = 50 + your group number

Example: Group 14 uses the dimension, 64.

What you enter:

a) Short andmediumtext for thedimension:

b) Dimension, XY

c)Consolidationunit/consolidationgroup: Fieldlength,3.

Continued on next page

第 42 页 / 共 429 页

Unit2: MasterData AC660

d) Define all the output fields for the consolidation units and groups as

optional in the screen selection settings.

Task 2:

Ledger:

1. Ledger:

Youarecreatingconsolidatedstatementsinthecurrency,USD,andwillbe

using theledger, US, which isalreadycreated.

CheckthattheledgercurrencyofledgerUSmatchestheoneusedinyour

prototype, which is USD.

Findoutwhichcurrencyisusedinthestandardledger,1C.

Task 3:

Global session parameters:

1. Define the global session parameters:

a) Dimension XY (see section Task 1)

b) Ledger “US” in USD

c)Actualversion100(providedinthestandardsystem)

d) Period 012, 2002

e) (Group G1 will consolidate in the implementation year––period

012/2002––using the SAP system.)

f)ChartofaccountsXY(whereXY=50+yourgroupnumber),whichhas

already been defined by your colleague.

Task 4:

DefinehierarchyH1(H1Group##)forstatutoryconsolidation.

1. DefinehierarchyH1 for statutoryconsolidation.

a) Assign the consolidation groups (CGs) and consolidation units (CUs)

A-Etothishierarchyasrequired,usingtheinformationonthestructureof

corporategroupG1,asprovidedbythesteeringcommittee.

b)CreateconsolidationunitsA,B,C,DandE:ConsolidationunitAbelongs

toCGG1; ConsolidationunitsB-EbelongtoCGG2.

c)Thesteeringcommitteehasprovidedyouwiththefollowinginformation

to help you create master data:

Enterprise Structure

Continued on next page

第 43 页 / 共 429 页

AC660 Lesson: Consolidation Structure

- CU A, B, C, E: Corporate office USA

- CU D: Corporate office Germany

- Local currency: The country’scurrency

Note: CountrycurrencyforGermany: EUR

- CU A: Parent company of CG G1

- CU B: Parent company of CG G2.

Note: Tolocatetheparent indicator, inthemasterdatarecordof

the CG go to Assignments tab.

Data Transfer Methods

-ConsolidationunitsB,C,D,andEdonotuseanSAPsystem,andtherefore

reporttheirfinancialdatabysendinganMSExcelfiletothecorporateoffice.

- Consolidation unit A sendsits dataonpaper to the group headquarters,

where the data is entered manually.

Fiscal year variant

-Allunitsuseafiscalyear(FY)variant,whichconsistsofacalendaryear

and 4 special periods (K4).

Note: You define the FY variant in Consolidation Group

MaintenancebyselectingGoto→FYvariant.

Consolidation frequency

Consolidation groupsG1 and G2 disclose consolidated statementsat the

end of each quarter.

Generate sets before exiting the hierarchy.

2. Demonstratethenavigationwithinthenewhierarchy:

FullycollapsethehierarchyandusethesearchfunctiontofindconsunitA.

.FocusthehierarchydisplayonconsgroupG2andthenbackonG1.

3. Createa“dummy”defaultpartnerunitforyourdimension:

A default consolidation unit must be established for each dimension.

This default CU is required for the data collection task (Unit 4) and the

ConsolidationofInvestmenttask(Unit6)tobesuccessful.

- Create a new consolidation unit “999”by copying consolidation unit

“999”from dimension 50. This will be used as a default partner unit for

your dimension

Continued on next page

第 44 页 / 共 429 页

Unit2: MasterData AC660

-Assignthisnewconsolidationunit“999”toyourdimensionasthedefault

partner unit.

第 45 页 / 共 429 页

AC660 Lesson: Consolidation Structure

Solution 1: Consolidation Structure

Task 1:

Define a dimension

1. Define a dimension using the code, XY.

XY = 50 + your group number

Example: Group 14 uses the dimension, 64.

What you enter:

a) Short andmediumtext for thedimension:

b) Dimension, XY

c)Consolidationunit/consolidationgroup: Fieldlength,3.

d) Define all the output fields for the consolidation units and groups as

optional in the screen selection settings.

a) Defining a dimension

MenuPath: Tools→Customizing→IMG→EditProject→SAP

Reference IMG → Enterprise Controlling → Consolidation →

MasterData→DefineDimensions→CreateDimension

Donotuseanother dimensionasatemplate.

ChooseEnter. OntheDimensionCreatescreen,enterDimensionXY

inthe Short text and Medium textfields.

SubstituteXYwith50+your groupnumber.

Enter 03 in the fields Length of consolidation unit and Length of

consolidation group.

ChooseScreenselectionCUandScreenselectionCGtogotothedetail

screens. Enter1forallthefieldstospecifythattheyareoptional. Use

the green arrow to come back out.

Save your entries.

Task 2:

Ledger:

1. Ledger:

Youarecreatingconsolidatedstatementsinthecurrency,USD,andwillbe

using the ledger, US, whichisalreadycreated.

Continued on next page