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

第 172 页 / 共 529 页

Unit3: DataCollection AC660

These group-specific postings are only valid for the corresponding

consolidation group: level 02, 12, 22, 24.

(24: Two-sidedelimination: Consolidationgroupchangewithspeciallogic)

Postinglevels02,12, 22aredefinedfordivestitures.

The“Preparation for consolidation group changes”tasksusesthesedivestiture

postinglevelstopostthebalancesheettozeroforthosefinancialstatementitems

that support a breakdown by activity type (that is, whose subitem category is

controlledsuchthatthesubitemdivestitureactivitytypecanbemaintainedduring

theadjustmentpostingfortheadjustedreport data).

Additional note:

The special logic refers to the accounting technique “mutual stock method”.

Duringdataselection, datarecordswithpostinglevel23aretakenintoaccount

evenwhenneithertheconsolidationunitnorthepartnerunitshouldbeincluded

on mutual stock basis.

Systemdocumentation: Preparationforconsolidationgroupchanges

Changestoaconsolidationgroupresultfromacquisitionstoordivestituresfrom

consolidation units.

1. Topreparefortheconsolidationgroupchanges,youcanperformpostings

tocorrectthereportdata,adjustedreportdata,andconsolidatedreportdata

that exists for the consolidation unit:

• Forthebalancesheetitemsofanacquiredordivestedconsolidation

unitwithbreakdownbysubitem, itmakessensetorepost thevalues

tosubitem“Acquisitiontoconsolidationgroup”or“Divestiturefrom

consolidation group”.

• In the financial statement items of the profit and loss statement, it

makessensefor an acquisition torepost theshareof periodsbefore

theacquisitiontofinancialstatementitem“Retainedearningsbefore

first consolidation”.

Thepostingsarealwaysdependentontheconsolidationgroup.

Definedocumenttypeswithpostinglevel02(reportdata: consolidation

groupchange)andpostinglevel12(standardizingentry: consolidation

group change) and one or more tasks.

2. To generate the preprocessing postings to correct the consolidated data,

define document types with posting level 22 (Two-sided elimination:

consolidationgroupchange)andpostinglevel24(Two-sidedelimination:

consolidationgroupchangewithspeciallogic)andoneormoretask.

Systemdocumentation: Subitemsforacquisitionanddivestiture

162

第 173 页 / 共 529 页

AC660 Lesson: Validation and Postings

This indicator for screen selection control must be activated for the subitems:

Whenit ischecked, adivestituresubitem (activitytype) canbedefinedfor the

subitems.

Posting levels II

Usethisgraphictodiscusstheindividualdocuments:

Document number 1 involves consolidation unit UnitC and thus all the

consolidationgroups(becauseUnitCiscontainedinallconsolidationgroups).

Documentnumber2involvesthereceivablesandpayablesbetweentheassociated

companiesUnitAandpartnerunitUnitB,itinvolvesCG2andCG1.

Documentnumber3involvesthereceivablesandpayablesbetweentheassociated

companiesUnitAandpartnerunitUnitD,thedocumentispostedinCG1,since

thisistheconsolidationunitthatcontainsbothconsolidationunits.

UnitA has no partner relationship to UnitD within CG2; UnitD is an external

companyforUnitA.AttheCG1level,UnitAandUnitDareassociatedcompanies

whosereceivables/payableshave tobeeliminated.

Consolidationofinvestmentscanbeperformedtwicehere: onceatthelevelof

subgroup CG3 (UnitD holds shares in UnitE) and at the level of consolidated

groupCG1(UnitAonlyholdsaminorityshareinUnitD,forexample).

Documentnumber4isdependentonCG3. Taskconsolidationofinvestmentswas

startedinCG3; theconsolidationentryalsoinvolvesCG1.

Summary:

Thetaskconsolidationofinvestmentsisperformedeconomically,usingposting

levelsandaconsolidationgroupreferencewithfewsteps.

Thepostinglevelsallowthemodelingofcorporatestructuresofanycomplexity,

andguaranteesthattheconsolidationofsubgroupsismodeledcorrectlyfor the

overall consolidated group.

163

第 174 页 / 共 529 页

Unit3: DataCollection AC660

Figure 40: Postings and Document Types

Twotypesofentriesarepostedduringconsolidation,adjustingorconsolidation

entries.

Thesystempostsautomaticentries totheselecteditemsthat you specify, such

as retained earnings in the balance sheet and incomestatement, provisionsfor

taxationinthebalancesheet,andincometaxexpensesintheincomestatement.

Postingsare differentiatedbythedocument type.

Eachdocumenttypeisassignedtoasinglenumberrangeforaparticularversion.

Apostinglevelandothercontrolparametersareassignedtoeachdocumenttype.

Note: Youshoulduseadocumenttypeforonetaskonly,toenableyou

to repeatandreversepostings. Thesystemneedstobeabletoidentify

the documents posted for a task.

164

第 175 页 / 共 529 页

AC660 Lesson: Validation and Postings

Figure 41: Document Types

SAPConsolidationsupportsawiderangeofautomaticpostings. Youcanalsopost

standardizingandconsolidationentriesmanually. Postingsareclassifiedbymeans

ofdocumenttypes. Thisenablesyoutoperformasimpleanalysisandoutlinethe

