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

第 1 页 / 共 529 页

AC660

EC-CS Consolidation Functions

mySAP Financials

Date

Training Center

Instructors

Education Website

Instructor Handbook

Course Version: 2005 Q1

Course Duration: 5 Day(s)

Material Number: 50071532

Owner: Klaus Wirthmann (D032741)

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

第 2 页 / 共 529 页

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 页 / 共 529 页

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 页 / 共 529 页

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 页 / 共 529 页

Contents

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

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

Course Objectives ..................................................... ix

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

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

Enterprise Controlling ..................................................7

Unit 2: Master Data ...................................................... 19

Consolidation Interface...............................................21

Consolidation Structure ..............................................29

Consolidation Chart of Accounts....................................56

Unit 3: Data Collection.................................................. 87

Overview of Data Collection.........................................89

Status Management.................................................100

Data Entry.............................................................118

Validation and Postings .............................................154

Unit 4: Currency Translation.........................................187

Currency Translation Methods and Keys.........................189

Translation and Rounding Differences............................203

Unit 5: Interunit Elimination & Consolidation of Investments 253

Interunit Elimination..................................................255

Consolidation of Investment........................................290

Customizing Settings................................................336

Sequence of Activities...............................................353

Equity Method........................................................361

Reclassification.......................................................384

Unit 6: Balance Carry Forward.......................................405

Execution of Carry Forward ........................................406

Appropriation of Carry Forward....................................426

Unit 7: Information System...........................................435

Reports for Consolidation...........................................437

Drilldown Reporting..................................................449

第 6 页 / 共 529 页

Contents AC660

Unit 8: Versions .........................................................495

Version Concept......................................................496

Appendix 1: Appendix ..............................................509

Index .......................................................................517

第 7 页 / 共 529 页

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 Duration Details

Unit 1:

Positioning

Consolidation Strategy Requirement 20 Minutes

Enterprise Controlling 30 Minutes

Unit 2: Master Data

Consolidation Interface 20 Minutes

Consolidation Structure 40 Minutes

Exercise 1: Consolidation Structure 20 Minutes

Consolidation Chart of Accounts 50 Minutes

Exercise 2: Exercises for Financial Statement Chart

of Accounts, Financial Statement Items 15 Minutes

Unit 3: Data Collection

Overview of Data Collection 20 Minutes

Exercise 3: Exercise for Entering Data in Financial

Tables 15 Minutes

Status Management 20 Minutes

vii

第 8 页 / 共 529 页

CourseOverview AC660

Exercise 4: Data Monitor 10 Minutes

Data Entry 50 Minutes

Exercise 5: Online Data Entry 30 Minutes

Exercise 6: Flexible Upload 30 Minutes

Validation and Postings 40 Minutes

Exercise 7: Validation 15 Minutes

Exercise 8: Posting 30 Minutes

Unit 4: Currency Translation

Currency Translation Methods and Keys 20 Minutes

Translation and Rounding Differences 50 Minutes

Exercise 9: Currency Translation 10 Minutes

Exercise 10: Validation II Minutes

Unit 5: Interunit Elimination & Consolidation of Investments

Interunit Elimination 40 Minutes

Exercise 11: Interunit Elimination 20 Minutes

Consolidation of Investment 50 Minutes

Exercise 12: Consolidation of Investments –

Methods 50 Minutes

Exercise 13: Consolidation of Investments -

Activities in the Consolidation of Investments 30 Minutes

Customizing Settings 50 Minutes

Sequence of Activities 30 Minutes

Equity Method 50 Minutes

Exercise 14: Consolidation of Investments – Equity

Method 30 Minutes

Exercise 15: Validation 20 Minutes

Reclassification 20 Minutes

Unit 6: Balance Carry Forward

Execution of Carry Forward 30 Minutes

Exercise 16: Executing Carry Forward 15 Minutes

Appropriation of Carry Forward 20 Minutes

Unit 7: Information System

Reports for Consolidation 20 Minutes

Exercise 17: Journal Entry Reporting 20 Minutes

Drilldown Reporting 50 Minutes

Exercise 18: Drilldown Reporting 20 Minutes