distinction between different businessfunctions.

Thesystemautomaticallygeneratesjournalentries, suchasfinancialstatement

balancingadjustmentsanddeferredincometaxes. Inthisway,youcancontrolthe

specialitemsfordeferredtaxesindependentlyoftherespectivedocumenttype. In

addition,withdocumenttypesthatarelargerthanorequalto20,youcandefinea

clearingitemforcross-consolidationunitspostings. Across-consolidationunit

postingcantakeplaceonlyfor thesepostinglevels.

Toindicateselecteditemsforthedocumenttype,enteranitemforthedebitand

credit postings.

You need to use different document types to distinguish between manual and

automaticpostings. Youcanuseidenticalordifferentnumberrangesforposting.

Theaccount assignmenttakesplacebytheitemnumberandasrequiredbythe

sub-assignmentpossibilities,whichyoucanspecifyindividually.

Areversalfunctionandamassreversalfunctionisavailableforsingledocuments.

165

第 176 页 / 共 529 页

Unit3: DataCollection AC660

Figure 42: Posting Levels I

The posting level standardizes the postings in the Consolidation system. For

example:

• Adjustments to reported financial data

• Standardizing Entries

Further posting levels:

• Space: Financial data fromreal-timeupdate

• 08: Itemsubstitutionbasedonlevels“space”,00,and01

• 23: Two-sided elimination (special logic), particularly for eliminating

investmentrevenueduringmutualstockconsolidation

• R0toR3 Reporting ReportWriter (roll-up only)

Standardizingentriesarevalidinalltheconsolidationgroups,whichcontainthe

consolidation unit that is posted against.

Two-sided consolidation entries are valid only for the consolidation groups in

whichtheconsunitandthepartnerunitareconsolidatedusingthepurchase, or

proportional, ormutualstockmethod(levels23and24).

Postings that are dependent on the consolidation group are valid only for the

relevant consolidation unit (levels 02, 12, 22, and 24) or for the consolidation

groupandalltheother groupsinwhichitisincluded.

166

第 177 页 / 共 529 页

AC660 Lesson: Validation and Postings

Figure 43: Posting Levels II

Youspecifyapostinglevelwhenyoudefinedocumenttypes.

Journal entries are stored in the database with a respective posting level. In

reporting, theycanbesubdividedbythepostinglevel.

Intheaboveexample,documentsareportrayedfordifferenttasks:

• Activity 1:

ThestandardizingentrytoconsunitConlyaffectsthisunit. Thedocument

is valid in all the cons groups (CG).

• Activity 2:

TheeliminationofIUpayablesandreceivablesbetweenAandBisvalid

in the cons groups 1 and 2.

• Activity 3:

TheeliminationofIUpayablesandreceivablesbetweenAandBisvalid

intheconsgroup1,asbothcompaniesareonlyaffiliatedtocompaniesat

the group level.

• Activity 4:

The taskconsolidationof investmentsis started inCG1, the document is

createdinthelowestaffectedconsgroupCG3andisalsovalidinCG1.

167

第 178 页 / 共 529 页

Unit3: DataCollection AC660

Demonstration: Document Types

Purpose

To demonstrate document types

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. DemonstratethedocumenttypesindetailintheIMG.

2. Ifnecessary, discussthepossibleusesforsomeofthecontrolfunctionsin

the document types.

3. Create a standardizing entry.

168

第 179 页 / 共 529 页

AC660 Lesson: Validation and Postings

Exercise 7: Validation

133

Exercise Duration: 15 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Definesimplevalidationrulesusingtheformulabuilder

Business Example

You have now entered in the individual financial statement data of all the

consolidation units in your prototype example.

This datanow needsto be validated, in order toprovidea correct basisfor the

following tasks.

Task:

Defining and running a validation:

1. DefinevalidationVXY(whereXY=50+yourgroupnumber).

The validation containstwo simplesteps:

1st check:

EnsuresthatthesumofassetFSitemsisequaltothesumofliability/equity

FS items.

2nd check:

Checkswhether depreciation ofmachineryand equipment inthebalance

sheet isequaltothedepreciationexpenseofmachineryand equipmentin

the income statement.

Hint: Specifythestandardmessages601and607,andusethelocal

currency fields for message output.

2. Assignthevalidationruletoallconsolidationunits.

3. Runthetaskthatvalidatesthelocalcurrencydata. Thesystemautomatically

blocksthetaskifitissuccessfullycompletedforthewholegroupG1.

Youhavealreadymadetheappropriatesettingintheprevioussection

169

第 180 页 / 共 529 页

Unit3: DataCollection AC660

Solution 7: Validation

Task:

Defining and running a validation:

1. DefinevalidationVXY(whereXY=50+yourgroupnumber).

The validation containstwo simple steps:

1st check:

EnsuresthatthesumofassetFSitemsisequaltothesumofliability/equity

FS items.

2nd check:

Checkswhether depreciation of machineryand equipment inthebalance

sheet isequal tothedepreciationexpenseofmachineryandequipment in

the income statement.

Hint: Specifythestandardmessages601and607,andusethelocal

currency fieldsfor message output.

a) To define a validation, choose:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data →Validations for Reported Data and Standardized Data →

Definevalidations→Createvalidation→Choose

EnterVXYasthenameofyourvalidation(whereXY=50+yourgroup

number)anddescriptionGroup##Validation. Enter.

Put cursor on VXY folder . Then choose Insert step icon. Edit the

stepsPrerequisite,Check,Messagesuccessivelybyplacingcursoron

each and double-clicking.

Make the following settings for the validation using the Formula

Builder

Validationstep001: Totalassets=Totalliabilities+stockholders’

equity

Continued on next page

170

第 181 页 / 共 529 页

AC660 Lesson: Validation and Postings

Field/DataType Value

Prerequisite: TRUE

Check: SUM(ECCSDAT-HSLYD)whereT100000

= SUM (ECCSDAT-HSLYD) where

T200000

Message: Usetheexistingmessage601

T100000and T200000 areRules. You accessthembyselecting the

Rules tab.

Clickonthebuttonsintheformulabuildertoselectthem.

Youcan display thetechnical namesin thetop section ofthe screen

bychoosingSettings→TechnicalnamesorbyselectingtheDisplay

TechnicalNameicon(3rdicon)totherightofthefieldnamelistings.

When choosing Table fields, first select Data structure for CS

validation,thenyouwillseethefielddescriptions,forexample,local

currency YTD.

Hint: Notethatthecheckisstructuredasfollows:

SUM(*Tablefield*)WHERE*Rule**Operator*SUM

(*Table field*) WHERE *Rule*

Ifthetrafficlightisnotgreen,thesyntaxisincorrect.

WithcursoronVXYonleftsideofscreen,chooseInsertstepicon.

Validation step 002 : Depreciation of machineryandequipment in

thebalancesheet=depreciationofmachinery andequipment inthe

income statement

Field/DataType Value

Prerequisite: TRUE

Check: SUM (ECCSDAT-HSLYD) where

T191500 + SUM (ECCSDAT-HSLYD)

whereT311950 = ‘0.00’

Message: Usetheexistingmessage607

Hint: UsetheexistingrulesT191500_220andT311950.

ChoosetheCONSTANTbuttontoentertheconstantvalue0.

Continued on next page

171

Field/DataType	Value
Prerequisite:	TRUE
Check:	SUM(ECCSDAT-HSLYD)whereT100000 = SUM (ECCSDAT-HSLYD) where T200000
Message:	Usetheexistingmessage601

Field/DataType	Value
Prerequisite:	TRUE
Check:	SUM (ECCSDAT-HSLYD) where T191500 + SUM (ECCSDAT-HSLYD) whereT311950 = ‘0.00’
Message:	Usetheexistingmessage607

第 182 页 / 共 529 页

Unit3: DataCollection AC660

Save your definition.

2. Assignthevalidationruletoallconsolidationunits.

a) Assignthevalidationtoyourconsunitsbychoosing:

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data →Validations for Reported Data and Standardized Data →

Assign Validationsto ConsolidationUnits

SelectNewEntries. Maketheassignmentforperiodcategory2and3.

EnteryourvalidationinthecolumnsVal. rptdandVal. stdforeach

of your cons units.Save.

3. Runthetaskthatvalidatesthelocalcurrencydata. Thesystemautomatically

blocksthetaskifitissuccessfullycompletedforthewholegroupG1.

Youhavealreadymadetheappropriatesettingintheprevioussection

a) Sinceyouhavealreadydefinedvalidationtasksandassignedthemto

thetaskgroup, youonly need toensurethat theAutomaticblocking

indicator issetforbothofthevalidationtasks.

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→DefineTaskGroup

Selectyourtaskgroupanddoubleclickonassigntaskstotaskgroup.

Nowgototheapplicationandrunthedatamonitor. Executethelocal

currency vaidation task for consolidation group G1 by placing the

cursoratthecrosssectionbetweenunitG1andtheLOCALVALtask,

and choosing Update run.

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→ Data Collection → Monitor

Open up the hierarchy.Position the cursor on the intersection of

consolidationgroupG1andthetaskVALIDLC.SelectUpdateRun.

Open up the results table. You should see green lights for the

validations you created.

172

第 183 页 / 共 529 页

AC660 Lesson: Validation and Postings

Exercise 8: Posting

137

Exercise Duration: 30 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Post a standardizing entry.

Business Example

• Youwanttopresentamanualadjustmententry.

You assume that consolidation unit A recorded a useful life of 10 years

foranasset,whereasthegroupwilldepreciatetheassetonlyoveraperiod

of 5 years.

This posting, which has aneffect on earnings, automatically triggersan

allocationofdeferredtaxesandanadjustmentofannualnetincome.

Thetaxrateof40%appliestoallconsolidationunits.

Youalreadycreatedthenecessaryselecteditemsinapreviousstep.

• Youalsoexplainhowtopostareversalofagenerateddocument.

Youaddone moreassumption toyour example:

Theinformationregardingthedifferenceinthedepreciablelifewaswrong.

Theoriginaldepreciationof consolidationunit Awascorrect, and should

notbeadjustedforthecorporategroup. Youthereforepostareversaltothe

document that was posted.

Task:

Depreciation adjustment:

1. Depreciation adjustment:

1)Defineataxrateof40%forallconsolidationunitsforpostingdeferred

taxes.

Hint: UsethefunctionCarryoutMassChange.