Unit 8: Versions

Version Concept 40 Minutes

viii

第 9 页 / 共 529 页

AC660 Course Overview

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

SAP Software Component Information

TheinformationinthiscoursepertainstothefollowingSAPSoftwareComponents

and releases:

Youshouldhaveattendedthecourse,AC660,atleastonce,andreadthemanual

and the SAP Consolidation documentation. In addition, you should have a

commandovercommercialknowledgeintheconsolidationarea. Itisessentialthat

youbecompletelyfamiliar withconsolidationfunctionsandhaveanextensive

understanding of customizing.

Youshouldalsohaveanunderstandingofthefollowing:

• Basicknowledgeofdrill-downreporting,ReportPainter,andReportWriter.

• Basicknowledgeofincomestatementbycostofsalesaccounting(Working

knowledge of US GAAP and international legal reporting requirements

is helpful).

• Knowledge of theFI-LCcomponentishelpful.

Literature:

• KarlheinzKüting,Claus-PeterWeber: DerKonzernabschluβ,Stuttgart,1997

• Adolf G. Coenenberg: Jahresabschluβ und Jahresabschluβanalyse,

Landsberg/Lech ,1997

• BasicknowledgeinCOandlogistics,drilldownreporting

• Functions in detail: SAP Consolidation

第 10 页 / 共 529 页

CourseOverview AC660

Itisrecommendedthatyouattendthefollowingcoursesasapreparationtoteach

this course.

• AC660SAPConsolidation: ConsolidationFunctions

• AC010 Introduction to External Accounting

• AC665 SAP Consolidation: Integration

Thefollowingonlinehelpisrecommendedaspreparation

• R/3 Library → AC Accounting → EC Enterprise Controlling → EC

Consolidation

• IMG documentation

• IDES Processes of SAP Consolidation

ItwillhelpifyouhaveknowledgeofFI,includinggeneralledgeractivitiesand

the interfaces between FI and SAP Consolidation and SAP Consolidation and

CO-PCA.

第 11 页 / 共 529 页

Unit 1

Positioning

GivetheparticipantsanoverviewofSAP’sR/3solutionforEnterpriseControlling

anditsfunctionality. Telltheparticipantsaboutthedemandsplacedonmodern

consolidation software. Give them an overview of the functionality of SAP

ConsolidationanditsintegrationwithotherSAPapplications.

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...................................................7

第 12 页 / 共 529 页

Unit1: Positioning AC660

Lesson: Consolidation Strategy Requirement

Lesson Duration: 20 Minutes

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

Explainhowandwhyincreasingglobalizationdemandsdecentralizedcorporate

management for independent organizational units. Next, provideaninsight of

decentralizationofresponsibilityasthestrategyadoptedtoachieveglobalprocess

optimization.

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

Explain how to manage business in different countries and markets. Explain

thatcomplexcorporatestructureshavetobemanagedeffectively. At thesame

time,increasingglobalizationdemandsdecentralizedcorporatemanagementfor

independentorganizationalunits. Detailthefactthatnear-marketbusinessunits

havetobemanagedlocallyinordertofullyachievetheirmarketpotential.

第 13 页 / 共 529 页

AC660 Lesson: Consolidation Strategy Requirement

Figure 1: Managing a Global Enterprise

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

Describe how to advance the group’s global strategy by applying

management-oriented corporate structure in addition to legal structure and

target-based management.

Globalprocessoptimizationallowssynergies,whichmeansknow-howandcore

competencies, to be detected quickly and used efficiently in the group. New

businessconceptscanbetransferredfromoneunittoanother.

Enterprisegoalsareincreasinglybeingsetfromtheoutsidebyshareholders. The

executiveboardhasthetasktoimplementthesegoalsinternally.

Thecorporategroupheadofficecalculatesthekeyfiguresanddefinesthegoals

forthestrategicbusinessentities. Here,non-monetarysuccessfactorsalsohavean

influence. Thegrouphastherelevantinformationbeforehand,anddoesnothave

towaituntiltheeffectsareseenintheincomestatement.

Formerly, external and internal accounting are normally separate procedures