2) Define document type 10 for postings in local currency (LC) in

conjunction with deferred taxes.

For this document type create a new number range 10 with document

numbersfrom1000000000through1999999999.

Continued on next page

173

第 184 页 / 共 529 页

Unit3: DataCollection AC660

3) Create a new task calledSTD POST :

a)Shorttext: Adj.Entry; mediumtext: AdjustmentEntry·

b)Assignthenewdocumenttype10tothetask,makingiteffectivefromlast

year and period 12.

4)AddtaskSTDPOSTtothetasksinyourtaskgroup.

5) Posttheadjustmententryin thedatamonitor.

Makeanoteofthedocumentnumberanddisplaythedocument.

In the Information System, display a list of the totalsrecordsand journal

entries.

2. Reversethe document created beforehand.

1)Displaythedocumentandmakesurethatthereversaldocumentnumberis

recordedintheoriginaldocument,andtheorganizationdocumentnumberis

recorded in the reversal document.

2) Block the taskSTD POST in the data monitor for the entire corporate

group G1.

174

第 185 页 / 共 529 页

AC660 Lesson: Validation and Postings

Solution 8: Posting

Task:

Depreciation adjustment:

1. Depreciation adjustment:

1)Defineataxrateof40%forallconsolidationunitsforpostingdeferred

taxes.

Hint: UsethefunctionCarryoutMassChange.

2) Define document type 10 for postings in local currency (LC) in

conjunction with deferred taxes.

For this document type create a new number range 10 with document

numbersfrom1000000000through1999999999.

3) Create a new task called STD POST :

a)Shorttext: Adj.Entry; mediumtext: AdjustmentEntry·

b)Assignthenewdocumenttype10tothetask,makingiteffectivefromlast

year and period 12.

4)AddtaskSTDPOSTtothetasksinyourtaskgroup.

5) Posttheadjustmententry inthedatamonitor.

Makeanoteofthedocumentnumberanddisplaythedocument.

In the Information System, display a list of the totals records and journal

entries.

a) Depreciation adjustments:

1) Add the percentage rate for posting deferred taxes in the master

records of the consolidation units.

Since this change is the same for all units, use the Mass Changes

function.

Menu Path: Tools→Customizing →IMG →Execute Project →

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Master Data → Organizational Units → Consolidation Units →

Carry out a mass change

Enter the following values:

Continued on next page

175

第 186 页 / 共 529 页

Unit3: DataCollection AC660

Field/Data Type Value

Dimension XY

Consolidation group G1

Consolidation units A through E

Version 100

Year Current Year

Period 12

Newvalues→saveasnewvalue 40 % tax rate

Test run No

Execute program.

2) Define the new document type 10.

Menu Path: Tools→Customizing→IMG→ ExecuteProject→

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ManualPosting→Definedocumenttypes

ChooseNewentries andenter thefollowing:

Field/Data Type Value

Document type 10

Description ADJUSTMENTENTRIES

Posting level 10

Balance check 0

Application 9

Manual posting Select theindicator

Postinginlocalcurrency Select theindicator

Deferred Taxes Select the indicator for debits

and credits

Number Range Maintenance:

Number range ID 10

Number range 101000000000to1999999999

Year valid until (2003)

ChooseNumberRanges/AutoReversalfolder. ChooseNewEntries.

Specifyversion100andthenumberrange(10).

Continued on next page

176

Field/Data Type	Value
Dimension	XY
Consolidation group	G1
Consolidation units	A through E
Version	100
Year	Current Year
Period	12
Newvalues→saveasnewvalue	40 % tax rate
Test run	No

Field/Data Type	Value
Document type	10
Description	ADJUSTMENTENTRIES
Posting level	10
Balance check	0
Application	9
Manual posting	Select theindicator
Postinginlocalcurrency	Select theindicator
Deferred Taxes	Select the indicator for debits and credits
Number Range Maintenance:
Number range ID	10
Number range	101000000000to1999999999
Year valid until	(2003)

第 187 页 / 共 529 页

AC660 Lesson: Validation and Postings

ChooseDefineNumberRange. ChooseInsertintervaliconandenter

dataaslistedabove. Savethenumber range.

Save your entries.

3) Define a new task for the adjustment entry and insert the task in

the existing task group.

Menu Path: Tools→Customizing →IMG →Execute Project →

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→ Manual Posting→Definetasks

ChooseNewentriesandcreatethetaskSTDPOST.textStdPosting)

Selectthistask anddouble-clickDocument TypeAssignmentfolder.

ChooseNewEntries andspecifythefollowing:

Field/Data Type Value

Effective year year 2002

Effective period Last year

Document type 10

4)Aftersavingtheseentries,addtaskSTDPOSTasaNewEntryto

task group DATA.

Menu Path: Tools→Customizing →IMG →Execute Project →

SAPReferenceIMG→EnterpriseControlling→Consolidation→

Data→DataMonitor→DefineTaskGroup

Selectyourtaskgroupanddoubleclickonassigntaskstotaskgroup.

Selectnewentries. Addthetask STDPOST.

Save your entries

5)Intheapplication,runthedatamonitorandexecutetheadjustments

taskforconsolidationunitAbyplacingthecursoratthecrosssection

between unit Aand theSTDPOST task, and choosing Updaterun.

EnterdocumentheadertextandthenselectLineItemstab.

Field/Data Type Value

Item191500,Subitem220 -100

Item311950,Subitem0003 100

Saveandmakeanoteof thedocument number whenit isdisplayed

on the status line.

Todisplaythedocument,fromwithinthedatamonitor,choose:

Continued on next page

177

Field/Data Type	Value
Effective year	year 2002
Effective period	Last year
Document type	10

Field/Data Type	Value
Item191500,Subitem220	-100
Item311950,Subitem0003	100

第 188 页 / 共 529 页

Unit3: DataCollection AC660

Menu Path: Goto →Journal entries

Select the following:

Field/Data Type Value

Dimension XY

Consolidation group G1

Consolidation unit A

Version 100

Fiscal year 2002

Period 12

Document type 10

Posting level 10

Chart of accounts XY

Makesureyoudeleteanyotherentries. Afterconfirmation,theselected

document will be displayed.

An alternative way of displaying the document is to directly select

thedocumentnumberthatwasdisplayedonthestatuslinewhenthe

adjustment wasposted. Todothis, choose:

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→DataCollection→Manualposting→Display

2. Reversethe document created beforehand.

1)Displaythedocumentandmakesurethatthereversaldocumentnumberis

recordedintheoriginaldocument,andtheorganizationdocumentnumberis

recorded in the reversal document.

Continued on next page

178

Field/Data Type	Value
Dimension	XY
Consolidation group	G1
Consolidation unit	A
Version	100
Fiscal year	2002
Period	12
Document type	10
Posting level	10
Chart of accounts	XY

第 189 页 / 共 529 页

AC660 Lesson: Validation and Postings

2) Block the task STD POST in the data monitor for the entire corporate

group G1.

a) Reversal:

Toenterareversalagainstanalreadyposteddocument,runtheSTD

POSTtaskfromthedatamonitorforconsunitAbychoosingUpdate

run.or, in the application menu go to:

MenuPath: Accounting→Enterprisecontrolling→Consolidation

→DataCollection→Manualposting→Enter

UnderCopyfromenterthedocumentnumberoftheentryyouposted

beforehand, andselect theReverse flag.

Afterenteringaheadertextforthereversal,choosetheLineItemstab.

ReversethisdocumentbychoosingPost(orUpdate).

Finally,blockthetaskSTDPOSTfortheentiregroupbyplacingthe

cursoratthecrosssectionbetweenthetaskandconsolidationgroup

G1, and selecting Block.

179

第 190 页 / 共 529 页

Unit3: DataCollection AC660

Lesson Summary

You should now be able to:

• Explain the concept of validations

• Describe postings and document types

180

第 191 页 / 共 529 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Explain the data collection methods from both SAP systems and the

non-SAP systems

• Use financial data in consolidation

• Describe the features of the status monitor

• Customize data monitor

• Assign tasks in the data monitor

• Describe the settings for online dataentry

• Define data entry layouts

• DescribeofflinedataentrywithMicrosoftAccess/Excel

• Explain flexible upload

• Explain the concept of validations

• Describe postings and document types

181

第 192 页 / 共 529 页

UnitSummary AC660

182

第 193 页 / 共 529 页

AC660 Test Your Knowledge

Test Your Knowledge

147

1. Incaseofdatacollectionfromnon-SAPsystems,thereisMicrosoftAccess

dataentryusinganadditionalMicrosoftExcelinterface.

Fillintheblankstocompletethesentence.

2. The dataisrecordedusingvariousdatacollectionprocedures.

Fillintheblankstocompletethesentence.

3. Which of these isNOT true about tasks?

Choosethecorrectanswer(s).

□ A Tasks are user-defined

□ B Tasks can begrouped intotaskgroups

□ C Tasks can only be run in test mode

□ D Taskscanberunsuccessivelyuptothenextmilestone

4. A group-dependent task group must always be a partial number of the

tasknumber and must alwaysstart with the first taskof the

global task group.

Fillintheblankstocompletethesentence.

5. Whichtaskcanbeenteredonlyonceinthedatamonitortaskgroup?

Choosethecorrectanswer(s).

□ A Balance carry forward

□ B Manual posting

□ C Rollup to consolidation groups

□ D Data collection

6. Explainhowyoucancategorizethedetaillevelofthefinancialdatareported

by a unit.

7. WhatareUser-definabledataentrylayoutsusedfor?

183

第 194 页 / 共 529 页

TestYourKnowledge AC660

8. WhencanyouuseofflinedataentrywithMicrosoftAccess/Excel?

9. Whenisflexibleuploadused indatacollection?

10. Duringflexibleupload,youcannotselectdifferentupdatesessions.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

11. You can check the validation result step-by-step in the

Fillintheblankstocompletethesentence.

12. Youdonotrequirevalidationacrossconsolidationunitsordimensions.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

13. Thepostinglevelstandardizesthepostingsinthe

system.

Fillintheblankstocompletethesentence.

184

第 195 页 / 共 529 页

AC660 Test Your Knowledge

Answers

149

1. Incaseofdatacollectionfromnon-SAPsystems,thereisMicrosoftAccess

offlinedataentryusinganadditionalMicrosoftExcelinterface.

Answer: offline