duetodifferentvaluationmethods. Nowadays,thegoalistouniteexternaland

internalaccountingbecausetherequirementsforlegalconsolidationalsocontain

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

第 14 页 / 共 529 页

Unit1: Positioning AC660

managedinaccordancewiththeinternalenterprisestructures,whichcanbevery

extensive. Thismeansthatextremelyflexiblestructuresarerequired. Asaresult,

SAPConsolidationisnot based on companiesonly.

Figure 2: Strategy - Decentralization ofResponsibility

Globalprocessoptimizationallowssynergies(know-how,corecompetencies)to

bedetectedmorequicklyandusedmoreefficientlyinthegroup. Newbusiness

conceptscanbetransferredfromoneunittoanother.

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 theincome statement.

Formerly, externalandinternal accountingwereusuallyseparate(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,

SAPConsolidation isnotonlybasedoncompanies.

第 15 页 / 共 529 页

AC660 Lesson: Consolidation Strategy Requirement

Facilitated Discussion

Todiscusstherequirementsoftheconsolidationstrategy

Discussion Questions

Usethefollowingquestionstoengagetheparticipantsinthediscussion.Feelfree

to use your own additional questions.

Discusstherequirementsoftheconsolidationstrategy.

第 16 页 / 共 529 页

Unit1: Positioning AC660

Lesson Summary

You should now be able to:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

第 17 页 / 共 529 页

AC660 Lesson: Enterprise Controlling

Lesson: Enterprise Controlling

Lesson Duration: 30 Minutes

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

DescribehowSAPConsolidationisembeddedinenterprisecontrolling. Explain

the tools that SEM provides to simulate, analyze, monitor, and communicate

strategic enterprise aspects. Briefly present each of the SEM components.

Elaborateontherequirements,functions,andintegrationofSAPConsolidation.

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.

Strategic Enterprise Management

SEMprovidesenterprisemanagementwiththetoolsforthesimulation,analysis,

monitoring,andcommunicationofstrategicenterpriseaspects.

ExplainthefunctionofeachcomponentofSEMtooptimizeenterprisecontrolling.

第 18 页 / 共 529 页

Unit1: Positioning AC660

SEM-BCS ensures that consolidated data can be used as the basis for SEM

reporting.

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

Discussindetailtherequirements,applications, characteristics, andintegration

of SAP consolidation.

Consolidation: Requirements

Automaticgenerationofconsolidatedfinancialstatements

Flexible definition of consolidation methods

In legal consolidation, the consolidation units are the legally independent

companies. Theyreporttheirindividualfinancialstatementstothegroup,which

is usedto calculatethegroupfinancial statements.

第 19 页 / 共 529 页

AC660 Lesson: Enterprise Controlling

The consolidation groups for management consolidation can be profit centers

or business areas.

Integrated data from the operative systems can be transferred directly to the

consolidation module in an SAP system.

Intheprocess,youcanworkwithplannedorbudgetvaluesorperformsimulations.

All standard international consolidation methods are supplied in the standard

configuration.

Consolidation Functions

Youcanusethistopictogiveabriefoverviewoftheconsolidationfunctionsand

stress the emphasis of the AC660 course.

Integration of SAP Consolidation

SAPconsolidatesattheorganizationalunitscompany,businessarea,andprofit

center, andisoptimallyintegratedwiththesesystems.

Iftheoperativeapplicationsandtheconsolidation system arecontained inone

system and client, thenthe datacan be transferred to theconsolidation system

online.

Inaddition,datacanbetakenfromexternalsystemsasaperiodicextractorrollup.

• Internalandexternalgroupreporting/consolidation

– Projectionofanynumberofparallelhierarchies

– Differentdatacategories,suchasactualdata,budget,andforecast

• Completeautomationofactivities-evencomplexones

– Divestitures,transfers,andchangesinindirectinvestment

• Comprehensive reporting

• International accounting rules

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

Automaticcreationofconsolidatedfinancialstatements.

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.

第 20 页 / 共 529 页

Unit1: Positioning AC660

Thestandardsystemincludesalltheinternationalconsolidationmethodsthatare

commonly used.

Figure 4: SAP Consolidation: Function

Applications of SAP Consolidation:

• Company consolidation

• Management consolidation

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

第 21 页 / 共 529 页

AC660 Lesson: Enterprise Controlling

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),

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.