2. Thetotalsdataisrecordedusingvariousdatacollectionprocedures.

Answer: totals

3. Which of these isNOT true about tasks?

Answer: C

Taskscanberuninbothtestand updatemodes.

4. Agroup-dependenttaskgroupmustalwaysbeapartialnumberoftheglobal

tasknumberandmustalwaysstartwiththefirsttaskoftheglobaltaskgroup.

Answer: global

5. Whichtaskcanbeenteredonlyonceinthedatamonitortaskgroup?

Answer: B

ThetaskManualpostingcanbeenteredseveral timesin thedatamonitor

task group.

6. Explainhowyoucancategorizethedetaillevelofthefinancialdatareported

by a unit.

Answer: Youcanusefinancialdatatypestocategorizethedetaillevelsof

thefinancialdatareportedbyaunitandtodetailthecategoryofdatathatit

reports. For example, youcanassignonefinancial datatypetounitsthat,

duetotheirsizeandimportance, enterhighlydetaileddataandadifferent

data type to units of lesser importance.

7. WhatareUser-definabledataentrylayoutsusedfor?

Answer: User-definabledataentrylayoutsareusedforentering reported

financialdataonlineintheSAPsystem. Theycanalsobeusedforentering

data offline.

185

第 196 页 / 共 529 页

TestYourKnowledge AC660

8. WhencanyouuseofflinedataentrywithMicrosoftAccess/Excel?

Answer: You can use offline data entry with Microsoft Access/Excel if

oneormoreconsolidationunitsdonotuseanyintegration,butadminister

their reported financial data on PC.

9. Whenisflexibleuploadused indatacollection?

Answer: Flexible upload can be used in data collection if one or more

consolidation units do not use integration, but administer their reported

financial data on PC.

10. Duringflexibleupload,youcannotselectdifferentupdatesessions.

Answer: False

Duringflexibleupload,youcanselectdifferentupdatesessions,inorderto

guaranteethetreatmentofdatastreams,whichalreadyexist.

11. Youcancheckthevalidationresultstep-by-stepinthevalidationlog.

Answer: validation log

12. Youdonotrequirevalidationacrossconsolidationunitsordimensions.

Answer: False

You need validation across consolidation units or dimensions to ensure

reconcileddatainlegalandmanagementconsolidation.

13. Thepostinglevelstandardizesthepostingsintheconsolidationsystem.

Answer: consolidation

186

第 197 页 / 共 529 页

Unit 4

Currency Translation

151

You would have already explained the configuration of the master data and

the transfer of the individual financial statement data. Next, the data that was

transferredinthelocalcurrencyor/andthetransactioncurrencyhastobetranslated

into the group currency. You do this to perform the subsequent consolidation

tasks. ExplainaboutcurrencytranslationinSAPsystem. Detailhowtoconfigure

the translation methods for each consolidation unit. Create tasks for currency

translation. Explain how to set up special financial statement items that are

required when translationdifferences with aneffect onnet income are posted.

Examinehowtomaintaintheexchangeratetableandthetableoftranslationratios.

Unit Overview

TheunitcoverscurrencytranslationinSAPConsolidation. Youwilllearnhow

to configure the translation methods for each consolidation unit. You will be

abletocreatetasksforcurrencytranslationandsetupspecialfinancialstatement

itemsthatarerequiredwhentranslationdifferenceswithaneffectonnetincome

areposted. Finally,youwillbeabletomaintaintheexchangeratetableandthe

table of translation ratios.

Unit Objectives

After completing thisunit, you will beableto:

• Determine the need for currency translation

• Evaluate currency translation methods

• Use currency translation keys

• Determine exchange rates

• Examinethetranslationofindividualfinancialstatementvaluesintogroup

currency

• Managecurrencytranslationdifferencesthatdonotaffectnetincomeorthe

ones that affect net income

• Explain rounding differences

187

第 198 页 / 共 529 页

Unit4: CurrencyTranslation AC660

Unit Contents

Lesson: Currency Translation Methods and Keys..........................189

Demonstration: Currency Translation....................................200

Lesson: Translation and Rounding Differences.............................203

Demonstration: Currency Translation ...................................220

Exercise 9: Currency Translation.........................................223

Exercise 10: Validation II..................................................245

188

第 199 页 / 共 529 页

AC660 Lesson: Currency Translation Methods and Keys

Lesson: Currency Translation Methods and Keys

Lesson Duration: 20 Minutes

152

Lesson Overview

Thislessonwillgiveyouanoverviewofcurrencytranslationmethods. Thislesson

will cover currency translation keysandcomparethevaluesof two translation

keys. Youwillalsolearnabouttherelationshipbetweenthecurrencytranslation

keys and the exchange rate indicator.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Determine the need for currency translation

• Evaluate currency translation methods

• Use currency translation keys

• Determine exchange rates

Provideinformationonthemajorelementsofcurrencytranslation. Explainhow

thecombinationofexchangerateindicator andcurrencytranslationkeymakes

itpossibletoapplydifferenttranslationmethodstothefinancialstatementitems

of different sets.

Business Example

Thegroup,G1,planstointroducethecomponent,SAPConsolidationbytheend

of this year. Financial data reported by consolidation units is collected in the

Consolidationapplicationinlocalcurrency. Noticethat thelocalcurrencyof a

consolidationunitisnotthesameasthegroupcurrency. Youneedtotranslatethis

dataintogroupcurrencybeforeyoucancreateconsolidatedfinancialstatements.

Currency Translation Methods

Currency Translation: Briefly mention all the major elements of currency

translation. Usethespecifiedexampletoexplainhowcurrencytranslationworks.

Generally, different partsof thebalance sheet can betranslated usingdifferent

exchangerates. For example, fixedassetsare translatedat historical exchange

rates,whilecurrentassetsaretranslatedatcurrentexchangerates. Toachievethis,

itemsetsmustbedefinedinthesystemthatgrouptogetherthefinancialstatement

itemsthat weretranslated at the same rate. The corresponding exchange rates

mustalsobedefined. Ifthebalancesheetandincomestatementarenottranslated

in a “linear” manner with a uniform exchange rate, then currency translation

189

第 200 页 / 共 529 页

Unit4: CurrencyTranslation AC660

differenceswilloccur. Thedevelopmentofcurrencytranslationdifferencescanbe

extremelyinteresting,whichiswhythesystemoffersseveralreportsforanalyzing

these currency translation differences.

CustomizingElementsforCurrencyTranslation: Discussthemaincustomizing

elementsandtheircontext. Eachconsolidationunitcanbetranslatedindividually

by assigning it a translation method.

Atranslationmethodcontainstheinformationaboutthereferenceexchangerate

indicator to use, the underlying consolidation chart of accounts, and various

method entries. The method entries are differentiated between the translation

entries and the rounding entries (more details about this difference will be

mentioned later).

Themethodentriesinclude theitem sets(that is, theitemsetandsubitem set),

informationabouttheexchangerateindicator andthecurrencytranslationkey,

and information about the financial statement items for posting any currency

translation differences that arise.

The entries of the financial statement items for translating and posting the

differencesaredependentontheconsolidationchartofaccountsused,asarethe

namesof the selected financial statement items.

WhenatranslationmethodiscopiedthatwascreatedforadifferentFSchartof

accounts,thenallconsolidationchartofaccounts-specificentries(sets,andsoon)

havetobemodifiedtofitthenewconsolidationchartofaccounts.

You already referred to the selected financial statement items and their

maintenanceduringthediscussionof consolidation chartsof accounts. Atthis

point, repeatthat theselectedfinancialstatementitemsfor currencytranslation

particularlyinvolvethe“retainedearnings/annualnetincome”financialstatement

items in the income statement and the balance sheet, which are changed

automatically during currency translation.

Theexchangeratetypesareanothercustomizingelement. Theexchangeratetype

isallocatedatime-specificcombinationofexchangerateversionandexchange

rateindicator. For moreinformationonthistopic, see“DeterminingExchange

Rates”.

Define the translation ratios for all combinations of exchange rate type, from

currency, andto currency intheappropriatetable.

The exchange rate table contains the date-specific exchange rates for all

combinationsexchangeratetype,fromcurrency,andtocurrency.

190

第 201 页 / 共 529 页

AC660 Lesson: Currency Translation Methods and Keys

Figure 44: Currency Translation

Thecurrencytranslationtaskenablesyoutotranslatefinancialdatareportedby

consolidationunitsintheirlocalcurrencyintothecurrencyoftheconsolidation

group.

Currency translation is based on translation methods. You can define several

methodstotranslatedatareported by yourconsolidationunits. Youcan assign

everyconsolidationunit by timeperiodandversion.

Thetypeofcurrencytranslationyou usedependsontherelationshipsbetween

yourcorporategroupanditsindividualconsolidationunits(functionalcurrency).

Youcandefineanyofthecommonly-usedtranslationmethods,suchastemporal

methodandcurrent-ratemethod,foryourchartofaccounts.

191

第 202 页 / 共 529 页

Unit4: CurrencyTranslation AC660

Figure 45: CurrencyTranslation -Customizing Elements

Translationmethodsindicatetheexchangerateusedtotranslatecertainitems,and

howanysubsequenttranslationorroundingdifferencesaretobehandled.

Translationmethodsareassignedtoconsolidationunitsintheirmasterdata.

Item sets are rangesof items that are translated using thesametranslation key

and exchange rates.

Example:

Fixed assets: Translated using historical rates

Current assets: Translated using current rates

Incomestatement: Translated using averagerates

Ifyouwanttranslationdifferencestobepostedwithaneffectonnetincome,you

needtocreateselecteditemsforautomaticposting. Thesearetypicallyitemsfor

retainedearnings/netincomeintheincomestatementandbalancesheet.

You store exchange rates for exchange rate types in the exchange rate table.

Exchangeratetypesareacombinationofthetranslationversionandtheexchange

rate indicator.

Translation methodsaredimension-dependent.

192

第 203 页 / 共 529 页

AC660 Lesson: Currency Translation Methods and Keys

Currency Translation Keys

Thecombinationofexchangerateindicatorandcurrencytranslationkeymakes

itpossibletoapplydifferenttranslationmethodstothefinancialstatementitems

of different sets. The currency translation key specifies the base currency, the

table for determining the exchange rate, and the procedure for calculating the

group currency value. In the process, the exchange rate indicator determines

whetherthecurrentexchangerate,theaveragerate,oradifferentexchangerate