第 22 页 / 共 529 页

Unit1: Positioning AC660

Facilitated Discussion

Todiscussthefunctionsof enterprise controlling

Discussion Questions

Usethefollowingquestionstoengagetheparticipantsinthediscussion.Feelfree

to use your own additional questions.

Discussthefunctions of enterprisecontrolling

第 23 页 / 共 529 页

AC660 Lesson: Enterprise Controlling

Lesson Summary

You should now be able to:

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline therequirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

第 24 页 / 共 529 页

UnitSummary AC660

Unit Summary

You should now be able to:

• Evaluatetheneed for aconsolidated software

• Evaluatetheneedtounitetheinternalandexternalaccounting

• DescribehowSAPConsolidationisembeddedinenterprisecontrolling

• ExplainhowSEMoptimizesenterprisecontrolling

• Outline the requirements for consolidation

• IdentifytheapplicationsandcharacteristicsofSAPConsolidation

• ExplaintheintegrationofSAPConsolidationwithotherSAPapplications

第 25 页 / 共 529 页

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.

第 26 页 / 共 529 页

TestYourKnowledge AC660

7. ConsolidateddataistransferredtotheExecutivInformationSystem,which

highlysummarizeddatafromall enterpriseareasfor one

company or the group as a whole.

Fillintheblankstocompletethesentence.

第 27 页 / 共 529 页

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

第 28 页 / 共 529 页

Unit1: Positioning AC660

第 29 页 / 共 529 页

Unit 2

Master Data

Explain that to perform a consolidation, the units to be consolidated must be

definedinthesystem,andtheindividualunitshavetobegroupedtogetherinthe

consolidationgroups. Further, theFSchart of accountsmust bedefinedwhose

individualfinancialstatementitemsthenformthefoundationforentry,posting,

andevaluation. Start by providinganoverviewoftheSAPConsolidation user

interface. Describehowtodefineconsolidationunitsandgroups,tomodeltheir

corporatestructureintheSAPsystem. Explainhowtoworkwiththeconsolidation

chartofaccounts, itsfinancialstatementitems, andthebreakdowncategory,to

characterize the different subitems.

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

第 30 页 / 共 529 页

Unit2: MasterData AC660

• Describe the financial statements items

• Explain the breakdown categoryand subitems

• Explainhowcharacteristicsstructurethetransactiondataofconsolidation

• Describe the function of user-defined attributes 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 ...............................................21

Demonstration: Consolidation Task Level Menu........................25

Lesson: Consolidation Structure...............................................29

Demonstration: Creating a Dimension and the Existing Consolidation

Group Hierarchy.............................................................32

Demonstration: Master Record Ledger, Version, Consolidation Unit,

Consolidation Group, and Hierarchy......................................38

Exercise 1: Consolidation Structure ......................................43

Lesson: Consolidation Chart of Accounts ....................................56

Demonstration: Demonstration of Financial Statement Items and

Breakdown Categories......................................................61

Demonstration: Demonstration of Account Assignment Information .62

Demonstration: Demonstration of custom characteristics in the items

and cons groups. ............................................................63

Exercise 2: Exercises for Financial Statement Chart of Accounts,

Financial Statement Items..................................................71

第 31 页 / 共 529 页

AC660 Lesson: Consolidation Interface

Lesson: Consolidation Interface

Lesson Duration: 20 Minutes

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

Describethefunctionsof globalparametersand hierarchical displays. Explain

thecomponentsoftheSAPConsolidationlistprocessor. Outlinetheuseofthe

standard SAP tools andmulti-level customizing.

Business Example

ThegroupG1planstoconsolidatebytheendofthisyear. Youhavetopresentthe

basicworkingsoftheConsolidationinterfacetothemanagement.

Working with Consolidation Interface

Global Session Parameters

Theglobalsessionparameterssavetheuser-specificsettingsforthedimension,