is used for translation.

Amajorcriterionfordifferentiatingbetweentheindividualtranslationkeysisthe

basecurrency. Whilecurrencytranslationkey9usesthetransactioncurrencyas

the base currency, all other translation keys use the local currency as the base

currency.

Formoreinformationonthedifferencesbetweentheindividualtranslationkeys,

consultthesubject“Differenttranslationkeysandexchangerateindicators”inthe

currencytranslationunitoftheSAPsystemdocumentation.

Explaineachof thesetranslationkeystotheparticipantsandusethefollowing

examples. Startyourpresentationwithacomparisonofcurrencytranslationkeys

1 and 5.

Translation at group currency value 0:

Usedincountrieswithhighinflation. Therearetwobasicwaystoproceed.

1. Theconsolidationunitisonlyrecordedinthegroupcurrency.

2. Someofthefinancialstatementsarerecordedinlocalcurrencyandgroup

currency(suchasfixedassets),whiletheremainingpartisrecordedsolely

in the local currency.

193

第 204 页 / 共 529 页

Unit4: CurrencyTranslation AC660

Procedure:

1. Double the asset entry in the FS chart of accounts, such as 191100 Real

estateentryinLCand191101RealestateentryinGC

2. Enterthefinancialstatementitem191100intheformwithoutabreakdown

by activity type

3. Enterfinancial statement item191101inthegroupcurrencywithactivity

types

4. Define thecurrency translation methods:

2 item sets for the fixed assets

a) Financialstatementitem191100withcurrencytranslationkey0(group

value is set to zero)

b) Financialstatementitem191101withcurrencytranslationkey6(group

valueexistsandwillnotbenottranslatedagain)

Thebalancesheet currency translationdifferenceof thefixed assets

results in the balance of the currency translation differences with

regard to sets a) and b).

Exchange rate: 2.0

FS item TC LCGCDefault Difference

191100 1,000 0 2,000 -2,000

191101 0 3,000 0 +3,000

Note: Postdifferencestothesamefinancialstatementitem.

Translationatthecurrentexchangeratethroughtheexchangeratetable:

Also see the R/3 documentation, unit “Currency translation”, example for

translation keys 1 and 5.

Historictranslationbyacquisitionyearthroughtheexchangeratetable:

Year 1998

Exchangerate: 0.5FSitemAcquisitionyearPeriodLCGC

191500 1998 12 5,000 2,500

Year 1999

Exchangerate0.4FSitemAcquisitionyearPeriodLCGCReference

191500 1998 00 5,000 2,500 2,000

Difference 500

191500 1999 12 4,000 1,600 1,600

Historictranslationthroughchangesininvestmentstable:

194

第 205 页 / 共 529 页

AC660 Lesson: Currency Translation Methods and Keys

Asanexample, showtheentryof afirstconsolidationfor theacquisitionof an

investment in consolidation unit B for consolidation unit D in the changes in

investmentstable(2597D).Thevalueofthecapitalstockinconsolidationunit

Dwasrecordedinthetableinboththelocalcurrencyandthegroupcurrencyin

period12ofyear 1998. Thishistoricalgroupcurrencyvalueisnotchangedby

thecurrencytranslation,sincefinancialstatementitem250100iscontainedina

set (T-250100) thatwasassigned currency translationkey4. Thesystem does,

however,determineacurrencytranslationdifferenceintheamountof250,caused

bytheparalleltranslationoftheitemvaluewiththereferenceexchangerateof0.5.

Historictranslationthroughchangesininvesteeequitytable:

Likecurrencytranslationkey3,above,thedifferencebeingthatthevaluesinthe

table of changes in investee equity are used.

Translationatthemonthlyexchangeratethroughtheexchangeratetable:

SeetheR/3documentation,unit“Currencytranslation”,examplefortranslation

keys 1 and 5.

Existinggroupcurrencyvalueisnottranslatedagain:

Aconsolidationunit suppliesitsindividual financial statement databothinthe

local currency and the group currency, using an appropriate data transmission

procedure like realtime update or rollup.

User-defined exchange rate determination:

Theuser-definedexchangeratedeterminationthroughauserexitisonlyavailable

in Release 4.5 and later.

Translationof transactioncurrency documentsat theaverageannual exchange

rate through the exchange rate table:

Usethesameexampleasforcurrencytranslationkey1,andreplacetheheaderof

thelocalcurrencycolumnwiththetransactioncurrency.

Atranslation of thetransactioncurrency at the monthly exchangerate through

the exchange rate table:

Usethesameexampleasforcurrencytranslationkey5,andreplacetheheaderof

thelocalcurrencycolumnwiththetransactioncurrency.

195

第 206 页 / 共 529 页

Unit4: CurrencyTranslation AC660

Figure 46: Currency Translation Keys

Different financial statement item sets are normally translated using different

exchangerates. Youusevariouscombinationsofthecurrencytranslationkeyand

theexchangerateindicatortodeterminetheseexchangerates.

The currency translation key determines the base currency for translation, the

table used to find the exchange rate, and the procedure to calculate the group

currency values.

Thecurrencytranslationkeysarefixedandcannotbechanged,excepttranslation

key 7.

Figure 47: Comparison of Translation Keys 1 and 5

196