the version, the year, the period, the consolidation chart of accounts, and the

ledger during a system session.

Advantage:

Theinformationfromtheglobalparametersistakenasfixedordefaultvaluesat

startup,andisdisplayedinthestatusbarincustomizingandwhenpresentingthe

consolidation results.

Hierarchy Displays

This section isa summaryof thedemonstration.

第 32 页 / 共 529 页

Unit2: MasterData AC660

Consolidation: List Processor

The list processor is not important here.

Asaresult,donotgetintoanylevelofdetailforthissection.

• 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 settingsfor 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 whichyoucan explain in stages (Drilldown).

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.

第 33 页 / 共 529 页

AC660 Lesson: Consolidation Interface

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

parameterscanbechanged asand when required.

Whenyourun afunction, the informationsaved asyour globalparameters are

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.

第 34 页 / 共 529 页

Unit2: MasterData AC660

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

use hierarchical displayswith simplenavigation.

第 35 页 / 共 529 页

AC660 Lesson: Consolidation Interface

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 run interunit elimination for the entire consolidation

groupandwanttoseetheresultsforonlyoneconsolidationunitinspecial,you

can use the filter function.

Thereport-reportinterfaceenablesyoutoaccessotherreportsinConsolidation.

Severallinksarepredefined. Theotherscanbedefinedbyusers.

ThesearchfunctionisidenticaltothestandardSAPlistsearch. Aspecialfunction

isavailabletosearchforerrormessages. Thedateandtimeareaddedwhenalist

isprinted. Afunctiontodefinepagebreaksisavailableaswell.

Demonstration: Consolidation Task Level Menu

Purpose

TodemonstratetheworkingoftheSAPConsolidationtasklevelmenu

第 36 页 / 共 529 页

Unit2: MasterData AC660

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Definetheglobalsessionparametersforyourdemonstration:

Dimension: 50

Version: 100

Fiscal year: 2002

Period: 12

Consolidation chart of accounts: 50

Ledger: US

Showbothmenupaths: IMGandtasklevelmenu.

Displayahierarchy,basedonconsolidationgrouphierarchyH1whichyou

havealreadyconfiguredforyour demonstration.

The list processor is not important here; it is introduced in the currency

translation unit.

第 37 页 / 共 529 页

AC660 Lesson: Consolidation Interface

Facilitated Discussion

Discussion Questions

Usethefollowingquestionstoengagetheparticipantsinthediscussion.Feelfree

to use your own additional questions.

第 38 页 / 共 529 页

Unit2: MasterData AC660

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

第 39 页 / 共 529 页

AC660 Lesson: Consolidation Structure

Lesson: Consolidation Structure

Lesson Duration: 40 Minutes

Lesson Overview

Thislessonshowsyouhowtodefinetheconsolidationunitandhowindividual

unitscanbegroupedtogetherinconsolidationgroups. Youwilllearnaboutthe

purposeanduseof dimension. Thislessonwillalso explainhow to workwith

a ledger and versions.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describethe purposeand use of Dimension

• Explain how dimension can be used

• Explainhowtoworkwithaledgerforaconsolidationgroup

• Evaluateandstatetheadvantageofusingaversionforconsolidation

• Describeaconsolidationunitandaconsolidationgroup

Discuss in depth the concept of consolidation unit and consolidation group.

Describetheroleofdimensionandstatetheuseofvariousconsolidationtypes.

Outline how to handle a ledger. Explain the version concept, which includes

various special versions.

Business Example

Thegroup,G1,planstointroducethecomponentConsolidationoftheSAPsystem

bytheendofthisyear. Youarerequiredtodefineconsolidationunitsandgroups

torepresentthestructureofyourcorporategroupintheSAPsystem.

Dimensions

Consolidation Units and Groups

Organizational structures:

Thecompanyformsthefoundationforconsolidationunitsandtheir automatic

generation.

The business object consolidation unit is the smallest unit in the corporate

structureforwhichcompleteconsolidationcanbeperformed.

The business object consolidation group can be any grouping of several

consolidationunitsforconsolidationandreportingpurposes.